Mission
This project will allow UMS to begin to build underlying data integration and business intelligence strategies to leverage contemporary tools while facilitating professional development of staff and stakeholders. Through this initiative, UMS will be afforded opportunity to explore best practices in the development of discrete, targeted datamarts that will serve core reporting, analysis and data mining needs of campuses while informing a viable, iterative enterprise-wide data warehousing strategy. This project will allow exploration of data extraction, data integration, data transformation and data management strategies driven by robust data governance, data architecture, database management, business intelligence and data analytics needs of the UMS community.
Pilot Planning
- Datamart Pilot (Restricted access)
- Athena & DARTS Communication (Restricted access)
Datamart Job Documentation
Tools:
Talend
- Data Integration tool
- Build data models based on PeopleSoft data
- Use Microsoft SQL Server as a data platform
- https://www.talend.com/
Working group:
GitLab
Microsoft Power BI
- Data Visualization Software
- Build reports and dashboard
- https://powerbi.microsoft.com/en-us/
Working group:
Data Cookbook
- Data Dictionary
- Report Specifications and Collections
- Data Governance Workflows and Approvals
- https://ums.datacookbook.com/
Work in progress:
- Demo Feedback Survey (June 2018)
- SmartSheet (Restricted access)
Attachments:
planning.png (image/png)
flow-chart.png (image/png)
presentation.png (image/png)
mission.png (image/png)
email.png (image/png)
contract.png (image/png)
documents.png (image/png)
1564984.png (image/png)
1564984 (1).png (image/png)
icon.jpg (image/jpeg)
vision.png (image/png)
network.png (image/png)
folder.png (image/png)
folder (1).png (image/png)