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

Master Microsoft POWER QUERY in POWER BI & Excel (ETL Tool) | Udemy
English | Size: 1.09 GB
Genre: eLearning

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

What you’ll learn
Enjoy CLEAR and CONCISE step by step lessons from instructor in FULL HD 1080 P video
Perform BASIC transformations such as filtering, changing data types, remove columns and creating new calculated columns
Learn to CLEAN data and LOAD data using parameters
Perform ADVANCED transformations such as Merging, Appending, Unpivoting, Grouping and Calculating Custom Columns

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 :

Introduction and Course Content

Basic Data Transformations – Learn about filtering data, changing data types, adding new columns and removing columns

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

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.

Who this course is for:
Excel users who want to learn how to create PROFESSIONAL reports in Power BI with Power Query
Learners who want to LEARN Microsoft Power Query in Power BI