sql server analysis services(ssas) : 1)Multi dimensional analysis solution Developing analysis services solution data sources data source views creating a cube 2)Dimension wizard configuring dimensions defining hierarchies sorting and grouping attributes 3)Cube wizard Planning for Cube Design Measures Creating Measure Groups Cube Customizations and Options 4)MDX MDX expressions for calculations MDX quering against OLAP cube 5)cube and its functionalities Implement actions Implement Perspectives Implement Translations Implement key performance indicators Implement partitions 6)Security & deployment |