Revealed: Power BI Query Editor For Cleaner BI Data

Discover The Query Editor Secrets Microsoft Was Supposed to Teach You, But Never Did

3.70 (44 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
1,317
students
1 hour
content
Jun 2017
last update
$19.99
regular price

What you will learn

Implement insightful tips and tricks to save yourself hours of time while delivering professional results

You will master the Query Editor's push-button, formula and multi-query functions and own the data cleansing process

You will discover my four-step 'data-cleansing' guideline to professionally scrub your data the first time, every time

Import Data, Remove Top Rows, Use First Row as Header, Remove Columns, Change Type, Rename Columns, Sort Rows, Filter Rows, Close & Load, Rename Query, Merge Columns, Create Conditional Column, Move Column, Duplicate Column, Transform Column, Rename Column, Reference another query, Filter, Group By, Rename query, Group & Apply

This course does not cover all available Query Editor features (such as pivot & unpivot data, split columns, and combine files) but provides the basic knowledge so you can learn more and take advantage of everything it has to offer

Description

2nd in my series of Udemy courses on mastering data cleaning in the age of big data

Every day is training day!  Think about how the data explosion is changing analytics and your career prospects. You can join the fun by learning to create simple but powerful BI data transformations.

Microsoft has the right tool for to do this.  It’s called Power BI Query Editor. Want to learn how to use it and have more career opportunities?  You are in the right place!

Learn and Master Power BI Query Editor To Strengthen Your Data Analytics Career

If you're like me, you want the best data possible 'feeding' your Power BI visualizations . . .

  • create fast, repeatable data transformations that improve Power BI analysis and reporting 
  • push-button, formula and multi-query functions
  • change 'dirty' data into clean, structured data for better dashboards and visualizations
  • the perfect course for new Power BI users who need to increase their Query Editor and career skills


Control your data instead of letting it control you

_______________________________________________________________________________________________

Some comments from students:

"I feel so empowered by this course! Thank you soooo very much for delivering this masterpiece of a course in an easy to digest manner; and I hope to see more courses from you!"           - Aisha I.

"Step by Step mastery course!  Really worth."           - Prabhakar K.

"Very clear instructions and a great way to expand into data analysis."           - Kenneth L.

_______________________________________________________________________________________________

My simple strategies will save hours and let you avoid data cleaning mistakes.  Here they are in this unique course!

  • I GUARANTEE your investment in learning Power BI Query Editor will be the best you can make! It will pay you back every time you use it.
  • I will respond to all questions so you can use these simple strategies in a fool-proof way

The career power of learning Power BI Query Editor is amazing. It's time for you to see the benefits.

Let's get started!

- Doug


Content

Diving In to Power BI Query Editor

The Power BI Query Editor Welcomes You
Yes, The Power BI Query Editor Is Part of Power BI Desktop
All Together Now - - Let's Install Power BI Query Editor Ourselves
Microsoft Power BI Desktop Update Available - June, 2017
How often does Microsoft update Power BI?

Power BI Query Editor Essentials

Time To Explore the External Data Ribbon
Let's Get Into the Query Editor Layout
Query Editor Ribbons - Your New Best Friend
Here's How Data Should Really Get Transformed
Can I Combine Different Transformation Types?

Three Levels of Power BI Query Editor Excellence

Push Button Transformations Can Get You Moving Fast
Kick Up The Volume With Formula Transformations
Flying High With Multiple Query Transformations
What is the best way to learn the Query Editor?

Power BI Query Editor Bonus Material

Microsoft Power BI is changing the business world and here's how you can benefit
Here's Why I Created This Course
Career Tip - Your Data Skills Are In Demand
What is one key benefit of the Query Editor?
Power BI Query Editor and Power Query for Excel
Are Power BI Query Editor and Excel Power Query similar?

Screenshots

Revealed: Power BI Query Editor For Cleaner BI Data - Screenshot_01Revealed: Power BI Query Editor For Cleaner BI Data - Screenshot_02Revealed: Power BI Query Editor For Cleaner BI Data - Screenshot_03Revealed: Power BI Query Editor For Cleaner BI Data - Screenshot_04

Reviews

JAYAKRISHNAN
September 3, 2018
if aware of power query, it's pretty basic stuf, but for expreme beginners, it is good for a understanding of what it can be done.
James
November 18, 2017
This course is very much in need because those without BI experience may import data and go directly to creating visuals for a dashboard. However, having worked with data for over 30 years, I can tell you what the instructor is saying is very true. Unless the data you are importing has already gone through a cleaning process such as data that has gone through SQL Server Integration Services (SSIS) where one or more Extract, Transform and Load (ETL) packages have been created and the data has gone through its ETL process into some table called Dimension and Fact tables, then I can tell with certainty the data will be data and will need to be cleansed. There are a lot of other things that can be done in the Query Editor besides cleansing as the Instructor has touched on that when completed will help your with the performance of your Data Model (the data used to create your dashboard). Basically, what I wanted to say about this course it is for those that have never used the Query Editor. Maybe those that have already created data visualizations but didn't understand the need for the Query Editor. This is a very basic, for the absolute beginner course. I gave the course 5-stars because I believe he felt that it was important enough, which is an understatement, when you Get Data, make sure you click the Edit button to take you into the Query Editor and look at the data you want to use in your dashboard visualizations. Again, this is a very basic course and that is why the instructor encouraged his students to go through the various transformations, to understand what can be done to make working with the data once you are finished with it in the Query Editor. I agree 100% with the instructor and I'm sure all of us would, the data has to be clean first or the dashboards we create will not be accurate and will not be something anyone can trust. Great job, Doug, but making sure those just being introduced to this technology does not miss this important step of the process.
Keith
October 22, 2017
I enjoyed this course but did find it quite short. I realize it is for entry level users but I felt like there was still a lot of functionality that could have been covered off
Sarwar
May 29, 2017
Very easy to understand the basic of Power BI Query editor. Great for the beginners like me although to master it one may need to practice other features of query editor with your own data to simulate the basic and learn advance feature by taking advance courses. Regardless this course is stepping stone to start learning Power BI query editor. Thanks to the instructor to help breaking the ice using very simple example.
Pradip
May 27, 2017
This course is too basic. I thought a lot of details will be covered in it. Its only for the beginners and not at all for pro user. There are many features in Qyery editor like: 1. Data sourse settings 2. Manage parameters 3. Properties 4. Split Columns 5. Merge Query 6. Append Qyery 7. Combine files 8. Importing the data from social media like facebook and cleaning that data 9. Transpose 10. Pivot & unpivot data 11. Structured column 12. Extract and several techniques are not explained. I was expecting it to be an advanced query editor program.
Aisha
May 22, 2017
I feel so empowered by this course! Thank you soooo very much for delivering this masterpiece of a course in an easy to digest manner; and I hope to see more courses from you!
Kenneth
May 22, 2017
The course was very detailed oriented, explaining in depth procedures. Very clear instructions and a great way to expand into data analysis.
Billy
May 16, 2017
Clear instruction. Includes sample files, which is really great because I can follow along with the teacher. Learned several thing so worth watching. This will help me with Power BI. Enjoyed the extra materials and intro music.

Charts

Price

Revealed: Power BI Query Editor For Cleaner BI Data - Price chart

Rating

Revealed: Power BI Query Editor For Cleaner BI Data - Ratings chart

Enrollment distribution

Revealed: Power BI Query Editor For Cleaner BI Data - Distribution chart
1158074
udemy ID
3/26/2017
course created date
11/22/2019
course indexed date
Bot
course submited by