Analysis Services 教程Analysis Services tutorials

适用于: 是SQL Server Analysis Services是Azure Analysis ServicesAPPLIES TO: yesSQL Server Analysis Services yesAzure Analysis Services

表格建模 (1400年兼容级别) Tabular modeling (1400 compatibility level)
适用于 Azure Analysis Services 和 SQL Server 2017 Analysis Services 及更高版本。Applies to Azure Analysis Services and SQL Server 2017 Analysis Services and later. 本教程提供的课程介绍如何通过使用 SQL Server Data Tools (SSDT) 为虚构的公司 Adventure Works 创建基本的 Analysis Services 表格模型。This tutorial provides lessons on how to author a basic Analysis Services tabular model for the fictitious company, Adventure Works, by using SQL Server Data Tools (SSDT).

表格建模(1200 兼容级别)Tabular modeling (1200 compatibility level)
适用于 Azure Analysis Services 和 SQL Server 2016 Analysis Services 及更高版本。Applies to Azure Analysis Services and SQL Server 2016 Analysis Services and later. 本教程提供的课程介绍如何通过使用 SQL Server Data Tools (SSDT) 为虚构的公司 Adventure Works 创建基本的 Analysis Services 表格模型。This tutorial provides lessons on how to author a basic Analysis Services tabular model for the fictitious company, Adventure Works, by using SQL Server Data Tools (SSDT).

多维建模Multidimensional modeling
适用于 SQL Server 2012 Analysis Services 和更高版本。Applies to SQL Server 2012 Analysis Services and later. Azure Analysis Services 不支持多维模型。Multidimensional models are not supported on Azure Analysis Services. 本教程提供的课程学习基本技能和 SSDT 中进行多维建模的概念。This tutorial provides lessons for learning fundamental skills and concepts of multidimensional modeling in SSDT. 完成后,您将拥有基于 Adventure Works 数据,可从 Excel、 Reporting Services 或任何其他客户端应用程序连接到 Analysis Services 多维数据集数据库。When you're finished, you will have a cube database based on Adventure Works data that you can access from Excel, Reporting Services, or any other client application that connects to Analysis Services.

数据挖掘Data Mining
适用于 SQL Server 2012 Analysis Services 和更高版本。Applies to SQL Server 2012 Analysis Services and later. Azure Analysis Services 不支持使用数据挖掘多维模型。Multidimensional models with Data Mining are not supported on Azure Analysis Services. 此教程集合介绍如何使用向导和集成可视化创建数据挖掘解决方案。This collection of tutorials describe creating data mining solutions using wizards and integrated visualizations.

示例Samples

项目和已完成的模型数据库示例Project and completed model database samples

示例数据建模项目和已完成的示例模型数据库目前GitHub 上的 Analysis Services 的 Adventure WorksSample data modeling projects and completed sample model databases are available at Adventure Works for Analysis Services on GitHub.

代码示例Code samples

打开源代码示例和社区项目网址GitHub 上的 Analysis Services 存储库Open source code samples and community projects available at Analysis Services repo on GitHub.

SQL Server 数据库和 SQL Server 数据仓库示例SQL Server Database and SQL Server Data Warehouse samples

Adventure Works 和 Wide World Importers 示例数据库位于GitHub 上的 SQL Server 示例存储库Adventure Works and Wide World Importers sample databases are available at SQL Server Sample Repository on GitHub.