Master Microsoft POWER QUERY in POWER BI & Excel (ETL Tool)

Learn how to import, transform and prepare data using the Query Editor in Microsoft Power BI

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn the to use the AMAZING Power BI tool to transform and prepare your data for analysis. You will learn to use the Query Editor to connect to data, perform advanced transformation and also to clean data.

In this course :

1. Introduction and Course Content

2. Basic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columns

3. Advanced Data Transformations - Merging data into one table, Appending data, Unpivoting data, Grouping data, conditional rules and custom fields

4. Data Cleansing - Techniques and skills to clean up your data

If you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Power BI data effectively!

Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert.

This course has been updated for 2022 in full HD video quality, so you will learn on the latest Power BI interface.