Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) and data mining tool inMicrosoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors – Multidimensional and Tabular (from wikipedia).
Learn SSAS: PDF, Videos and Demo files:
01. Download SSAS Tutorials PDF file from Microsoft 02. Adventure Works for SQL Server 2012 from CodePlex 03. SSAS 11 Videos of PCTeach.me: 04. http://pcteach.me/Series/microsoft-ssas/ 05. 6 Lessons of SSAS MDX 06. 7 Videos of SSAS MDX
SSAS Videos at PCTeach.me:
01. Analysis Services - 01 Prerequisite Guide 02. Analysis Services - 02 Data Source Creation 03. Analysis Services - 03 Data Source Views 04. Analysis Services - 04 Cube Creation 05. Analysis Services - 05 Dimension Fundamentals 06. Analysis Services - 06 Dimension Hierarchies 07. Analysis Services - 07 Dimension Attribute Relationships 08. Analysis Services - 08 Dimension Storage 09. Analysis Services - 09 Dimension Discretization 10. Analysis Services - 10 Parent/Child Dimension Hierachies 11. Analysis Services - 11 Star and Snowflake Schemas