Are you new to Power BI and want to learn how to create a basic KPI report featuring BANS and trends? If yes, you should try to recreate this NCAA P&L basic KPI report in Power BI.
The WOW21 W1 and WOW21 W2 challenges are available on the Workout-Wednesday website.
Table of Contents
show
Learning Outcome
The learning outcome of this challenge are as follows:
- Create a simple data model
- Create a formula using M code
- Learn how to format basic headers and visuals
- Publish your report
Dataset
The dataset is a breakdown of the NCAA athletic department expenses and revenues by year.
Download the NCAA profit and loss dataset here.
Requirements
Guide
- Using the Power Query Editor,
- Use the first rows in the school_dim table as headers
- Remove NULL and aggregated values in the FBS Conference column as stated in WOW21 W1 challenge
- Add Custom Column. Name it Total Profits
- Add your formula to the Total Profits custom column as follows:
= [Total Revenues] - [Total Expenses] + [Excess Transfers Back]- Set the data type to decimal
- Click “Save & Apply”
- Proceed to create your dashboard
- Publish your dashboard
Result
In less than 15 minutes, I was able to recreate the NCAA P&L basic KPI report dashboard in Power BI.
Here’s what I achieved.
Happy Analyzing!