Summary: Migrated static Tableau reports to interactive Power BI with a governed KPI layer.
S · Situation
Leadership needed fast, trusted clinical/pharmacy KPIs; legacy reports were static and slow.
T · Task
Deliver a governed model with RLS, standardized metrics, and quick drilldowns.
A · Action
Star schema; calc groups; incremental refresh; query tuning; SSIS ingestion; SQL Agent scheduling.
R · Result
- 0%+ Tableau views migrated
- Significantly faster dashboard loads; higher exec adoption
Stack: Power BI, SQL Server, DAX, SSIS, Tableau