How to Perform Analysis with SQL Server Analysis Services Project (Step by Step Instruction)

How to Create Cubes, Dimensions and Measures in SQL Server Business Intelligence

What is the use of data if it is not for Analysis. What is the use of RDBMS if it is not providing the Analytics functionality. Here we take a look at the SQL Services Project of SQL Server 2008

There are multiple open source softwares like Pentaho / Jasper etc. that provide the functionality we will see below but nothing comes with the ease like SSAS

To start, open Business Intelligence Studio and create Analysis Services Project

 The wizard will create a project aling with required folders - Dimensions and Cubes the two most important of any Business Intelligence project

Creating Cube is easy in SQL Server. Right click on Cubes and select New Cube - a beautiful Wizard will guide

Select the Generate tables option

The below step helps you in Creating new Dimensions - OLAP is all about measures (Facts and Dimensions)

Facts and Dimensions in SQL Server

Time dimension is created and filled automatically by SQL Server based on settings

The above figure shows the measures and dimensions created by SQL SERVER.

 

 

Now we have the logical data model, we can create the Schema . SQL SERver Schema Creation Wizard helps to  create the required schema

How to import Large files (TXT / CSV) to SQL Server 2008 using SSIS

 SQL Server's Integration Services provides the functionality to laod

This can be done from the SQL Server by selecting the integration services project

The following