12/04/2012 12:17:52 PM
For those who thought that SQL, MDX and C# were enough languages to learn, PowerPivot introduces a new expression language, DAX (Data Analysis Expressions). DAX offers the power and flexibility of set based languages, while retaining the simplicity and familiarity of Excel-like formulas. This session explains the fundamentals and concepts behind DAX and demonstrates how to add business logic in PowerPivot using calculated columns and measures. Various categories of DAX functions will be demystified, including scalar functions, table functions, aggregates and time intelligence.
Aout the Presenter
Gavin Russell-Rockliff is the National Business Intelligence Lead for Avanade Australia.
He has a passion for all things related to data interpretation and analysis, and how they impact business decisions.
In his career, he has been able to help clients across a wide variety of industries, including retail, hospitality, finance, Government, and manufacturing. Solutions implemented have covered all elements of the Microsoft BI stack, SSIS, SSAS, SQL, SSRS, MDS, SharePoint, and of course, Excel!
Avanade is a subsidiary of Accenture. It is a multinational IT consulting and software company that develops business software from a Microsoft products platform.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish |
On: Tuesday, 17 April 2012