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.
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.
Course Content
- PQ 1 – What is Power Query –> 1 lecture • 7min.
- PQ 2 – Data Types –> 1 lecture • 2min.
- PQ 3 – Fixing Dates & Date Locale Setting –> 1 lecture • 5min.
- PQ 4 – For Columns – MOVE, REMOVE, RENAME, DUPLICATES –> 1 lecture • 3min.
- PQ 5 – Split Columns –> 1 lecture • 5min.
- PQ 6 – Merge –> 1 lecture • 6min.
- PQ 7 – Filtering Rows –> 1 lecture • 2min.
- PQ 8 – Removing Duplicates and Errors –> 1 lecture • 4min.
- PQ 9 – Sorting –> 1 lecture • 4min.
- PQ 10 – Appending Data from Multiple Excel Worksheets –> 1 lecture • 9min.
- PQ 11 – Appending Data from Multiple Excel Workbooks (Same Table Names) –> 1 lecture • 9min.
- PQ 11-1 – Appending Data from Multiple Excel Workbooks (Same Sheet Names) –> 1 lecture • 6min.
- PQ 12 – Appending Data from Multiple Excel Workbooks – Different Table and Sheet –> 1 lecture • 10min.
- PQ 13 – Replace and Fill –> 1 lecture • 3min.
- PQ 14 – Formatting Numbers and Dates –> 1 lecture • 5min.
- PQ 15 – Adding Custom Calculated Columns –> 1 lecture • 3min.
- PQ 16 – GroupBy –> 1 lecture • 11min.
- PQ 17 – Unpivot –> 1 lecture • 5min.
- PQ 18 – 6 Types of Joins –> 1 lecture • 29min.
- PQ 19 – Create Calendar in PQ vs. DAX –> 1 lecture • 14min.
Requirements
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.