Are you looking for fun new data to practice your data visualization skills?
Excited for Harry Potter’s 20th Anniversary special coming in January?
We have just what you need, including another chance to win a free all-access membership to Maven Analytics!
We’ve just added a brand new data set to the Data Playground, containing the scripts from the Harry Potter movie franchise.
There is a ton to explore and visualize here, so pull out your wand, fire up your favorite BI tool (Excel, MySQL, Power BI, Tableau, etc.), and make the magic happen!
To go along with this release, we’re launching the Maven Magic Challenge and giving away a free all-access membership to the winner.
We’ll share more about the challenge details below, but first let’s talk about the data…
About the dataset
This dataset contains 6 tables in CSV format
The Dialogue table contains all 7,444 lines of dialogue from the 8 Harry Potter movie scripts, and contains foreign keys that can be matched to a specific chapter, character, and place from the Wizarding World
The Chapters table contains the 234 chapters from the Harry Potter movie scripts, with fields containing the chapter name and number, and the related movie
The Movies table contains the 8 movies from the Harry Potter series, with fields containing the movie title, release year, runtime, budget, and box office revenue
The Characters table contains the 166 characters that had lines of dialogue in the movies, with fields containing the character’s name, species, patronus, and more!
The Places table contains 74 locations from the Wizarding World, with fields containing the place name and category (Hogwarts, Hogsmeade, etc.)
The Spells table contains the 61 spells cast in the movies, with fields containing the incantation, spell name & effect, and the color of the light cast (HINT: Try to search for the incantation in the movie dialogues to join the tables!)
How to play the Maven Magic Challenge
To participate in this challenge, all you need to do is share a single page visual that captures the magic of the Harry Potter movies.
Here’s how to submit your entry:
Share a LinkedIn post mentioning @Maven Analytics and the hashtag #mavenmagicchallenge, with your single page visual based on the challenge objective above
Complete the official challenge submission form to make sure you are entered for a chance to win
Make sure to follow Maven Analytics on LinkedIn for updates on the challenge and invite your connections to play along!
How to win
Finalists will be chosen by the Maven team based on creativity, design, and visualizations. The winner will be selected from the finalist pool by the Maven team, via live voting.
What you can win
As part of the Maven Magic Challenge, we'll be giving away 1 annual all-access Maven membership completely free of charge. The winner will get access to all of our Excel, Power BI, Tableau, and SQL courses, as well as our ongoing Machine Learning series, all with direct support and coaching from our expert instructors.
No purchase is necessary to participate. As always, this challenge is open to both current Maven subscribers and everyone else.
Check out the official rules below...
Official Terms (Maven Magic Challenge)
Maven Analytics will give away 1 Annual subscription for an Individual account. After the one year period, the subscriptions will expire.
No purchase is necessary to enter.
Data Analyst Bootcamp is not included in this prize. That is a separate offering, and not eligible.
The challenge will close to new entries on Friday, December 31st, 2021, at 11:59pm Eastern Standard Time. All entries must be submitted prior.
After the submission deadline, finalists will be chosen by the Maven team.
Maven Analytics will select 1 winner from the finalists, and will announce the winner on Wednesday, January 12th, 2022 at 10:00am Eastern Standard Time. The official announcement will be posted on LinkedIn from the Maven Analytics LinkedIn account.
Don't want to participate in the Maven Magic Challenge? No problem. You can still analyze the data on your own. All of the Data Playground datasets are completely free and are available for everyone to learn with. Feel free to dig in anytime.
Check out the Harry Potter Movie Scripts dataset, and many more, at the Data Playground.
Happy analyzing!
BLACK FRIDAY CAME EARLY!
Save up to 50% on Maven Pro plans today!
This week, we're offering up major discounts on individual subscriptions at Maven Analytics. Don't wait -- this offer ends Wednesday, November 6th!
Enrique Ruiz
Sr. Learning Experience Designer
Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.