Toll free: 1-800-385-1607
support@euwebinars.com
Beginners Guide to Data Transformations in Power Query
Markus Ehrenmueller-Jensen
Duration: 60 Minutes
Access Recorded Version
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Support
Toll free: 1-800-385-1607
Mailto: support@euwebinars.com
Overview:
Data rarely arrives in a format ready for reporting. Columns are misnamed, headers are misplaced, values are inconsistent, and tables are structured for data entry - not analysis. Power Query provides a powerful, repeatable way to transform raw data into clean, reliable datasets.
This beginner-friendly session introduces the essential concepts and techniques of data transformation in Power Query. Rather than memorizing steps, you’ll learn how to think systematically about shaping data: removing errors, standardizing formats, splitting and merging columns, pivoting and unpivoting data, and preparing tables for a proper data model.
Through practical demonstrations, you’ll see how small transformation decisions impact downstream modeling and performance. By the end of the session, you’ll understand how to build refresh-safe, maintainable transformation pipelines that set your reports up for success.
Why you should Attend:
If your reports rely on messy Excel files, inconsistent exports, or “quick fixes” in the data model, you may already be building on unstable ground. Poor transformations lead to duplicated logic, broken refreshes, slow models, and numbers you can’t confidently explain. In “Beginner’s Guide to Data Transformations in Power Query”, you’ll learn how to clean, shape, and structure data properly inside Microsoft Power BI - before bad data practices turn into long-term technical debt.
Areas Covered in the Session:
- Understanding the role of Power Query in the analytics workflow
- Importing data from common sources (Excel, CSV, databases)
- Cleaning data: removing errors, blanks, and inconsistencies
- Renaming, reordering, and changing data types correctly
- Splitting and merging columns
- Filtering data effectively
- Appending and merging queries
- Understanding applied steps and the M transformation process
- Best practices for building maintainable transformation pipelines in Microsoft Power BI
Who Will Benefit:
- People who (start to) work with Power BI
Speaker Profile
Markus Ehrenmueller-Jensen is the founder of Savory Data, with a career spanning project leadership, data engineering, and business intelligence architecture since 1994. He holds degrees in software engineering and business education and serves as a professor of databases and project engineering at HTL Leonding, a technical college. He is also certified in PL-300 (Power BI Data Analyst), DP-203 (Azure Data Engineer Associate Certification), DP-600 (Fabric Analytics Engineer Associate), and DP-700 (Fabric Data Engineer Associate).
Markus actively contributes to the global data community, speaking regularly at international conferences such as SQL Bits in London, Power BI Next Step in Copenhagen, Data Saturdays throughout Europe, and SQL Days. He co-founded SQL PASS Austria in 2013 and the Power Platform User Group Austria in 2016; both organizations merged in 2021 to form Data Community Austria. Since 2014, he has organized Data Community Austria Day in Vienna, fostering knowledge sharing among data professionals. In recognition of his technical leadership and community involvement, Markus has been honored as a Microsoft Data Platform Most Valuable Professional (MVP) since 2017.
In addition to his speaking engagements, Markus contributes articles to reputable journals and has authored the book "Data Modeling with Microsoft Power BI," published in June 2024.