O'Reilly logo

Reporting with Microsoft SQL Server 2012 by Bill Anton, James Serra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required