Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

MASTERCLASS: MS Power Query Basic Concepts with Tips & Tricks

person icon Rahim Zulfiqar Ali

4.4

MASTERCLASS: MS Power Query Basic Concepts with Tips & Tricks

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

updated on icon Updated on Sep, 2024

language icon Language - English

person icon Rahim Zulfiqar Ali

English [CC]

category icon Development ,Data Science,Data Analysis

Lectures -16

Resources -30

Duration -2 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

MASTERCLASS - Microsoft Power Query Fundamentals Concepts with Tips & Tricks | 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 developing 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 clean data.

In this course :

PQ 1 - What is Power Query

PQ 2 - Data Types

PQ 3 - Fixing Dates & Date Locale Setting

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

PQ 5 - Split Columns

PQ 6 - Merge

PQ 7 - Filtering Rows

PQ 8 - Removing Duplicates and Errors

PQ 9 - Sorting

PQ 10 - Appending Data from Multiple Excel Worksheets

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

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

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

PQ 13 - Replace and Fill

PQ 14 - Formatting Numbers and Dates

PQ 15 - Adding Custom Calculated Columns

PQ 16 - GroupBy

PQ 17 - Unpivot

PQ 18 - 6 Types of Joins

PQ 19 - Create Calendar in PQ vs. DAX

Goals

  • Power Query is an ETL tool created by Microsoft for data extraction, loading, and transformation, and it is used to retrieve data from sources, process it, and load them into one or more target systems.

Prerequisites

  • None
MASTERCLASS: MS Power Query Basic Concepts with Tips & Tricks

Curriculum

Check out the detailed breakdown of what’s inside the course

PQ 1 - What is Power Query

1 Lectures
  • play icon PQ 1 - What is Power Query 06:34 06:34

PQ 2 - Data Types

1 Lectures
Tutorialspoint

PQ 3 - Fixing Dates & Date Locale Setting

1 Lectures
Tutorialspoint

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

1 Lectures
Tutorialspoint

PQ 5 - Split Columns

1 Lectures
Tutorialspoint

PQ 6 - Merge

1 Lectures
Tutorialspoint

PQ 7 - Filtering Rows

1 Lectures
Tutorialspoint

PQ 8 - Removing Duplicates and Errors

1 Lectures
Tutorialspoint

PQ 9 - Sorting

1 Lectures
Tutorialspoint

PQ 10 - Appending Data from Multiple Excel Worksheets

1 Lectures
Tutorialspoint

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

1 Lectures
Tutorialspoint

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

1 Lectures
Tutorialspoint

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

1 Lectures
Tutorialspoint

PQ 13 - Replace and Fill

1 Lectures
Tutorialspoint

PQ 14 - Formatting Numbers and Dates

1 Lectures
Tutorialspoint

PQ 15 - Adding Custom Calculated Columns

1 Lectures
Tutorialspoint

PQ 16 - GroupBy

1 Lectures
Tutorialspoint

PQ 17 - Unpivot

1 Lectures
Tutorialspoint

PQ 18 - 6 Types of Joins

1 Lectures
Tutorialspoint

PQ 19 - Create Calendar in PQ vs. DAX

1 Lectures
Tutorialspoint

Instructor Details

user profile image

Rahim Zulfiqar Ali

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515