Portfolio Project · Kaggle Dataset Analysis

Harry Potter Movies
Analytics Dashboard

Dialogue · Characters · Spells · Locations · All 8 Films
Source: Kaggle — maricinnamon/harry-potter-movies-dataset

Samuel Then · Data Analyst · SQL · Tableau

View on GitHub → SQL Queries · Tableau Preview
8
Films Analyzed
7,312
Total Dialogue Lines
166
Unique Characters
61
Unique Spells
74
Locations Referenced
Top 10 Characters by Dialogue Lines All Movies
Harry Potter
1,854
1,854
Ron Weasley
853
853
Hermione Granger
831
831
Albus Dumbledore
469
469
Rubeus Hagrid
226
226
Severus Snape
165
165
Minerva McGonagall
129
129
Horace Slughorn
125
125
Voldemort
118
118
Remus Lupin
110
110
Key Insight
Harry Potter leads with 1,854 lines — 25.4% of all dialogue across 8 films. Gryffindor characters account for the vast majority of screen time.
Dialogue Share by House
7,312
Total Lines
Gryffindor 71.8% · 5,253
Slytherin 11.6% · 850
Ravenclaw 3.0% · 221
Hufflepuff 0.8% · 56
Dialogue Lines per Movie All 8 Films
1
Philosopher's Stone
867
2
Chamber of Secrets
974
3
Prisoner of Azkaban
860
4
Goblet of Fire
733
5
Order of the Phoenix
1,127
6
Half-Blood Prince
1,050
7
Deathly Hallows Pt.1
996
8
Deathly Hallows Pt.2
705
Key Insight
Order of the Phoenix has the most dialogue (1,127 lines), while Deathly Hallows Pt. 2 has the fewest (705) — consistent with the finale's action-heavy, dialogue-light pacing.
Most Referenced Spells By Incantation in Dialogue
Spell Incantation Type Mentions
Patronus CharmExpecto PatronumCharm12
General Counter-SpellFiniteCharm11
Wand-Lighting CharmLumosCharm10
Disarming CharmExpelliarmusCharm8
Boggart-Banishing SpellRiddikulusCharm7
Summoning CharmAccioCharm7
Imperius CurseImperioCurse5
Unlocking CharmAlohomoraCharm5
Impediment JinxImpedimentaJinx4
Killing CurseAvada KedavraCurse4
Harry vs Hermione vs Ron — Lines per Film
P.S. C.S. P.A. G.F. O.P. H.P. DH1 DH2
Harry
Hermione
Ron
Top Locations Referenced
P.S. C.S. P.A. G.F. O.P. H.P. DH1 DH2
Chamber of Secrets
Ministry of Magic
Godric's Hollow
Ministry of Magic
Godric's Hollow
Samuel Then · Data Analyst · Portfolio Project · 2025
SQL Tableau Advanced Excel DAX
Data: Kaggle · maricinnamon/harry-potter-movies-dataset