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.