FANTASY FOOTBALL EDITION

dbt™ Data Modeling Challenge

The Data Modeling Challenge has ended – stay tuned for the next one!

FANTASY FOOTBALL EDITION

dbt™ Data Modeling Challenge

The Data Modeling Challenge has ended – stay tuned for the next one!

Why Join This Challenge?

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

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!)

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
September 9, 2024, at 11:59 PM PT
Winners Announced: September 12, 2024

Prizes

Show off your data skills and win big!

$1,500 USD

$1,000 USD

$500 USD

Ready, Set, Analyze

January 2, 2025

Submission Deadline

February 4, 2025, 11:59 PM PT

Winners Announcement

February 6, 2025

How It Works

Sign up for the challenge. If you meet the entry requirements, you'll receive all credentials to get started.
Use Snowflake for data warehousing and compute.
Use Paradime to develop dbt™ models.
Use Lightdash to analyze the datasets and create visualizations.
Submit your GitHub repository with code and insights in README.md.
Our expert judges independently score each submission.
Winners announced!

Detailed instructions and resources provided upon registration. Check out the Challenge's GitHub repo for more details.

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.

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.
Lighthouse: 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

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.
Lighthouse: 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

Judges Panel and Judging Criteria

Our challenge will be evaluated by an esteemed panel of industry experts:

Parker Rogers

Data, Paradime

Oliver Laslett

Co-Founder & CTO, Lightdash

Joshua Lee

Head of Analytics at The Undroppables

Marta Paes

Senior Product Manager, Materialize

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.

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 of each criterion, please refer to the full challenge details below. Our judges are looking for creative, insightful, and well-executed projects that demonstrate your data modeling and analysis skills. Good luck!

For a detailed breakdown, refer to the full challenge details below.

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.

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:
- Paradime for SQL & dbt™ development.
- Snowflake for data storage and compute.
- Lightdash for data analysis and visualizations.
- GitHub repository for version control.
Must be able to explain their code and insights. You can use ChatGPT, but you better understand it! 🤣

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:
- Paradime for SQL & dbt™ development.
- Snowflake for data storage and compute.
- Lightdash for data analysis and visualizations.
- GitHub repository for version control.
Must be able to explain their code and insights. You can use ChatGPT, but you better understand it! 🤣

Challenge Deliverables

Participants are expected to submit:

A GitHub Repository containing:
- Code: our dbt™ models and any other applicable scripts (Example).
- README.md: A narrative of your submission—how you built it, what you built, and the insights you discovered (with visualizations).

Participants are expected to submit:

A GitHub Repository containing:
- Code: our dbt™ models and any other applicable scripts (Example).
- README.md: A narrative of your submission—how you built it, what you built, and the insights you discovered (with visualizations).

FAQs

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 💬

How can I obtain technical support?

Am I allowed to incorporate additional data?

Do participants begin from scratch?

Am I allowed to incorporate additional data sources?

Is this event a hackathon?

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

How can I obtain technical support?

Am I allowed to incorporate additional data?

Do participants begin from scratch?

Do you have SLA guarantees? What support will I get?

Am I allowed to incorporate additional data sources?

Is this event a hackathon?

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

How can I migrate from e.g. dbt™ Cloud to Paradime?

Do I need to host dbt™ Core?

Stop Managing Pipelines. Start Shipping Them.

Join the teams that replaced manual dbt™ workflows with agentic AI. Free to start, no credit card required.

Start for free

Stop Managing Pipelines. Start Shipping Them.

Join the teams that replaced manual dbt™ workflows with agentic AI. Free to start, no credit card required.

Start for free

Stop Managing Pipelines. Start Shipping Them.

Join the teams that replaced manual dbt™ workflows with agentic AI. Free to start, no credit card required.

Platform

NEW

Resources

ADD-ONs

Industries

About

Legal

*dbt® and dbt Core® are federally registered trademarks of dbt Labs, Inc. in the United States and various jurisdictions around the world. Paradime is not a partner of dbt Labs. All rights therein are reserved to dbt Labs. Paradime is not a product or service of or endorsed by dbt Labs, Inc.

Platform

NEW