Categories
Uncategorized

Power BI Time-Intelligence: Beyond the Basics

Quick note to the Power BI developers looking to up their DAX game… I’ll be presenting a new session – Power BI Time-Intelligence: Beyond the Basics – to the following user groups…

Baltimore SQL Server Users Group
April 20, 2020 | Details

Atlanta BI SQL Server Users Group
May 4, 2020 | Details

…if you can’t make those don’t worry, there will be plenty more opportunities posted in the next few weeks!

Power BI Time Intelligence – Beyond the Basics

Time-Intelligence refers to analyzing calculations and metrics across time and is the most common type of business intelligence reporting. Power BI has a lot of built in capabilities to help you get started but these alone are not enough for most real-world solutions.

The key to mastering time-intelligence in Power BI is a good date table and understanding how to manipulate the filter context. This session will teach you how to do both!

In this (demo-heavy) session, we’ll quickly review Power BI’s built-in time intelligence capabilities and why you should avoid them! We’ll also cover the importance of a good date table, what attributes it should include, and how it can be leveraged to simplify complex time-intelligence calculations. Finally, we’ll breakdown many of the 40+ DAX time-intelligence functions, showing you how they work under the covers (hint: filter context) and how they can used in combination to accommodate complex business logic.

Need immediate help? Contact me here

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s