Marco Russo from SQLBI: Time Intelligence and Date Tables in Power BI

Session Title: Time intelligence and date tables in Power BI
Description:
Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation’
This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.

Prerequisites:
You should have some experience in importing data in Power BI and creating models with one ore more dates. Some knowledge of DAX is welcome, even if not required.

Bio:
Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services.
A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services.
Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.
Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits.