Business Intelligence

SQT10 Time Intelligence in Power BI

11/16/2021

4:15pm - 5:30pm

Level: Intermediate

Thomas LeBlanc

Data Warehouse Architect/MVP

Data on the Geaux

Once a model is built in Power BI, the developer will need to understand what's already built to help with date grouping. A simple data table can be added as a dimension table from a Data Mart or built with a DAX formula. This session will look at the Date Table in a Tabular Model in Power BI. The flow will continue into the DAX functions most useful. There will be a guide with example code for groupings and filters. The Time Intelligence in Power BI data models is one option a developer should always include.

You will learn:

  • What is time intelligence
  • The Date Dimension
  • DAX functions for Time Intelligence