Next Meeting: Wed, Apr 05 2017
HASSUG April Meeting
Event Type: In-Person
Online Meeting URL: None
6:00 – 6:20 – Networking & Pizza
6:20 – 6:25 – Announcements
6:25 – 7:30 – Time Intelligence in DAX By Marco Russo
Note: We had the opportunity for Marco to speak to us while he is in town, so we hope you can take advantage of it!
UTC : Wed, Apr 05 2017 23:00 - 00:30
Event Time : Wed, Apr 05 2017 18:00 - 19:30 Central Daylight Time
Your Local Time: Wed, Apr 05 2017 23:00 - 00:30
10111 Richmond Ave
Direction: We will be meeting on the first floor in Suite 170.
Time Intelligence in DAX
Marco Russo, Consultant SQLBI
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 is a Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design. He has spoken at international conferences such as Ignite, PASS Summit, SQLRally, and SQLBits. Marco is also the author of several books about Analysis Services, Power Pivot, and DAX.