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

School district staff reviewing state reporting charts on printed reports and a laptop at a conference table
What MCG automated
FLDOE data filesDaily automated ingestionSQL Server data martsEvery department

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

K-12 state reportingData mart designSQL ServerData pipeline automationFLDOE data integrationRisk management analytics

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.

Microsoft Solutions Partner, Data and AI (Azure) badge

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.

Talk to us →
Scroll to Top

Join Our Team of
Data & AI Innovators!