Neal Waterstreet

Atlanta Modern Excel – August Meeting

by Leave a Comment

Topic: Introduction to Power Query

Summary: In this session, I will introduce you to Microsoft’s new self-service ETL tool “Power Query” for Excel.  I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline.  I will show you how you can discover and mash data from public data sources within Power Query.  If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn the new way to acquire and clean your data using “Power Query” in Excel.

Speaker: Damu Venkatesan

When: 6:30PM on Wednesday, August 17, 2016

Where: Microsoft Alpharetta Office, 1125 Sanctuary Pkwy #300, Alpharetta, GA 30009

Atlanta Modern Excel – July Meeting

by Leave a Comment

Topic: Friends & Foes: What does it mean to be an Excel power User?

Summary: As an Excel Pro, you’ve got lots of friends – all of those people you support with your fast reporting, the accountant down the hall who you showed a pivot table to for the first time, your boss who you introduced to slicers, etc. But as an Excel Pro you also have lots of enemies that you might not even know about (or maybe you do know about them!). This session is all about learning to make new friends as you step up your game with the new “Power” tools in Excel. To everyone else you’ll become much more than “just an Excel user” although deep down in your heart Excel will still be your first love. We’ll “touch on” Power Pivot, Power Query, Power BI, SSAS Tabular, & DAX – this will not be a technical talk.

Speaker: Austin Senseman, Lead Consultant, Ten Thousand Things

When: Wednesday, July 20, 2016

Where: Microsoft Alpharetta Office, 1125 Sanctuary Pkwy #300, Alpharetta, GA 30009

Presenting at Atlanta Microsoft Business Intelligence Group

by Leave a Comment

I’m presenting R 101 (Introduction to R) at the Atlanta Microsoft Business Intelligence Group on Monday, March 30th. It is the first time I’ve presented in a year and a brand new topic (for me) – R.

Here is the abstract:

“Even though it has been around for a long time, R is still one of the leading languages for data science. It has recently started to attract a lot of attention, but what is R and what is it used for? This session will help with getting started using R by looking at the basics of the language including: reviewing the basics of the R syntax, leveraging existing packages, importing and modifying data and visualizing the results.”

If you get a chance, please try to stop by.