Welcome to the second half of “Conquer Your Bracket with Power BI“. Hopefully you enjoyed the first half, and if you missed it here is a link back. As I stated in my Part 1 of this blog, Power BI is a great data visualization tool. So, in Part 2 I will be showing you the report I created to coincide with our bracket tournament contest.
For testing and demo purposes, I created a demo mockup of the report. It is identical in format, but the data is not related to any of the contest data (For the real report, go here.) Feel free to explore the report pages and follow along with my descriptions below. All the pages are interactive so don’t be shy to play around with all the fun features!
Leaderboard: The leaderboard page displays information for the Top 20 users. It shows the points per round in one graph, and the overall score in another. There is also a list displaying the user names and overall rank.
User Page: This page shows a detailed breakdown of an individual’s points by round, their overall score, current rank, and accuracy. The user simply searches the slicer for their name and voila! All the boxes change displaying that user’s information.
Participation Breakdown: The heat map gives us a visualization of our impact for this campaign. All we are doing is taking zip codes, submitted by the users, and using the filled map visualization to display the number of users within the states. It works internationally as well! Note: You might have to scroll in and out inside the map to bring the US into view.
Tournament History: To be honest, I just really wanted to use the tree map visualization, it’s my favorite! All the information on this page came from Wikipedia and the NCAA tournament history page. Power BI is able to use many different data sources to supply your reports. I used the URL of the web pages, and Power BI looked for any tables I could use. From there I imported what data I wanted to show, and picked the appropriate visualizations. This page lets the user see how many titles were won by which schools from 1939 to 2015. If you pick a date in the “Year” slicer, it will show you what school one that year, who the coach was, their record for that season, their opponent, and the final score of the championship game. Pretty sweet, huh?
All in all, Power BI is a fantastic tool for making your data come to life! As with all software it does have its limitations, but Power BI continues to keep improving.