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

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

Requirements

Download the Power BI Desktop app which is available free from Microsoft for Windows

Description

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 ContentBasic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columnsAdvanced Data Transformations - Merging data into one table, Appending data, Unpivoting data, Grouping data, conditional rules and custom fieldsData Cleansing - Techniques and skills to clean up your dataIf 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.

Overview

Section 1: PQ 1 - What is Power Query

Lecture 1 PQ 1 - What is Power Query

Section 2: PQ 2 - Data Types

Lecture 2 PQ 2 - Data Types

Section 3: PQ 3 - Fixing Dates & Date Locale Setting

Lecture 3 PQ 3 - Fixing Dates & Date Locale Setting

Section 4: PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES

Lecture 4 PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES

Section 5: PQ 5 - Split Columns

Lecture 5 PQ 5 - Split Columns

Section 6: PQ 6 - Merge

Lecture 6 PQ 6 - Merge

Section 7: PQ 7 - Filtering Rows

Lecture 7 PQ 7 - Filtering Rows

Section 8: PQ 8 - Removing Duplicates and Errors

Lecture 8 PQ 8 - Removing Duplicates and Errors

Section 9: PQ 9 - Sorting

Lecture 9 PQ 9 - Sorting

Section 10: PQ 10 - Appending Data from Multiple Excel Worksheets

Lecture 10 PQ 10 - Appending Data from Multiple Excel Worksheets

Section 11: PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)

Lecture 11 PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)

Section 12: PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)

Lecture 12 PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)

Section 13: PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet

Lecture 13 PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet

Section 14: PQ 13 - Replace and Fill

Lecture 14 PQ 13 - Replace and Fill

Section 15: PQ 14 - Formatting Numbers and Dates

Lecture 15 PQ 14 - Formatting Numbers and Dates

Section 16: PQ 15 - Adding Custom Calculated Columns

Lecture 16 PQ 15 - Adding Custom Calculated Columns

Section 17: PQ 16 - GroupBy

Lecture 17 PQ 16 - GroupBy

Section 18: PQ 17 - Unpivot

Lecture 18 PQ 17 - Unpivot

Section 19: PQ 18 - 6 Types of Joins

Lecture 19 PQ 18 - 6 Types of Joins

Section 20: PQ 19 - Create Calendar in PQ vs. DAX

Lecture 20 PQ 19 - Create Calendar in PQ vs. DAX

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