有哪些示例数据可用于 Power BI?What sample data is available to use with Power BI?

假设你初次接触 Power BI,想要试用但没有任何数据。Say you're new to Power BI and want to try it out but don't have any data. 或者你有一个数据集,但由于你(尚)不了解 Power BI 的工作原理,担心由于某种原因可能损坏数据集?Or maybe you have a dataset, but because you don't understand (yet) how Power BI works, you worry that you might somehow damage your dataset?

不需要有压力!No need to stress out! obviEnce (www.obvience.com) 和 Microsoft 已创建示例供你使用,直到你可以更放心地使用 Power BI。obviEnce (www.obvience.com) and Microsoft have created samples for you to use until you feel more comfortable with Power BI. 数据经过匿名处理并表示不同行业:金融、人力资源、销售等。The data is anonymized and represents different industries: finance, HR, sales, and more. 随着你不断阅读我们的联机文档,将会发现使用这些相同示例的教程和示例,这意味着,你将能够沿用这些内容。And as you read through our online documentation you'll discover tutorials and examples that use these same samples which means that you'll be able to follow along.

每个示例都可以采用以下几种格式:内容包、单独的 Excel 工作簿和 .pbix 文件。Each of these samples is available in several formats: as a content pack, as an individual Excel workbook, and as a .pbix file. 如果你不知道这些内容是什么,或如何着手处理,请不要担心。If you don't know what these things are, or how to get your hands on them -- don't worry. 我们将在本文后续部分介绍这些内容。We'll explain it all later in this article. 我们针对每个示例创建了一个 教程 ,这是一种文章类型,介绍示例所基于的场景并指导你完成不同的方案。And for each sample we've created a tour which is a type of article that tells the story behind the sample and walks you through different scenarios. 一种方案可能是回答经理的问题,另一个可能查找竞争对手的见解,或创建要共享的报表和仪表板,或解释业务转型。One scenario might be answering questions for your manager, another might be looking for competitive insights, or creating reports and dashboards to share, or explaining a business shift.

但在我们开始之前,请通读使用示例的法律准则。But before we get started, please read through these legal guidelines for using the samples. 完成后,我们将介绍这些示例并向你展示如何使用它们。When you're done we'll introduce the samples and show you how to use them.

Power BI 示例 Excel 工作簿的使用准则Usage guidelines for the Power BI sample Excel workbooks

请在使用 Power BI 示例之前阅读此信息。Please read this information before using the Power BI samples.

© 2015 Microsoft Corporation。©2015 Microsoft Corporation. 保留所有权利。All rights reserved. 文档和工作簿“按原样”提供。The documents and workbooks are provided "as-is." 工作簿中陈述的信息和观点(包括 URL 和其他 Internet 网站引用)如有更改,恕不另行通知。Information and views expressed in the workbooks, including URL and other Internet Web site references, may change without notice. 你须自行承担使用风险。You bear the risk of using it. 某些示例仅供说明之用,纯属虚构。Some examples are for illustration only and are fictitious. 不作任何实际关联,也不推断任何实际关联。No real association is intended or inferred. 对于此处提供的信息,Microsoft 不作任何明示或暗示的担保。Microsoft makes no warranties, express or implied, with respect to the information provided here.

对于任何 Microsoft 产品中的任何知识产权,工作簿不为你提供任何法律权利。The workbooks do not provide you with any legal rights to any intellectual property in any Microsoft product. 你可以复制此工作簿并将其用于内部参考。You may copy and use this workbook for your internal, reference purposes.

工作簿和相关的数据由 obviEnce 提供。The workbooks and related data are provided by obviEnce. www.obvience.comwww.obvience.com

ObviEnce 是侧重于 Microsoft Business Intelligence 的 ISV 和知识产权 (IP) Incubator。ObviEnce is an ISV and an Intellectual Property (IP) Incubator focused on Microsoft Business Intelligence. ObviEnce 与 Microsoft 紧密协作,共同开发快速了解和部署 Microsoft Business Intelligence 解决方案的最佳做法和领先观念。ObviEnce works closely with Microsoft to develop best practices and thought leadership for jump-starting and deploying Microsoft Business Intelligence solutions.

工作簿和数据均为 obviEnce, LLC 的财产,并已共享以专门用于通过行业示例数据演示 Power BI 功能。The workbooks and data are property of obviEnce, LLC and have been shared solely for the purpose of demonstrating Power BI functionality with industry sample data.

