Self-Service Analytics: Sales Solution

Brief Description

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.

Overview

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.

Read more and download files here...