What is DAX?

DAX is the formula or expression language used in Power BI. Looking much like Excel formulas, DAX can be used to create tables, add columns to existing tables and to define “measures”. Meaures are calculations used in reporting of data and metrics. To take modelling in Power BI up a notch, you will need to understand DAX.
Master DAX in PowerBI


  • Dates: Jul 31st, 2019
  • Dates: Aug 15th, 2019
  • Time: 12:00pm AEST
  • Price: $99
  • Skill Level: Beginner
  • Duration: 60 mins
  • CPD hours: 60 mins
  • Live Q&A
  • Instructor Led
  • Class size (max): 25
  • Exercise Materials
  • Great Reviews
  • Recorded Playback

BOOK NOW


Learning Outcomes in a Nutshell

We will begin by revisiting the basic concepts of Excel formulas and then focus on where DAX is used in Power BI. We will introduce Quick Measures, the easiest way to perform calculations without writing any code. Then we will demonstrate some basic DAX functions before wrapping up with some suggested next steps based on your learning needs.

Course Content
What and Where is DAX
  • What is the DAX language
  • Where is DAX used

Formulas in Excel

  • Structure of Excel Formulas
  • How Excel formulas translate to DAX

  Power BI Data Modelling

  • Getting started with Data Modelling
  • Tables and Relationships

  Aggregations in Power BI visuals

  • Using DAX to Aggregate

  Quick Measures in Power BI

  • What are Quick Meaures
  • Creating a Quick Measure

  Basic DAX functions in Power BI

  • What is a DAX Function
  • Creating a basic DAX function

  Creating tables, measures and columns

  • Create a Table
  • Create a calculated column
  • Create a measure

  Learning stages of DAX and useful resources

  • What to expect on the DAX journey
  • Where to from here

Course Prerequisites
There are basic skills and software requirements for this workshop. To get the most out of this webinar, make sure you have the software ready to go.

Skill Requirements:

  • Able to use common Excel forumulas (such as IF, SUM, VLOOKUP)
  • Able to create Power BI reports, dashboards and visuals
  • Familiarity with Power BI Desktop and basic data models
  • Understand Get Data and how to create relationships between tables

Software Requirements:

  • Microsoft Excel and Power BI Desktop

Meet our Trainer

Matt Cymblak is the Technical Lead at Excel Consulting and has recently led the development of advanced and specialised course in Business Intelligence (Power BI and DAX) as well as modern offerings in Office 365.

He has a breadth of Information Technology experience having spent over 12 years at a global automotive manufacturer. That entailed roles spanning responsibilities across the Asia Pacific region, dealing with the associated technology and business complexities of such an operating environment and experiencing many different jobs across the IT operation.

Matt then had a stint in an analytical-driven start-up intent on shaking up the energy sector; the green-field beginnings of designing a business and leveraging modern technology.

At Excel Consulting, Matt brings his technology and L&D experience together – not only as a leader and mentor in the corporate world but also several years of lecturing, tutoring and supporting University learning.


How our Webinars Work

  • Click Book Now, select your Webinar and Sign Up
  • Receive Email with Login Details
  • 5 Days ahead of course check your login credentials work
  • Day of course Log On to join the Webinar
  • Q&A session will be facilitated and explained by the presenter
EXCEL CONSULTING Microsoft WORKSHOPS


Why train with Excel Consulting?

“We are passionate about Professional Development and continue to invest in our trainers, courses and material so our students can achieve fantastic learning outcomes.”

presentation

Instructor Led

cityscape-2

Remote Login

notebook

Materials

clock_re

Short Sessions

certificate

Expert Trainers

chat

Live Q&A


Book Now or if you are eager to learn more, check out our face-to-face Power BI Courses.