I got homework for May 20, when I’m done with the Techionista training
Thanks for sharing, Petra, I like seeing thought process in your posts. If you’d like to iterate, you may try outlined (unfilled) for the recommended hours so that your hours spent become main focus. Flipping to horizontal would give more space for words, too. #SWDchallenge
First step: Make a table of the worksheet. Now it has all additional rows that do not contain the right information
Load the excel into PowerBI and do some transformations
Fill blanks in the “week nr” column
Replace the 1 null value in column “onderdeel”
In the column “begintijd” and “eindtijd” needs only to be time and no date
Recalculate the column “totale tijd”
The column “in uren” rounded to 2 decimals
Oh the column “totale tijd” is not giving the right values, I want to see the amount of minutes in there, back to Edit Queries, to find out why. Ah Data Type was Any, changed that to Duration en minutes
Yes my Data looks good
Add the excel file with the advised hours from Microsoft and Techionista
Do some transformations
Check the relation between the two tables
First visualization; a bar chart showing my hours, compared with Microsoft and Techionista
Conclusion hours by subject
The red bars show the hours that where planned by Techionista, black is what Microsoft advised, for 3 topics Techionista scheduled lesser hours than Microsoft advised. Green is what I actually have spend. For 3 subjects and the capstone I have spend more hours than Microsoft had advised.
The second visualization I want to make is a line chart, showing the time spend per day from the beginning to the end.
First I added a new table with dates, so I could use the date as the x-axis
Than I made a chart, where I visualised the hours per day and than the topic as legend. Only to realise that a line chart is not clear. So I changed it into a bar chart, which gave me the idea I wanted to see.
I also made a table to show the description by subject
Conclusion hours by day and subject
The further I got into the study, the more hours I have spend during the day.
This month is the first time I’m going to join the Challenge. My motivation is: practicing with a given dataset and show it to others and see what others have done with the same data. Looking forward to join.
Today I was reading a post on LinkedIn and thought, this looks interesting and challenging. It was a post about storytelling with data and they challenge people to do a practice making a visualisation in the first week of the month and to share it. I’m thinking of taking up this challenge this month, see how far I can get, with the knowledge I have right now and my available time.