When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
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
This Course Includes
udemy
4.7 (474 reviews )
4h 56m 
english
Online - Self Paced
professional certificate
Udemy
About Master Microsoft POWER QUERY in POWER BI & Excel (ETL Tool)
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.
What You Will 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.