2022 Week 15 | Power BI: March Madness

Introduction

For basketball fans in the United States, March is a special time.  It is when 64 of the best college basketball teams match up in a single elimination tournament to see who is the NCAA Men’s Basketball champion.  The early rounds of the tournament provide long days of basketball games across several TV stations.  This is why it is called March Madness.  There is nothing quite like a huge underdog taking down a top ranked team.

We are continuing the color theme in April and this challenge will use several matrix color options.  As a fan of March Madness, I wanted to do incorporate it into this challenge.  What I found was I did not see any good examples of tournament brackets being created in Power BI.  

While this could likely be done using a custom visual, I wanted to keep the visualization more simple.  As such, I have developed a dataset that will allow you to create a bracket in Power BI, showing the results of the last 8 teams left in the NCAA Men’s basketball tournament.

While there is a mathematical way to identify the row in the dataset as well as the winner, I was not out to torture anyone this week, so I decided to include it.  Feel free to write the measures necessary to do this for extra credit.

Requirements

LET’S START THE MADNESS!!!

  1. Download the excel file from data.world.
  2. Load the data into Power BI  — Consider how you’d like to join the data
  3. Using the matrix visual, recreate the NCAA Men’s Basketball Elite Eight Bracket
  4. The champion does not need to be visualized with the rest of the bracket.  Feel free to show the champion using whatever method you choose.
  5. Pay close attention to all color options including background, text color, text on/off, as well as conditional color formatting
  6. Have fun with the challenge!  See if you can do any additional interesting things with the formatting.

 GOOD LUCK!

Dataset

This week you can find the data here. You have the option to build the data model from scratch or start with the completed data model.

Share

After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke@MMarie, @shan_gsd, @KerryKolosko, and @NerdyWithData. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year. 

Solution

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top