This repository contains my solutions to the Workout Wednesday challenges, designed to improve data visualization skills in Power BI.
Workout Wednesday is a weekly challenge focused on re-creating complex data-driven visualizations. Each folder in this repository corresponds to a specific challenge, complete with the PowerBI workbook and any additional resources used in the solution.
Enjoy exploring the solutions, and feel free to reach out if you have any questions!
| Project Name | Description | Dataset | GitHub |
|---|---|---|---|
| 2021 Week 1 | Power BI: Connecting To & Modeling Data This challenge involves creating a cleaned dataset with teams from the Football Bowl Division and building a data model properly relating dimension tables to the fact table. The goal is to use as few steps as possible. |
Download Dataset | GitHub Repository |
| 2021 Week 2 | Power BI: Creating Basic KPI Report This task involves creating a basic KPI report using Power BI, incorporating important KPI reporting elements like BANs, trends, and breakdowns. The requirements include creating a new field for Total Profits and a KPI dashboard with high-level measures and trends. |
Download Dataset | GitHub Repository |
| 2021 Week 3 | Power BI: Adding Slicer and Interactivity This challenge involves enhancing the KPI report by adding a slicer for Year and editing interactions for better filtering of KPIs and bar charts. The goal is to improve interactivity and visualize how much money the MAC conference made in 2016. |
Download Dataset | GitHub Repository |
| 2021 Week 4 | Power BI: Drill Through This week focuses on adding drill through functionality from a Summary View to a School View, allowing further analysis of NCAA Conference expenses and revenues. The challenge also involves determining which school contributed the most to the MAC's financial losses in 2016. |
Download Dataset | GitHub Repository |