Get and Transform Data with Power Query

Author: Matt Allington

Microsoft Power BI is a self service Business Intelligence tool used for creating, publishing, and sharing reports. In this course you will learn everything you need to know to prepare and transform your data to load into Power BI for using the BI features and generate reports..

Duration:
6h 0m
Tools:
  • Power BI
Skills:
  • Data Preparation
  • Data Transformation

What you'll learn?

  • Introduction to Power Query, including hands-on learning of several reusable patterns that cover common use cases for loading ad hoc data
Course

Get and Transform Data with Power Query

$129Renews at $29 per year
(All prices in USD)
  • 6h 0m of training content
  • 5 modules
  • Downloadable files and Handouts
  • Support and Discussion
  • Certificate of Completion

Get and Transform Data with Power Query

$129

PLEASE NOTE:

This course and its companion course, Extracting Data Insights with Power BI and DAX, have been superseded by Power BI for the Business Analyst Online.

This new course includes all of the videos and materials in both Foundations of Power BI and Extracting Data Insights, but also contains an expanded section on Power Query and includes bi-weekly live, online Q&A sessions for direct help with your questions. Plus, any new or updated content will only be available in this new course.

We highly recommend enrolling in Power BI for the Business Analyst Online instead of this course.

Course Description

This training course was developed by Matt Allington, a Microsoft MVP (Power BI) and author of the best-selling book Supercharge Power BI

Microsoft Power BI is a self service Business Intelligence tool used for creating, publishing, and sharing reports. You can also create dashboards that will enable your organization’s decision-makers to easily navigate across all datasets to gain real business insights from a one-stop-shop.

In this course you will learn everything you need to know to start using the Power BI family of tools without having to be a programmer. The course is for beginners; it doesn’t require any programming or reporting experience and starts with a dataset that has already been prepared for you. (There is no coverage of data modeling in this course, as this is discussed in Matt’s companion course, Extracting Insights with Power BI and DAX.)

As we begin exploring Power BI, you’ll quickly see what makes it such an amazing tool to work with. After an overview of exactly what Power BI is and what it can do, as well as the components that make up self-service business intelligence, you will get some hands-on practical experience by building your very first report using Power BI Desktop. We’ll show you how to define a layout, how to add elements such as logos, titles, and create visuals such as Maps, Column Charts, Bar Charts, Line Charts, Slicers, and Cards.

You will also learn about the default cross-filtering, how to set it the way you want, and what difference is between Slicer filtering and cross-filtering. We’ll show you how to develop a customized theme, and how to use Bookmarks in your report to create various views of the report and view them later like a PowerPoint presentation. You will then apply some of these techniques when building several other types of reports along with Matt.

One of the other powerful features of Power BI is the ability to publish and share reports via a browser and mobile devices.  While working with PowerBI.com, you will learn how to create dashboards and use some of the other amazing built-in tools such as Quick Insights and Analyze in Excel to help you leverage your reporting assets.

Who this course is for?

  • Anyone who wants to start with Power BI.
  • Anyone that is self taught with Power BI but is missing a breadth of understanding that comes from structured training. 
  • This is a beginner’s course and doesn’t require any programming or reporting experience.
  • It is ideally suited to anyone that wants to learn the capabilities of Power BI so they can consume and/or build reports for others.

Course Update Log

First release of the course with the original live recording.

Videos replaced with newly recorded versions using studio sound settings and updated Power BI User Interface.

Course name changed from Data to Dashboard Using Power BI to Foundations of Power BI – Data to Dashboard

Phase 4 (final phase) of Dimensional Modeling for the Excel Pro released, including the following module:

  • Methodology for Creating a Data Model

Course Formats

On-Demand
This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files and practice sets.

How does the subscription work?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Matt Allington

Matt Allington

Matt Allington is one of the founding partners of Skillwave.Training, and the founder of Excelerator BI in Australia. He is an expert in Power BI and DAX training, and has 30+ years of experience in using data to deliver business value. Matt is an author, blogger, and eight-time Microsoft MVP that specializes in Power BI, Power Pivot, and Power Query. He brings his business and IT experience to solve general business data problems quickly and efficiently.

FAQs

How do I access the course materials? Are they downloadable?

The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.

Where are the course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.

How do I receive my Certificate of Completion?

After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.

What support is included with the course? How do I ask questions?

All users with a current course subscription receive access to our private Discussion Forum, where they can ask questions related to the course materials, as well as how to apply those teachings to their own work. This forum is also intended to act as a place for students to practice their own learnings by helping others with those questions. While the focus of this forum is primarily aimed at allowing students to learn by helping each other, they are monitored by our course authors as well. For technical issues related to the site, course access, or other questions regarding your account, please get in touch through our Contact Us page.

How do I renew my subscription?

Our system will automatically renew your subscription for another year on your expiry date using the billing information on file. About a month (4 weeks) before your current expiry date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details, so your access is uninterrupted.

How do I cancel my subscription

You may cancel your subscription at any time, and you will continue to have access to all the course materials until your expiry date. To cancel your subscription, go to the Subscriptions of your Account Dashboard and select the subscription to cancel. After your subscription expires, you will no longer have access to the course materials.

What payment methods do you accept? What currency is used?

We accept credit card payments through our secure online payment portal, Stripe. If you would like to discuss other payment options, please get in touch through our Contact Us page. All transactions are charged in US Dollars. Please note that because Skillwave is registered in Canada, we are required by Canada Revenue Agency to collect the 5% Goods & Services Tax (GST) on registrations made by Canadians.

What is your refund policy for this course?

We think you will love our training; however, if you are unsatisfied with the training for any reason, we offer a 14-day 100% money-back guarantee, as long as you have completed less than 25% of the course. All we ask in return is that you tell us why you were unsatisfied with the training. We do not offer refunds if you have completed over 25% of the course and/or it is more than 14 days after the purchase date.

Can an account be shared with or transferred to another user?

Logins, downloads, and other materials are for the exclusive use of the registered user only. Sharing of credentials is in violation of our site policies and may result in termination of product and/or site access without notice.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

29h
18 Modules
$695