Improve Data Transformations Using M in Power Query | Alejandra Horvath | VanPUG PBI Ed - Aug 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: https://1drv.ms/u/s!AuhhLgCXSCKKgZBjl...
Final Solution: https://1drv.ms/u/s!AuhhLgCXSCKKgZBi5...
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
YouTube: / @alejandrahorvath
Instagram: instagram.com/empowered2xl
TikTok: tiktok.com/@alejandrahorvath
Twitter/X: twitter.com/@alejandrahorv