Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Microsoft Power BI

Revealed: Power BI Query Editor For Cleaner BI Data

Discover The Query Editor Secrets Microsoft Was Supposed to Teach You, But Never Did
Rating: 3.6 out of 53.6 (42 ratings)
1,312 students
Created by Doug Burke
Last updated 6/2017
English
English [Auto]
30-Day Money-Back Guarantee

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

4 sections • 15 lectures • 1h 1m total length

  • Preview03:11
  • Yes, The Power BI Query Editor Is Part of Power BI Desktop
    02:15
  • Preview02:51
  • Preview00:28
  • How often does Microsoft update Power BI?
    1 question

  • Preview03:44
  • Preview05:48
  • Query Editor Ribbons - Your New Best Friend
    08:13
  • Preview03:32
  • Can I Combine Different Transformation Types?
    1 question

  • 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?
    1 question

  • Preview00:58
  • Preview01:18
  • Preview00:15
  • 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?
    1 question

Instructor

Doug Burke
Financial Systems Leader and Experienced Teacher
Doug Burke
  • 4.1 Instructor Rating
  • 352 Reviews
  • 8,323 Students
  • 5 Courses

If you're like me, you see tremendous value in developing your career in data analytics, business intelligence and creating financial systems. Companies need these skills more than ever.

But did you know  . . . 

 ** The hardest part of any useful business intelligence system is getting clean data **

This statement comes from my 20+ years of experience building data analytics systems at Fortune 500 companies. Let me share my secrets so you get much better at cleaning your analytics data for better financial systems.

____________________________________________________________________

My specialty is creating clean data using Excel Power Query and Power BI Query Editor for analysis and visualizations.  

I love this topic . . . Learn from me.  

> I read the software user manuals so you don't have to

> I enjoy teaching complex topics in a clear, simple manner

> I'm very involved in the analytics community as a member of Microsoft's Power BI User Panel, and a frequent speaker at Oracle analytics events 

Courses like mine are not widely available so I decided to create one. Thanks to the internet, a global audience now shares this knowledge.

Take my courses and enter a community of like-minded people who want everyone to succeed.  I will personally answer any question posted and provide frequent updates on what's happening in the Power Query and Power BI communities.  There is so much value here and I encourage you to join.

____________________________________________________________________

** You can dramatically improve your data cleaning skills today ** 

What are you waiting for?

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.