Home

Awesome

dbt™ Data Modeling Challenge - NBA Edition

Welcome to the Paradime dbt™ Data Modeling Challenge - NBA Edition!

Table of Contents

  1. Getting Started
  2. Competition Details
  3. Building Your Project
  4. Example Submission

Getting Started

Step 1: Registration and Verification

Step 2: Account Set-Up

After verification, you'll receive two emails from Paradime:

  1. Snowflake Account Credentials: Contains your Snowflake account details. Search for an email with the subject line "Start Your NBA Data Modeling Challenge – Your Snowflake Credentials."
  2. Paradime Platform Invitation: An invitation to access the Paradime Platform. Search for an email with the subject line "Final Step: Activate Your Paradime Account for the NBA Challenge."

Step 3: Paradime Account Configuration

Step 4: Kickstart Your Project

Need Help?: Join the #nba-challenge channel on Slack for assistance.


Competition Details


Building Your Project

Now that you're set up, you have until March 8, 2024 to complete and submit your project!

Step 1: Getting to Know the Paradime Editor

Step 2: Getting to Know the NBA Data Sets

Explore 7 NBA data sets provided by Paradime, each with primary and foreign keys for insightful analysis. Detailed information about each dataset is available in the staging files and YAML file. If reading YAML file is confusing, you can learn about each data set and columns in within the Paradime Catalog UI

Step 3: Generating Insights

Your goal is to build dbt™ models that reveal compelling insights for NBA fans and General Managers. Here are some suggested topics:

Creating Data Visualizations

Choose any data visualization tool. Paradime has various BI tool integrations like Power BI, Lightdash, Metabase, Preset, Tableau, Metabase, and Looker.

Alternatively, Alternatively, export the data behind your dbt™ models from Snowflake to .csv files. Note: We'll verify if the .csv export matches your dbt™ models. [Add screenshot]

Submitting Your Project

Submission deadline: March 8th, 2024 Submit the following to Parker Rogers (parker@paradime.io) upon completion:

Example Submission

Here's an example project that fulfills all requirements and would be elligble eligible for cash prizes. Feel free to use this template for your submission, but ensure your insights are unique!

Table of Contents

  1. Introduction
  2. Data Sources
  3. Methodology
  4. Visualizations
  5. Conclusions

Introduction

Explore my project for the dbt™ data modeling challenge - NBA Edition, Hosted by Paradime! This project dives into the analysis and visualization of NBA statistics, designed for basketball enthusiasts and analysts.

My GitHub repo

Data Sources

My analysis leverages three key NBA datasets from Paradime:

Methodology

Tools Used

Applied Techniques

Visualizations

Team Playoff Appearances

Visualization of playoff appearances for all 30 NBA teams, including their playoff appearance rates.

Team Playoff Appearances

Insights: The Los Angeles Lakers' dominance in playoff appearances, and the San Antonio Spurs' highest playoff appearance rate. The Spurs have only missed the playoffs 9 times!

Player Playoff Games

Assessment of NBA players with the highest number of playoff game wins and their win percentages. The '*' next to NBA Player name indicates if they're a member of the NBA Greatest 75 Team

Player Playoff Games

Insights: LeBron James has the most playoff wins of any player, but here's what's most interesting: Of the 25 players with the most playoff wins, only 12 of them are members of the NBA Greatest 75 team. There are several players listed that impact playoff wins and compliment their team's best players, but aren't known as on the the all time greats, such as: Derek Fisher, Robert Horry, Danny Green.

Top Playoff Scorers

Showcases players who achieved the the most points scored in any playoff season.

Top Playoff Scorers

Insights: Michael Jordan, LeBron James, and Kobe Bryant are the only players having three seasons within the top 25 highest most points scored in a playoff season.

Top Regular Season Scorers

Highlights NBA players who scored the most in regular seasons.

Top Regular Season Scorers

Insights: Wilt Champerlain is one of the best regular season scorer of all time. In addition to having the most points scored in any regular season ever (4,029), he also has six season in the top 25. The only other player with 6 top 25 seasons is Michael Jordan. In the chart above, notice that Wilt Champerlain doesn't appear once in the top 25 playoff scorers of all time 👀.

NBA Players by University

Displays which universities have produced the most NBA players.

NBA Players by University

Insights: Kentucky has produced the most NBA players in NBA history by a significant margin.... Go Wildcats!

Conclusions

This project offers key insights for NBA enthusiasts, such as: This project successfully extracts significant insights from NBA data that NBA fans would find interesting, such as: