Database Reference
In-Depth Information
VISuALIz ATI o N
ADDITIoNAL INForMATIoN
Column chart
Similar to the bar charts, they include options for clus-
tered, stacked, and 100% stacked. Data labels can be
included as well.
Line chart
Line charts can support multiple values or can be broken
out by a particular dimension attribute. Data labels can
be included as well.
Pie chart
Pie charts can be broken out by a particular dimension
attribute. Data labels cannot be included.
Small multiples
Also known as trellis charts; can turn a single chart into
smaller repeating charts based on groupings and can be
organized either horizontally or vertically. This option is
available in the Field Well when a chart is selected.
Scatter chart
Also known as a bubble chart. Provides ability to analyze
three metrics simultaneously and also provides a play
button feature to enable viewing how data changes over
time. You can view the history of a particular bubble by
clicking it to see the trail over time (assuming time was
set up in the chart).
Map
The map uses the Bing map service to provide geo-
coding to plot the data elements using geographical data
elements such as text or latitude and longitude.
Card
The card provides an index style layout for dimension
members, which can include images as well as text and
data values.
BISM: THE FIrST rEQuIrEMENT For PoWEr VIEW
As mentioned previously, a BISM tabular model is the foundation for the
Power View reports in Reporting Services. If you are using Excel 2013, which
now has native support for data models, you will be able to create a Power
View report from any data formatted as a table in addition to using tabular
data models. The native data model capabilities in Excel 2013 are limited, and
an advanced BISM tabular model will provide you much more functionality.
Also, it is a good idea to build a BISM tabular model with Analysis Services to
centralize your data and enhancements (such as calculated values or images,
etc.). That is functionality you can't get if you just import data into Excel and
then create a Power View report.
