fbpx
Go back to Courses

Extracting Data Insights with Power BI and DAX

  • On-Demand
Author: Matt Allington
In this course, you will learn everything you need to know to start your journey of extracting data insights from Power BI using the DAX language, with expert guidance from Matt Allington (one of the best DAX trainers in the business).
Course

Extracting Data Insights with Power BI and DAX

$129 USD for the first year, $29 USD/year after that
This Course contains:
3h 0m of video content
2 Content Modules
Downloadable files and Handouts
Support and Discussion groups
Certificate of completion
DURATION:
3h 0m
TOOLS:
Power BI
Excel
SKILLS:
DAX Formulas
Data Modeling

What you'll learn?

An introduction to data modeling in Power BI (the skills are also transferable to Power Pivot for Excel)
Coverage of the fundamentals of the DAX language (Data Analysis eXpressions)
Practical use cases for common functions in the DAX language
The CALCULATE function – the most important function in DAX
Table functions such as ALL and FILTER
In-built Time Intelligence
What-if Analysis
The SWITCH function

Course Overview

Course Description

DAX, or Data Analysis eXpressions, is the data modeling language used by Power BI and Power Pivot for Excel. When you know how to write DAX formulas, you can access the hidden information from deep within the data, and then visualize your data in Power BI to extract the business value

In this training course, you will learn everything you need to know to start your journey of extracting data insights from Power BI using the DAX language.

Everyone that is competent in Excel can learn how to become good at Power BI by learning and using DAX. But not all Power BI training is created equal. This course was developed by Matt Allingtona Microsoft MVP (Power BI), DAX expert, and author of the bestselling book Supercharge Power BI. It is a video version of the same training course that Matt has been delivering in Australia to live classes for more than 5 years.

Unlike some other learning resources, this course dives into the details of the DAX language, teaching you everything you need to know to get started on your journey to analyze your data using Power BI. DAX can be difficult to pick up and understand if you are trying to teach yourself. In this course you will get expert guidance direct from Matt Allington (one of the best DAX trainers in the business).

When you know how to write DAX (Data Analysis eXpressions) formulas, you can access the hidden information from deep within the data, and then visualize your data in Power BI to extract the business value. In this training course you will learn everything you need to know to start your journey of extracting data insights from Power BI using the DAX language.

Who this course is for?

This is a beginner’s course and doesn’t require any programming experience. It is recommended, however, that you have a solid understanding of Pivot Tables and/or how to use Power BI to visualize data that has been prepared for you by someone else. You should consider completing Matt’s companion course, Foundations of Power BI – Data to Dashboard, prior to beginning this course. (Although it is not mandatory, most people do both courses.)

  • Business analysts who are venturing into self-service business intelligence using Power BI or Power Pivot for Excel.
  • IT professionals that want to fast-track their learning of the DAX language and data modelling.
  • People that have to report on and analyze data that has not been prepared for them in advance by someone else.

Course Update Log

First release of the course.

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.

Course Content

Introduction to Power BI and DAX
4 Lessons
Introduction to Data Modeling with Power BI
Loading Data
Introduction to DAX
Some New DAX Functions
Building DAX Knowledge
8 Lessons
The CALCULATE Function
The ALL Function
Time Intelligence
The FILTER Function
Loading Multiple Data Tables
What-if Analysis in Power BI
SWITCH Function
Next Steps

How subscription works?

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

Microsoft MVP
Matt Allington is one of the founding partners of Skillwave.Training, and the owner and principal consultant at Excelerator BI Pty Ltd. in Australia. He is an expert in Power BI training and has 30+ years of experience in using data to deliver business value. Matt is a 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.

FAQ

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.
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.

Reviews

Extracting Data Insights with Power BI and DAX

0
(0 Review)
5
4
3
2
1

Reviews

There are no reviews yet.

Only verified customers who have purchased this product may leave a review.

Recommended Courses

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