User ID:

User ID:

User ID:

User ID:

User ID:

User ID:

User ID:

Dimensional Data Modeling: Graph Data Modeling Day 3 Lab

Description

In this lab, we build a network of NBA players and see who they play against/with the most and for which teams!

Transcript preview: Dimensional Data Modeling: Graph Data Modeling Day 3 Lab

Welcome to Dimensional Data Modeling Day 3 lab. In today's lab, we are going to be doing a hands-on exercise where we are going to be building a graph data model to see which NBA players play with each other in games and which NBA players are a part of which teams at which time. So we will be building very data agnostic thing in post-res that will allow us to analyze these complex. Relationships between players, uh, to be ready for this lab, make sure you have Docker installed, make sure you have the repo in the description below cloned and that you have Docker up and running and you can connect to postcress with a visualizer something like Data grip or DB visualizer D Beaver, one of those SQL editor tools is gonna be super important to get you to where you want to go here. You could use PG admin too, I guess, but I hope you enjoy the lab today and if you want to do more of these hands-on exercises with hot technologies like iceberg and Trino, definitely check out the Data Expert Academy in the description below, and I hope to see you there. Oh, in the presentation, right, we talked a lot about vertexes and edges. So that, that's what we're gonna do is we're gonna do a create table here. We're gonna call this, um, we call this vertices, right? Cause that's actually the correct name here. So then we're gonna have identifier, that's a text. And then you have a type, which is gonna be a vertex type. Oh, I already have vertex type in here.