BI Reporting: Reports and Subscriptions Solution
The files on this page show a scenario that uses Report Builder 3.0, SharePoint Server 2010, and Microsoft Excel 2010 together to create a reporting solution. The scenario features data analysis, rich report design, and flexible delivery of content.
- Together, the files on this page provide a business intelligence reporting scenario, a visual summary diagram of the solution described in that scenario, and details about the fictional company, Contoso. The scenario describes the report requirements and how Contoso employees used Microsoft applications to provide a meaningful and useful reporting solution. Download the materials on this page for comprehensive information about this reporting scenario. Documents:
- BI_Reporting_Solution.docx: The complete, step-by-step Business Intelligence reporting scenario
- * ContosBIRptSummary.rdl: A report definition file for a summary report featuring sparkline charts, with parameterized links to a detailed report
- * ContosoBIRptDetail.rdl: A report definition file for a flat detailed report with parameters for product channel and category
- ContosoProductDetails.xlsx: An Excel workbook containing data that was exported from ContosoBIRptDetail.rdl, cleaned up, and then saved to the current Excel format
- Reporting_Solution_Package.zip: A compressed file that contains the scenario and all supporting files
- ReportingScenarioMindMap.pdf: A visual representation of the steps taken in the BI Reporting and Subscriptions solution
This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.
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.
Operating Systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Vista, Windows XP
- SharePoint Server 2010, Enterprise Edition
- SQL Server 2008 R2, including the following:
- Analysis Services
- Reporting Services
- Office 2010, including the following:
- Five individual files are available for this scenario. You can download them separately, or you can download the compressed .zip file, which includes all the files. To extract the entire contents of a compressed folder, right-click the folder, click Extract All, and then follow the instructions.