Visa utbildning.se som: Mobil

Missa inte Upskill & Reskill den 25 januari 2023 – ett digitalt och kostnadsfritt event! Anmäl dig idag 

Introduction to DAX for Power BI

Learning Tree International AB
Kort om utbildningen
2 dagar
20 900 SEK exkl. moms
Nästa tillfälle: 2022-11-28 - Washington
Öppen utbildning
Distans, London, New York, Ottawa, Stockholm, Washington

Beskrivning av: Introduction to DAX for Power BI

This Introduction to DAX for Power BI presents Data Analysis Expressions (DAX) in Power BI from an intermediate to an advanced level. The journey starts with an introductory discussion about DAX, the syntax of DAX statements, and how to write structured DAX in the DAX editor. You also get an introduction to DAX Studio, a third-party tool that can be used to write DAX. You can decide if you want to use DAX Studio for the course exercises.

We will discuss many of the functions in DAX and how they could be used in a Power BI Project including explaining the use of iterator functions vs standard statistical functions. There are discussions explaining Calculated Columns, Tables, and Measures discussing the differences. There is also an explanation about Quick Measures and how we can utilize those. We will explain DAX Context and where those contexts apply. There are separate discussions for the CALCULATE function, the usage of a Data Model and incorporating a Date Dimension, and also using Time Intelligence Functions. We will conclude with a discussion around utilizing DAX with Row Level Security.

Introduction to DAX for Power BI Delivery Methods

  • In-Person

  • Online

Introduction to DAX for Power BI Course Benefits

  • Structure DAX with Power BI and DAX Studio

  • Extract business intelligence by using DAX

  • Add value with measures, calculated columns and calculated tables using DAX

  • Utilize the different types of Dax functions

  • Appreciate DAX context and where it applies

  • Understand the use of a Data Model and how to extend it

  • Create a Star and/or Snowflake schema as your data model

  • Add a Date dimension to your model

  • Implement Row Level security with DAX

  • Develop a Star Schema from a Flat File Schema

  • Decide when to use M in Power Query or DAX in Power BI

  • Leverage continued support with after-course one-on-one instructor coaching and computing sandbox

Introduction to DAX for Power BI Course Outline

Introduction to DAX for Power BI Course Information

Prerequisites

  • Introduction to Microsoft Power BI Training
  • Power BI: Hands-On Reports and Dashboards Training
  • Power BI: Advanced Data Modeling and Shaping (One-Day Course)
  • or equivalent working experience

Audience Profile

This course has been designed specifically for experienced model developers. We recommend that attendees have prior experience working with Power BI Desktop to create data models.

Exam Information

Learning Tree Exam provided at the end of class

Introduction to DAX for Power BI Course Outline

Chapter 1: Introduction to DAX

In this module, you will learn:

  • What is DAX ?
  • DAX Functions
  • Calculated Columns and Tables
  • Quick Measures and Measures
  • DAX Context
  • Writing DAX in Power BI

Hands-On Exercise 1.1: Introduction to DAX

Chapter 2: Working with a Data Model

In this module, you will learn:

  • Understand the role of the Data Model in Power BI
  • Describe the components of a Data Model
  • What are Star and Snowflake schemas?
  • Fact and Dimension tables
  • How to build a Data Model from multiple Data sources
  • Why create a Date Dimension?

Hands-On Exercise 2.1: Working with a Data Model

Chapter 3: Using DAX in Power BI

In this module, you will learn:

  • Writing DAX with DAX Studio
  • Formatting DAX with DAX Formatter
  • Summarizing and Aggregating functions
  • Working with Joins
  • Filtering with DAX
  • Other useful Dax Functions

Hands-on Exercise 3.1 Working with DAX Functions – Part 1

  • Describe the power behind the CALCULATE function
  • Add filters with the CALCULATE function
  • Ignore filters with the CALCULATE function
  • Update filters with the CALCULATE function
  • Describe Time Intelligence and the Time Intelligence functions

Hands-On Exercise 3.2 Working with DAX Functions – Part 2

Chapter 4: DAX and Row Level Security

In this module, you will learn:

  • What is Row Level Security ( RLS )
  • Useful DAX functions for RLS
  • Defining Roles for RLS
  • Crating DAX Rules for RLS
  • Managing Security and working with Members

Exercise 4.1 Implementing Row Level Security

Chapter 5: Comparing DAX and M

In this module, you will learn:

  • Overview of M in Power Query
  • When to use M or DAX

Intresseanmälan

Fyll i formuläret för att få mer information om Introduction to DAX for Power BI, direkt från arrangören. Det är gratis och inte bindande!

Learning Tree International AB

Learning Tree International

Learning Tree är ett internationellt utbildningsföretag med över 40 års erfarenhet av att leverera utbildning till yrkesverksamma IT-proffs, projektledare, verksamhetsutvecklare och chefer. Vi erbjuder allt från enstaka kurser till globala utbildningsprogram, och vi hjälper våra kunder att införa hållbara processer som fungerar idag och förbereder...


Läs mer om Learning Tree International AB och visa alla utbildningar.

Kontaktuppgifter till Learning Tree International AB

Learning Tree International AB

Fleminggatan 7
112 26 Stockholm

 Visa telefonnummer

Recensioner
Kursrecensioner
Bli den första att recensera Introduction to DAX for Power BI!

Arrangörsrecensioner
(4,5)
Baseras på 1063 recensioner.
Alla recensioner för arrangören
Intresseanmälan

För att få mer information om utbildningen Introduction to DAX for Power BI från Learning Tree International AB, fyll i dina uppgifter: