After a long week of upsetting data, we finally got some fun data to work with, Harry Potter!  I knew for this one I would focus a bit more on formatting and presentation and as the data was quiet clean I could spend a bit more time on the fun stuff rather then data processing.  The data was from Kaggle and can be found at this link  It contained all the characters, spells, locations, movies, and finally all the words spoken throughout every film.    I decided I was going to try and find the most magical parts of Harry Potter world, which means the places with the most spells.  I had a lot of fun with this one so let’s get into it!



There wasn’t really anything needed for this data, just to join it all together.  I did so on the provided IDs and then did a text match for the spells as there was no spell ID in the other sets.  I won’t waste time explaining, you can see the simple workflow below:


The Dashboard

The dashboard starts with some BANS showing the spell summaries for all seasons, under that I had some sparklines just to set the stage and provide some overview.  Before I get into the detail, I did get a bit carried away and wish I had more time to really drill down into some of the details and add some more features.  Nonetheless I still think it is a good dashboard. Following the BANs I explain what I classify magical as and show that spells are normally distributed over a movie and unfortunately do not mean more money.  Harry Potter fans must not be fans of action.


Moving down a level onto location I used dynamic zoning so that when the user clicks on a place category it brings up another bar chart with the 5 most magical locations within that category.  Nothing too surprising here just that a lot of magic happens in the classroom.


Drilling down again I wanted to look into houses, and seeing as Harry, Ron & Hermione are all in Gryffindor, it was pretty obvious what house was going to be most magical.  I wanted to add a bit more to this one in the tooltips and interactivity but ran out of time.  I made a bar chart for each house on the left and a line chart tracking their progress over movies on the right.  I also set up a highlight action so it is easy to track each house’s progress.  The bars on the left required some unique formatting to get the colours in without breaking the colour scheme so I created a dual axis with labelling on 0.


Next I broke down the wand performance and seeing as each person usually on uses one wand type it was Hermione’s and Harry’s wands that were the most magical.  I also tracked each wand core most popular spell, In the tool tip I had which wizard used it most and on the right I had the most popular spells. These spells were also filtered by selecting the wand core.  I also introduce a measure select which chooses between spell count, unique spells, and % of using spells that are unique.


The last piece of information is the lowest level of detail, the wizards.  There is no surprises here, Harry and Hermione are the top two by a long shot.  On the right I plotted the measure select over time and interestingly Hermione had the most unique spells in Movie 7.  She also has the fifth highest rate of using unique spells, combining that with her amount of total spells I would say she is contending for the best wizard overall.  This also has a highlight action for each wizard and some fun formatting for the colours.




Well, dashboard week is finally over and what a way to end it.  I learnt and stressed a lot this week but I am happy to have done it.  Harry Potter to end it was great, I got to spend a lot of time focusing on formatting and I got to use Figma for the first time in a real dashboard.  Thanks for checking out my blogs and dashboards.  Check this one out at the link below.



Mikael Nuutinen
Author: Mikael Nuutinen