Logo - Skillwave Training

Extracting Data Insights with Power BI and DAX

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

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
Course Icon - Extracting Data Insights with Power BI and DAX

Extracting Data Insights with Power BI and DAX

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

Extracting Data Insights with Power BI and DAX

$129

PLEASE NOTE:

This course and its companion course, Foundations of Power BI – Data to Dashboard, 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

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.

This course superseded by Power BI for the Business Analyst Online. We recommend enrolling in the new course instead.

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.

About the author

Matt Allington

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 and DAX training, and has 30+ years of experience in using data to deliver business value. Matt is an author, blogger, and 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.