Details
Speaker: Melissa de Korte, Automatisering & Data-analyse (Automation and Data Analyst)
Agenda:
Power Query in the Trenches: 3 Solutions to a Data Problem
Plenty Q&A
Session outline:
Data often needs to be reshaped before it can be used for analysis. And just like there are usually three or more ways to do things in Excel, there are often multiple routes to convert ugly data into the required tabular format. It’s fascinating how many different approaches you can take! In this session, Melissa de Korte will explore three different solutions that can be used to unwind a messy data set using practical problem solving with Power Query/M.
Speaker profile:
Melissa is an all-around Power Platform enthusiast and Enterprise DNA expert. On a mission to share what she's learned, in particular her passion for solving practical problems with Power Query/M.
Learn more about Melissa de Korte at linkedin.com/in/melissa-de-korte-64585884/
See you in the online live class session!
Join the community: meetup.com/microsoft-excel-and-data-analysis-learning-community/
(c) class.urbizedge.com
Recording of past sessions are available at youtube.com/playlist?list=PL0kdLm6FekrMWYBcervKPF_eAZk9dnoSI
- Microsoft Excel Office Hour 98: Power Query in the Trenches: 3 Solutions to a Data Problem ( Download)
- Power Query in the Trenches: 3 Solutions | Melissa de Korte | VanPUG Excel Track-Jun 2022 ( Download)
- 3 solutions to a data problem | Melissa de Korte ( Download)
- Create A Dimension Table From A Text File - Intro To Problem Of The Week #2 (Power Query) ( Download)
- Power Query (Excel) + M Code | Excel Modelling and Reporting with M ( Download)
- How to use Fill in Power Query ( Download)
- PowerBI Guru Series E24 - 5 Amazing Things With Power Query with Melissa de Korte ( Download)
- MS Excel Toronto Meetup - Power Query Route to M(astery): Challenge Yourself - Melissa de Korte ( Download)
- Connect Live with Melissa de Korte ( Download)
- Power Query Route to M(astery): Challenge Yourself! | Melissa de Korte Nov 2022 ( Download)
- Excel Weekend 7 - Pivot Table Secrets - Bill Jelen, MVP ( Download)
- MS Excel Toronto Meetup – Pivot Table Tips and Tricks – Bill Jelen ( Download)
- MS Excel Toronto Meetup - Excel Skirmishes with Oz and Bill - Oz du Soleil and Bill Jelen ( Download)
- Master Data Analysis ( Download)
- Date & Time Formats in Excel: Automate Formulas for Budgets, Price Lists, and More ( Download)
