SSAS hands on Part 1

We will start with AdventureWorksDW2012 database by which we will explore most of the SSAS features. We will use subset of the database with below set of tables

DimProduct

DimProductSubCategory

DimProductCategory

DimDate

DimReseller

DimEmployee

DimPromotion

DimCurrency

DimSalesTerritory

DimGeography

FactResellerSales

Below is the diagram of data mart.

 

Now to create a new SSAS project follow below step

First create a new SSAS project from FileàNewàProject Menu

 

Select Analysis Service MultiDimensional and Data Mining Project and give a name to the project.

 

      Create a Data Source by right clicking and selecting new Data Source on right hand side Solution Explorer Window

 

Create a Data Source View (by selecting above tables) by right clicking and selecting new Data Source View on right hand side Solution Explorer Window

 

You will get the dsv created in your SSAS project like below

 

In next part we will start and learn Dimension Design in SSAS.