Loading ...

What is SSAS? Analytic services learning resources


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