Neal Waterstreet

Some things I've learned about Data Warehousing, Business Intelligence and other stuff too

Atlanta Modern Excel – May Meeting

by Leave a Comment

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)

DIAD with Prologika

by Leave a Comment

Last week I was able to assist Teo Lachev with the Dashboard in a Day presentation at the Microsoft office in Alpharetta. We had good attendance with over 50 people participating in the class. I’d never attended a DIAD class, and I had a few observations.

The audience appeared to have some experience with Power BI before this class. This experience is evidence of Power BI’s popularity. The reaction last week is what I’d expected from Power Pivot, but that hasn’t really materialized.

There was a wide array of job responsibilities in attendance. A wide range of departments that are learning to use this tool. The questions at the end covered many different topics.

This day goes quickly despite the long list of tasks for attendees. I’d be surprised if anyone finished entirely, but I think that they got a substantial amount completed. Enough to get started!

Atlanta Modern Excel – May Meeting

by Leave a Comment

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)

Atlanta Modern Excel – April Meeting

by Leave a Comment

And…we’re back.

Topic: 7 Ways to Integrate Excel with Power BI

Summary: Power BI is gaining a momentum but Excel still rules the corporate world. Fortunately, Power BI and Excel are not exclusive choices. Join me to learn how you can preserve your Excel investment in Power BI. I’ll start by explaining the value Power BI brings to different types of users in your organization. Then, I’ll discuss and demo seven options for integrating Excel with Power BI:

  • Import Excel files in Power BI Service
  • Build self-service data models from Excel data
  • Deploy Excel models to Power BI
  • Convert Excel models to Power BI
  • Connect to Excel reports
  • Analyze Power BI datasets in Excel
  • Add Excel reports to Power BI dashboards

Speaker: Teo Lachev, Microsoft MVP, Prologika

When: Wednesday, April 19, 2017

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