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:

1. Share a LinkedIn post mentioning @Maven Analytics and the hashtag #mavenmagicchallenge, with your single page visual based on the challenge objective above

2. 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!