Dashboard Day 5

Today marks the final day of dashboard week, and we were provided with some data from the Harry Potter movies series. Now if you aren’t familiar with Harry Potter, it essentially follows a young wizard’s journey through Hogwarts School of Witchcraft and Wizardry, battling dark forces while uncovering his true destiny. The dataset we were given essentially contains all of the dialogue information for the entire series, what chapter they occurred in, and what movie they occurred in. From this data, my goal was to discover who had the most lines of dialogue, and who spoke the most words per line of dialogue.


Since the data was very cleaning, bringing all the datasets together was a breeze. All that was required was to determine the new measures I would be creating. To determine the number of lines of dialogue, I simply ran a batch macro that would count the number of times a specific character spoke in a given combination of movie and chapter. From this batch macro and the new lines of dialogue measure, I could then use a combination of formula tools (mainly regex) to get the words per line spoken.


Now that I have all the measures I desired, I could start building the dashboard. To find the character that had the most lines of dialogue, I used a combination of bar charts. The first gave the most prominent character at face value, and the second was more investigative so that users could investigate where people were speaking the most. To visualize the average words spoken per line, I used a combination of a bar and a line chart. The first bar chart simply gives the average number of words spoken per line for a character, and the line chart gives context into how the average number of words spoken per line has changed overtime.

To see the full dashboard, check out this link: https://public.tableau.com/app/profile/jay.mcintosh/viz/HarryPotterTheBoywhoGetsStraighttothePoint/HarryPotterDashboard

To see the source of data, check out this link: https://www.kaggle.com/datasets/maricinnamon/harry-potter-movies-dataset?resource=download