Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

Tutorial scenario


In this exercise, you will step into the shoes of a business user working in the sales department at a fictitious bike retailer called Adventure Works. You have been tasked with creating a report for the department that will provide a breakdown of internet sales by customer attributes, product categories, and geography. After developing the report, you will need to deploy it to the company's existing SharePoint site where it can be accessed by other users in the sales department.

Creating a BI Semantic Model (BISM) connection

Before Power View reports can be created in SharePoint, a connection object must be created pointing to the data source, which in this demo will be an Analysis Services Tabular model. This task is typically carried out by IT ahead of time since it usually requires a bit more technical knowledge about the systems' infrastructure than can be reasonably expected of the business users.

However, for the sake of this exercise, we will quickly walk through the...