Visualizing StudentTrackerSM Detail Report data with Power BI
John Grubb, Northeast State Community College
This workshop is a hands-on experience working with your own institutional data. Participants will work with the facilitator and other participants to shape and visualize national student clearinghouse data. Each participant should bring:
A laptop with Power BI preloaded (no license necessary) and extension cord
A StudentTrackerSM Detail Report from the National Student Clearinghouse that was requested well before the conference and loaded on your laptop. Please delete SSN and Name columns ahead of time. However, be aware that each student record may consist of many rows of data and will need a unique identifier for the process, such as Banner ID or a surrogate unique ID, which will enable us to filter student data.
Optional: Your institution may want to supplement the National Student Clearinghouse data with additional data points such as program or demographic data, which would need to be joined to the National Student Clearinghouse data via the Banner ID or other unique identifier. We may not have time for optional data, but If the work goes well, we will consider enhancing data.
Deliverables include detailed instructions for the session and your own visualization of the data.