Using Business Intelligence Analysis : Analysis Visualizations
  

Analysis Visualizations

Business Intelligence Analysis offers many ways to visually display data. These graphics are called visualizations, and include maps, charts, and grids.

Setting Chart Options

The Set Chart Options allow you to define the chart display (colors, legend, number of charts per row, bullet styles, and more). To access the Chart Options dialog box, click More actions and options in the Business Intelligence Analysis toolbar and choose, Chart Options. The following window is opened:
 
Chart options are defined below:

General

Option
Description
Background
Fill type defines the background color of the chart and the specific fill colors used. A Gradient will result in a gradual color transition in the fill color. Choose the color you want from the available color pickers (Fill Color, End Color) You can select not to have a fill color (None), or select a single background color (Solid).
Labels
Allows you to select a font type, size, formatting, and color of the labels in your chart.
Domain Limit
Allows you to limit the number of plot values that display in a chart.

Axis

Axis
Allows you to adjust the axis range. When set to Auto Range, the chart will scale based on the data. If you have a time series chart, you may want to set the range manually so that figures, (not close to the 0 axis), display correctly; (see image below). Select a Scale option to manage instances where numeric values in a chart are so long that they affect the display.

Legend

Option
Description
Show Legend
Allows you to enable to disable the legend display
Position
Allows you to select the placement (Top, Right, Bottom, Left) of the legend on the chart
Background Color
Allows you to select a background color for the legend
Font
Allows you to set the font type, size, format, and color associated with your legend

Other

Option
Description
Line Charts
Allows you to set the Bullet Style for points on a line chart and assign Line Width
Multi-Charts
Allows you to define the number of charts that display when using the Multi-Charts feature
 
 

Displaying Multi-Charts in Analysis

The Analysis multi-chart feature allows you to display multiple charts in a single Analysis report. For example, you can use this feature when you want to display the same data over different years. The multi-chart feature prevents you from having to create separate filters and reports.
1. Create or open an Analysis report.
Important: You must have Auto-Refresh Mode disabled (see the section Disabling Auto Refresh Mode above) to use the Multi-Chart feature.
2. Click the Switch to Chart Format button, , to change to chart format.
3. Move the appropriate fields into the Multi-Chart section. The field auto populates with the different charts dependent upon the level placed in the Multi-Chart field.
4. Save the report.
 

Geography Map Visualizations in Analysis

Geo maps allow users the ability to visualize data on a geographic map. This visualization type will plot a pin on a map based on the location attribute used. You can then use a measure to color-code the pen and/or use a measure to specify the size of the pin. If your model has geographic annotations then the location information will be retrieved by the geoService automatically.
An example of a bar chart showing several chart properties.

Customizing Geography Map Visualizations in Analysis

The Properties panel enables you to customize the appearance of map visualizations.
The Properties Panel.
The Pattern drop-down box allows you to decide the way the colors of the pins populate. The appearance does not denote any of the data, it is solely for aesthetics. You have the option of selecting:
Gradient
3 Step
5 Step
 
The Color drop-down box allows you to decide which colors denote large measures and which colors denote smaller measures. The color denotes the size of the data, from small to large. You have the option of selecting:
Red Yellow Green
Red Yellow Blue
Blue Scale
Gray Scale
You also have the option of checking the Reverse Colors box, which will allow you to choose the inverse colors so they appear large, to small.

Scatter Chart Visualizations in Analysis

Scatter charts allow users the ability to visualize data on a graph. This visualization type will plot a bubble on a graph based on the attributes used. You can then use a measure to color-code the bubble and/or use a measure to specify the size of the bubble.
An example of a scatter chart showing several scatter chart properties.

Customizing Scatter Chart Visualizations In Analysis

The Properties panel enables you to customize the appearance of scatter chart visualizations. Click on the Chart Options button within the Properties to make the Chart Options dialog appear.
The Chart Options Dialogue Box.
 
The Chart Options drop-down box allows you to customize your chart. Within the four different tabs, you have the ability to choose:
Charft fill type. If you choose a fill type other than none, you can customize the color (or colors if you choose a gradient).
Font type, size and emphasis for the labels
Axis ranges
Legend visibility
Legend position
Legend Background appearance (if it appears and if so, what color)
Font type, size, and emphasis for the Legend
For multi-charts, the number of charts per row
The Domain Limit maximum number of plot values

Heat Grid Visualizations in Analysis

Heat Grids allow you the ability to visualize data so you can identify patterns of performance. This visualization type will color-code your results so you view complex business analysis in an easy-to-understand visualization.

Customizing Heat Grid Visualizations in Analysis

An example of a grid showing several grid properties.The Properties panel enables you to customize the appearance of map visualizations.
The Properties Panel for a heat grid.
The Pattern drop-down box allows you to decide the way the color of the pins populate. The appearance does not denote any of the data, it is solely for aesthetics. You have the option of selecting:
Gradient
3 Step
5 Step
The Color drop-down box allows you to decide which colors denote large measures and which colors denote smaller measures. The color denotes the size of the data, from small to large. You have the option of selecting:
Red Yellow Green
Red Yellow Blue
Blue Scale
Gray Scale
You also have the option of checking the Reverse Colors box, which will allow you to choose the inverse colors so they appear large to small. You may also change shape of the measures within the Shape: drop-down box. The measures can be alternated between Square to Circle.
The Properties panel enables you to customize the appearance of scatter chart visualizations. Click on the Chart Options button within the Properties to make the Chart Options dialog appear.
The Chart Options Dialogue Box.
The Chart Options drop-down box allows you to customize your chart. Within the four different tabs, you have the ability to choose:
Chart fill type. If you choose a fill type other than none, you can customize the color (or colors if you choose a gradient).
Font type, size and emphasis for the labels
Axis ranges
Legend visibility
Legend position
Legend Background appearance (if it appears and if so, what color)
Font type, size, and emphasis for the Legend
For multi-charts, the number of charts per row
The Domain Limit maximum number of plot values