Speaking at SQL Saturday 347, Washington D.C.

I will be speaking at the upcoming SQL Saturday in Washington D.C. I have two sessions, one on DAX and one on Power Query.

Get Into Evaluation Context with DAX, the Language of PowerPivot

Data Analysis Expressions (DAX) is the language of PowerPivot and the Analysis Services Tabular engine. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula. Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demonstrate row and filter context.

This session will be at 9:40 AM on Saturday December 6th.

Data Discovery with Power Query for Excel

Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing.

This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.

This session will be at 2:55 PM on Saturday December 6th

Hope to see you there.

Reeves

About Reeves Smith

Reeves Smith is a consultant and trainer. He holds a Bachelor’s Degree in Applied Mathematics from University of Colorado at Colorado Springs and a Microsoft Certified Master with over 17 years of experience working with SQL Server. Reeves is an independent BI consultant and teammate with Linchpin People. He is an active member of the Denver, CO, PASS chapter and delivers technical presentations at local and regional conferences and user groups. He has had the opportunity to work on various development and data warehouse projects within industries like banking, DoD, energy, entertainment, gaming, healthcare, manufacturing, oil and gas, travel, and telecommunication. You can follow him on Twitter at SQLReeves.
This entry was posted in Speaking. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s