Power BI Data Modeling & DAX

Beginning/Intermediate 1 day

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

  1. 9:00am - 5:00pm PT
  2. 12:00pm - 8:00pm ET
$299.50
  1. 6:00am - 2:00pm PT
  2. 9:00am - 5:00pm ET
$299.50
  1. 9:00am - 5:00pm PT
  2. 12:00pm - 8:00pm ET
$299.50
  1. 6:00am - 2:00pm PT
  2. 9:00am - 5:00pm ET
$299.50
$99.00
$129.00
$149.00

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

You may also be interested in

Transform Data with Power Query Editor Using Power BI

Learn more about this course

  • Payments by purchase order and invoice incur a $50 service fee.
  • Paying party will receive a payment confirmation email upon receipt of payment.
  • Each registered student will receive an email with the course details.
  • Students will receive electronic copies of the course materials and may print one hard copy for their personal use. The course materials are copyrighted and any other reproduction or distribution of these materials is strictly prohibited.

This class requires a local copy of Power BI Desktop. Download it for free.

Instructor-led online

We recommend using two monitors in order to simultaneously view the training presentation and hands-on class work.

You’ll receive a Zoom link to join the class. We recommend using a headset instead of the computer’s microphone and speakers. You may also listen to the audio by phone.

Instructor-led online

  • 100% refund for cancellations made more than 10 days before the first class
  • 50% refund for cancellations made 5-9 days before the first class
  • No refund for cancellations made less than 5 days before the first class

Self-paced

  • Full refund if cancelling within 24 hours of registration
  • $15 fee for cancellations after 24 hours of registration
  • No refund for cancellations after 15 days of registration
  • Shared subscriptions will be immediately deactivated and no refund issued