Microsoft SSAS Online Training
SSAS - SQL Server Analysis Services
The main usage of SSAS is to build OLAPS/Online analytical processing. The basic idea to create OLAP is to trade of increased storage space for speed of querying. OLAP does this by pre-calculating and storing aggregates when you identify the data that you want to store in an OLAP data base, analysis services analyze it in advance. (Online Training Materials are the best Institutes for Microsoft SSAS Online Training)
The basic concepts of OLAP
1. Cube: The basic unit of storage and analysis in analysis services is the cube.
A cube is a collection of data that is been aggregated to allow queries to return data quickly.
Cubes are ordered into dimensions and measures. Dimensions come from dimension table. Measures come from fact table.
Dimension Table: It contains hierarchical data by which you would like to summarize.
For example: An order table that you might group by year, month, week and day of receipt.
Dimension: Each cube has one (or) more dimensions. Each dimension based on one (or) more dimension tables.
Fact Table: It contains basic information that you want to summarize.
NOTE: Any table that you have used with SUM, Average functions in a total. Query is a good bet to be a fact table.
Measure: Each cube will contain one (or) more measures. Measure is a key value to analyze (or) to evaluate the performance of organization.
Schema: There are two types of schemas in OLAP
1. Star Schema
2. Snow Flake Schema
- In star schema, every dimension table related directly to fact table.
- In snow flake schema some dimension tables are related
indirectly to the fact table. (Microsoft
SSAS training is offered by Online Training Materials)