As a first report on PowerBI, we had to use a dataset composed of information about the different MakeOvermondays since the start of the learning event.
The first step I took was to decide whas I'd want to look at, since we had fields about the size of the data, number of rows, columns, and cells, I decided to look at how the size of data evolved through the years.
My second step was to transform the data using PowerQuery. The data cleaning step started with the removal of empty fields left in the data. As I planned to look at the data over time, I create a date field from the combination of years and week. As the years were originally a number and not a date, I used the create column from example to transform it myself into a data, to which I added 7 days per week from the week number field.
I also decided to calculate my running totals in PowerQuery. Looking back I would not do it this way again, instead I would use the quick measure tool to create the running totals of all the measures I want.
I then started building my report. First, I built the KPIs, representing the total data used (in Gb), number of cells, rows and columns since the start of MakeOverMonday.
Next up was the first line chart, for this I created a parameter which allows the user to select between looking at the size over time or the number of cells. This is a really cool functionality that is so simple to apply in PowerBI!
Then I build my third chart, showing the trend in Rows vs Columns over time, showing how both measures changed over time, showing how massive the temperature anomalies data was!
This leads us to the tooltip, for both chart I wanted to be able to know which dataset was represented in each data point. I therefore made a viz just to get the Week number, year and name of the dataset when hovering a point.
The last step was just to format, for this I used the format painter tool (https://www.thedataschool.co.uk/jules-claeys/power-bis-format-painter/) as well as grouping (https://www.thedataschool.co.uk/patrick-maguire/grouping-and-aligning-in-power-bi-how-does-it-work/).
Then just had to publish it to my workspace and public it here:
Also available here: https://app.powerbi.com/view?r=eyJrIjoiNzZmMjkyZTYtNGY3Ny00N2M0LThjZmItZTIxZmM2ZmM3MmU3IiwidCI6ImNlZjk5OTUzLWM0OTYtNGE4MS1iMDYxLTNlYmU1ODRjY2ZjYyIsImMiOjh9