Database Reference
In-Depth Information
This is where a self-service reporting tool such as
Power View
comes in. It is so
intuitive and easy to use that most business users can start developing reports with
it with little or no training. The interface is so visually appealing that it makes report
writing fun. This results in users creating their own reports, thereby empowering
businesses to make timely, proactive decisions and explore issues much more
effectively than ever before.
In this chapter, we will cover the major features and functions of Power View,
including the setup, various ways to start Power View, data visualizations, the
user interface, data models, deploying and sharing reports, multiple views, chart
highlighting, slicing, filters, sorting, exporting to PowerPoint, and finally, design tips.
We will also talk about PowerPivot and the
Business Intelligence Sematic Model
(
BISM
). By the end of the chapter, you should be able to jump right in and start
creating reports.
Getting started
Power View
was first introduced as a new integrated reporting feature of SQL
Server 2012 (Enterprise or BI Edition) with SharePoint 2010 Enterprise Edition. It has
also been seamlessly integrated and built directly into Excel 2013 and made available
as an add-in that you can simply enable (although it is not possible to share Power
View reports between SharePoint and Excel).
Power View allows users to quickly create highly visual and interactive reports via
a
What You See Is What You Get
(
WYSIWYG
) interface. The following screenshot
gives an example of a type of report you can build with Power View, which includes
various types of visualizations:
Sales Dashboard
