17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

Time Intelligence in DAX

Time Intelligence is probably the most interesting feature of any analytical solution. Computing Year To Date, Month To Date, Same Period Previous 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 that require to think out of the box, using advanced data modeling and querying techniques to produce interesting and useful formulas.
Presented by Alberto Ferrari at SQLBits X
Tags DAX
  • Downloads
  • SpeakerBIO
    alberto_ferrari.jpg
    Alberto Ferrari is a Business Intelligence consultant. Alberto helped several software houses to build complex BI solutions, from the OLTP to the final OLAP cubes, providing planning hints all over the development lifecycle. He is a book author also, having worked on "Exper Cube Development with Microsoft SQL Server 2008" with Marco Russo and Chris Webb and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning with Marco Russo.
    http://sqlblog.com/blogs/alberto_ferrari/default.aspx http://sqlblog.com/blogs/alberto_ferrari/rss.aspx
  • Video
  • Session Files Explorer
    The network name cannot be found.