SSAS Project Week (Business Intelligence Training)  

Posted in , , , ,

This week is my fifth week of the BI training. Seems there are too much to learn at once. Our project for this week is the continuation of what we did in SSIS two weeks ago. Wherein we design an ETL (Extract-Transform-Load) to create the staging area for the project solution This week, we use SSAS (SQL Server Analysis Services) to implement the cube and do dimension processing from the cube. We created first the OLAP Structure and load the dimension from the staging area to the OLAP Database.

In the SSAS solution, we created one cube and five dimensions. We use MDX as the query language and feed this into the KPI (Key Performance Indicator) in SSAS. Mainly, MDX is the query language that is used in SSAS environment. In this project we test the KPI and the OLAP facts tables and dimension in Excel. Above are some of the screen shots that was taken from the SSAS that I develop.

Bookmark and Share

This entry was posted on Thursday, August 20, 2009 and is filed under , , , , . You can leave a response and follow any responses to this entry through the Subscribe to: Post Comments (Atom) .


Post a Comment