Racing Towards Insights (2023-10-27: New Stars Of Data)

In this session, I explore the capabilities of the Visual Studio Code Data Wrangler extension and Microsoft Power BI using real results from the Sale Sizzler 5k race series. I'll uncover valuable insights through engaging visualisations and user-friendly and low-code data transformations.

This session will cover the following key steps:

Discovering the convenience of the Visual Studio Code Data Wrangler extension for effortlessly transforming and cleaning the race results

Taking a closer look at the Python code generated by Data Wrangler to understand what's happening behind the scenes.

Loading the transformed race results into Power BI to generate informative visualisations and analyse trends.

Join me if you're a data professional, a budding analyst or a sports enthusiast!

Resources at https://github.com/MrDamienJones/Community-Sessions/tree/main/RacingTowardsInsights

Transcript

1. 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
2. Damien Jones Data Engineer @ SecureDev AWS & Azure Certified Creator @ amazonwebshark.com Runner; Keen Gardener; Dog Dad ♂ He/Him 🌍 Manchester UK 🦈 Fin Fan
3. Agenda Sale Sizzlers Introduction VS Code Data Wrangler Introduction Data Wrangler & Power BI Demos Summary & Questions
4. 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
6. Sale Sizzlers Data Runner Data Event Data
7. Sale Sizzlers: Rank Data Overall Position Gender Position Age Category Position
8. Insights Gender & Age Running Clubs https://unsplash.com/photos/hBfiJshiBvc https://unsplash.com/photos/LOyaOZu6g4Q Fastest Times https://unsplash.com/photos/x5GcXFvJJhI
9. Visual Studio Code Read Code Write Code Deploy Code Free!
10. VS Code Data Wrangler VS Code Extension by Microsoft In active development Designed for data cleansing Also free!
11. Data Wrangler Benefits No-code interface Data updates in real time Source data unchanged Similarities to Excel and Power Query
12. 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
13. 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/
20. Demos – VS Code (Sizzler 1)
21. Demos – Power BI
22. Summary
23. Sale Sizzlers What they are What data they generate What insights were wanted
24. VS Code Data Wrangler What are VS Code and Data Wrangler Data Wrangler benefits Data Wrangler features Demo
25. Power BI Built a model Examined visuals Generated insights
26. @amazonwebshark MrDamienJones amazonwebshark.com damien@amazonwebshark.com Me MrDamienJones Thanks! https://www.flaticon.com/