SQL Server Analysis Services (SSAS)
Data
warehouse developers use Business Intelligence Development Studio to develop
and deploy Analysis Services projects, and use SQL Server Management Studio to
manage the Analysis Services databases instantiated from these projects. Microsoft SQL Server Analysis Services (SSAS)
delivers online analytical processing (OLAP) and data mining functionality
through a combination of server and client technologies, further reinforced
through the use of a specialized development and management environment coupled
with a well-defined object model for designing, creating, deploying, and
maintaining business intelligence applications. Analysis Services helps managers, employees, customers, and
partners to make more informed business decisions by enabling them to analyze
information accumulated during a company's dayto-day operations.
Online analytical processing (OLAP) is a technique for aggregating data to enable business users to
dig into transactional data to solve business problems.
The
basic concepts of OLAP include:
- Cube
- Dimension table
- Dimension
- Level
- Fact table
- Measure
- Schema