Explore the world of Game of Thrones by running Cypher queries in Memgraph to find out the killer influencer, the most treasonous character and the real GoT winner!
Get the query collection: https://memgr.ph/GoT-Deaths-collection
Download Memgraph: https://memgraph.com/downloads
Check the docs: https://memgraph.com/docs
GitHub: https://github.com/memgraph
Discord: https://memgr.ph/discord00:00 Intro
00:37 Install Memgraph and load the dataset
01:57 Graph schema
03:09 Query collection used to explore the dataset
03:23 The basic queries counting episodes, characters and deaths
04:17 The number of episodes per season
05:30 Episodes without deaths
08:43 Suicides
09:37 Staying alive in GoT (PageRank)
13:54 GoT winners
15:44 Killer influencer (Betweenness centrality)
17:25 Jon Snow's analysis
18:33 The most treasonous character
19:30 The shortest path of killings with the highest victim count
20:19 Editing the graph style
0 Comments