Power BI Data Modeling & DAX

Beginning/Intermediate 1 day
Back to course catalog

In this course you will learn to

  • Get familiar with data modeling terminology
  • Understand relationships
  • Filter data
  • Work with dates
  • Examine aggregates and historical reporting
  • Build a union calculated table
  • Get familiar with row-level security
  • Optimize a model
  • Understand DAX context
  • Work with CALCULATE and ALL functions
  • Handle dates with DAX
  • Review common DAX functions
  • Manipulate string data
  • Use DAX with time
  • Use DAX with semi-additive measures

Included in this course

  • Hands-on exercises
  • Course manual

Suggested attendees

Business analysts with technical skills or IT personnel.  No DAX experience required. Basic experience with Power BI and data manipulation is beneficial.

Choose Format

Instructor-led online
$99.00
$129.00
$149.00
Private group training
888-601-6010

Course Outline

  • Data modeling
  • Learn terminology
    • Data models
    • Schemas
    • Tables
    • Relational data
    • Transactional data vs. dimensional data
    • Facts and dimensions
    • Snowflakes
    • Denormalization
  • Understand relationships
    • Joins
    • Cardinality
  • Filter data
    • Understand filtering and cross-filtering
    • Work with multiple fact tables
    • Handle many-to-many relationships
  • Work with dates
    • Understand dates
    • Continuous vs. non-continuous dates
    • Parts of a date
  • Create date tables
    • DAX functions
    • Manual creation
    • M
  • Work with dimensions
    • Discuss slowly changing dimensions
    • Handle a role-playing dimension
  • Aggregate data
    • Look at granularity issues
    • Review snapshots
    • Store historical data
    • Discuss materialized views
    • Work with aggregate tables
  • Calculated tables
    • Create calculated tables
    • Add a union
  • Data security
    • Handle data security
    • Row-level security
    • Security filters
  • Review how to optimize a data model
  • DAX
  • Contextual DAX
    • Understand context
    • How to create DAX and consider:
      • Row context
      • Filter context
  • Use DAX to calculate percent of total with CALCULATE and ALL
  • Create DAX functions to work with dates
  • Additional common functions
    • Learn the difference between SUM and SUMX
    • Work with COUNTROWS
  • Use DAX functions with string data types
  • Discuss time and date-based functions
  • Review additive vs. semi-additive measures