In the previous tutorials we have fetched the tennis_wta data, transformed and loaded it in the data lake. We will now use Power BI Desktop to connect to this data lake, load and further transform the data in Power Query, build a data model and interactive reports on top of it.
But before we begin, let’s take a moment to think about what information we would like to see in these reports. How are we going to use them? What are the points of interest that will bring valuable information and insights to our audience? Having a purpose in mind is the first step towards shaping and modeling the data in a way that it will provide answers to our questions.
Consider your audience and tell a story on one screen.
For whatever reason, I am maybe someone curious to know who is last year’s winner of the US Open. Or who played the Rogers Cup final two years ago.
Or I am a fan of Serena Williams, and I want to see an overview of her entire professional activity: tournaments, wins, rankings, evolution over time.
Or I want to see how Naomi Osaka compares to Ashleigh Barty: number of tournaments, wins, rankings over time.
Sketch out your ideas first.
Use a tool of your choice to create a mockup. It doesn’t matter if you use Excel or Power Point or even Power BI Desktop.
Tournament Overview Report
The first Power BI report we will build will provide an overview of tournaments.
I want to be able to filter by date (year/month), see the list of all the matches played during a tournament, all sets and scores of a specific match, as well as how the match opponents compare to each other in terms of wta points, ranking or number of tournaments.
I used Excel to sketch the Tournament Overview report.
What’s next
Our first Power BI goal is to build the the Tournament Overview report. Open Power BI Desktop and let’s get started.
Want to read more?
Microsoft learning resources and documentation:
How to Design Visually Stunning Reports
{ DataWhale.ca } 