Power BI

Higher Education Retention Analytics using Power BI

Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This solution shows student persistence, retention, and graduation patterns, leveraging a Student Information System (SIS) as the data source. Year-over-over retention and graduation rates can be filtered to allow deeper examination of trends at the college and major level. Additional views, including retention and graduation rate tables by major and ethnicity, are included within the report solution.  The entire solution with documentation can be downloaded here.

The following image shows the first view within the report: overall persistence, retention, and graduation rates by year of first time student cohort. This report allows users to quickly show institutional retention and graduation trends across time, with the option to filter the view to show only specific colleges and/or majors.

image

This report was built in Power BI Desktop and published to Power BI web service to share with the campus community.

While the report initially used a manually refreshed Excel file of student enrollment as the data source, the architecture shown below was developed to extract and automate the reoccurring refresh of data.

image

For this example, Stetson University extracted data from BANNER using Argos for Enterprise reporting and exported to Excel.  While Stetson University used Argos to extract the data, any data extraction tool, such as SQL Server Integration Services (SSIS), can be used.

The download zip file contains the following items to help you quickly create your own retention report:

· a step by step guide to setting up the files and configuring Power BI,

· a Data Dictionary, which contains detailed information on the FTIC (first time in college) views, tables, and variables used to create the extracted data file,

· a sample Excel source data workbook, and

· the Higher Education Retention report template which contains the data model and reports.

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

4 thoughts on “Higher Education Retention Analytics using Power BI

  1. Permalink  ⋅ Reply

    David Tavares

    June 29, 2016 at 2:46pm

    Hi Patrick,

    I am getting this error when I connect to the FTIC.xlsx.

    Expression.Error: The Column ‘PIDM’ of the table wasn’t found

    • Permalink  ⋅ Reply

      pleblanc

      October 6, 2016 at 12:36pm

      Yep. I fixed that error in the new download. If you download the latest copy it should be fixed. If not email me at Patrick@sqllunch.com and I will assist.

Leave a Reply to pleblanc Cancel reply

Your email will not be published. Name and Email fields are required.