工作簿和/或数据的任何使用必须包括上述属性(也位于每个工作簿随附的信息工作表上)。Any uses of the workbooks and/or data must include the above attribution (that is also on the Info worksheet included with each workbook). 该工作簿和任何可视化对象必须附有以下版权声明:obviEnce ©。The workbook and any visualizations must be accompanied by the following copyright notice: obviEnce ©.

单击下面任一链接下载 Excel 工作簿文件或 .pbix 文件即表示你同意上述条款。By clicking any of the links below to download the Excel workbook files or .pbix files, you are agreeing to the terms above.

可用示例Available samples

我们提供八个示例供你使用。Eight samples are available for you to use. 每个示例代表不同的行业。Each one represents a different industry.

客户盈利率示例 Customer Profitability sample

浏览客户盈利率示例Take a tour of the Customer Profitability sample

此行业示例分析了 CFO 对其管理人员、产品和客户的关键指标。This industry sample analyzes a CFO's key metrics for her executives, products, and customers. 你可以调查哪些因素会影响公司的盈利率。You can investigate what factors impact the company's profitability.

人力资源示例 Human Resources sample

浏览人力资源示例Take a tour of the HR sample

此行业示例通过分析新员工、在职员工和离职员工关注公司的招聘策略。This industry sample focuses on the hiring strategy for a company by analyzing new hires, active employees, and employees who've left. 通过浏览数据,你可以找到自愿离职和招聘策略中的偏见的趋势。By exploring the data, you can find trends in voluntary separations and biases in the hiring strategy.

IT 支出分析示例 IT Spend Analysis sample

浏览 IT 支出分析示例Take a tour of the IT Spend Analysis sample

在本行业示例中,我们分析比较了公司 IT 部门的计划成本与实际成本。In this industry sample we analyze the planned vs. actual costs of the IT department of a company. 这种比较可以帮助我们了解公司年度计划的效果如何并调查与计划有巨大偏差的区域。This comparison helps us understand how well the company planned for the year and investigate areas with huge deviations from the plan. 在此示例中,公司将经历年度计划周期,然后分季度生成新的最新估计 (LE),以帮助分析过去财年中 IT 支出的变化。The company in this example goes through a yearly planning cycle, and then quarterly it produces a new Latest Estimate (LE) to help analyze changes in IT spend over the fiscal year.

机会分析示例 Opportunity Analysis sample

浏览机会分析示例Take a tour of the Opportunity Analysis sample

此行业示例探索软件公司的销售渠道。This industry sample explores a software company's sales channel. 销售经理通过按地区、交易规模和渠道跟踪机会和收益来监视其直接和合作销售渠道。Sales managers monitor their direct and partner sales channels by tracking opportunities and revenue by region, deal size, and channel.

采购分析示例 Procurement Analysis sample

浏览采购分析示例Take a tour of the Procurement Analysis sample

此行业示例分析了 CFO 对其管理人员、产品和客户的关键指标。This industry sample analyzes a CFO's key metrics for her executives, products, and customers. 你可以调查哪些因素会影响公司的盈利率You can investigate what factors impact the company's profitability

零售分析示例 Retail Analysis sample

浏览零售分析示例Take a tour of the Retail Analysis sample

此行业示例分析了跨多个商店和地区销售的商品的零售数据。This industry sample analyzes retail sales data of items sold across multiple stores and districts. 指标将比较本年度与去年在以下领域的绩效:销售、单位、毛利和差额,以及新店铺分析。The metrics compare this year's performance to last year's in these areas: sales, units, gross margin, and variance, as well as new store analysis.

销售和市场营销示例 Sales and Marketing sample

浏览销售和市场营销示例Take a tour of the Sales and Marketing sample

此行业示例分析了制造公司 VanArsdel Ltd。它允许首席市场官监视该行业以及 VanArsdel 的市场份额。This industry sample analyzes a manufacturing company, VanArsdel Ltd. It allows the Chief Marketing Officer to watch the industry and the market share for VanArsdel. 通过浏览示例,你可以找到公司的市场份额、产品量、销售和市场情绪。By exploring the sample, you can find the company's market share, product volume, sales, and sentiment.

供应商质量示例 Supplier Quality sample

浏览供应商质量示例Take a tour of the Supplier Quality sample

