Name: Time intelligence and date tables in Power BI & Excel - Marco Russo
Start: 2018-05-16T18:30:00-04:00
End: 2018-05-16T20:00:00-04:00
Location: Microsoft Office - Avalon

• What we'll do
Session by Marco Russo, MVP, Author, DAX Guru

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.

• What to bring

• Important to know
We will provide only soft drinks as we do not have any sponsors. Please RSVP as space is limited.

Damodaran Venkatesan (Damu)

Atlanta Modern Excel User Group

Technology

Business Intelligence

Data Analytics

Data Visualization

Predictive Analytics

Microsoft Excel

Microsoft Office

Spreadsheets

DAX Power BI

Microsoft Excel PowerPivot

Power Query

Power Pivot

Time intelligence and date tables in Power BI & Excel - Marco Russo

Microsoft Office - Avalon

Share

Atlanta Modern Excel User Group

Time intelligence and date tables in Power BI & Excel - Marco Russo

Atlanta Modern Excel User Group

Details

Members are also interested in