PL-300: Using Time Intelligence in Power BI
Microsoft Power BI 2.96
| Intermediate
- 7 Videos | 54m 14s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this coursedefine a date table to represent a date using a variety of dimensions and formatsset a relationship between a date table and a fact tablemodify the range of dates in the current context using the DATEADD function
-
perform year-to-date and month-to-date computations on data by altering the current contextcalculate the year-to-date sales values using the TOTALYTD functionsummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview3m 4sUP NEXT
-
2.Creating a Date Table12m 20s
-
3.Relating Date Tables to Other Tables10m 48s
-
4.Using the DATEADD Function to Modify Date Ranges11m 25s
-
5.Using Year-to-date and Month-to-date Functions10m 9s
-
6.Applying the TOTALYTD Function4m 4s
-
7.Course Summary2m 25s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.