Basketball Player Athlete Exercise Sport Concept

March Madness is here and the Aptitive team wanted to have a little fun by building a mini (data) Science Fair Project using Snowflake, Tableau and NCAA data.

Project Overview

Using historical March Madness data from 1985 through 2016, we analyzed how frequently teams win based on dimensions like geography, tournament round, and year. We used a high-speed Snowflake data warehouse and connected Tableau dashboard to answer detailed questions and gleam insights into this years performance.

To make this happen, we first ingested and modeled the data into Snowflake using SnowSQL and a S3 bucket (ordinarily stored as a csv). From there, we created a live connection from Tableau to specify the Snowflake storage and data warehouse used to compute the report. Finally, we published the interactive March Madness dashboard to Tableau Online for easy interaction from all interested parties!

Here are some of the questions we explored, click the visualization to see the answers.

  1. Which team has won the most NCAA tournament games since 1985?

Answer: Duke with 85 Wins

  1. Which team has won the 2nd most National Championships?

Answer: Duke with 5 Championships

  1. When was the last time Georgetown won more than 3 games in a tournament?

Answer: 2007 when they won 30 games

  1. What team has won the most games when playing in the West region?

Answer: Arizona with 32 wins

  1. Who won the tournament in 2000?

Answer: Michigan State

  1. In 2007-2016, what team won the most Elite Eight games?

Answer: Kentucky with 4 wins

  1. In 2000-2009, in the East, what team won the most Sweet 16 games?

Answer: North Carolina with 3 games

Although this project was just a bit of March Madness fun, it illustrates how your business can visualize and interact with key performance indicators. ¬†Whether your analyzing financials, marketing, or operations, by having a conversation with your data via your BI tool, you can answer your business questions and dramatically improve your team’s performance.
If your interested in seeing more projects featuring the latest and greatest data and technology solutions and how they can impact your organization, join us on May 23rd in Chicago for the (data) Science Fair. Learn more and register here.

See the dashboard in action in this video