416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Overview - Datasets

Hide navigation
Modified on Wed, 11 Apr 2012 04:15 PM Categorized as Datasets, Overview
Click to return to: Documentation | Defining Datasets


&dw; lets you create datasets instead of KPIs for use during dashboard design. A dataset represents the tabular data from a virtual table or a virtual cube that you want to visualize on a dashboard. Datasets are ideal for showing data in a data grid control.

See Creating a Dataset.


The following figure illustrates how datasets fit into the overall &dw; workflow.

Workflow for datasets.

Workflow for datasets.

Dataset columns

Use the Columns tab in the Dataset Designer to define the columns of your dataset. Base this definition on the columns of a virtual table, or the measures/dimensions of a virtual cube. In the case of a virtual table, you can optionally make use of existing standard or time dimensions, which allow you to add more capabilities to your dataset, such as support for advanced filtering and drill-downs.

See Defining Dataset Columns.

States and state groups

For a given metric, you can divide the entire range of possible metric values into a set of mutually exclusive sub-ranges or states. This set of mutually exclusive states is called a state group. For example, you can define a state group consisting of:

  • a Bad state representing metric values from 0 to 99
  • a Good state representing metric values from 100 to infinity.

By defining states and state groups for your datasets, you can drive certain data visualizations on your dashboard, such as a state indicator control.

See Defining States for a Dataset.

Ordering and sorting rules

Use the Ordering and Sorting tab in the Dataset Designer to re-order dataset columns and to specify sorting rules (⪚ ascending order, descending order) for the individual values of a dataset column.

See Ordering and Sorting Rules for a Dataset.

Configuring annotations

Use the Annotations tab in the Dataset Designer to manage user annotation groups that are associated with your dataset.

See Configuring Annotations for a Dataset.

Previewing a dataset

Use the Preview tab in the Dataset Designer to view the data generated through your dataset. You can use this preview option to quickly verify the definition of your dataset.

See Previewing a Dataset.

Visualizing a dataset

Once you have saved and checked in your dataset, you can use it to design a dashboard. For example, you can choose to visualize the dataset using a data grid control.

Designing a dashboard using a dataset.

Designing a dashboard using a dataset.

Stubbed datasets

By creating a stubbed dataset, you can set up a complete dataset definition without having to prepare a data connector or virtual table beforehand. Instead, you define the dataset columns and data types explicitly, and use generated (e.g. random) data to populate the column values.

Once created, a stubbed dataset can be used directly in the Dashboard Designer, allowing you to prototype dashboards even before the actual data has been set up. The key principle is that dashboard design and data preparation can proceed in parallel once the business metrics (e.g. stubbed datasets and stubbed KPIs) have been defined.

See Creating a Stubbed Dataset.

Related topics

Click to return to: Documentation | Defining Datasets

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.