Power Query Editor - Deconstructed

Power Query Editor is a powerful that allows you to make changes in your data. But a common issue is that Power Query Editor’s functionality isn’t always used to its full potential. In a recent webinar, trainer and consultant Nick Lee, deconstructs Power Query Editor so you gain a better understanding of how to best utilize Power Query Editor.

In this demo heavy webinar, Nick goes over all the different functionalities within Query Editor. This extremely powerful tool can do many things for you such as:

• Data Transformations – changing data types, removing and adding columns, merging columns, filter and sorting your data, etc. and this list goes on.
• Data Cleansing
• Apply Business Rules that suit your company’s needs.

These are all covered in the demo, so you can see all that you can do with the Power Query Editor and how you can use the tools and functionality that comes with it. As Power Query uses the M language, Nick goes over what M is and how to write M formulas.

Watch the full free webinar below and learn how to fully exhibit your skills in the Power BI Desktop’s Query Editor, as well as how to utilize M and learn all the functionalities available to use that are often not utilized.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI, Power Apps, Power Automate, Copilot Studio, Fabric, Azure and other Microsoft applications.

Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks, along with fresh content every week.

It's also incredibly easy to get started with your 7-day free trial. No credit card required. Just click below and you'll be on your way.