Client success · K-12
Orange County Public Schools: Automated State Reporting and Risk Management Data Marts
The short answer
Midtown Consulting Group (MCG) helped Orange County Public Schools (OCPS), one of Florida's largest school districts, build two Microsoft SQL Server data marts: a State Reporting Data Mart with automated daily ingestion of Florida Department of Education (FLDOE) files, and a Risk Management Data Mart for employee, workers' compensation and liability claims data. The automated pipelines reduced manual work and made both datasets more timely for the departments that relied on them.
Last updated November 2026
At a Glance
- Client
- Orange County Public Schools (OCPS)
- Sector
- K-12 public education · Orlando, Florida
- Services
- Data mart design, automated data ingestion pipelines, data management and reporting
- Technologies
- Microsoft SQL Server, SQL Server Management Studio, automated ETL pipelines
- Data
- FLDOE state reporting files; employee, workers' compensation and liability claims data
- Outcome
- Reduced manual data handling and more timely state reporting and risk management data across departments
Challenge
Shared data, many departments
Many OCPS departments contributed to and relied on state reporting and risk management data, but collaborating on it was difficult. The district needed a scalable system that could serve every group that worked with these datasets.
Solution
Two purpose-built SQL Server data marts
MCG built a State Reporting Data Mart that ingested FLDOE data files automatically every day and organized them for analysts in SQL Server Management Studio, plus a Risk Management Data Mart that brought employee and claims data together for cross-department use.
Outcome
Timely data, less manual work
Automated ingestion replaced manual file handling, and both datasets reached the teams that used them faster. The data marts gave OCPS a scalable foundation for its broader data management goals.
Capabilities Used in This Project
Ready for the next step?
MCG modernizes SQL Server data marts onto Microsoft Fabric and Power BI, and adds Ask Duvall, our AI assistant for K-12 districts, so district staff can ask plain-language questions about FLDOE filings, school grades, attendance and enrollment and get answers with links to sources.
Talk to us about K-12 state reporting →FAQ
Frequently Asked Questions
What did Midtown Consulting Group build for Orange County Public Schools?
MCG built two Microsoft SQL Server data marts for OCPS: a State Reporting Data Mart with automated daily FLDOE file ingestion, and a Risk Management Data Mart for employee, workers' compensation and liability claims data.
What is a data mart, and why did OCPS need one?
A data mart is a focused, well-organized slice of data built for one subject area and the people who use it. OCPS needed data marts so its many departments could work from the same timely state reporting and risk data without manual file handling.
Can MCG automate FLDOE state reporting for other Florida districts?
Yes. MCG builds automated FLDOE data ingestion, state reporting data marts and Power BI reporting for Florida school districts, and its Ask Duvall assistant answers questions about state reporting data in plain language.
Does MCG work with Microsoft Fabric for K-12 districts?
Yes. MCG implements Microsoft Fabric for school districts and migrates existing SQL Server data marts and reports onto it.
About Midtown Consulting Group
Midtown Consulting Group (MCG) is an Atlanta-based data and AI consulting firm and Microsoft Solutions Partner for Data & AI (Azure). Its 100+ consultants design, build and run data platforms and AI solutions for K-12 school districts, colleges, universities and businesses, specializing in Microsoft Azure, Microsoft Fabric, Power BI, machine learning and generative AI with Anthropic's Claude, Microsoft Copilot and Copilot Studio.
Still assembling state reports by hand?
Talk with the team that automated OCPS's FLDOE data pipelines.