此行业示例着重于传统供应链的其中一项挑战 — 供应商质量分析。This industry sample focuses on one of the typical supply chain challenges — supplier quality analysis. 有两个主要度量值在此分析中发挥作用:瑕疵品总数和瑕疵品所造成的停工时间总计。Two primary metrics are at play in this analysis: total number of defects and the total downtime that these defects caused. 此示例有两个主要目标:了解质量方面最佳和最差的供应商,并确认在找出及剔除瑕疵品方面表现更佳的工厂,从而最大限度地缩短停工时间。This sample has two main objectives: understand who the best and worst suppliers are, with respect to quality, and identify which plants do a better job finding and rejecting defects, to minimize downtime.

现在你已经知道可用的内容了。Now you know what's available. 可以开始了解如何获取这些示例。Time to learn how to get ahold of these samples.

如何获取这些示例How to get the samples

正如你上面所了解到的那样,这些示例以几种格式提供:内容包、Excel 工作簿和 .pbix 文件。As you read above, the samples are available in several formats: content packs, Excel workbooks, and .pbix files. 我们将介绍如何使用每种示例,首先从内容包开始。We'll describe how to use each of these, starting with content packs.

内容包 Power BI 示例The Power BI samples as content packs

内容包是可从 Power BI 中获取的唯一示例格式,无需离开 Power BI 就能找到内容包。Content packs are the only sample format that is available from within Power BI; you don't have to leave Power BI to find them. 内容包实质上是用户创建且可与 Power BI 服务一起使用的一个或多个仪表板、数据集和报表的捆绑包。A content pack is essentially a bundle of one or more dashboard, dataset, and report that someone creates and that can be used with Power BI service. 用户创建内容包与同事共享。People create content packs to share with colleagues. 每个 Power BI 示例内容包都包含一个数据集、报表和仪表板。Each of the Power BI sample content packs contains a dataset, report, and dashboard. 内容包对 Power BI Desktop 不可用。Content packs are not available for Power BI Desktop. 如果你想要了解有关内容包的详细信息,请阅读 Power BI 中的内容包简介If you'd like to learn more about content packs, read Intro to content packs in Power BI.

在 Power BI 服务中获取并打开示例内容包Get and open a sample content pack in Power BI service

  1. 打开 Power BI 服务 (app.powerbi.com),并登录。Open Power BI service (app.powerbi.com) and log in.

  2. 在左下角,选择“获取数据”。In the bottom left corner select Get data.

  3. 在显示的“获取数据”页上选择“示例”图标。On the Get Data page that appears, select the Samples icon.

  4. 选择其中一个示例以打开该示例的说明。Select one of the samples to open a description of that sample. 然后选择“连接”。Then choose Connect.

  5. Power BI 导入内容包,并将新的仪表板、报表和数据集添加到当前工作区。Power BI imports the content pack and adds a new dashboard, report, and dataset to your current workspace. 新的内容会以黄色星号标记。The new content is marked with a yellow asterisk. 使用这些示例对 Power BI 进行测试运行。Use the samples to take Power BI for a test run.

现在你拥有数据,已经快成功了。Now that you have data, you're on your way. 使用示例内容包尝试按我们的一些教程操作,或仅打开 Power BI 服务并浏览。Try out some of our tutorials using the sample content packs or just open Power BI service and explore.

Excel 文件 Power BI 示例The Power BI samples as Excel files

