Revealed: Power BI Query Editor For Cleaner BI Data
3.7 (42 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,311 students enrolled

Revealed: Power BI Query Editor For Cleaner BI Data

Discover The Query Editor Secrets Microsoft Was Supposed to Teach You, But Never Did
3.7 (42 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,311 students enrolled
Created by Doug Burke
Last updated 6/2017
English
English [Auto-generated]
Current price: $48.99 Original price: $69.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 3 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • Students should be familiar with Power BI
  • Students should have prior experience working with data
  • Power BI Desktop and Query Editor run only on Windows operating systems. There is currently no native Mac version. If you have a Mac, you will need to run Windows on it (ie Parallels, Boot Camp, etc) to use Power BI Desktop and Query Editor.
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


Who this course is for:
  • This course is for new Power BI users looking to increase their knowledge of the Query Editor
  • This course is not for Power BI Desktop experienced pros. The focus is on getting new users up and running with Query Editor.
  • They want to feed their Power BI visualizations with 'clean' data, even if the source is very 'unclean'
  • They see value in learning to create automated data transformations to save time and improve accuracy
  • If you know Excel, you'll take to Query Editor like a fuzzy duck to water
Course content
Expand all 15 lectures 01:01:54
+ Diving In to Power BI Query Editor
4 lectures 08:45

Learn how the Query Editor can save you time by providing clean data and dramatically improving your Power BI experience

Preview 03:11
Yes, The Power BI Query Editor Is Part of Power BI Desktop
02:15

How often does Microsoft update Power BI?

How often does Microsoft update Power BI?
1 question
+ Power BI Query Editor Essentials
4 lectures 21:17

'DogCatSquirrel_intro.xlsx' contains sample data for Lecture 6 - External Data Ribbon

Preview 03:44
  • 'Query_Editor_Ribbons_Guide.pdf' is a convenient overview to the Query Editor ribbons.  One place to see all the functions available across the Home, Transform, Add Column and View ribbons.
  • 'DogCatSquirrel_Level_1.xlsx' contains sample data for Lecture 7 - Query Editor Layout
Preview 05:48

Excel file for lecture "Query Editor Ribbons"

Save this file to a directory where you can load it using the Power BI Desktop Query Editor

Query Editor Ribbons - Your New Best Friend
08:13

Can I combine different transformation types (push-button, formula, multi-query) within one query?

Can I Combine Different Transformation Types?
1 question
+ Three Levels of Power BI Query Editor Excellence
3 lectures 26:22

Excel file for lecture "Level 1 - Push Button Transformations"

Save this file to the same directory where you loaded the file from the earlier lecture

Push Button Transformations Can Get You Moving Fast
12:21
Kick Up The Volume With Formula Transformations
08:10
Flying High With Multiple Query Transformations
05:51

What is the best way to learn the Query Editor?

What is the best way to learn the Query Editor?
1 question
+ Power BI Query Editor Bonus Material
4 lectures 05:29

What is a key benefit of the Query Editor?

What is one key benefit of the Query Editor?
1 question
Power BI Query Editor and Power Query for Excel
02:58

Are Power BI Query Editor and Excel Power Query similar?

Are Power BI Query Editor and Excel Power Query similar?
1 question