Data Sources

How does the data flow through DSI systems?

If you are interested in learning more about DSI's architecture and how the data flows through our systems, read about here

How often is the data updated?

The Student Systems and Financial data are updated on a nightly basis using day old application data. Human Resource data are updated on a monthly basis on the 27^th of each month. All of our update processes clear and rebuild current and historical data each time, so they are always ‘current state’ as opposed to being snapshots representing specific points in time.

Based on reporting requirements the amount of history may vary from one application to the next, but in general we display the most recently recorded data plus 4 prior years, but the data captured currently goes back to 2011. In the future we expect to extend the number of years of historical data we save to support predictive analytics and our Denodo Self Service application which allows users to select and download data directly.

How is this data validated?

While building these data sources we employ multiple levels of quality assurance to insure that we are providing information to decision makers that is accurate, timely and consistent. First we compare our tables to source system tables, then insure that the data is transformed properly as it moves through the system, and finally when possible we compare to the IUIE, UIRR reports and other existing sources as appropriate.