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
resultIdID number Int, no null 
yearYear of eventInt, , no null 
roundRound of the event in YearInt, , no null 
Event nameEvent Name varchar(50), no null 
Event dateEvent dateDate : (dd mmm yyyy) 
circuit nameCircuit namevarchar(50), no null 
latLatitudefloat
lngLongitudefloat
codeDriver CodeVarchar(3), null 
Driver’s forenameDriver’s forenamevarchar(250), no null 
Driver’s surnameDriver’s surnamevarchar(250), no null 
dobDriver’s Date of Birth Date : (dd mmm yyyy) 
Driver’s nationalityDriver’s nationalityvarchar(250)
Constructor nameConstructor namevarchar(250)
constructor’s nationalityconstructor’s nationalityvarchar(250)
Driver’s  numberDriver’s  numberInt, null
gridStarting Position on the GridInt, null
positionOrderpositionOrderInt, no  null
pointspointsInt, no  null
lapsCompleted LapsInt, no  null
timeCompletion Timetime (hh:mm:ss.ms…), no null 
millisecondsCompletion Time (in milliseconds)Int, null
fastestLapfastestLapInt, null
rankrankInt, null
fastestLapTimeFastest Lap Timetime (hh:mm:ss.ms…), no null 
fastestLapSpeedFastest Lap Speedfloat
statusRace Completion Statusvarchar(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.

Ready to kick start your data analytics journey?