Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 56 Minute(s)
Language
English
Taught by
Rahim Zulfiqar Ali
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
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 :
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.
Course Content
- 32 section(s)
- 33 lecture(s)
- Section 1 PQ 1 - What is Power Query
- Section 2 PQ 2 - Data Types
- Section 3 PQ 3 - Fixing Dates & Date Locale Setting
- Section 4 PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES
- Section 5 PQ 5 - Split Columns
- Section 6 PQ 6 - Merge
- Section 7 PQ 7 - Filtering Rows
- Section 8 PQ 8 - Removing Duplicates and Errors
- Section 9 PQ 9 - Sorting
- Section 10 PQ 10 - Appending Data from Multiple Excel Worksheets
- Section 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)
- Section 13 PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet
- Section 14 PQ 13 - Replace and Fill
- Section 15 PQ 14 - Formatting Numbers and Dates
- Section 16 PQ 15 - Adding Custom Calculated Columns
- Section 17 PQ 16 - GroupBy
- Section 18 PQ 17 - Unpivot
- Section 19 PQ 18 - 6 Types of Joins
- Section 20 PQ 19 - Create Calendar in PQ vs. DAX
- Section 21 Append Data from Multiple Different Excel Files Combination of XLSX & CSV
- Section 22 Working with very LARGE Datasets | 4+ Million Rows | Power Query and Power Pivot
- Section 23 Skip Files with Errors Benefit when Appending Data from a Folder
- Section 24 How to Extract Dates From Text Strings in Power Query
- Section 25 How to Append Data from Many Excel Files into Microsoft POWER BI
- Section 26 How to Calculate Hours Worked for Employees on Complex Data & to Summarize
- Section 27 Fuzzy Lookup in Microsoft Excel / POWER BI (2 Methods: Addin or Power Query)
- Section 28 Normalize Data using Power Query
- Section 29 Combine Multiple Tables and Perform Aggregation Sum | POWER QUERY Solution
- Section 30 LinkedIn Profile Optimization Tips | Exploring Jobs (On-Site + Remote)
- Section 31 Create Sales Analytical Dashboard in POWER BI Desktop (Sep-2024)
- Section 32 Fuzzy Lookup (POWER QUERY) Approximate Match for Text in Microsoft Excel
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 covered in this course
Reviews
-
NNisar Abbas
very impressive and to the point lectures. Thank you Raheem.
-
RRao Muhammad Kamran
Learn some new thing from this content
-
AAlaa Abdelhamid Ali
The course need to cover all power query options
-
AAbdul Qaum
very good experience
