Slide 1
Slide 1 text
Racing Towards Insights
Analysing the Sale Sizzler 5k Series with
VSCode Data Wrangler And Power BI
Damien Jones (he/him)
Data Engineer, SecureDev @amazonwebshark
MrDamienJones
amazonwebshark.com
damien@amazonwebshark.com
MrDamienJones
Slide 2
Slide 2 text
Damien Jones
Data Engineer @ SecureDev
AWS & Azure Certified
Creator @ amazonwebshark.com
Runner; Keen Gardener; Dog Dad
♂ He/Him 🌍 Manchester UK 🦈 Fin Fan
Slide 3
Slide 3 text
Agenda
Sale Sizzlers Introduction
VS Code Data Wrangler Introduction
Data Wrangler & Power BI Demos
Summary & Questions
Slide 4
Slide 4 text
Sale Sizzlers
5k road race series operated by Sale Harriers
Manchester
First events in 2002
Four events each Summer
Since 2016 results published by Nifty as CSV
Slide 5
Slide 5 text
No content
Slide 6
Slide 6 text
Sale Sizzlers Data
Runner Data
Event Data
Slide 7
Slide 7 text
Sale Sizzlers: Rank Data
Overall Position
Gender Position
Age Category Position
Slide 8
Slide 8 text
Insights
Gender & Age Running Clubs
https://unsplash.com/photos/hBfiJshiBvc https://unsplash.com/photos/LOyaOZu6g4Q
Fastest Times
https://unsplash.com/photos/x5GcXFvJJhI
Slide 9
Slide 9 text
Visual Studio Code
Read Code
Write Code
Deploy Code
Free!
Slide 10
Slide 10 text
VS Code Data Wrangler
VS Code Extension by Microsoft
In active development
Designed for data cleansing
Also free!
Slide 11
Slide 11 text
Data Wrangler Benefits
No-code interface
Data updates in real time
Source data unchanged
Similarities to Excel and Power Query
Slide 12
Slide 12 text
Data Wrangler Benefits
One single transformation process
Data is ready when it hits Power BI
Reduce Power BI computational load
Transform data closer to source
Slide 13
Slide 13 text
Roche's Maxim of Data Transformation
Data should be transformed…
As far upstream as possible
As far downstream as necessary
https://www.linkedin.com/in/matthewroche/
Slide 14
Slide 14 text
No content
Slide 15
Slide 15 text
No content
Slide 16
Slide 16 text
No content
Slide 17
Slide 17 text
No content
Slide 18
Slide 18 text
No content
Slide 19
Slide 19 text
No content
Slide 20
Slide 20 text
Demos – VS Code (Sizzler 1)
Slide 21
Slide 21 text
Demos – Power BI
Slide 22
Slide 22 text
Summary
Slide 23
Slide 23 text
Sale Sizzlers
What they are
What data they generate
What insights were wanted
Slide 24
Slide 24 text
VS Code Data Wrangler
What are VS Code and Data Wrangler
Data Wrangler benefits
Data Wrangler features
Demo
Slide 25
Slide 25 text
Power BI
Built a model
Examined visuals
Generated insights
Slide 26
Slide 26 text
@amazonwebshark
MrDamienJones
amazonwebshark.com
damien@amazonwebshark.com
Me
MrDamienJones
Thanks!
https://www.flaticon.com/