每个示例内容包还可以作为 Excel 工作簿提供。Each of the sample content packs is also available as an Excel workbook. Excel 工作簿旨在与 Power BI 服务一起使用。The Excel workbooks are designed to be used with Power BI service.

  1. 使用下面的链接分别下载文件,或下载所有示例文件的 zip 文件Download the files individually using the links below, or download a zip file of all the sample files. 如果你是高级用户,可能想要下载 Excel 工作簿以浏览或编辑数据模型。If you're an advanced user, you might want to download the Excel workbooks to explore or edit the data models.

  2. 保存下载的文件。Save the downloaded file. 保存文件的位置不同会造成一定的差异。Where you save the file makes a difference.

    • 本地 - 如果你将文件保存到计算机上的本地驱动器中或者组织中的其他位置,则在 Power BI 中,你可以将文件导入到 Power BI。 Local - If you save your file to a local drive on your computer or another location in your organization, from Power BI, you can import your file into Power BI. 你的文件实际上一直保存在本地驱动器中,因此整个文件并未真正导入到 Power BI。Your file will actually remain on your local drive, so the whole file isn’t really imported into Power BI. 实际上,在 Power BI 网站中创建新的数据集,数据(某些情况下为数据模型)将加载到数据集中。What really happens is a new dataset is created in your Power BI site and data, and in some cases the data model, are loaded into the dataset. 如果你的文件有任何报表,则这些报表会显示在你的 Power BI 网站中的“报表”下。If your file has any reports, those will appear in your Power BI site under Reports.
    • OneDrive - 企业 – 如果你有 OneDrive for Business,并且使用登录 Power BI 的同一帐户登录到其中,这是将 Excel、Power BI 或 .CSV 文件中的工作与你在 Power BI 中的数据集、报表和仪表板保持同步的有史以来最有效的方法。 OneDrive - Business – If you have OneDrive for Business and you sign into it with the same account you sign into Power BI with, this is by-far the most effective way to keep your work in Excel, Power BI, or a .CSV file in-sync with your dataset, reports, and dashboards in Power BI. 由于 Power BI 和 OneDrive 都位于云中,Power BI 大约每小时会连接你在 OneDrive 上的文件一次。Because both Power BI and OneDrive are in the cloud, Power BI connects to your file on OneDrive about every hour. 如果发现任何更改,你的数据集、报表和仪表板会在 Power BI 中自动更新。If any changes are found, your dataset, reports, and dashboards are automatically updated in Power BI.
    • OneDrive - 个人 – 如果你将文件保存到自己的 OneDrive 帐户,你会像使用 OneDrive for Business 那样获得很多相同优势。 OneDrive - Personal – If you save your files to your own OneDrive account, you’ll get many of the same benefits as you would with OneDrive for Business. 最大的不同之处在于,当你首次连接至你的文件(使用“获取数据 > 文件 > OneDrive – 个人”)时,你将需要使用 Microsoft 帐户登录 OneDrive,这通常与你用于登录 Power BI 的帐户不同。The biggest difference is when you first connect to your file (using Get Data > Files > OneDrive – Personal) you’ll need to sign in to your OneDrive with your Microsoft account, which is usually different from what you use to sign in to Power BI. 当使用你的 Microsoft 帐户登录 OneDrive 时,请务必选择“使我保持登录状态”选项。When signing in with your OneDrive with your Microsoft account, be sure to select the Keep me signed in option. 这样一来,Power BI 将能够大约每小时连接你的文件一次,并确保你在 Power BI 中的数据集同步。This way, Power BI will be able to connect to your file about every hour and make sure your dataset in Power BI is in-sync.
    • SharePoint 团队网站 – 将 Power BI 文件保存到 SharePoint 团队网站与保存到 OneDrive for Business 大致相同。 SharePoint Team-Sites Saving your Power BI files to SharePoint – Team Sites is much the same as saving to OneDrive for Business. 最大的区别是你从 Power BI 连接到文件的方式。The biggest difference is how you connect to the file from Power BI. 你可以指定一个 URL 或连接到根文件夹。You can specify a URL or connect to the root folder.
  3. 打开 Power BI 服务 (app.powerbi.com),并登录。Open Power BI service (app.powerbi.com) and log in.

    提示

    现在,你可能想要创建新的仪表板并以计划进行导入的文件的名称对其命名。At this point you may want to create a new dashboard and name it after the file you plan on importing. 否则,在导入 Excel 数据集时,Power BI 将不会创建以示例命名的新仪表板,而改为将磁贴添加到当前已打开的仪表板。Otherwise, when you import the Excel dataset, Power BI won't create a new dashboard named after the sample but instead will add a tile to the dashboard that you currently have open. 选择该磁贴将转到数据集的报表。Selecting that tile will take you to the dataset's report. 这不是什么大问题,因为你稍后也可以创建新仪表板,但从新仪表板开始操作将为你节省一个或两个步骤。This isn't a major big deal as you can always create a new dashboard later, but starting with a new dashboard saves you a step or two.

  4. 在左下角,选择“获取数据”。In the bottom left corner select Get data.

  5. 在显示的“获取数据”页上,选择“文件 > 获取”。On the Get Data page that appears, select Files > Get.

  6. 导航到下载并保存示例的位置。Navigate to the location where you downloaded and saved the sample.

  7. 选择该文件,此处是保存在 OneDrive for Business 上的 Procurement Analysis Sample.xlsx,然后选择“连接”。Select the file, in this case Procurement Analysis Sample.xlsx which was saved on OneDrive for Business, and choose Connect.

  8. 选择是导入数据,还是将工作簿引入 Power BI 并完全按照其在 Excel Online 中的方式查看该工作簿。Choose whether to import the data or to bring the workbook into Power BI and see it exactly as it is in Excel online.

  9. 如果选择“导入”,Power BI 会导入示例工作簿并将其添加为名为采购分析示例的新数据集。If you select Import, Power BI imports the sample workbook and adds it as a new dataset named Procurement Analysis Sample. 如果工作簿具有任何 Power View 工作表、表或范围,或数据模型,Power BI 还会创建一个(具有相同的名称)的报表。If the workbook has any Power View sheets, tables or ranges, or a data model, Power BI also creates a report (with the same name). 如果还没有打开仪表板,Power BI 将创建一个新的仪表板。And if you don't already have a dashboard open, Power BI creates a new dashboard. (如果在单击“获取数据”时打开了仪表板,则会在该仪表板上看到新的空白磁贴。(If you had a dashboard open when you clicked Get Data, you'll see a new blank tile on that dashboard. 单击该磁贴将转到刚刚添加数据集的报表)。Clicking that tile will take you to the report for the dataset you just added). 新内容以该示例命名,并以黄色星号标记。The new content is named after the sample and is marked with a yellow asterisk.

  10. 数据集准备就绪!When the Your dataset is ready! 屏幕出现时,选择“查看数据集”或“获取快速见解”,或只需使用 Power BI 左侧导航栏来找到并打开关联的报表或仪表板。screen appears, select View dataset or Get Quick Insights or simply use your Power BI left navbar to locate and open the associated report or dashboard.

