Skip to Content

EdInsight - Data Warehouse

On this page...

EdInsight LogoEducators in Iowa are harnessing the power of EdInsight, Iowa’s education data warehouse to transform data into information since the project inception in 2007.




EdInsight Utilization GraphicSurpassing 4,000 users state-wide. Every district has at least one user. EdInsight is delivering over 5,000 reports per month and empowering educators with information. “It’s been a great project to be a part of and very gratifying to see people using EdInsight to make decisions”, stated Jason Grinstead, former Project Manager. “We routinely work with Area Education Associations (AEAs) and Districts to build prototype reports and, when perfected, roll them out to all users. It’s a highly collaborative model.”

“Educators told us in our initial focus groups that assessment data and comparisons would be the most important.” By viewing utilization of the reports this has been absolutely true.





EdInsight Report Utilization GraphicRoughly 49,000 Assessment-based reports have been executed over the last 12 months, illustrating student performance graphically and quantitatively over time.

District and Individual student level reporting have been the most dominant, comparing and contrasting like-districts and student performance over time.

EdInsight also includes Graduation and Dropout reports.  The C-11 report, defining the count of students that enroll in college in 16 months has been updated with two years of data.




Success through Collaboration

AEA 267 has been a great success story applying EdInsight in program development. With over 1,200 EdInsight users in AEA 267 alone, Jon McKenzie and Joe Kremer have formed program training using reports from EdInsight to support data analysis within districts. Assessment-based reports like ASMT 1.1.4 and ASMT 1.1.3 were designed specifically to support trainings in the AEA to evaluate student growth and performance histories.

“Using data to support decisions and initiatives is really an easy sell. Having information readily available and ALL the history puts the focus on analysis rather than data gathering and sets the foundation for improvement”, states Kym Stein, Educational Consultant at AEA 267.

AEA 267 already had a culture of applying data. By developing canned reports in EdInsight to support specific initiatives, EdInsight usage in 267 is the highest in the state and positive effects are being made.

“Although we are intently focused on our own districts, it is imperative that we look to our peers to understand performance trends and analysis, states Dawn Anderson-Rascher of Davenport CSD.  These reports in EdInsight allow us to quickly and easily perform comparative analyses, without crunching data or merging data sets.  We hope to extend these reports and format past assessment data and use the format to compare Dropout, Graduation and C-11 reporting.”

Usage and adoption continues to expand throughout the state.


Security Portal Implementation

Soon, EdInsight access will be regulated by a self-service security portal under the control of local Security Officers. The portal, also known as EdPortal will apply EdInsight’s security model in accordance with Family Educational Rights and Privacy Act (FERPA) and under the approval of local Security Officers.  Access to small cell size, individual student level and Free and Reduced Lunch (FRL) will all be regulated by the portal’s security engine.

More information about the Iowa Education Portal.


EdInsight Report Menu

EdInsight offers 20 pre-formatted reports which are designed to answer an educational question quickly, with a minimum of training. EdInsight also contains multiple data cubes providing end users the ability to do ad hoc analyses. The table below defines the reports as of the 1.15 Release. 


