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