(可选)从 Excel 内查看 Excel 示例(Optional) Take a look at the Excel samples from inside Excel itself

想要了解 Excel 工作簿中的数据如何转换为 Power BI 数据集和报表?Want to understand how the data in an Excel workbook gets converted to Power BI datasets and reports? 通过在 Excel 中打开 Excel 示例和浏览工作表可得到答案。Opening the Excel samples in Excel and exploring the worksheets provides some of the answers.

  • 首次在 Excel 中打开示例工作簿时,你可能会看到两个警告。When you first open a sample workbook in Excel, you may see two warnings. 第一个警告指出工作簿处于受保护的视图中。The first says the workbook is in Protected View. 选择“启用编辑”。Select Enable Editing. 第二个警告指出该工作簿有外部数据连接。The second may say that the workbook has external data connections. 选择“启用内容”。Select Enable Content.

  • 每个工作簿包含多个工作表。Each workbook contains several sheets. 由于所有这些 Excel 示例都至少有一个包含可视化效果的 Power View 工作表,在将 Excel 文件导入到 Power BI 时,你将会获得一个数据集一个报表。Because these Excel samples all have at least one Power View sheet with visualizations, when you import the Excel file into Power BI you'll end up with a dataset and a report.

    你可能需要启用 Power View 外接程序You may need to enable the Power View add-in.

  • 那么实际数据在哪儿呢?So where's the actual data? 实际数据位于 Power Pivot 数据模型中。It's in the Power Pivot data model. 若要查看数据,在“PowerPivot”选项卡上,选择“管理数据模型”。To see the data, on the PowerPivot tab, select Manage Data Model.

    看不到 PowerPivot 选项卡?Don't see the PowerPivot tab? 启用 Power Pivot 外接程序Enable the Power Pivot add-in.

  • “信息”选项卡提供有关创建该示例的公司 obviEnce 的信息。The Info tab provides information about obviEnce, the company that created the sample.

.pbix 文件 Power BI 示例The Power BI samples as .pbix files

每个示例内容包还会作为 Power BI .pbix 文件提供。Each of the sample content packs is also available as Power BI .pbix file. .pbix 文件旨在与 Power BI Desktop 一起使用。The .pbix files are designed to be used with Power BI Desktop.

  1. 使用下面的链接单独下载各个文件。Download the files individually using the links below. 选择下面的链接会将文件自动保存到 Downloads 文件夹。Selecting these links saves the file automatically to your Downloads folder.

    [Supplier Quality Analysis Sample PBIX](http://download.microsoft.com/download/8/C/6/8C661638-C102-4C04-992E-9EA56A5D319B/Supplier-Quality-Analysis-Sample-PBIX.pbix)
  1. 在 Power BI Desktop 上,选择“文件 > 打开”并导航到保存示例 .pbix 的位置。From Power BI Desktop, select File > Open and navigate to the location where you saved the sample .pbix.

  2. 选择要在 Power BI Desktop 中打开的 .pbix 文件。Select the .pbix file to open it in Power BI Desktop.

后续步骤Next steps

Power BI 基本概念Power BI basic concepts

教程:连接到 Power BI 示例Tutorial: Connect to the Power BI samples

Power BI 数据源Data sources for Power BI

更多问题?More questions? 尝试参与 Power BI 社区Try the Power BI Community