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
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.