IT Skills Data and Databases Data Visualization Design Data Models in Power BI
A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis.
Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations.
Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context.
When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations.
Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context.
When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
| Objectives |
|---|
PL-300: Using Time Intelligence in Power BI
|
