Using Dundas BI recommendations
To assist you in designing views, Dundas BI provides guidance and recommendations to help you select the most fitting visualization according to industry best practices.
2. Recommended data visualizations
Based on the measures and hierarchies you place on the metric set, Dundas BI will recommend certain data visualizations. You can find these recommendations under the Recommended section of the Re-Visualize toolbar option, or at the top of the Re-Visualize context menu.
As part of the recommendations, Dundas BI offers a few pre-configured visualizations:
- Point Chart – When Point Chart is recommended, you would use it the same way you would use a bar chart, except that the numeric axis may automatically start above zero, shrinking the range of values displayed along the axis and making it easier to see small differences between the values. When you use a bar chart, the numeric axis should always include zero because each bar starts from zero and it would be misleading otherwise.
- Correlation Matrix – This option uses the correlation matrix formula visualization (CORRMATRIX) to create a new table with a color rule applied to repeated measure columns. Correlation Matrix shows how each measure correlates with each other measure over the rows that were selected. There may be a positive correlation shown in a shade of blue, a negative correlation shown in a shade of red, or no correlation shown in light gray.
- Data Bar Table – A table of data bar columns with totals turned off on the metric set. Data Bar Table allows you to spot patterns of correlation between multiple columns of many bars, and the row heights and padding are reduced to fit more bars.
- Parallel Coordinates – This option creates a new line chart where the metric set has been transposed to place measure names along the bottom axis and percentages along the left axis. Parallel Coordinates displays a separate line for each row of data that was originally selected, plotting where each of its values falls within the total range of each measure's values as a percentage. This allows you to look for overall patterns between the measures while also allowing you to single out individual lines to see its movement.
- Forecast Analysis – This option uses the exponential smoothing formula visualization (EXPSMOOTH) to add forecasting to a line chart when displaying dates along the bottom axis and numeric values along the left axis. Forecast Analysis produces a detailed forecast using the best available method, taking into account seasonality and emphasizing recent data, and displays it as a line on top of a semi-transparent confidence interval.
3. Smart data visualizations
Every time you add or remove data from the metric set, the Smart data visualization functionality will automatically re-visualize to the most fitting recommended data visualization.
To activate this functionality, either drop data onto the canvas or select the Smart data visualization from the toolbar. Selecting a specific data visualization will not activate this functionality.
As an example of the functionality, drop the LineTotal measure from the [Sales].[SalesOrderDetail] table of the Adventure Works database onto the Metric Set Designer canvas.
The initially selected visualization is a Table.
Next, add the OrderQty and UnitPrice measures to the metric set.
The metric set is automatically re-visualized into a Bar Chart.
Next, add the ProductID hierarchy to the metric set.
The metric set is automatically re-visualized into a Bubble Chart.
3.1. Stopping the automatic behavior
You can stop the automatic behavior at any point by either re-visualizing to a data visualization of your choice or customizing the visualization, which includes any of the following actions:
- Making a change on the Visualization tab of the Data Analysis Panel.
- Applying a theme or style.
- Making a change on the Properties tab.
- Using a contextual command from the toolbar or the context menu to change a visualization property.
- Re-opening the metric set or view after it had been saved.
- Using the drop zones that appear on a visualization on the Dashboard Designer (for example, the Column drop zone on a table will add a column and not re-visualize).
- When using the Metric Set Designer, Dundas BI may recommend auto-generated formula visualizations (such as Parallel Coordinates, Correlation Matrix, Histogram, etc.). However, re-visualizing to one of these options will move you to the Dashboard Designer.