Introduction to DAX

Summary

In this course you’ll learn how to advance your analytic capabilities in Power BI using DAX (Data Analysis Expressions). You’ll learn how to use DAX to create columns/measures, & add these to your charts to get insights that can’t always be obtained by clicking & dragging. You’ll apply key concepts through case-study style learning, with concise lessons & applied assessments.  Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This is a course for advanced learners who are familiar with creating charts and visualizations in Power BI Desktop. You don’t need any knowledge of DAX for this course. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to improve their ability to analyze data using Power BI.

Course Overview

This Kubicle course contains 12 lessons, 4 exercises and 1 Exam. It covers the following topics:

  • Calculated Columns
  • Creating Measures
  • Aggregation Functions
  • The Calculate Functions
  • Logical Functions
  • The Switch Function
  • The RankX Function
  • Count and Distinctcount
  • Text Functions

Key Outcomes

Once you’ve completed this course, you’ll understand how to write formulas in DAX. You’ll be able to create columns and measures and add them to your visualizations. You’ll know how to use many of the most important functions that DAX has to offer. The skills you’ll learn in this course will enable you to perform more advanced data analysis than is possible using the simple click and drag approach to creating visualizations.