Wednesday afternoon, time to sit down and have a look at the dataset of this week. Earlier this week I did not have the time, because last week I started a new job at TU Delft as reporting specialist. This job is working with Oracle BI Publisher en SAP Business Objects based on my SQL knowledge.
For the data used in this challenge there has been a survey among 1,000 parents in the US to find out what the average time is that their children sleep compared with the recommended hours by the CDC.
The data set has 13 rows and 3 columns. The original visualisation shows a table with this data and an extra column with the deficit in different colours.
When I imported the data, I created an extra column with index numbers to make sure I could sort the information on the right grade order if needed so. For the deficit I created a new measure.
In PowerPoint I have made a template to use a jpg background of all the pages of my PowerBI pages. It shows 3 fields, description of the challenge, the original visualization and my visualization. At the bottom there is a bar with the MakeoverMonday logo, the week number and a link to the challenge.
For these weeks challenge I wanted to use a visualization from the AppSource of PowerBI and found the visual “Line and stacked column chart with table” from Definitive Logic. During designing I have chosen not to use the line. I liked it because it is showing the numbers and a column chart.
The PowerBI file is having a page for every week that I have completed the challenge. There is a first page for the introduction, where there are bookmarks to go to the right week.
The tweet about this week drew attention and ended up in an article from NodeXL. I became an influencer. Feeling proud. https://nodexlgraphgallery.org/Pages/Graph.aspx?graphID=222716#headerTopHashtags