FANTASY FOOTBALL EDITION

dbt™ Data
Modeling Challenge

Data enthusiasts, it's time to showcase your skills! Join Paradime and Lightdash for an exciting dbt™ data modeling challenge. Derive insights from real fantasy football data and compete to win up to $1,500!
🔥 Join now 🏈
SOCIAL MEDIA EDITION

dbt™ Data
Modeling Challenge

📣 The challenge has ended—more coming soon! Stay tuned! 🔥
Social media logos icon image collage
Logo icon - ParadimeLogo icon - LightdashLogo icon - GithubLogo icon - Github
Movie poster photo collage

Why Join This Challenge?

  • Showcase your SQL, dbt™, and analytics expertise
  • Work with cutting-edge tools used by top tech companies
  • Analyze real-world social media data to showcase your creativity and analytical prowess
  • Win Amazon gift cards worth up to $3,000
  • Build your portfolio and career prospects
  • Network with industry professionals and peers
Start Your Data Adventure 🌟
Movie poster photo collage

Why Join This Challenge?

  • Showcase your SQL, dbt™, and analytics expertise
  • Work with cutting-edge data tools
  • Analyze real-world NFL & fantasy football data
  • Win Amazon gift cards worth up to $1,500
  • Build your portfolio and career prospects
  • Network with like-minded industry professionals
Start Your Challenge 🌟Start Your Data Adventure 🏈

Challenge Overview

Welcome to the dbt™ Data Modeling Challenge - Fantasy Football Edition! This global competition invites data practitioners to transform raw fantasy football data into powerful insights. Use Paradime, Snowflake, and Lightdash to craft SQL queries, develop dbt™ models, and create compelling visualizations. Uncover trends and tell data-driven stories that will wow the judges for a chance to win $1,500.
Key dates:
  • Start: January 2, 2025
  • Submission Deadline: February 4, 2025, 11:59 PM PT
  • Winners Announced: February 6, 2025 (Right before the Superbowl!)
Make an Impact Now 🔥
Movie poster photo collage

Prizes

Show off your data skills and win big!
#1
$3,000
Amazon gift card
#2
$2,000
Amazon gift card
#3
$1,000
Amazon gift card
Compete for the Top Spot 🏆
Exciting winning movie scene Polaroid collage represents the prize for data modeling challenge winners
Movie poster photo collage

Prizes

Show off your data skills and win big!
#1
$1,500
Amazon gift card
#2
$1,000
Amazon gift card
#3
$500
Amazon gift card
Compete for the Top Spot 🏆

About the challenge

A whistle-blowing icon represents the start of the challenge.
Ready, Set, Analyze
January 2, 2025
An alarming alarm clock icon represents the challenge timeline's deadline.
Submission deadline
February 4, 2025,
11:59 PM PT
A loudspeaker icon indicates the time of the challenge winner announcement.
Winners announced
February 6, 2025

How it works

  • 1. Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.
  • 2. Use Snowflake for data warehousing and compute.
  • 3. Use Paradime to develop dbt™ models.
  • 4. Use Lightdash to analyze the datasets and create visualizations.
  • 5. Submit your GitHub repository with code and insights in README.md.
  • 6. Our expert judges independently score each submission.
  • 7. Winners announced!
Detailed instructions and resources provided upon registration. Check out the Challenge's GitHub repo for more details.
Begin Your Data Journey 🗺️

Who should participate?

  • Data Analysts
  • Analytics Engineers
  • Data Engineers
  • Data Scientists
  • Anyone passionate about data and fantasy football!
This is a solo challenge to showcase your individual talents. Participants should have hands-on experience with SQL, dbt™, and Git.
Show Us What You've Got! 💪

Tools you'll use

While these tools are required in this competition, we encourage you to use additional tools and technologies to enhance your project.
  • Paradime: The AI-powered, one-stop-shop analytics engineering platform for dbt™.
  • Snowflake: Industry-leading cloud data platform for secure and scalable data warehousing.
  • Lightdash: The open-source business intelligence tool that brings your dbt™ metrics to life with powerful visualizations and collaborative features.
  • GitHub: Version control and project submission
Master Industry-Leading Tools 🛠️
Master Industry-Leading Tools 🛠️

Judging Criteria

Our challenge will be evaluated by an esteemed panel of industry experts:
Judging Criteria:
  • Value of Insights (1-10): Are the insights interesting and relevant? Get creative! Uncover something fun and accurate that you'd find compelling in fantasy football analysis.
  • Complexity of Insights (1-10): Are you creating relationships between datasets and providing in-depth analytical conclusions? While complexity doesn't equal value, using multiple datasets can enhance insights.
  • Quality of Materials (1-10): Is your code of professional quality? Are your data visualizations well-designed? Are your insights clear to the reader?
  • Integration of New Data (1-10): How effectively have you integrated new, relevant data to enhance your project? Adding additional datasets can positively influence other scoring criteria.
