Welcome to April 2022 Data DNA – Dataset Challenge!
Data DNA is your monthly learning and development appointment with yourself and hundreds of passionate data people. For free! Join us every month to work with a given data set and create better, more effective data visualizations, analysis and help us make information more accessible. The Data DNA community comes together every month from around the globe and we would love for YOU to become part of it, too.Win a $200 Amazon Voucher from our sponsors Astrato & Onyx Data and 2 data books from our sponsors Packt!
A winning entry will be chosen based on best visualization and successfully following the entry rules – winning a $200 Amazon voucher code courtesy of Astrato & Onyx Data, an ebook copy of Between the Spreadsheets by Susan Walsh and 2 books from packt!
The top 5 entries will also receive 2 data books from our sponsors Packt Plus, all entries submitted using Astrato will be entered into a special mini-competition. And the winning entry will receive an exclusive Astrato goodie bag!
We also now have amazing badges to be won!
How to submit your entry:
- Follow Onyx Data on LinkedIn (it’s OK if you already follow Onyx Data)
- Share a LinkedIn post on your profile that contains both a direct @ mention to @Onyx Data, @Astrato Analytics and the hashtag #dataDNA
- In your post, share an image of your visualization or dashboard (remember, it must be a single image)
- Tag, mention, and invite 5 connections to view your post or play along (optional)
How to Create an Astrato Entry:
Want to try your hand at Astrato? The April Onyx DataDNA Challenge is the perfect dataset for fun, fast, and creative exploration!
This month, you’ll find the data available in the Astrato DemoData Connection. Follow the steps below to get started:
- Log in to Astrato
- Click “Create Workbook” at the top right corner of your workspace.
- On the next screen, select “New Data View”.
- Select the Demodata Snowflake connection from the Data Source list. This will open the Data View Editor.
- Select the F1 Results Table and begin to create your masterpiece!
Formula 1 (F1) Data Dataset
- This month we are analyzing historic Formula 1 (F1) data!
- Can you identify the dominating drivers and constructors of Formula 1 (F1)!
Data Dictionary
| Column Name | Column Name (Details) | Data Type |
| resultId | ID number | Int, no null |
| year | Year of event | Int, , no null |
| round | Round of the event in Year | Int, , no null |
| Event name | Event Name | varchar(50), no null |
| Event date | Event date | Date : (dd mmm yyyy) |
| circuit name | Circuit name | varchar(50), no null |
| lat | Latitude | float |
| lng | Longitude | float |
| code | Driver Code | Varchar(3), null |
| Driver’s forename | Driver’s forename | varchar(250), no null |
| Driver’s surname | Driver’s surname | varchar(250), no null |
| dob | Driver’s Date of Birth | Date : (dd mmm yyyy) |
| Driver’s nationality | Driver’s nationality | varchar(250) |
| Constructor name | Constructor name | varchar(250) |
| constructor’s nationality | constructor’s nationality | varchar(250) |
| Driver’s number | Driver’s number | Int, null |
| grid | Starting Position on the Grid | Int, null |
| positionOrder | positionOrder | Int, no null |
| points | points | Int, no null |
| laps | Completed Laps | Int, no null |
| time | Completion Time | time (hh:mm:ss.ms…), no null |
| milliseconds | Completion Time (in milliseconds) | Int, null |
| fastestLap | fastestLap | Int, null |
| rank | rank | Int, null |
| fastestLapTime | Fastest Lap Time | time (hh:mm:ss.ms…), no null |
| fastestLapSpeed | Fastest Lap Speed | float |
| status | Race Completion Status | varchar(250), no null |
Data DNA – Dataset Challenge April 2022
Welcome to the Onyx Data April 2022 Data DNA – Dataset Challenge!
This month we will be visualizing the Formula 1 (F1) Data Dataset!
Please read the challenge terms and conditions before participating.
