SUPER EARLY BIRD DISCOUNT (UNTIL DECEMBER 15th, 2023) - $199
EARLY BIRD DISCOUNT (UNTIL JANUARY 1st, 2024) - $250
REGULAR PRICE - $299
End-to-End Data Preparation and Transformations - with Power Query
LOCATION: Microsoft Teams Webinar
Upcoming Training Date
January 8th, 2023: 8AM - 1PM PT (Check Local Time)
As an existing Power Query user, you should already have a good foundation in the basics of Power Query, including importing and shaping data, and using basic M functions such as filtering and transformation steps. You should also be familiar with concepts such as parameters, the advanced editor, the M (mash-up) language, and query folding.
In this course, we will take your skills to the next level by diving deeper into these topics and introducing you to more advanced functions and practices.
You will learn about advanced Power Query techniques such as: advanced performance tuning and optimization, leveraging the Query Diagnostics tool, implementing Incremental Refresh, applying Query Folding and Lazy Evaluations, working with complex data structures, understanding advanced M functions, exploring the advanced editor, and more.
Best practices and recommendations will build upon the methodologies and features to provide an enhanced DAX language understanding.
Consulting & Training
We provide many consulting services related to Power BI or Excel reporting. Including everything from Data Acquisition with Power Query, Data Modeling, or Visualization & Design.
Our services range from customized co-development, to structured training depending on the client's needs.
Articles & Videos
We also have numerous articles, videos, and other content we publish multiple times a month on various media platforms.
Many of these articles showcase great practices, techniques, or other important information related to Power BI or Excel.