For more information, see AdventureWorks OData Feed (on CodePlex). The Adventure Works sample data that we'll use is available via an OData data feed. 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 2016 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 import data into Excel, use that data to create reports in a worksheet, and connect filters to those reports. This makes it possible to publish the workbook to a library in SharePoint Server 2013. Our example dashboard uses data that is imported into Excel using an OData data feed. The example dashboard described in this article resembles the following image:įigure: Basic Excel Services dashboard that contains two reports and two slicers
This article describes, step by step, how to use Excel 2016 to create a basic dashboard that contains two reports and two filters. APPLIES TO: 2013 2016 2019 SharePoint in Microsoft 365
