Complete Introduction to Power BI Query Editor

Learn how to IMPORT, TRANSFORM, CLEANSE and MANIPULATE data using the Query Editor in Microsoft Power BI

4.63 (3151 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
11,945
students
3 hours
content
Jun 2023
last update
$69.99
regular price

What you will learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video

Have a COMPREHENSIVE understanding of connecting and transforming data using Microsoft Power BI

Enjoy CLEAR and CONCISE step by step instruction from a best selling Udemy instructor

Load data into Power BI from a multitude of different SOURCES including SQL Server, Excel, CSV, JSON, XML and Google Analytics

Perform BASIC transformations such as filtering, changing data types, remove columns and creating new calculated columns

Perform ADVANCED transformations such as Merging, Appending, Unpivoting, Grouping and Calculating Custom Columns

Learn to CLEAN data and LOAD data using parameters

Description

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 is available in full HD video quality, so you will learn on the latest Power BI interface. Students who have taken this course have this to say:

WHAT STUDENTS ARE SAYING:

  • "I absolutely endorse the content of this course. Very well explained and good examples as well. Thank you so much!"

  • "The instructor is well knowledgeable to what he is sharing. Thank you. Even though, I am an intermediate user and use Power BI for over two years, I found some that I haven't known."

  • "He explains the concepts very well. I like that the course has short practical activities to practice what I learned."

Lifetime access to course materials and practice activities.

ABOUT THE TRAINER

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 300 000 enrollments & 250 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon QuickSight & his courses average over 4.5 stars out of 5. 

ABOUT THE COURSE

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 - which is part of the Power BI Master Class Series), you will cover:

  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, Grouping data, conditional rules and custom fields

  4. Data Cleansing - Techniques and skills to clean up your data

  5. Connecting to Data Sources - Learn how to connect and access data from a variety of different data sources including, files, databases, web URL, JSON and XML

  6. How to use the Power BI Service dataflows

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI.

Content

Introduction

Introduction to the Course
Please download the Training Data Files

Overview of the MCSA BI Reporting Qualification

Overview of the MCSA BI Reporting Certification
Links to the Microsoft MCSA BI Reporting resources

Sign up and Access Power BI Service and Desktop

Signing up for Power BI Service and Desktop
Practical Activity - Sign up for Power BI and Download the Desktop Application

Connect to Power BI Connections and Data Sources

Introduction to Power BI Data Connections and Sources
Overview of Data Connections and Sources
Loading Data from SQL Server
Loading Data from an Excel file
Practical Activity - Loading Data from Excel into Power BI
Loading Excel Data from One Drive for Business
Loading Data from .csv and .txt files
Practical Activity - Load Data from a CSV file
Loading Data from the Web
Practical Activity - Connect to Data on the Web
Loading Data from XML files
Loading Data from SQL Analysis Services
Loading Data from the Power BI Service
Loading Data from JSON
Loading Data from Google Sheets
Loading Data into the Power BI Service
Loading Data from Google Analytics
Conclusion to the Connecting to Data Sources

Perform Transformations

Introduction to the Transformations Section
Overview of the Query Editor
Basic Transformations - Filtering, Change Data Types, Remove Columns etc.
Practical Activity - Transforming Data in Power BI
Basic Transformations - Add New Fields, Calculate Age etc.
Merging Data from Different Data Sources
Practical Activity - Merging Data in Power BI
Appending Data from Different Data Sources
UnPivot Data
Unpivoting Data with Dates
Grouping Data
Custom Calculations
Conclusion to Performing Transformations

Cleaning Data and Using Parameters

Introduction to Cleaning Data and Parameters
Cleaning Data - Part 1
Cleaning Data - Part 2
Creating Parameters in Query Editor - Part 1
Creating Dynamic Parameters with Queries
Conclusion to Cleaning Data

Conclusion

Conclusion to the Course

Screenshots

Complete Introduction to Power BI Query Editor - Screenshot_01Complete Introduction to Power BI Query Editor - Screenshot_02Complete Introduction to Power BI Query Editor - Screenshot_03Complete Introduction to Power BI Query Editor - Screenshot_04

Reviews

Mohammed
October 29, 2023
this course has actually taken my knowledge from zero to hero. very easy to follow and comprehend. I totally recommend this course.
Anthony
October 23, 2023
Being that this course was specifically for Power Query editor, I was expecting more information on the M query language. On the contrary, this course is tagged as an introduction so maybe I underestimated the amount of knowledge I had coming into this course. Overall, course was well put together.
Ediberto
October 5, 2023
Excelente curso, porem algumas partes ficaram um pouco confusas, por conta de "faz e deleta", mas no geral o curso é sensacional.
Fred
September 12, 2023
I opened Power BI desktop for the first time just a few weeks ago and this course and one of Ian's other courses have brought me up to speed on this powerful tool. Thanks!
Tim
August 24, 2023
I am an avid Excel user, but wanted to learn how to utilize data from different sources for analysis.
Jill
July 31, 2023
Ian is an excellent instructor. His presentations are methodical and thorough. I have been working with Power BI for several years, and I am learning something new every lesson.
Al
July 25, 2023
This instructor is very easy to follow. I like the quizzes after the demos. They help reinforce what you just watched. Great coursestructure! Great teaching style!
Richelle
July 24, 2023
I was amazed with this course. The discussion is easy to understand and the step-by-step is adaptable to beginners. Excellent Ian!
Cristian
July 4, 2023
You should put another idioms options, at least in the subtitles of the videos, for the people who hasn´t full domain of english idiom :(
Robert
June 20, 2023
This was a very good course for me, I learned a lot of features and functions that I have not had a chance to learn prior. This course is especially useful for my co-workers who have never seen Power Query (Query Editor) or Power BI before. This course will give them a detailed overview of what Query Editor can do and will teach them the foundational skills they will need to start using Power BI and Query Editor right away.
Brian
May 28, 2023
This was a very detailed and expansive review of the Power Query Tool. This is a must take for any one who wants to know more about the Power Query Tool.
Sjoerd
April 24, 2023
Same as the two other trainings, very clear explanation, and no boring moments throughout the whole training, it stays interesting until the end.
Rebecca
April 20, 2023
Ian Littlejohn never disappoints. I've completed several of his courses and plan to complete several more. His explanations are clear, examples are practical, and video style is top notch. I highly recommend any course he facilitates.
Chris
March 11, 2023
This was a 5 star course until I got to Section 6 about connecting to other data sources. The SQL Server connection was turned off years ago, yet the section hasn't been updated, or the technical issue hasn't been corrected. There could at least be a popup at the beginning of the section warning new students. This was extremely disappointing in an overall excellent course.
Eric
January 11, 2023
Amazing! Wish you did power query for just excel also. However, this is also helpful because there isn't a huge difference.

Charts

Price

Complete Introduction to Power BI Query Editor - Price chart

Rating

Complete Introduction to Power BI Query Editor - Ratings chart

Enrollment distribution

Complete Introduction to Power BI Query Editor - Distribution chart
1626968
udemy ID
4/2/2018
course created date
11/21/2019
course indexed date
Bot
course submited by