Never had the time to learn DAX? Now is the time! Author Owen Duncan just released a DAX 101 course as part of the DAX Resource Center Wiki to help you learn DAX basics quickly and efficiently. The title says you can do this in 30 Minutes, but don’t...

This article is a follow-up on a previous blog post titled “ How to Build a VSTO-Based PowerPivot Workbook ,” which discussed some of the advantages and disadvantages of building PowerPivot workbooks by using VSTO. A key VSTO advantage is...

Happy New Year 2012, everybody! With the release of SQL Server 2012 ante portas, this is going to be a very exciting year. So, let’s start this year with a release announcement: An updated version of the whitepaper “ Data Analysis Expressions...