AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
1min snip
Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069
The Adam Shilton Podcast
The Impact of Getting Data Structure Right in Power Query
Proper data structure simplifies formulas in Power Query, reducing complexity. When the structure is correct, formulas become easy. People often struggle with complex formulas due to poor data structures, necessitating intricate formulas. Power Query establishes an ideal structure, eliminating the need for complex formulas. A 2020 study on Power Query users revealed that they saved between 22 and 89 working days per year by ensuring their data was in the right shape before use, with an average of 76 days saved.
00:00
Transcript
Episode notes
Get the Snipd
podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any
moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share
& Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode