Excel Power Query: Clean Your Analytics Data Like A Pro
4.4 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
598 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Power Query: Clean Your Analytics Data Like A Pro to your Wishlist.

Add to Wishlist

Excel Power Query: Clean Your Analytics Data Like A Pro

Build great data analysis and you'll build a stronger analytics career. Beginners guide to Power Query skills.
4.4 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
598 students enrolled
Created by Doug Burke
Last updated 6/2017
English
Current price: $10 Original price: $70 Discount: 86% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 2 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You will control your data - - instead of letting it control you. Invest an hour and get a lifetime of benefits.
  • You will build fast, repeatable data transformations that improve your Excel analysis and reporting
  • You will use the Power Query Editor and its many push-button, formula and multi-query functions
  • You will install the Power Query add-in for Excel on your computer and also get Microsoft's monthly new features updates
  • You will take a big career step forward as a professional data analyst who understands the importance of 'clean' data
  • Items covered: Import Excel file, remove top rows, use first row as header, remove columns, change type, split columns by delimiter, rename columns, close & load, merge columns, conditional columns, reorder columns, rename steps, move steps, view 'M' code, sort rows, filter rows, rename query, reference, group-by, duplicate, refresh, merge
  • Power Query has many features - - this course does not cover everything but provides a solid foundation so you can navigate the ribbons and learn more on your own
View Curriculum
Requirements
  • Basic knowledge of Microsoft Excel
  • An interest in learning a great new Excel skill that will enhance your career while saving you time & effort
  • Beginners course for people new to Power Query; focus is on getting new users up and running
  • Excel for Windows or Office 365. Power Query does not work in native Mac unless you're running Windows OS such as Boot Camp or Parallels VM.
  • Power Query is known as Get & Transform in Excel 2016; this course applies to both
Description

This course is essential for developing your data career

1st in my series of Udemy courses on mastering data cleaning in the age of big data

Your data career is in your hands. Stand out by making data transformations that are simple to use and quick.  This lets companies make better business decisions, faster.  People notice and it provides you with a solid career.  

Microsoft has the best tool to do this.  It’s called Excel Power Query.  Want to use it like I do and improve your data career opportunities?  This is the course you should take.

Introduce Yourself To Excel Power Query To Strengthen Your Data Analytics Career

  • Create fast, repeatable data transformations that improve Excel analysis and reporting
  • Use the Power Query Editor and its many push-button, formula and multi-query functions
  • Change 'dirty' data to 'clean' data in a structured and reliable way
  • Install the Power Query add-in for Excel on your computer and get monthly feature updates

_______________________________________________________________________________________________

Comments from students:

"Simple and to the point.  If you're unsure of where to begin with Power Query, this is the course to take.  Thank you!"
          - Cynthia S.

"Bravo! I love every video in this course. Mr. Burke is a true teacher - He seems to know the learning pain points of students and then simplifies and arranges the lessons for maximum learning."
          - Aisha I.

"Well summarized and articulate. Be sure to do the little exercises to fully grasp the concepts."
          - Rudi P.

_______________________________________________________________________________________________

Become a more valuable professional. Spending less time manipulating data & more time analyzing it.

The explosion of data is changing the business world at an accelerating rate.  Power Query is the perfect analytics tool for  helping companies manage their data.  Learning this awesome power is within everyone's reach.  Let me prepare you for a career that will evolve as this new world evolves. 

  • Learn secrets and strategies to save countless hours and avoid the mistakes I once made
  • Unique video presentations transfer the most important knowledge from me to you
  • Modules explain the theory behind the techniques and show demonstrations of their use
  • This investment in learning Power Query will be the best you can make! It will pay you back every single time you use it. It will pay you back every single time you use it.

The career enhancing power of learning Power Query is amazing. It's time to see the tremendous benefits.

Who is the target audience?
  • This course is for all analysts who need a better way to handle large amounts of data
  • They want to improve or eliminate their manual, error-prone spreadsheet data transformations and replace with a simpler, more reliable system
  • They understand the benefits of a systems-based approach and want to take their data transformation techniques to a much higher level
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:09:47
+
Power Query Introduction
2 Lectures 03:37

After this lecture, students will be able to identify five significant reasons why Power Query is a game-changer in the Excel world for Finance and Accounting data handling.

Preview 02:37
+
Power Query Essentials
5 Lectures 24:19

After this lesson, students will be able to identify and understand the purpose of the different sections of the Excel Power Query Ribbon.

Preview 06:33

After this lecture, students will be able to identify and understand how to use the 'Home' ribbon functions of the Power Query Editor.

The Power Query Editor Is Revolutionary
08:58

After this lecture, students will be able to identify and understand how to use the 'Transform', 'Add Column' and 'View' ribbon functions of the Power Query Editor.

How the Power Query Editor Will Rock Your World
04:14

After this lecture, students will be able to install Power Query and perform updates whenever new versions become available.

Here's How To Install and Update Power Query Software
04:21

+
Three Levels of Power Query Excellence
3 Lectures 35:01

After this lecture, students will be able to use Power Query's simple 'push-button' features to transform their data.

Preview 12:11

After this lecture, students will be able to use Power Query's more advanced formula features to transform their data.

There Seems To Be A Formula For Everything (Level 2)
10:18

After this lecture, students will be able to use create combine multiple queries into seamless Power Query's solutions.

Who Would Have Thought Multiple Queries Could Be So Wonderful (Level 3)
12:32
+
Power Query Bonus Lectures
2 Lectures 06:54

After this lecture, students will understand how Power Query compares to other data transformation tools used by Finance and Accounting.

Alternatives to Power Query
03:12

After this lecture, students will be able to understand the difference between Excel Power Query and Microsoft's other data transformation product called 'Power BI'.

Hold On - - Let's Compare Power Query to Power BI
03:42
About the Instructor
Doug Burke
4.3 Average rating
42 Reviews
1,407 Students
3 Courses
Data Systems Leader and Experienced Teacher

If you're like me, you see tremendous value in developing your career in data analytics, big data and business intelligence. 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.

____________________________________________________________________

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?