Launching a district data warehousing project

A redesign of a school district’s information systems is always a challenge, but Winston-Salem/Forsyth County Schools (WSFCS) was further complicated by rapid growth, changing demographics and school choice. WSFCS is the fifth-largest system in North Carolina, with 80 schools and approximately 52,000 students and 8,000 teachers and administrators. The system gains about 500 students a year, so new schools are regularly being opened.

In a district with significant ethnic and socio-economic diversity, it is critical to have more than percentages and summaries of student achievement, but to know which students and teachers might need extra help. Distribution of students changes, sometimes markedly. Parents can choose from their neighborhood schools, another school in their zones, or from 15 magnet programs.

Despite dynamic growth and change, and faced with a hodgepodge of disparate data sources and ad hoc processes, WSFCS was able to create a unified information infrastructure that now delivers meaningful, interactive, visual reports to support data-driven decisions. How did we do it?

Redefining the information environment

Find and evaluate the current data sources.
Five years ago, the WSFCS director of accountability, superintendent and director of curriculum spent a year studying the district’s different data sources. The result was scary. The data was everywhere, fragmented and overlapping. They needed to pull all of it together.

(Next page: More steps and tips)

Want to share a great resource? Let us know at


We’re Celebrating 25 Years with 25 Giveaways!

Enter Each Day to Win the Daily Gift Card Giveaway

and the Grand Prize drawing for an

Apple iPad!

Visit eSchool News each day through April 1, 2023 to enter the daily $25 Gift Card drawing.
Each daily entry counts as one entry for the grand prize drawing. See details and rules.
Giveaway is open only to legal residents of the fifty (50) United States and Canada who are employed full- or part-time in K-12 education.