Neal Waterstreet

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

Atlanta Modern Excel – May Meeting

Posted on Written 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

Posted on Written 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)