Adventure Works Internet Sales 教程 (1400)Adventure Works Internet Sales tutorial (1400)

适用对象:是SQL Server 2017 Analysis Services 及更高版本 是Azure Analysis Services 否Power BI PremiumAPPLIES TO: yesSQL Server 2017 Analysis Services and later yesAzure Analysis Services noPower BI Premium

本教程提供的课程介绍如何创建和部署在表格模型1400年兼容级别This tutorial provides lessons on how to create and deploy a tabular model at the 1400 compatibility level. 如果您熟悉 Analysis Services 和表格建模,完成本教程是了解如何创建和使用 Visual Studio 中部署基本表格模型的最快方法。If you're new to Analysis Services and tabular modeling, completing this tutorial is the quickest way to learn how to create and deploy a basic tabular model by using Visual Studio. 具备先决条件后,应该花费两到三个小时才能完成。Once you have the prerequisites in-place, it should take two to three hours to complete.

学习内容What you learn

  • 如何创建新的表格模型项目1400年兼容级别装有 SSDT 的 Visual Studio 中。How to create a new tabular model project at the 1400 compatibility level in Visual Studio with SSDT.

  • 如何从关系数据库到表格模型项目工作区数据库导入数据。How to import data from a relational database into a tabular model project workspace database.

  • 如何创建和管理模型中表之间的关系。How to create and manage relationships between tables in the model.

  • 如何创建计算的列、 度量值和关键绩效指标可帮助用户分析关键业务指标。How to create calculated columns, measures, and Key Performance Indicators that help users analyze critical business metrics.

  • 如何创建和管理透视和层次结构可帮助用户更轻松地通过提供业务和特定于应用程序的视点中浏览模型数据。How to create and manage perspectives and hierarchies that help users more easily browse model data by providing business and application-specific viewpoints.

  • 如何创建分区,以便将表数据划分为可独立于其他分区进行处理的更小逻辑部分。How to create partitions that divide table data into smaller logical parts that can be processed independent from other partitions.

  • 如何通过创建角色以及用户成员来保护模型对象和数据的安全。How to secure model objects and data by creating roles with user members.

  • 如何部署到的表格模型Azure Analysis Services服务器或SQL Server 2017 Analysis Services使用 SSDT 的服务器。How to deploy a tabular model to an Azure Analysis Services server or SQL Server 2017 Analysis Services server by using SSDT.


若要完成本教程,需要:To complete this tutorial, you need:


本教程基于 Adventure Works Cycles,虚构公司。This tutorial is based on Adventure Works Cycles, a fictitious company. Adventure Works 是对大型的跨国制造公司,生产的自行车,产品、 部件和附件的北美、 欧洲和亚洲的商业市场。Adventure Works is a large, multinational manufacturing company that produces and distributes bicycles, parts, and accessories for commercial markets in North America, Europe, and Asia. 公司雇佣了 500 名工人。The company employs 500 workers. 此外,Adventure Works 还雇用遍布其市场群的多个区域销售团队。Additionally, Adventure Works employs several regional sales teams throughout its market base. 你的项目将创建一个表格模型,来分析 AdventureWorksDW 数据库中的 Internet 销售数据的销售和市场营销用户。Your project is to create a tabular model for sales and marketing users to analyze Internet sales data in the AdventureWorksDW database.

若要完成本教程,必须完成多个课程。To complete the tutorial, you must complete various lessons. 在每个课程中,有一些任务。In each lesson, there are tasks. 完成每个任务的顺序是必需的课程。Completing each task in order is necessary for completing the lesson. 虽然在特定的课程中可能有多个任务的实现类似的结果,但如何完成每个任务的方式略有不同。While in a particular lesson there may be several tasks that accomplish a similar outcome, but how you complete each task is slightly different. 此方法显示了通常没有多个方法以完成一个任务,并使用已在前面的课程和任务中掌握的技能。This method shows there is often more than one way to complete a task, and to challenge you by using skills you've learned in previous lessons and tasks.

各个课程的目的是指导使用 SSDT 中包括的功能的许多创作基本的表格模型。The purpose of the lessons is to guide you through authoring a basic tabular model by using many of the features included in SSDT. 因为每一课都以上一课为基础,所以,您应该按顺序完成课程。Because each lesson builds upon the previous lesson, you should complete the lessons in order.

本教程不提供管理在 Azure 门户中,通过使用 SSMS,或使用客户端应用程序浏览模型数据来管理服务器或数据库服务器的经验教训。This tutorial does not provide lessons about managing a server in Azure portal, managing a server or database by using SSMS, or using a client application to browse model data.


本教程包括以下几课:This tutorial includes the following lessons:

课程Lesson 学完本课的估计时间Estimated time to complete
1-创建新的表格模型项目1 - Create a new tabular model project 10 分钟。10 minutes
2 - 获取数据2 - Get data 10 分钟。10 minutes
3 - 标记为日期表3 - Mark as Date Table 3 分钟3 minutes
4 - 创建关系4 - Create relationships 10 分钟。10 minutes
5 - 创建计算列5 - Create calculated columns 15 分钟15 minutes
6 - 创建度量值6 - Create measures 30 分钟30 minutes
7-创建关键绩效指标 (KPI)7 - Create Key Performance Indicators (KPI) 15 分钟15 minutes
8 - 创建透视8 - Create perspectives 5 分钟5 minutes
9 - 创建层次结构9 - Create hierarchies 20 分钟20 minutes
10 - 创建分区10 - Create partitions 15 分钟15 minutes
11 - 创建角色11 - Create roles 15 分钟15 minutes
12 - 在 Excel 中分析12 - Analyze in Excel 5 分钟5 minutes
13 - 部署13 - Deploy 5 分钟5 minutes

补充课程Supplemental lessons

这些课程不是完成本教程中,所必需的但可以帮助更好地理解高级表格模型创作功能。These lessons are not required to complete the tutorial, but can be helpful in better understanding advanced tabular model authoring features.

课程Lesson 学完本课的估计时间Estimated time to complete
详细信息行Detail Rows 10 分钟。10 minutes
动态安全性Dynamic security 30 分钟30 minutes
不规则层次结构Ragged hierarchies 20 分钟20 minutes

后续步骤Next steps

若要开始,请参阅第 1 课:创建新的表格模型项目To get started, see Lesson 1: Create a new tabular model project.