Reporting GSRMT Subgroup 2023-10-05
Misty’s topics
Data warehouse
Systems: Cognos, PowerBI
Reports can be scheduled
Validation, validation cycle
Micahla: Are there limitations to requests?
Depends on the requester’s educational need to know/business need - may require approval from Registrar
Lane: Enrollment report that is sent out - only includes priority 10 programs
What other types of information would be beneficial to us? Depends
Get a report on who’s on LOA
Report delivery
emailed/shared - refreshed on a cadence - hard-coded parameters
Cognos - run on demand, set your own parameters
If a report takes a long time, BIA may recommend amendments to make the reports lighter/faster
PowerBI - each dash will have its own link
Report vs. PowerBI dash
Depends on the amount of detail you want to see with your aggregates
When you want to see the big picture and drill down to specific students
How to get Cognos access - BIA request
Tips on how to get the right data -
What are your pain points?
What are your ongoing problems?
Be mindful of your timelines/expectations for completion
Currently don’t have a library of reports - over 7500 reports in Cognos
Misty will develop a list of things we might like as a starting point. Might have a list in about a week.
Misty open to more meetings for report ideas.
Lane: reports to support retention - year-over-year retention for example