Thursday, June 9, 2011

Data Warehouse Improvements

The folks at ESE are taking steps to improve the performance of the data warehouse in the short-term (given the pre-release of MCAS data scheduled for June) as well as the longer-term (August and beyond). One of the steps that will be most beneficial to EDW users is that there will be a direct link to pre-run reports stored in district dropboxes.

The pre-run reports will be:

Pre-burst District Reports (for district-level users with 209 and 210 roles)
o Items Analysis
o Performance, CPI and SGP by Subgroup
o Data files (.csv, .xls)

Pre-burst School reports (for school-level users with 211 roles)
o Student Roster
o Items Analysis
o Performance, CPI and SGP by Subgroup
o Data files (.csv, .xls)
o MCAS-Alt Portfolio

Additional updates and improvements will come later in the summer with re-designed reports and enhanced servers for the main EDW database. Stay tuned!