For a detailed breakdown, refer to the full challenge details below.

Challenge details

A plus icon, which serves as the accordion trigger in FAQ section

Entry requirements

  • Participants must be current or former data professionals (Data Analysts, Analytics Engineers, Data Engineers, Data Scientists, etc.).

  • Solo participation only (no teams).

  • Must have hands-on experience with SQL, dbt™, and Git.

  • Participants must use, but are not limited to, the following tools:

  • Must be able to explain their code and insights. You can use ChatGPT, but you better understand it! 🤣

A plus icon, which serves as the accordion trigger in FAQ section

Challenge deliverables

Participants are expected to submit:

  • A GitHub Repository containing:

    • Code: Your dbt™ models and any other applicable scripts (Example).

    • README.md: Tell the complete story of your project - from data sources and methodology, to visualizations and key findings (Example).

A plus icon, which serves as the accordion trigger in FAQ section

Judging criteria

  • Value of insights (1-10):
    Are the insights interesting and relevant?

  • Complexity of insights (1-10):
    Are you creating meaningful relationships between datasets and providing in-depth analysis?

  • Quality of materials (1-10):
    Is your work polished and professional?

  • Integration of new data (1-10):
    How effectively have you leveraged additional datasets to enhance your findings?

A plus icon, which serves as the accordion trigger in FAQ section

Judges

A picture of Emily Hawkins, the judge of the data modeling challenge.
(Analytics Engineering,  GlossGenius)
A picture of Jake Hannan, the judge of the data modeling challenge.
(Data Platform, Sigma)
fabio
(Co-founder, Paradime)

Time is running out! Join the challenge now

📣 Please review the entry requirements to ensure you qualify
Thank you! We have received your submission and will be in touch shortly with next steps!
Looks like something went wrong while submitting the form. Can you try again?

Frequently Asked Questions

How can I obtain technical support?

A plus icon, which serves as the accordion trigger in FAQ section

For all technical support and challenge inquiries, use Paradime's #fantasy-football-challenge Slack channel.

Is seeking external assistance permitted?

A plus icon, which serves as the accordion trigger in FAQ section

Yes. While your submission must be your own work, you can use your network, online resources, and even ChatGPT for inspiration and learning.

Am I allowed to incorporate additional data?

A plus icon, which serves as the accordion trigger in FAQ section

Yes, incorporating additional data is required. The sample data we provide is optional.

Do participants begin from scratch?

A plus icon, which serves as the accordion trigger in FAQ section

No. We provide you the following resources:

Am I allowed to incorporate additional data sources?

A plus icon, which serves as the accordion trigger in FAQ section

Yes, incorporating additional data is required. The sample data we provide is optional. Any data you bring in must be user-generated social media data or relevant supplementary data.

Is this event a hackathon?

A plus icon, which serves as the accordion trigger in FAQ section

Not exactly. This is a 4-week, asynchronous competition. Participants work on their own time and submit by the deadline (February 4, 2025)

If I win, how will I receive a gift card?

A plus icon, which serves as the accordion trigger in FAQ section

Winners will receive an Amazon e-gift card via email.

What are some key strategies for developing insights from fantasy football data sets?

A plus icon, which serves as the accordion trigger in FAQ section

Aim to generate accurate and interesting insights. They should be "scroll stoppers"! Some ideas to explore:

  • Potential Insight Areas with Pre-Loaded Datasets:

    • Top Performers by Week/Season: Using player_stats_by_game, identify highest-scoring players each week and over the season.

    • Team Defense Impact: Using play_by_play, determine which defenses give up the most fantasy points by position.

    • Red Zone Efficiency: Using play_by_play, pinpoint which players or teams excel in scoring opportunities inside the 20-yard line.

  • Potential Insight Areas with External Datasets:

    • Top scoring players by week/season

    • Player consistency analysis (boom/bust metrics)

    • Impact of team matchups on player performance

    • Identifying players with high injury propensity

    • Forecasting 2025 draft prospects

    • High-cost/low-value player analysis

    • Exploring fantasy football drafting strategies:

      • Best Player Available (BPA)

      • RB-Heavy early drafting

      • Balanced roster construction

      • And more...

For technical support, visit Paradime's #fantasy-football-challenge Slack channel or the Lightdash Community. Participants can use additional tools and data sources to enhance their projects. However, all submissions must be individual work.
Join the Slack Community 💬