Title Example Report Description/Questions Answered
APR 4.1 - Student Achievement Each year a school or school district is required to submit an annual progress report to the local community, AEA, and Iowa Department of Education. APR 4.1 provides the student achievement information for that progress report. Counts and percentages of students broken down by proficiency levels, ethnicities and program indicators are displayed.
ASMT 1.1.1 - Individual Student Reports ASMT 1.1.1 displays how the student has performed in each of the Iowa Assessment subtests by year and displays a student’s proficiency.
ASMT 1.1.2 – Individual Student Assessment - Trend Available as a stand-alone report, you can go directly to a trend report and view all of the student's historical Iowa Assessment data. Additionally, you can start with Individual Assessment or Search by Student ID – all assessment reports allow progression or ‘drill through’ to Individual Assessment and Trend.
ASMT 1.1.3 - Individual Student List by Grade   This report provides a list of all students for a particular grade and Iowa Assessment subtest, with NGE, NSS and NPR scores. This report also contains bar code elements and drill through to ASMT 1.1.1 - Individual Student reports. Exportable to Excel, this provides an easy way to extract data without using Analysis Studio.
ASMT 1.1.4 - Individual Student List by Grade - NSS Score History    For users with Individual Student Level access, this report provides current and historical access to a list of student's NSS scores beginning with the prompted school year. Exportable to Excel, this is a convenient way to extract lists of students. 
ASMT 1.2.1 – Group Assessment This report answers the question ‘How is the group (AEA, District or Building) performing on the Iowa Assessment subtests?' The report presents the average National Standard Score or National Grade Equivalent for the selected location.
ASMT 1.2.2 – Group Achievement Context asmt122 Displays aggregate AEA, District and Building percent proficient across all NCLB Subjects and grades 3-8, 11. Sorted by percent proficient, this report allows you to select specific grades and subject for analyses. Users with Small Cell Size access will see non-redacted data for their specific area.
ASMT 1.3 – Cohort Performance Report asmt13 Matched, Simple and Cross Sectional Cohort analysis now may be performed at the levels of AEA, District and Building level. This answers the question: How is my group performing on ITP tests over time?
ASMT 1.4 – Assessment Cube Reports   ASMT 1.4 is a cube of assessment data for ad-hoc analysis. This menu item is limited to users that have participated in Cognos Analysis Studio training. Cubes are available for each AEA at the student level and one State-Level cube without student level information. Access to data is limited to your level (State, AEA or District).
EQTY 2.1/2.2 - AEA/District Equity Report eqty21 For district level and higher users with small cell size access, the purpose of the report is to examine Student, Employment and Course data for the purposes of reporting race, ethnicity and employment equity in the State, AEA and District.
CURR 6.1 - Curriculum Accreditation Report curr61 CURR 6.1 displays the number of Carnegie Units that are offered and taught in a building and allows for comparison with the State, AEA, or enrollment category. Comparison groups are configured by school type so that regular high schools, alternative schools, and charter schools are compared separately. Users are able to drill through and view details about the courses that the building offered in each accreditation area.
CURR 6.2 – Curriculum Accreditation Report Detail   CURR 6.2 displays all the courses that are offered and taught in the referenced building, grouped by accreditation area and course name. Carnegie Units and student enrollments are subtotaled by NCES course name and displayed as totals for accreditation.
SPED 7.1 - AEA Part B Special Education Data Profiles   The Special Education AEA Profiles Report allows users to display AEA-level data on many of the special education indicators that are required based on Iowa’s State Performance Report that is required by the Office of Special Education Programs (OSEP) under the Individuals with Disabilities Act (IDEA) of 2004. Annual outcomes and targets are displayed graphically for each indicator.
SPED 7.2 - District Part B Special Education Data Profiles   The Special Education District Profiles Report allows users to display district-level data on many of the special education indicators that are required based on Iowa’s State Performance Report that is required by the Office of Special Education Programs (OSEP) under the Individuals with Disabilities Act (IDEA) of 2004. Annual outcomes and targets are displayed graphically for each indicator.
UTIL 9.2 – School and District Comparison Report   UTIL 9.2 allows the user to find comparable schools or districts in terms of size (enrollment), and/or demographic variables.
IND 11.1 - Graduation Report   The Graduation Report provides users with current and historical graduation rates aggregated at the levels of State, AEA, District, and Building. Graduation rates are provided for the 2009-2010 school year and forward in the format of four-year and five-year cohort rates.
IND 11.2 - Dropout Report   This report defines count and content of dropouts at the State, AEA and District Level from 2005-2006 school year to current. With disaggregations and trending, this report will provide insight into the quantity and content of dropouts.
IND 11.6 - C-11 Report ind116 This report defines for each high school in the State, by student subgroup, the students who graduate from high school and who enroll in an Institution of Higher Education (IHE) within 16 months of receiving a regular high school diploma.


AEA Contacts

Support for the EdInsight project is provided by a network of trainers and site coordinators in our AEA's.  The network provides valuable professional development in data use and literacy, and EdInsight reporting and analysis training.

To sign up for training and access to EdInsight, contact your AEA liaison.


AEA Contact Email
267 Jon McKenzie
8 Gary Dannenbring
9 Edward Gronlund

10 Michelle Tressel
11 Karla Day
GH Sherry Huffman
GP Evan McCormick
NW Sue Chartier
Jordan Menning 


Printed from the Iowa Department of Education website on September 01, 2015 at 5:12pm.