Power BI Data Model Design: Using Time Intelligence

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 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

  • Playable
    1. 
    Course Overview
    3m 4s
    UP NEXT
  • Playable
    2. 
    Creating a Date Table
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.