Mastering Business Intelligence with DAX, Power BI and Excel (Video)

Description

• Copyright 2025
• Edition: 1st

• Online Video
• ISBN-10: 0-13-540704-4
• ISBN-13: 978-0-13-540704-2

Over 9 hours of video content

In this course, Michiel Rozema and Madzy Stikkelorum help you understand the core concepts of DAX and how to design, build, debug, and optimize DAX calculations.

Overview:

Since its launch, Power BI has quickly become the leading platform for business intelligence. With powerful self-service capabilities and integrated data preparation, analytics, and visualization features, Power BI enables business users to gain insights like no other. One of the core strengths of the platform is the DAX calculation language, which is available in Excel as well. While Power BI is designed to allow for easy entry, implementing sophisticated analyses with DAX can be a daunting task. If you work with data, you can use Power BI or Excel to implement sophisticated models to analyze and get insights from your data. To do this, you will need to learn to build calculations with the DAX language.

This course helps you to understand the foundational concepts in DAX and to design your own DAX calculations step by step. The course includes many exercises to practice your DAX skills. The central challenge in business intelligence is to translate the way your business works to appropriate data aggregations; this course will enable you to do just that.

Skill Level:

• Beginner/Intermediate

Learn How To:

• Understand the foundational concepts in DAX
• Design your own DAX calculations step by step
• Organize DAX Calculations and Create Visual Calculations
• Create and Use Calculation Groups

Course requirement:

• This course is an in-depth training on DAX, but starts with the very basics. Some experience in data models in Excel (Power Pivot) or Power BI (semantic models) will help.

Who Should Take This Course:

• Data analysts
• Business controllers
• Marketing specialists
• Business executives
• Managers

About Pearson Video Training:

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more.  Learn more about Pearson Video training at  http://www.informit.com/video.

 

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.



Sample Content

Table of Contents

Introduction

Lesson 1: Understand the Role of DAX

1.1 Understand the five-Layer model for business intelligence

1.2 Use DAX in Power BI

1.3 Use DAX in Excel

Lesson 2: Design Semantic Models

2.1 Understand the column store

2.2 Choose data types

2.3 Design efficient tables

2.4 Understand relationships

2.5 Define an effective model structure

2.6 Decide on model architecture

2.7 Exercises

Lesson 3: Learn the Basics of DAX

3.1 Extend a model with calculated columns

3.2 Extend a model with calculated tables

3.3 Understand measures

3.4 Use basic aggregations

3.5 Apply operators

3.6 Implement conditional logic

3.7 Exercises

Lesson 4: Organize DAX Calculations

4.1 Use a measure table and folders

4.2 Add metadata

4.3 Work with the DAX editor

4.4 Exercises

Lesson 5: Create Visual Calculations

5.1 Understand AutoExist

5.2 Leverage the visual matrix

5.3 Add a visual calculation

5.4 Use more advanced visual calculations

5.5 Navigate the visual matrix with DAX

5.6 Exercises

Lesson 6: Understand Filters, Context, and CALCULATE

6.1 Explore filters

6.2 Understand row context

6.3 Understand query context

6.4 Use filter context with CALCULATE

6.5 Exercises

Lesson 7: Build More Advanced Calculations

7.1 Use ALL functions

7.2 Change relationship behavior

7.3 Leverage KEEPFILTERS

7.4 Use variables in DAX

7.5 Exercises

Lesson 8: Use Time Intelligence

8.1 Create a date table

8.2 Understand time intelligence

8.3 Use common time intelligence functions

8.4 Exercises

Lesson 9: Understand DAX Table Functions

9.1 Use table aggregations

9.2 Leverage virtual tables

9.3 Understand row context in table functions

9.4 Retrieve summarized tables

9.5 Change context for table evaluation

9.6 Exercises

Lesson 10: Apply Table Functions Within CALCULATE

10.1 Understand filters and tables

10.2 Change context with virtual tables

10.3 Understand lineage

10.4 Exercises

Lesson 11: Use WINDOW Functions

11.1 Understand what changing context does

11.2 Understand INDEX, OFFSET, and WINDOW

11.3 Use PARTITIONBY and MATCHBY

11.4 Exercises

Lesson 12: Implement Parameters

12.1 Use numeric range parameters

12.2 Implement field parameters

12.3 Exercises

Lesson 13: Create and Use Calculation Groups

13.1 Understand calculation groups

13.2 Add calculation items

13.3 Use dynamic formatting

13.4 Create conditional calculation items

13.5 Exercises

Lesson 14: Use the DAX Query View

14.1 Use Performance Analyzer

14.2 Understand a visual's DAX query

14.3 Use the DAX query view

14.4 Apply quick queries and INFO functions

14.5 Debug measures

14.6 Exercises

Lesson 15: Learn from DAX Exercises

15.1 Understand lesson 2 exercises: semantic models

15.2 Understand lesson 3 exercises: basic DAX

15.3 Understand lesson 4 exercises: organize calculations

15.4 Understand lesson 5 exercises: visual calculations

15.5 Understand lesson 6 exercises: context

15.6 Understand lesson 7 exercises: advanced calculations

15.7 Understand lesson 8 exercises: time intelligence

15.8 Understand lesson 9 exercises: table functions

15.9 Understand lesson 10 exercises: table filters

15.10 Understand lesson 11 exercises: WINDOW functions

15.11 Understand lesson 12 exercises: parameters

15.12 Understand lesson 13 exercises: calculation groups

15.13 Understand lesson 14 exercises: DAX query view

Summary



Updates

Submit Errata

