Retention Analytics

Patrick LeBlanc shows collegiate retention data 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 BANNER 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.

This also serves as a Power BI demo, in case you’re hurting for good examples.

Related Posts

SUM() Or SUMX()

Matt Allington explains when to use SUM() or SUMX() in DAX: Example: Total Sales SUMX = SUMX(Sales,Sales[Qty] * Sales[Price Per Unit]) SUMX() will iterate through a table specified in the first parameter, one row at a time, and complete a calculation specified in the second parameter, eg Quantity x Price Per Unit as shown in […]

Read More

Drilldown Player Custom Visual

Devin Knight continues his Power BI custom visuals series: In this module you will learn how to use the Drilldown Player Custom Visual.  The Drilldown Player acts like a slicer that animates other visuals around it on your report. Click through for the video.  This can be a useful visual for kiosks or demonstrations, as […]

Read More

Categories

June 2016
MTWTFSS
« May Jul »
 12345
6789101112
13141516171819
20212223242526
27282930