...
Do nothing: maintain status quo. Not very nice!
Automation: Implementing full or semi-automated data ingestion from Oriel to TIS. This can streamline the process and reduce manual errors.
Enhanced ETL: Improving ETL processes to efficiently handle and store Oriel data in a query-able format for easy querying. Create subset of relevant data for TIS, enriched with timestamps for change tracking.
Data mapping: Developing automated mapping tools to reduce manual data handling.
Data integration: Developing a more robust data integration process to ensure that programme and curriculum details are accurately mapped from Oriel to TIS.
Integrated Process/System Development: Using Oriel procurement to create a more integrated system for data flow between Oriel and TIS.
Tableau integration: Exploring the use of Tableau for data management and quality tracking. Using Tableau to automate data splitting for different audiences and to create reports to map Oriel data to TIS bulk upload format, identify and track upload issues, and data qualityStandardization: Standardizing program names and numbers across systems for better alignment.
Alignment: Aligning Lists of Values (LoV) to minimize manual data matching efforts, by ensuring Oriel and TIS use the same lists of values for fields.
Standardization: Standardizing program names and numbers across systems for better alignment.
Automation: Implementing full or semi-automated data ingestion from Oriel to TIS. This can streamline the process and reduce manual errors.
🏹 Strategic Recommendations
...