Partnering with Stetson University, I am happy to share the second installment of our Power BI Higher Education Analytics solutions.  This solution shows Fall term enrollment data and trends, including enrollment by degree level, class level, residency, gender, ethnicity, college, and major.  The entire solution with documentation can be downloaded here.

Click on the report below to see Stetson University’s enrollment report in action. Flip through the pages and click a few of the slicers to see the full capabilities of the solution.
 

dashboard

This report was built with the Power BI Desktop and published to the web via the Power BI Service to share the data with the campus community.

Just as with the previous solution, the download zip file contains the following items to help you quickly create your own enrollment report:

  • a step by step guide to setting up the files and configuring Power BI,
  • a Data Dictionary, which contains detailed information on the views, tables, and variables used to create the extracted data file,
  • a sample Excel source data workbook, and
  • the Enrollment report template which contains the data model and reports.

The documentation included in the download assumes users understand how to extract data from their existing source systems and does not provide detailed guidance on this aspect of the process.

If you have any questions, suggestions, or concerns, please feel free to email myself at pleblanc@microsoft.com, Resche D. Hines, Ph.D. (rhines@stetson.edu) or Angela Henderson (ahender1@stetson.edu).

Stay tuned to my blog, Facebook page, and twitter (@patrickdba) for updates on forthcoming higher education reporting solutions.

Talk to you soon,

Patrick LeBlanc