
You must have some information about what authentication settings are used for Excel Services. For information about how to deploy Excel Services, see Configure Excel Services in SharePoint Server 2013 and Manage Excel Services data model settings (SharePoint Server 2013). If you do not have the sample data and a Business Intelligence Center site, have an IT administrator configure them for you using the instructions in Configure AdventureWorks for Business Intelligence solutions.Įxcel Services must be configured to support Data Models in the SharePoint environment that you are using. This scenario uses Adventure Works sample data and a Business Intelligence Center site in SharePoint Server 2013. Before you beginīefore you begin this operation, review the following information about prerequisites:Įxcel must be installed on the computer that you are using to create and publish the dashboard. By following the steps in this article, you'll learn how to create and configure reports in a worksheet and connect a slicer to those reports. This article also covers different display options that you can use when you publish a workbook.


The example dashboard described in this article resembles the following image: This article describes, step by step, how to create a Data Model, how to create some reports and a slicer, and then how to publish the dashboard to SharePoint Server 2013. APPLIES TO: 2013 2016 2019 Subscription Edition SharePoint in Microsoft 365
