Microsoft BI Community (MSBIC)

Next Meeting

iCal

Tuesday,

October

24

MSBIC October 2017 Meetup - Time Intelligence in Power BI with Marco Russo

Time Intelligence in Power BI

Time Intelligence is probably the most interesting feature of any analytical solution. Computing Year-To-Date, Month-To-Date, Same-Period-Last-Year, is quite easy in DAX but, as soon as the customer requests for time intelligence require working days’ evaluation, complex and custom calendar shapes, seasonal pattern recognition, the DAX formulas start to be harder to write.

In this session, we are going to show how to compute classical time intelligence with the built-in DAX functions. Then, we will show some more complex time intelligence formulas, which require thinking out of the box, using advanced data modeling and querying techniques to produce interesting and useful formulas.

 

Marco Russo

Marco is a Business Intelligence consultant and mentor.  His main activities are related to data warehouse relational and multidimensional design, but he is also involved in the complete development lifecycle of a BI solution. He has particular competence and experience in sectors like financial services (including complex OLAP designs in the banking area), manufacturing, gambling, and commercial distribution.  Marco is also an author and, in addition to his BI-related publications, he has authored books about .NET programming. He is also a speaker at international conferences such as TechEd, PASS Summit, SQLRally, and SQLBits.

http://www.sqlbi.com/author/marco-russo/

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids