What you need for this book
As a book which covers many aspects of tabular modeling, the recipes can be followed using a variety of software that incorporates tabular modeling. Although we focus on PowerPivot in Excel 2010 (this is still the most prevalent installation in corporate environments), the recipes can also be completed in Excel 2013. When recipes focus on server and corporate features, SQL Server Analysis Services 2012 (in tabular storage mode) is used. The complete list of software applications used in this book is:
- Excel 2010 (with the free PowerPivot add-in)
- Excel 2013
- SQL Server Data Tools (installed with SQL Server 2012)
- SQL Server 2012 (SQL Server Analysis Server Tabular Mode)