Development Activity with Power View | Reporting with Microsoft SQL Server 2012

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

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Reporting with Microsoft SQL Server 2012

Reporting with Microsoft SQL Server 2012

Overview of this book

Tutorial scenario

Creating a BI Semantic Model (BISM) connection

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access