YoVDO

Power BI Data Modeling with DAX

Offered By: LinkedIn Learning

Tags

Microsoft Power BI Courses DAX (Data Analysis Expressions) Courses Data Modeling Courses Calculated Columns Courses Aggregate Functions Courses Data Analysis Expressions (DAX) Courses

Course Description

Overview

Take your data modeling skills to the next level. Learn how to leverage Data Analysis Expressions (DAX) to create formulas for Power BI that extend your data model.

Syllabus

Introduction
  • Build powerful data models with DAX
  • What you will need
1. Set Up the Data Model
  • Data modeling: The basics
  • Get data for your model
  • Check relationships
2. DAX Aggregate Functions
  • Create a measure with SUM
  • Understanding DAX syntax
  • Display the measure in a matrix
  • Format a measure
  • Create measures with COUNT and COUNTROWS
  • Delete or edit a measure
  • Check your data with COUNTBLANK
  • Create a measure with DISTINCTCOUNT
3. Measures and Calculated Columns
  • Add a calculated column
  • Understand explicit vs. implicit measures
  • Create a measure with operators
  • Create a measure with DIVIDE
  • Iterators and row context: SUMX
  • Basic DAX date and time functions
4. DAX Logical and Filter Functions
  • Use FIND
  • Use IF
  • Use OR to handle case sensitivity
  • Use CALCULATE to create a simple filter
  • Use SWITCH
5. Using DAX Time Intelligence Functions
  • DAX time intelligence functions
  • Summarize year-to-date with DATESYTD
  • Visualize cumulative YTD data
  • Compare totals with SAMEPERIODLASTYEAR
Conclusion
  • Next steps

Taught by

Gini von Courter

Related Courses

MongoDB for Developers
MongoDB University
Data Wrangling with MongoDB
MongoDB via Udacity
Intro to Point & Click App Development
Salesforce via Udacity
SAP Business Suite powered by SAP HANA
SAP Learning
Desarrollo de Aplicaciones Web: Conceptos Básicos
University of New Mexico via Coursera