HASSUG and Houston BI User Group normally meets on the second Tuesday of every month during lunch time.   Occasionally, we will meet at other time, so please watch this page for updates. 

*** MEETING LOCATION  ***

         Improving
10111 Richmond Ave
Houston, Texas 77042

Next Meeting: Wed, Apr 05 2017

HASSUG April Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://meetu.ps/38lQrr

Meeting Agenda:

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!

When

iCal
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

Where

10111 Richmond Ave
Houston, Texas

Direction: We will be meeting on the first floor in Suite 170.

Featured Presentation

Time Intelligence in DAX

Speaker: Marco Russo, Consultant SQLBI

Summary: 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.

About Marco: 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.

Attachments

Welcome to the Houston Area SQL Server Users Group