PL-300: Using Time Intelligence in Power BI

Microsoft Power BI    |    Intermediate
  • 7 videos | 54m 14s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 166 users Rating 4.5 of 166 users (166)
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 PL-300: Analyzing Data with Microsoft Power BI certification exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Define a date table to represent a date using a variety of dimensions and formats
    Set a relationship between a date table and a fact table
    Modify 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 context
    Calculate the year-to-date sales values using the totalytd function
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 3m 4s
  • 12m 20s
  • Locked
    3.  Relating Date Tables to Other Tables
    10m 48s
  • Locked
    4.  Using the DATEADD Function to Modify Date Ranges
    11m 25s
  • Locked
    5.  Using Year-to-date and Month-to-date Functions
    10m 9s
  • Locked
    6.  Applying the TOTALYTD Function
    4m 4s
  • Locked
    7.  Course Summary
    2m 25s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course PL-300: Advanced Modeling Technique in Power BI
Rating 4.5 of 100 users Rating 4.5 of 100 users (100)
Course PL-300: Maps, Waterfall Charts, & Scatter Plots in Power BI
Rating 4.5 of 83 users Rating 4.5 of 83 users (83)
Course PL-300: Sharing Power BI Reports & Workspaces
Rating 4.7 of 122 users Rating 4.7 of 122 users (122)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Extracting Insights from Data Using Power BI
Rating 4.7 of 98 users Rating 4.7 of 98 users (98)
Course PL-300: Loading & Transforming Data in Power BI
Rating 4.7 of 830 users Rating 4.7 of 830 users (830)
Course PL-300: Sharing Power BI Reports & Workspaces
Rating 4.7 of 122 users Rating 4.7 of 122 users (122)