/
Reporting GSRMT Subgroup 2023-10-05

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

Identify GSRMT members who don’t have Cognos access - Denise will email team to see if anyone doesn’t have Cognos and open a ticket to set up access.