Topic: Time Intelligence and Date Tables in Power BI & Excel

Speaker: Marco Russo (MVP, Author, DAX Guru)

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

RSVP at https://www.meetup.com/Atlanta-Modern-Excel-User-Group/events/250622970/

When: Wednesday, May 16, 2018

Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)

Topic: Data Modeling for Atlanta Excellers

Speaker: Patrick LeBlanc  (https://twitter.com/patrickdba)

Summary: In this session, I will show you what, why, and how to do data modeling. In this session, we will take a flat data file and show you what you need to consider, how you can model this data in Excel as individual tabular structure and how you can connect these tables. You will walk away with the basic data modeling concepts and techniques that will be very useful in the real work when you do data analysis using Excel and PowerBI.

RSVP at https://www.meetup.com/Atlanta-Modern-Excel-User-Group/events/239729655/

When: Wednesday, May 17, 2017

Where: Microsoft Alpharetta Office, 1125 Sanctuary Pkwy #300, Alpharetta, GA 30009 (https://binged.it/2nYkfyz)