To follow the examples used in this book, we recommend that you have a PC with the following software installed on it:
Microsoft Windows Vista SP2 or greater for desktops
Microsoft Windows Server 2008 SP2 or greater for servers
Microsoft SQL Server Analysis Services 2012 Multidimensional
Microsoft SQL Server 2012 (the relational engine)
Microsoft Visual Studio 2012 and SQL Server Data Tools
SQL Server Management Studio
Excel 2007, 2010, or 2013 is an optional bonus as an alternative method of querying the cube
We recommend that you use SQL Server Developer Edition to follow the examples used in this book. We'll discuss the differences between Developer Edition, Standard Edition, BI Edition, and Enterprise Edition in Chapter 2, Building Basic Dimensions and Cubes; some of the functionalities that we'll cover are not available in the Standard Edition and we'll mention that fact whenever it's relevant.