Power BI DAX Fundamentals ( powerbidax | 21 hours )

• Basic knowledge of Power BI
• Familiarity with the DAX language

Audience

• Business analysts
• Data analysts
• Developers

Microsoft Power BI is a business intelligence platform for transforming, analyzing, visualizing, and presenting data. Data Analysis Expressions (DAX) is a formula language that allows users to create custom calculations and expressions in Power BI to analyze data and derive insights.

This instructor-led, live training (online or onsite) is aimed at beginner to intermediate-level business analysts, data analysts, and developers who wish to learn the fundamentals of DAX in Power BI.

By the end of this training, participants will be able to:

• Have a comprehensive understanding of Data Analysis Expressions (DAX) in Power BI.
• Create custom calculations and expressions in Power BI for analyzing data and deriving insights.
• Learn best practices to optimize DAX performance.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

• Overview of Power BI and its capabilities
• Overview of DAX

DAX Basics

• Understanding the role of DAX in Power BI
• Exploring the DAX formula syntax
• Creating basic DAX expressions
• Understanding data types in DAX

DAX Aggregation and Calculation Functions

• Using aggregation functions
• Using logical functions
• Using mathematical functions
• Using text functions
• Using data and time functions

Optimizing DAX Performance

• Identifying and resolving performance issues in DAX
• Understanding query context and evaluation order
• Optimizing DAX calculations and expressions
• Best practices for DAX development
• Tips and tricks for efficient DAX modeling

Summary and next steps