Database Reference
In-Depth Information
• Access to a Microsoft SQL Server 2012 Analysis Services instance
installed in tabular mode with the Adventure Works 2012 sample
tabular database deployed
• A browser with Microsoft Silverlight 5 installed
Microsoft SharePoint Server 2013 is available in a 180-day trial version from the
following location:
http://technet.microsoft.com/en-us/evalcenter/
hh973397.aspx
Microsoft SQL Server 2012 is available in a 180-day trial version (which includes SQL
Server Data Tools) from the following location:
http://www.microsoft.com/en-
us/download/details.aspx?id=29066
Adventure Works DW 2012 sample database is available for download from the
following location:
http://msftdbprodsamples.codeplex.com/releases/
view/55330
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.
