AnalyticsFoundry
Selected Work · Vol. I

Case studies in
analytics that ships.

A representative slice of platform-scale BI engagements. Real problems, real architectural decisions, honest accounts of what worked and what didn't. Client names anonymized where required; specifics shared with permission.

№ 01
Healthcare 2024 — Present

Building Admissions 360 — A Behavioral Health Analytics Platform on Microsoft Fabric

Client Behavioral health network (US)

Designed and led the implementation of an enterprise admissions analytics platform on Microsoft Fabric and Power BI, replacing a fragmented reporting estate with a unified semantic layer serving departments across the admissions journey.

  • Single semantic model serving 8+ department audiences with page-level access governed by Entra ID security groups
  • Reduced executive report distribution from manual weekly process to automated PDF flow with bookmark-driven navigation
  • Built automated KPI validation harness in Fabric Notebooks (SemPy) catching measure drift before it reached executive dashboards
Microsoft FabricPower BIOneLakeDirect LakeDAXSemPy
Read the case study →
№ 02
Retail & CPG 2022 — 2024

Rationalizing a Sprawling BI Estate — From QlikView Legacy to a Unified Power BI Platform

Client Multinational retail execution company

Led the consolidation of a fragmented BI environment spanning QlikView, legacy Power BI, and direct Snowflake/Databricks queries into a governed Power BI platform with shared semantic models and standardized deployment pipelines.

  • Retired 47 QlikView reports and consolidated 80+ Power BI assets onto 4 shared semantic models
  • Cut average new-report delivery time by 25–30% via reusable visual templates and shared measures
  • Established CI/CD for BI using Azure DevOps with deployment pipelines for dev/test/prod environments
Power BIAzure DatabricksSnowflakeAzure Data FactoryQlikViewDAX
Read the case study →
№ 03
Manufacturing 2018 — 2023

An Enterprise Semantic Model Serving 500+ Business Users

Client Global manufacturing client (via Infosys)

Designed and governed a multi-domain semantic model framework for a global manufacturing organization, supporting commercial analytics, operational reporting, and self-service consumption by 500+ users across 14 countries.

  • Single semantic layer serving 500+ business users with sub-second query response on fact tables in the 200M+ row range
  • Sourced commercial data from Salesforce ERP and operational data from ServiceNow into a unified analytical model
  • Reduced quarterly business review preparation time from weeks to days through executive-ready dashboards built on the shared model
Power BISSAS TabularAzure Analysis ServicesSnowflakeSSISDAX
Read the case study →