• Exeter, Devon EX2 7AE
  • hello@amesolutions.co.uk
  • Office Hours: Monday - Friday 8:30 AM – 5:00 PM
Thumb
A Practical Guide to Power BI DAX Training Course

A Practical Guide to Power BI DAX Overview

This page gives you a full overview of our Practical Guide to DAX Course what’s included, the key topics we cover, and what you can expect to learn as experienced user of Power BI.

    A Practical Guide to DAX Training Overview

    DURATION

    Two full days: 9:30am – 4:30pm

    LOCATIONS

    Exeter, Manchester, Liverpool, London, Bristol, Onsite at your premise, Remote Live Session via Teams

    For onsite courses we can provide the rental of laptops with the software pre-installed.

    SECTORS WE TRAIN

    NHS and Healthcare, MOD, Police, Councils, Energy, Water

    OVERVIEW AND OBJECTIVES

    This course is aimed at existing users of Power BI, Excel Power Pivot, or SQL Server Analysis Services (SSAS) Tabular, who need to take their data analysis skills to the next level.

    You will learn how to mine and expose hidden information with the DAX (Data Analysis eXpressions) language. Common business scenarios are covered, highlighting useful DAX patterns that can be implemented and adapted to solve a variety of simple and complex calculations. The theory behind the concepts of DAX will be emphasised through practical examples.

    Little, or no, previous knowledge of DAX is assumed. The training is designed from the ground up to introduce delegates to this new and powerful technology, and ultimately provide attendees with a more intimate knowledge of DAX. There is a linear progression throughout the training from the initial introductory material through to more intermediate and advanced topics. There is an emphasis on practical applications of DAX to enable delegates to be productive right from the word go after attending this course.

    You will find that this is a comprehensive course for this level, with plenty of illustrated examples and augmented with practical hands-on exercises.

    Upon successful completion of this course, students will be able to:

    🔹Create and use calculated columns

    🔹Create and use measures

    🔹Understand the key concepts of tabular data modelling

    🔹Understand evaluation contexts

    🔹Work with the CALCULATE function

    🔹Work with the FILTER function

    🔹Work with date functions

    🔹Understand time intelligence in DAX

    🔹Make decisions in DAX expressions

    🔹Understand iterator functions

    🔹Work with complex table relationships

    🔹Create and use custom calendars

    🔹Create and use DAX variables

    🔹Gracefully handle errors in DAX

    TARGET AUDIENCE

    The course is for existing users of Power BI, Excel Power Pivot, or SQL Server Analysis Services (SSAS) Tabular who want to advance their data analysis skills.

    WHATS INCLUDED

    🔹Professional instructor‑led training

    🔹Courseware included

    🔹Lunch provided

    🔹Free on‑site parking at our Exeter training suite

    🔹Certificate of completion

     

    COURSE PREREQUISITES

    Delegates should ideally have a working knowledge of Power BI Desktop, commensurate with that attainable by attending the 3-day “Power BI Desktop Complete” course, or similar. Alternatively, prior experience of Power Pivot, SQL Server Analysis Services (SSAS) Tabular, or similar tool that works with the tabular model, should prove suitable. No previous knowledge of DAX is assumed.

    WHY CHOOSE OUR Practical Guide to DAX TRAINING?

    With years of experience delivering Practical Guide to DAX courses to businesses and individuals, we make learning DAX simple, practical, and enjoyable. The Complete course provides the ideal foundation for building your skills for work, study, and personal use.

    SUBJECT AREAS

    • Course Overview
    • Introducing the DAX Expression Language
    • Adding Calculated Columns
    • Properties of Calculated Columns
    • Adding Measures
    • Formatting DAX Code
    • Measures that Use Other Measures
    • Benefits of Measures
    • Tabular Data Modelling Concepts
    • Table Relationships
    • Filters Across Multiple Tables
    • Active & Inactive Relationships
    • Using the CALCULATE Function
    • Evaluation Context
    • Filter Operators
    • Modifying the Filter Context
    • When Should You Use FILTER?
    • Using the FILTER Function
    • Date Functions in DAX
    • Introduction to Time Intelligence
    • Creating a Date Table
    • Time Intelligence Functions
    • Working with Weeks
    • Using the IF Function
    • Checking for the Existence of Data
    • The VALUES Function
    • The Purpose of Iterator Functions
    • The SUMX Function
    • Other Aggregate Iterator Functions
    • Understanding Semi-Additive Calculations
    • Multiple Relationships Between the Same Two Tables
    • The USERELATIONSHIP Function
    • Disconnected Tables
    • Introducing Custom Date Tables
    • Creating Measures to Work with Custom Calendars
    • Ranking Data
    • Using DAX Variables
    • Handling Errors in DAX
    Have Questions or Ready to Book?

    For more information, or to book onto our Practical Guide to DAX training course, please get in touch.

    If there’s a training course you’re interested in that isn’t listed on our website, let us know we can arrange one‑to‑one onsite training with our trainer.

    You can view our full list of training courses here.

    Office Location

    2nd Floor Wear House, Topsham Road,
    Exeter, Devon. EX2 7AE.

    Phone

    01392 824022

    Email

    hello@amesolutions.co.uk

    Name