November 4, 2020
To subscribe to this newsletter: click here!
Data Validation Scripts
As you continue or begin to populate the 2020-21 school year data please take advantage of using one of the numerous Data Validation Scripts available to use as a tool to assist in validating the integrity of data in your ODS. The list of available validation scripts that can be used in the MiDataHub cockpit to validate data can be found on the MiDataHub Website under "Support" > "Data Validation Queries" or by clicking here. Short descriptions of each query are included to provide you details on what data will be output. 

  • A few of the more widely used scripts are detailed below, along with some instructional tutorials on how to run each of them. 

School Data Load Analysis - This validation query provides a breakdown of data loaded in several categories for each school building within your district. This script is very helpful in ensuring all of the data is loaded for every school. For those that have used the At-A-Glance report located in the MiDataHub cockpit, you will find this script very similar in that it provides an aggregate count of records, but this script provides much more (and clearer) detail on each category of data residing in your ODS. 

School Section Analysis - This validation query can be used to validate that each school has sections published to MiDataHub and will provide the end user the counts of both students and assigned staff. 

Data Freshness Script - This query lists the tables that are populated with data, along with specific details on when they were first populated and most recently updated. This script is very useful in that it provides end users when the last update was made to a specific set of data (Student Section, Attendance, etc.). 

For more information on how to use the validation scripts in the MiDataHub cockpit please watch our video that walks through the process available on the MiDataHub Youtube Channel. 
Student Information System Status Calls
If you would like to get the latest updates on, "What's new and upcoming with your Student Information Systems connectivity to MiDataHub (and the Ed-Fi environment)", please join us during our monthly status calls with each Student Information Systems management team. If you are interested in joining these meetings please send us an email to support@midatahub.org and include your district, and student information system.

Please see the list below for the frequency of meetings occurring every month:
PowerSchool SIS
10:30 a.m. - 11:00 a.m. second Tuesday of month
eSchoolPLUS
11:00 a.m. - 11:30 a.m. last Thursday each month
Edupoint Synergy
2:00 p.m. - 2:30 p.m. second Tuesday each month
Skyward
3:00 p.m. - 3:30 p.m. second Tuesday of month
Infinite Campus
1:00 p.m. - 1:30 p.m. second Tuesday of month
MISTAR-Q
9:00 a.m. - 10:00 a.m. second Monday each month
Vendor Corner
The Vendor Corner will appear most weeks to highlight additions and changes to applications integrated with MiDataHub.  

Renaissance Learning
Meetings have started with the identified Return to Learn vendors, and the Michigan Data Hub team met with Renaissance Learning last week. Renaissance has identified column definitions for the Early Literacy, Math and Reading assessment files.

SAS EVAAS
  • Opt in window - Currently open, deadline not yet determined.
  • Opt out window - please reach out to EVAAS_Support@sas.com  or support@midatahub.org for any questions about opting out of EVAAS reporting.

Please visit our product catalog for more information on vendors.
Participation Update
New Live Districts
  • Oakland County Academy of Media & Technology
  • Waterford Montessori Academy

New Single Sign on Districts
  • American Montessori Academy
  • Avondale School District
  • Battle Creek Public Schools
  • Caro Community Schools
  • Central Montcalm Public Schools
  • Ecorse Public Schools
  • Flat Rock Community Schools
  • Fruitport Community Schools
  • Gibraltar School District
  • Jackson County ISD
  • Lincoln Consolidated School District
  • Muskegon Area ISD
  • North Dickinson County Schools
  • Otsego Public Schools
  • Richfield Public School Academy
  • River School
  • Saginaw Township Community Schools
  • Warren Woods Public Schools
  • Weston Preparatory Academy

Need to register your district?
Please email us at support@midatahub.org.