Chapter 2. Installing SSAS and Preparing for Cube Development

SQL Server Analysis Services (SSAS) is an analytical engine that can handle vast amounts of data with high performance. The server engine manages, processes, and queries the BI Semantic model (BISM). The BI semantic model consists of metadata defining the business logic and data access, and the data coming from the data sources.

This chapter will cover the following topics:

  • How to choose the correct model
  • Installing Analysis Services
  • Understanding the development toolset
  • Setting up the project environment for development