Term Census Report Deep Dive Training Video

This training video explains how to use the Term Census Report to answer the hypothetical questions, "What has the trend been in new first-time freshmen student enrollment in your program during the Fall quarter in the last 5 years? What about the last 10 years? Has there been growth or contraction of all new students, graduate and undergraduate, in your program for the last 10 completed years annually?" and export findings as an Excel document.

Tasks

  • Identify relevant Power BI tools for the Term Census report.
  • Apply slicers toward answering hypothetical questions 01, 02, and 03.
  • Create bookmarks focused toward answers for each hypothetical question.
  • Identify different export options and export table focused results.

Chapters

  • 0:00 - Introduction
  • 0:44 - Overview of Power BI
  • 1:44 - Navigating Pages and Applying Slicers
  • 2:34 - Answering Question 01
  • 4:06 - Creating a Bookmark for Question 01
  • 4:40 - Answering Question 02
  • 5:32 - Creating a Bookmark for Question 02
  • 6:35 - Answering Question 03
  • 9:39 - Creating a Bookmark for Question 03
  • 10:02 - Exporting Results
  • 11:15 - Conclusion