What You Need to Know Before
You Start

Starts 8 June 2025 02:38

Ends 8 June 2025

00 days
00 hours
00 minutes
00 seconds
course image

Power BI Time-Intelligence - Beyond the Basics

Explore advanced time-intelligence techniques in Power BI, including custom date tables, filter context manipulation, and complex DAX functions for sophisticated business analytics.
PASS Data Community Summit via YouTube

PASS Data Community Summit

2544 Courses


1 hour 3 minutes

Optional upgrade avallable

Not Specified

Progress at your own speed

Conference Talk

Optional upgrade avallable

Overview

Explore advanced time-intelligence techniques in Power BI, including custom date tables, filter context manipulation, and complex DAX functions for sophisticated business analytics.

Syllabus

  • Introduction to Advanced Time-Intelligence in Power BI
  • Overview of time-intelligence concepts
    Importance in business analytics
  • Custom Date Tables
  • Creating and configuring custom date tables
    Utilizing date tables for accurate time-based analysis
    Best practices for date table integration
  • Filter Context Manipulation
  • Understanding filter context in DAX
    Advanced filtering techniques
    Implementing complex slicers and filters
  • Advanced DAX Functions for Time-Intelligence
  • Deep dive into DAX time-intelligence functions
    Leveraging CALCULATE for dynamic calculations
    Using PREVIOUSMONTH, NEXTMONTH, SAMEPERIODLASTYEAR, and other functions
  • Designing Sophisticated Business Analytics
  • Combining multiple DAX functions for complex reports
    Building comprehensive dashboards with time-based insights
    Case studies: Practical application in business scenarios
  • Practices and Pitfalls
  • Common challenges and mistakes in time-intelligence
    Strategies for optimizing performance
  • Capstone Project
  • Developing a full-fledged time-intelligence report
    Peer review and feedback session
  • Conclusion and Next Steps
  • Recap of key concepts
    Additional resources for further learning

Subjects

Conference Talks