...
Do nothing: maintain status quo. Not very nice!
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 quality
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.
...
🏹Â Recommendations
Progressive automation: Progressively automate the most labour-intensive tasks, such as data field mapping and person record creation.
Stakeholder involvement: Foster stakeholder involvement to tailor solutions to local office needs
Data quality: Prioritize data validation and data quality checks to ensure integrity inaccuracies
Incremental improvement: Commit to a phased implementation, allowing for iterative testing, feedback, and adjustment, whilst minimizing disruptions
Training and support: Pursue comprehensive training and support for HEE Admins and local office users on the new system and processes to ease the transition.
API development: Explore development of an Oriel – TIS API for real-time data exchange and updates
Change management: Implement a change management plan to address the industry-wide impact of the onboarding process. Consider collaborative tooling to allow local offices to add their input directly, improving the alignment and accuracy of data.
...