Microsoft Download Center Archive

Self-Service Analytics: Sales Solution

  • Published:
  • Version: 1.0
  • Product: Other
  • Language: English

This business intelligence (BI) solution scenario describes the steps that employees of the fictional company Contoso take as they analyze sales and promotions data and share that analysis with others in the company.

This business intelligence (BI) solution scenario describes the steps that employees of the fictional company Contoso take as they analyze sales and promotions data and share that analysis with others in the company. In the scenario, sales data is first analyzed in Excel. Additional sales and promotions data is then imported into PowerPivot for Excel, and the data is further analyzed. After the analysis is complete, it is published to the PowerPivot Gallery in SharePoint and distributed via Reporting Services, enabling others in the company to interact with the analysis and develop additional insights. The scenario document that is available from the Microsoft Download Center provides step-by-step guidance, and the accompanying sample data lets you follow along with the document. There are three files available for this scenario:

  1. SelfServiceAnalytics.docx: Detailed description of the scenario, with steps to follow along.
  2. SelfServiceAnalytics.pdf: Interactive diagram that shows a visual flow of tasks.
  3. SelfServiceAnalytics_SampleData.zip: Access databases and Excel workbooks that are used in the scenario.

The document and sample data are required, and the diagram is helpful in understanding the sequence of tasks.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

Files
SelfServiceAnalytics.docx
  • SHA1: 81800692f9acec415a3c34cc8e0ad79bb2196788
  • Size: 688 KB
SelfServiceAnalytics.pdf
  • SHA1: 79733705bdd8ad3940cba12697532e79ef8f498e
  • Size: 1.69 MB
SelfServiceAnalytics_SampleData.zip
  • SHA1: d6a75dcde7f9fa081e07a4b49c501ade7f3adcb8
  • Size: 97.55 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows Server 2003, Windows Vista, Windows Server 2008, Windows XP, Windows 7

  • Server:
    • SharePoint Server 2010 Enterprise Edition, including the following:
      • Excel Services
    • SQL Server 2008 R2 Enterprise Edition, including the following:
      • PowerPivot for SharePoint
      • Database Engine (for the Contoso database)
      • Reporting Services (installed in SharePoint Integrated mode)
      • Reporting Services Add-in for SharePoint Products and Technologies
  • Client:
    • Excel 2010
    • PowerPivot for Excel

Installation Instructions

Download the scenario document, diagram, and sample data to your computer. After you download the sample data, extract the entire contents: right-click the folder, click Extract All, and then follow the instructions.

What is this?

Microsoft regularly deletes downloads for prior versions of Windows, Office, Visual Studio, SQL Server, and countless other products from their Download Center website. Legacy Update catalogues downloads that have been deleted from Microsoft Download Center since 2012.

Check our Microsoft Download Center Archive homepage or click Random to discover more downloads.

Deleted downloads are no longer supported by Microsoft, and may have known security vulnerabilities. After installing, check for updates using Legacy Update.

This page was generated from a snapshot of the Microsoft Download Center made on .