Introduction
In this week’s challenge we’re taking to the air! This challenge focuses on an unfortunately all too common scenario: dirty data and a not-quite-there data model. But that’s ok! Sigma makes it easy to change the data into something meaningful.
Have Fun!
Katrina
Need access to Sigma?
Note: You will only have view access to WOW Workbooks, Folders, and Workspaces, not edit access. Please create your WOW Workbooks under “My Documents.” We suggest creating a folder to organize all your workbooks.
Requirements
Note: At the time of publishing, this solution is best built on Snowflake.
- Create a data source that identifies the journey of a flight, the origin and arrival airports
- Filter to the top 10 most common journey paths
- Map the path of the flight, from the origin location to the arrival location
- Color the map by the flight count scale
- Feel free to choose any colors
- Match other formatting
Dataset
Sigma Sample Database > Fun > FAA > Flights and Sigma Sample Database > Fun > FAA > Airports
Share
After you finish your workout, share on LinkedIn, Sigma’s Community page, (or Twitter) using the hashtags #WOW2024 and #SigmaComputing, and tag Ashley Bennett, Eric Heidbreder, Katrina Menne, and Michal Shaffer!
Create an interactive, sharable version of your solution here.
Also, make sure to fill out the Submission Tracker so that we can count you as a participant this week to track our participation throughout the year.
Solution
Coming Soon…