Data Warehouse User Engagement Readout. Daniel Gold, Project Manager. Agenda:. Executive Summary Study Methodology and Participants Tool Needs and How They Align to Pyramid Common Reporting Tasks Process Opportunities What is Needed for Success Summary and Next Steps. Executive Summary.
Data Warehouse User Engagement Readout
Daniel Gold, Project Manager
HR and Finance under-represented! Further investigation to needs of these teams required.
Top 10 Prioritized Features:
The “Core Four”
What’s a Tiger Team?
“ A team of undomesticated and uninhibited technical specialists, selected for their experience, energy, and imagination, and assigned to track down relentlessly every possible source of failure”
- Program Management in Design and Development
All this would be better if… “we were able to gather point in time comparison and make the comparisons in a more efficient manner. Right now this takes 2 people approximate 6-8 hours every week to complete.”
Potential Reasons for production queries:
Historical point in time comparisons (snapshots)
Validate data obtained through MyInsights or ProClarity
Familiarity with querying production over using DW tools
During group discussions two types of data integrity / validation issues emerged:
“I think the most complex part of the reporting is validating the accuracy of the data. So much of what we do is this it takes the most time and is the most frustrating.”
“[M]anualmanipulation in excel is time consuming and there is risk of error. Data validation.”
All of this would be better if… “[It] didn't take extensive manipulation each time. Confidence that the data was correct.”
“[N]umerousproclarity reports are referenced in order to create the summer report. Difficult to identify the criteria used to create the ProClarity report and difficult to validate the data. Time consuming to create report.”
1 in 4 participants cited data validation as a time consuming and required step.
All this would be better if… “You could get a clear definition for what "active" means (e.g. not discontinued on PS, or what?!)”
“have you seen the terminology? there are five categories for each line. Things like STEM secondary non-STEM major”
Top 10 Prioritized Process Enhancements
User Rollout Track
Early adopter rollout
End User Rollout
Daniel Gold, Project Manager
Email [email protected]
The above items represent the report or report goal that participants identified in their reporting story forms. Duplicates intentionally included.
Tiger teams work best when they are small hand-picked groups focused on a specific task (e.g. simplifying enrollment reporting).
The team should include not only subject matter experts and power users, but also report and back-end database developers to speed up the process of weighing out potential solutions. These “tigers” are easily identified by being the go-to people in their area when a problem arises.
The activity should be time-boxed and the output should be a list of enhancements the team can prioritize and implement with the goal of delivering on the specific task assigned.