About the Data - Snapshot Dashboards
The Snapshot dashboards provided under the Advanced Analysis tab on the top menu primarily consist of a type of data grid called Dynamic Crosstabs. This type of chart has a list of “Available Data” items such as Race, ELL Status and School Name that you can drag-and-drop to either the “Columns” or the “Rows” position, and arrange as desired for the data combinations that you would like to view. Data can be filtered by clicking the three bars symbol to the right of the data item and selecting the desired values. Your preferred combination of rows and columns can be saved for future use by clicking the Save icon next to Current Session and naming the configuration.
Caution! While there are other options available in the Function box, only "Sum" produces usable results. Only use "Sum".
Specialized counts called Data Quality Indicators are provided at the top of most snapshot dashboards. These focus on aspects of current data relevant to that snapshot and potential data quality issues that should be investigated prior to the snapshot. Additional information regarding content and usage of the snapshot dashboards are included directly on each dashboard. Click on the blue links to expand the help text.
See Snapshot Preparation - Detailed Guide for more information about how to use these dashboards to prepare for an upcoming snapshot.
What are snapshots?
In general terms, snapshots are pieces of data that are copied from active, dynamic tables in the DPI Data Warehouse (DW) at a specific point of time to a “permanent” location to support current and future reporting. This facilitates reporting from an unchanging set of attributes, providing consistent, repeatable query results unaffected by the dynamics of real-world changes and corrections.
The Snapshot dashboards in WISEdash for Districts provide users with tools to query data captured in a snapshot and compare that data to their district’s current data from the main DW tables. These comparisons can help the district identify and correct data reporting deficiencies in preparation for a future snapshot event.
What data is captured in a snapshot?
All current student attributes recorded in the DW such as race, gender, ELL status, etc. - with the exception of disability information - is captured as of the date the snapshot is taken. This means that the snapshot will reflect the current data values from your SIS regardless of the intended use of that particular snapshot. For example, if a student was not economically disadvantaged on the Third Friday of September (TFS) but became disadvantaged just recently, a TFS snapshot taken today would record that student as disadvantaged.
Disability information is handled somewhat differently. Disability status, disability codes, education environment, and parentally placed private have associated begin and end dates that are also recorded in the snapshot. This allows the appropriate effective values to be selected for the intended use of that snapshot - i.e. disability attributes effective during the third Friday of September to be used in the TFS snapshot and those effective on October 1 for the Oct. 1 Child Count snapshot.
All enrollment changes and attendance values for the school year-to-date are captured with every snapshot.
How will snapshots be used?
The snapshots will serve as the permanent data source for certified reporting by DPI. This includes TFS Count Date enrollment, Oct. 1 Child Count, certified attendance, high school completion, dropouts, statewide assessment demographics, and others.
How may data in the snapshot be different than the WISEdata portal?
Data shown on these dashboards and all other WISEdash dashboards may differ somewhat from data shown on the WISEdata Portal for a number of reasons. Most often, this is due to data reporting errors that cause data values to be supressed or rejected from loading into the DW. In addition, data is loaded nightly into the DW instead of being updated in real time as with WISEdata. Please continue to examine unresolved errors in the WISEdata Portal and rectify these whenever possible. WISEdata is a continuous process that requires regular attention to maintain accurate and current data.
When viewing snapshot data in WISEdash, it is normal and expected that current WISEdata values would begin to change over time as updates are made to the student data in your SIS. Changes made in your SIS will flow through WISEdata to the DW nightly and be reflected in the next snapshot taken.
At what time of year should the snapshot dashboards be used?
The snapshot dashboards are designed to assist with verification and review of student data prior to the date on which the snapshot will be taken. In general, the snapshot dashboards are not intended for historic review. The October 1 Child Count Snapshot Dashboard is an exception as this count is only available as a snapshot dashboard at present. At the beginning of the school year snapshot dashboards for Attendance, Discipline, and Year End Completion are valuable to review the quality and accuracy of student data outcomes and demographics for the prior school year. Beginning October 1, review of the Third Friday of September and October 1 Child Count snapshot dashboards is critical to ensure timely and accurate data in the fall snapshot. In May, the Spring Demographics Snapshot is useful to review the current state of demographics, but not outcomes, during the spring assessment windows.
The snapshot dashboards handle security roles in a similar manner as all other dashboards, with a few exceptions.
- Using the Student-School Association set to Accountable enables users to include students that are (or were at the effective date of the snapshot) accountable to their district or school but attending a different school.
- Snapshot Preparation - Detailed Guide
- Using the Dynamic Crosstab User Guide
- Assessments in Wisconsin including schedules