The Iowa State University eData data warehouse is an environment for decision-making, supported by timely and accurate information from an official authenticated source.
A data warehouse consists of data extracted from the operational, or "transactional," database systems of various units such as the Registrar's Office, Controller's Department, Human Resources and Payroll, and makes that data available as historical snapshots for analysis and reporting purposes. By bringing data from disparate sources into a centralized repository, users from across the university who use the data warehouse share a consistent version of the information stored within.
Characteristics that distinguish data in eData from that found in the operational systems include:
- Ease of access and use. Data is organized and structured for improved understanding and easier access for reporting purposes.
- Consistency and updates. Copies of the data are made from strategic points in time. Once the data is placed into the data warehouse it is not changed (the data warehouse is a read-only database). Rather, the historical data stored in the data warehouse is periodically refreshed with data from the operational databases.
- Quick response times and stable data. Data from the data warehouse is accessed using the web-based IBM Cognos. There is no software to install, configure, or patch. Because the data and queries are stored on the eData site, there is no chance that you will lose or delete information.
Access to administrative information is determined by the role of the individual and may be contingent upon training, applicable data policies, and responsibilities. Contact your departmental or college IT coordinator for more information. Security and privacy will be prioritized over access. More information about eData access can be found in the eData policy.
Access to the university's eData reports is through the uBusiness tab in AccessPlus. Microsoft Internet Explorer and Mozilla Firefox are the preferred and recommended browsers for use with the eData Report Portals. Vendor support for Safari and Chrome was recently announced but certain functionality could be impacted for users of those browsers.
As champions of the eData project, members of the eData Leadership Group help to make and support key project scope decisions, review and approve plans for the development of the eData, and approve policies regarding data access, data security, and data confidentiality.
eData Leadership Group Members
|Ellen Rasmussen||Office of the Executive Vice President and Provost|
|Diane Beckman||Information Technology Services|
|Pam Elliott Cain||Office of the Vice President for Business and Finance|
|David Popelka||Information Technology Services|
|Martino Harmon||Office of Vice President for Student Affairs|
|Lynn Miller||University Information Systems, Data Warehousing|
|Gebre Tesfagiorgis||Institutional Research|
This is a common good service available at no charge.