Enterprise Analytics Platform
KinderCare Learning Companies
Designed and developed enterprise Power BI reporting solutions by integrating data from multiple on-premises systems through SSIS ETL into a centralized SQL Server data warehouse, enabling executives to monitor enrollment, staffing, finance, and operational performance through trusted analytics.
Project Overview
Delivering Enterprise Analytics for Executive Decision Making
KinderCare operates hundreds of childcare centers across the United States, generating large volumes of enrollment, staffing, operational, and financial data. The objective was to transform fragmented reporting into a centralized analytics platform that provided executives with consistent, trusted, and actionable business insights.
Business Challenges
Solving Real Enterprise Reporting Problems
Before implementing a centralized analytics solution, leadership faced several operational reporting challenges that impacted visibility, efficiency, and strategic decision-making.
Modernizing Cognos Reports
Migrated legacy IBM Cognos reports to modern Power BI dashboards, providing interactive analytics, improved performance, and a better executive reporting experience.
Siloed On-Premises Data
Enrollment, HR, finance, and operational data resided across multiple on-premises SQL Server systems, making consolidated reporting challenging.
Delayed Executive Reporting
Leadership depended on scheduled reports, limiting the ability to monitor operational performance and respond quickly to changing business needs.
Inconsistent Business Metrics
Different teams used varying KPI definitions, making it difficult to establish a single source of truth for executive reporting.
My Role
End-to-End Analytics Engineering
I was responsible for delivering the complete analytics solution—from gathering business requirements and engineering data pipelines to building enterprise Power BI dashboards used by leadership across the organization.
Business Requirements
Collaborated with business stakeholders to understand reporting requirements and define executive KPIs.
SSIS ETL Development
Developed and maintained SSIS packages to extract, transform, and load data from multiple on-premises operational systems.
SQL Server
Built optimized SQL queries, stored procedures, and data transformations for enterprise reporting.
Data Warehouse
Designed dimensional models and maintained an on-premises SQL Server data warehouse using star schema principles.
DAX & Data Modeling
Created reusable DAX measures, calculated columns, KPIs, and semantic models to support enterprise analytics.
Power BI Dashboards
Designed interactive executive dashboards for enrollment, staffing, finance, operations, and workforce analytics.
Performance Optimization
Optimized SQL queries, ETL processes, and Power BI reports to improve refresh performance and usability.
Business Impact
Delivered trusted reporting that enabled leadership to make faster, data-driven operational decisions.
Technology Stack
Enterprise BI & Analytics Stack
The solution leveraged Microsoft's on-premises Business Intelligence ecosystem to build scalable reporting, automated ETL pipelines, and executive Power BI dashboards.
Power BI
Executive Dashboards & Reporting
SQL Server
Enterprise Data Warehouse
SSIS
ETL & Data Integration
DAX
Measures & KPIs
Power Query
Data Preparation
SQL Server Agent
Scheduled ETL Jobs
Star Schema
Dimensional Modeling
On-Premises
Enterprise Infrastructure