Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 1 Minute(s)
Language
English
Taught by
Doug Burke
Rating
1 views
Course Overview
Discover The Query Editor Secrets Microsoft Was Supposed to Teach You, But Never Did
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
Course Content
- 4 section(s)
- 15 lecture(s)
- Section 1 Diving In to Power BI Query Editor
- Section 2 Power BI Query Editor Essentials
- Section 3 Three Levels of Power BI Query Editor Excellence
- Section 4 Power BI Query Editor Bonus Material
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
Skills covered in this course
Reviews
-
MMark Six
Thanks Doug for conveying valuable message within an hour.
-
JJAYAKRISHNAN NAIR
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.
-
JJames Moore
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.
-
KKeith Andrews
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
