Description
UNIT BI & Analytics team provides services in loading, cleansing, and integrating data into the ODS and EDW. The integrated data can be from systems such as Banner, DegreeWorks, Slate etc.
The Operational Data Store (ODS) is a database specifically designed for performance by grouping and re-organizing data into a simplified, easy-to-understand, business-focused format to provide end-users with the ability to quickly create and deploy operational and adhoc reports in real time or near-real time. The Enterprise Data Warehouse (EDW) is a multi-dimensional database (EDW) that can provide a complete picture of an institution’s current and past business conditions through aggregated data that can be refreshed daily or snapshot to show historical data at institution-specific points in time.
Eligibility
Faculty & Staff can access data in the ODS/EDW via UNIT approved reporting tools such as Cognos, Argos, Power BI etc.
How Much Does It Cost?
No Cost.
How to Access and Use
To request for support with data loading, cleansing, changes to predefined parameter(s), and data inconsistency troubleshooting, create a service ticket by clicking the "Submit ODS/EDW Support Request" button on this page.
To report an access issue, create a service ticket by clicking "Report ODS/EDW Support Issue" button on this page.
Service Levels
| Request |
Respond In |
Resolve In |
| Year End Process |
2 business days |
10 business days |
| Managing Configuration Rule |
2 business days |
10 business days |
| Data Integration and Loading |
2 business days |
10 business days |