官方:SSAS 多维模型
Analysis Services 多维解决方案使用多维数据集结构来分析多个维度之间的业务数据。 多维模式是 Analysis Services 的默认服务器模式。 它包括针对 OLAP 数据的查询和计算引擎,并且具有 MOLAP、ROLAP 和 HOLAP 存储模式以便在性能和数据可伸缩性要求之间进行权衡。 Analysis Services OLAP 引擎是行业领先的 OLAP 服务器,能够与多种 BI 工具很好地配合使用。 大多数 Analysis Services 部署都作为典型的 OLAP 服务器进行安装。
- 多维模型解决方案 (SSAS)
- 多维模型数据库 (SSAS)
- 多维模型数据访问(Analysis Services - 多维数据)
- 处理多维模型 (Analysis Services)
- 角色和权限 (Analysis Services)
官方:SSAS 数据挖掘
- 数据挖掘概念
- 数据挖掘算法(Analysis Services – 数据挖掘)
- 挖掘结构(Analysis Services – 数据挖掘)
- 挖掘模型(Analysis Services - 数据挖掘)
- 测试和验证(数据挖掘)
- 数据挖掘查询
- 数据挖掘解决方案
- 数据挖掘体系结构
官方:整合教程
- Analysis Services Tutorial Scenario
-
Multidimensional Modeling Tutorial
- Lesson 1: Defining a Data Source View within an Analysis Services Project
- Lesson 2: Defining and Deploying a Cube
- Lesson 3: Modifying Measures, Attributes and Hierarchies
- Lesson 4: Defining Advanced Attribute and Dimension Properties
- Lesson 5: Defining Relationships Between Dimensions and Measure Groups
- Lesson 6: Defining Calculations
- Lesson 7: Defining Key Performance Indicators (KPIs)
- Lesson 8: Defining Actions
- Lesson 9: Defining Perspectives and Translations
- Lesson 10: Defining Administrative Roles
- Tabular Modeling Tutoria
官方:分项教程
- Data Sources in Multidimensional Models
- Data Source Views in Multidimensional Models
- Dimensions in Multidimensional Models
- Cubes in Multidimensional Models
- Measures and Measure Groups
- Partitions in Multidimensional Models
- Calculations in Multidimensional Models
- Key Performance Indicators (KPIs) in Multidimensional Models
- Actions in Multidimensional Models
- Perspectives in Multidimensional Models
- Translations in Multidimensional Models (Analysis Services)
- Multidimensional Model Solution Deployment
Multidimensional Model Solutions (SSAS)
- Create a Dimension Using the Dimension Wizard
- Create a Dimension by Using an Existing Table
- Create a Time Dimension by Generating a Time Table
- Create a Dimension by Generating a Non-Time Table in the Data Source
- Define Database Dimensions
- Dimension Attribute Properties Reference
- Create User-Defined Hierarchies
- Define Attribute Relationships
- Use the Business Intelligence Wizard to Enhance Dimensions
- Configure String Storage for Dimensions and Partitions
- Define Linked Dimensions
Logical Architecture (Analysis Services - Multidimensional Data)
- Logical Architecture Overview (Analysis Services - Multidimensional Data)
- Server Objects (Analysis Services - Multidimensional Data)
- Database Objects (Analysis Services - Multidimensional Data)
- Dimension Objects (Analysis Services - Multidimensional Data)
- Cube Objects (Analysis Services - Multidimensional Data)
- User Access Security Architecture