Data-DNA DataSet Challenge

April 2022

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

Credit Ergast

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 (…), no null 
milliseconds Completion Time (in milliseconds) Int, null
fastestLap fastestLap Int, null
rank rank Int, null
fastestLapTime Fastest Lap Time time (…), 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.