The Technology Framework consists of various tools and technologies to support, facilitate, and enable people and processes for implementing the UBC Reporting Strategy.
- Visualizations and Analytics models
- Portal to access and publish reports and results from analytic models
- Reports and Analytics, includes departmental and enterprise reporting, and analytics
- Data Warehouse Data Marts
- Source of data for reporting: Data Marts primarily, Data Warehouse(DW)
- Data Warehouse and Data Marts ETL
- ETL packages to populate Data Warehouse and Data Marts
- RDS (Reporting Data Store)
- Source of data for the Data Warehouse
- RDS ETLs
- ETL packages to populate the RDS
Data Governance Reporting Tools
Data Governance Reporting tools' objectives are to facilitate the creation and maintenance of Data Governance processes and enable people to understand, and maintain quality data.
Current Data Governance Tools available:
- Data catalog, including reference and metadata management, glossaries, report definitions and data lineage
- Data security, including access control
- Data modelling and design
- Master data management
BI Reporting Tools
BI Reporting Tools enable the usage of historical quality data for analysis in the organization, as well as enable people to leverage quality data into business value through reports.
Current BI Tools available:
- Data Warehousing
- Integrating and consolidating data from various sources
- Point in time history maintenance
- Data security, including access control
- Report delivery
- Design and development of reports and dashboard
Self-Service Analytics Reporting Tools
Self-Service Analytics Reporting Tools enables the usage of historical quality data for analytics in the organization.
Current Self-Service Analytics Tools available:
- Operational Reporting Tools
- Develop reports that require specific formats
- Develop complex operational reports
- Includes data security, including access control
- Dashboard Delivery Tools
- Leverages data sets developed in a format and shape that optimizes the efficiency of the tools used for analytics