Sharepoint
United States (English) Sign in
Home Online 2013 2010 Other Versions Related Products Library Forums Gallery
This topic has not yet been rated - Rate this topic

Creating solutions using Adventure Works sample data

SharePoint 2013

Published: December 18, 2012

Learn how to create and use reports and dashboards using downloadable AdventureWorks sample data.

Applies to:  SharePoint Server 2013 Enterprise 

Are you or people in your organization new to business intelligence with Office? Have you or your colleagues wanted to learn, step by step, how to create and consume reports, scorecards, and dashboards? The articles in this section can help.

In this section

This section contains detailed information about how to create and consume reports, scorecards, and dashboards using downloadable AdventureWorks sample data. Each article describes how to perform specific tasks so you’ll know your way around business intelligence applications, such as Excel Services. The following table describes the articles that are included in this section.

Table: Summary of articles in this section

Article Description

Create an Excel Services dashboard using an OData data feed

This scenario shows how to create a basic dashboard that contains two reports and two slicers using data that is imported into Excel. This scenario also covers how to publish a workbook to a Documents library in either Office 365 or SharePoint Server 2013.

By following the steps in this article, you’ll learn how to perform the following tasks:

  • Import data into Excel using an OData data feed

  • Create a relationship between two tables in a simple Data Model

  • Create and configure a basic dashboard that contains two reports and two slicers

  • Publish a dashboard to a Documents library in SharePoint Server (on premises) or Office 365 (online)

  • View and navigate a dashboard in a browser window

Create an Excel Services dashboard using SQL Server Analysis Services data

Learn how to create a basic dashboard in Excel using a single external data connection to a cube that is stored in SQL Server Analysis Services.

This scenario shows how to create a dashboard that contains four reports and a timeline control in Excel. This scenario also covers how to publish content to SharePoint Server, and how to consume the content in a browser window.

By following the steps in this article, you’ll learn how to perform the following tasks:

  • Create and share an external data connection using Excel Services

  • Create and configure a dashboard that includes two PivotChart reports, two PivotTable reports, and a timeline control

  • View and navigate a dashboard in a browser window by using Excel Services

Create an Excel Services dashboard using a Data Model

Learn how to create a basic dashboard in Excel using a simple Data Model.

This scenario shows how to create a basic Data Model that contains several tables that are stored in SQL Server, and how to use that Data Model to create two reports and a slicer. This scenario also covers how to configure the reports to display meaningful information, and how to specify how you want a dashboard to be displayed in a browser window.

By following the steps in this article, you’ll learn how to perform the following tasks:

  • Create a Data Model that consists of several tables of data

  • Create and configure a dashboard that includes two reports and a slicer

  • Configure a PivotChart chart report to display meaningful information in the chart legend

  • Format numeric information in a PivotTable report

  • Configure a dashboard to be displayed using worksheet view or gallery view in a browser window

Change History

Date Description

December 18, 2012

Initial publication

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.