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.
Architecture
One Warehouse, One Definition Per Metric
Enrollment, staffing, and finance data lived in separate on-premises systems. I consolidated it into a single SQL Server warehouse using a dimensional star schema, so every downstream report drew from the same governed source instead of a spreadsheet-specific version of the truth.
Enrollment
Staffing
Finance
Operations
SSIS ETL Packages
SQL Server Data Warehouse
Star Schema Dimensional Model
DAX Semantic Layer
Power BI
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
Business Impact
What Changed for Leadership
Consistent Reporting Across Teams
One governed warehouse replaced team-by-team spreadsheets, so enrollment, staffing, and finance reporting used the same numbers.
Less Manual Reporting
Automated SSIS pipelines and scheduled Power BI refreshes reduced the repetitive manual work reporting used to require.
Clearer Visibility Into Key Metrics
Executive dashboards gave leadership a consistent, always-current view of enrollment, staffing, and operational performance.
Faster, More Informed Decisions
Leadership could act on trusted numbers directly, instead of waiting on ad hoc report requests.