Documentation

Analyze Data

This article provides an overview of selecting and analyzing data using metric sets.

Overview of the main elements of the Dundas BI data model and the flow of data in the system.

This article describes the purpose of slicers, columns, rows, and measures in the data analysis panel.

This article demonstrates how to use automatic joining and user hierarchies to combine related data together.

Add relationships between tables to facilitate automatic join functionality and user hierarchy creation in Dundas BI.

Dundas BI includes the ability to add and modify data within the application, and to store it in its warehouse data storage area.

This article shows you how to use the Expand and Collapse functionality to see more detailed breakdowns or step back to a summary view.

This article demonstrates how to create a ragged, unbalanced, or self-referencing hierarchy.

This article shows you how to format numbers and dates or times displayed in your metric set. Formats can be set in the metric set, or by using placeholder keywords in a data visualization's properties.

You can set up states on a metric set to display some data differently when it falls within that state, based on comparisons with other values.

This walkthrough shows you how to add a period over period (or date offset) comparison.

A contextual measure lets you enter your own values to augment existing data in your metric set within Dundas BI.

This article shows you how to add a count measure to display the number of records or values behind each row or column.

This article explains how to group multiple values into one when working with a metric set.

Filter your metric set to display the top or bottom 'N' number of items, or group the smallest or largest items together into one.

Dundas BI includes a time dimension with hierarchies ready to use for filtering, sorting, grouping, and drill down. It can be customized or you can create new ones.

This article shows you how to set or reset the default time dimension for a project.

This article shows you how null values and missing data can be set up to be displayed.

How to use a custom total calculation in measure subtotals or totals.

Auto-generated metric sets allow you to perform analysis of your data quickly and easily but they have limitations in terms of reuse and collaboration. This article shows you how to promote an auto-generated metric set into a standard metric set.

  • 1
  • 2

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri