Revealed: Power BI Query Editor For Cleaner BI Data

Revealed: Power BI Query Editor For Cleaner BI Data, available at $19.99, has an average rating of 3.7, with 15 lectures, 5 quizzes, based on 44 reviews, and has 1317 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is for new Power BI users looking to increase their knowledge of the Query Editor or This course is not for Power BI Desktop experienced pros. The focus is on getting new users up and running with Query Editor. or They want to feed their Power BI visualizations with 'clean' data, even if the source is very 'unclean' or They see value in learning to create automated data transformations to save time and improve accuracy or If you know Excel, you'll take to Query Editor like a fuzzy duck to water It is particularly useful for This course is for new Power BI users looking to increase their knowledge of the Query Editor or This course is not for Power BI Desktop experienced pros. The focus is on getting new users up and running with Query Editor. or They want to feed their Power BI visualizations with 'clean' data, even if the source is very 'unclean' or They see value in learning to create automated data transformations to save time and improve accuracy or If you know Excel, you'll take to Query Editor like a fuzzy duck to water.

Enroll now: Revealed: Power BI Query Editor For Cleaner BI Data

Summary

Title: Revealed: Power BI Query Editor For Cleaner BI Data

Price: $19.99

Average Rating: 3.7

Number of Lectures: 15

Number of Quizzes: 5

Number of Published Lectures: 15

Number of Published Quizzes: 5

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 20

Original Price: $59.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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 Curriculum

Chapter 1: Diving In to Power BI Query Editor

Lecture 1: The Power BI Query Editor Welcomes You

Lecture 2: Yes, The Power BI Query Editor Is Part of Power BI Desktop

Lecture 3: All Together Now – – Let's Install Power BI Query Editor Ourselves

Lecture 4: Microsoft Power BI Desktop Update Available – June, 2017

Chapter 2: Power BI Query Editor Essentials

Lecture 1: Time To Explore the External Data Ribbon

Lecture 2: Let's Get Into the Query Editor Layout

Lecture 3: Query Editor Ribbons – Your New Best Friend

Lecture 4: Here's How Data Should Really Get Transformed

Chapter 3: Three Levels of Power BI Query Editor Excellence

Lecture 1: Push Button Transformations Can Get You Moving Fast

Lecture 2: Kick Up The Volume With Formula Transformations

Lecture 3: Flying High With Multiple Query Transformations

Chapter 4: Power BI Query Editor Bonus Material

Lecture 1: Microsoft Power BI is changing the business world and here's how you can benefit

Lecture 2: Here's Why I Created This Course

Lecture 3: Career Tip – Your Data Skills Are In Demand

Lecture 4: Power BI Query Editor and Power Query for Excel

Instructors

Doug Burke
Financial Systems Leader and Experienced Teacher

Rating Distribution

1 stars: 2 votes
2 stars: 4 votes
3 stars: 5 votes
4 stars: 14 votes
5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu