Improve Data Transformations Using M in Power Query | Alejandra Horvath | VanPUG PBI Ed - Aug 2024
Вставка
- Опубліковано 26 вер 2024
- SESSION OUTLINE:
First, we will take a look at some of the latest features and updates to Power BI Desktop with Joseph Yeates. Next, Excel expert Alejandra Horvath will show us the transformative power of M. In this session, we'll take a look at a real-life example that uses practical data cleaning techniques for transforming nested tables. Learn how using M can enhance your data transformation skills in Power BI, making complex data manipulation tasks more efficient and effective.
Download Alejandra's files from the presentation:
- Working Files: 1drv.ms/u/s!Au...
- Final Solution: 1drv.ms/u/s!Au...
SPEAKER PROFILE:
Alejandra Horvath is a Power Query enthusiast with extensive experience empowering organizations and individuals minimizing the time entering data, automating reports and finding efficiencies, as well as providing training to optimize existing resources, such as Excel. She is Chartered Professional Accountant (CPA) in Canada, and a certified Microsoft Excel expert.
Connect with and follow Alejandra online at:
LinkedIn: linkedin.com/in/alejandrahorvath
UA-cam: / @alejandrahorvath
Instagram: empowered2xl
TikTok: tiktok.com/@alejandrahorvath
Twitter/X: @alejandrahorv
super❤
Get presentation with good tricks. PBIX file with the final solution is empty. Could you please re-upload? Thanks
Thanks for watching the presentation! When you open the file, go to the "Home" tab and click "Transform data", so the Power Query editor opens. You will then be able to see the 2 queries.
@@skillwavetraining . Ok i see the queries now. Thanks
Could you please share the file so we could follow along?
We've added links to Alejandra's files to the event description, but here are the direct links:
- Working Files: 1drv.ms/u/s!AuhhLgCXSCKKgZBjlZIVh2SAp_eu4w?e=lFvzt2
- Final Solution: 1drv.ms/u/s!AuhhLgCXSCKKgZBi5wPhVZu6cnH93g?e=41UOpt
@@skillwavetraining Thank you!