Intersection of Healthcare and Business Intelligence: Hospital Performance, Clinical Outcomes & F...Intersection of Healthcare and Business Intelligence: Hospital Performance, Clinical Outcomes & F...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Intersection of Healthcare and Business Intelligence: Hospital Performance, Clinical Outcomes & Financial Sustainability Analysis
An end-to-end healthcare business intelligence project analyzing 16,600 inpatient encounters across operational, clinical, and financial dimensions to identify what’s driving prolonged hospital stays, recurring readmissions, and rising costs.
Your dashboard shouldn't need a dashboard to explain it. 👀
Meet AdVisa, an affiliate analytics concept built around clarity, clean charts, and smarter data exploration.
Here's the design breakdown. 🧵
#DashboardDesign#SaaSDesign#UIUX#DataVisualization
(1/5)
Less noise. More insights. 📊
I organized revenue, spending trends, and campaign metrics into a clean dashboard that makes important numbers easier to scan.
Because the best analytics experience helps you find answers, not just data.
(2/5)
A full-stack RAG application that answers questions from a team's own documents, with every answer cited to the source document and page. I designed, built, tested and deployed it end to end:
document ingestion with content-based file validation;
semantic search with PostgreSQL + pgvector;
streaming answers over Server-Sent Events, with server-side citation verification;
multi-tenant workspaces with role-based access;
usage metering with quotas and a cost dashboard;
a crash-safe PostgreSQL job queue.
Deployed as a public demo on free tiers (Vercel, Render, Supabase) with hard caps on AI spend.
Citations verified against the retrieved passages; unsupported answers return "not found"
Tenant isolation in every query; Supabase Data API locked down (verified on production)
Durable ingestion queue (SKIP LOCKED, leases, retries): kill -9 under load lost nothing
Costs reserved before every AI call; per-user, per-workspace and deployment-wide caps
Data-driven model migration (5 configurations evaluated; about 74% cheaper per answer)
The reservation before the AI call is the detail most teams miss: you can add cost metering later, but you cannot un-spend the money after a runaway loop. On the crash-safe queue, with SKIP LOCKED plus leases, what happens to a lease held by a worker that is alive but stuck, do...
Organized data is easier to manage, review, and use.
This project focuses on transforming raw information into structured Excel tables with clear categories, consistent formatting, and business-ready organization.
✅ Excel Data Entry ✅ Spreadsheet Organization ✅ Table Creation ✅ Professional Formatting