Training Videos

Welcome to our Dundas
Dashboard Tutorials Series

Learn how to build dashboards for your business.

Lesson Description
About the Instructor
1. Fundamentals
  • Total Time: 4 minutes and 43 seconds

    Before you learn how to use Dundas Dashboard, spend five minutes learning why to use it. This video outlines five tips for creating effective dashboards.

    Links
    How to succeed at a dashboard project
    Dashboard design principles

  • Total Time: 6 minutes and 57 seconds

    This video introduces the terms and concepts you’ll hear in the remainder of the Dundas Dashboard tutorial series.

    Links
    Dundas Dashboard platform overview

  • Total Time: 2 minutes and 25 seconds

    In this video, learn about the integrated development environment of Dundas Dashboard, and how to begin adding metrics to a dashboard canvas.

    Links
    Dundas How-to: Data Flow

  • Total Time: 3 minutes and 56 seconds

    This tutorial introduces the four steps in the Dundas Dashboard workflow – from connecting your data sources through to the visual design of dashboards.

    Links
    Dundas How-to: Data Flow

  • Total Time: 3 minutes and 41 seconds

    KPIs and Datasets: this video explains what they are, the difference between them, and where and how to use them on a dashboard.

    Links
    Dundas How-to: Data Flow

  • Total Time: 4 minutes and 32 seconds

    In this video, learn about the check-in/check-system used within Dundas Dashboard to maintain referential integrity inside a multiple developer environment.

    Links
    Article: Saving Your Work

  • Total Time: 2 minutes and 27 seconds

    This tutorial goes over the three end user license types and how to apply them to user accounts within Dundas Dashboard.

    Links
    Dundas How-to: Windows User Login
    Article: Dundas Dashboard Licensing

  • Total Time: 2 minutes and 26 seconds

    Dundas Dashboard groups dashboards together into projects, which contain all of the objects necessary to publish a set of dashboards. This video describes the content of a project, and gives a guided tour of the project browser.

    Links
    Article: The Project Manager


2. Data Connectors
  • Total Time: 8 minutes and 4 seconds

    Dundas Dashboard leverages your existing data sources to populate your dashboards. This video introduces the concept of a data connector and shows you the connection process.

    Links
    Dundas How-to: Connect to SQL Server
    Article: Data Connectors
    Article: Data Source Requirements

  • Total Time: 4 minutes and 35 seconds

    Dundas Dashboard offers multiple options for caching data for faster retrieval. This tutorial goes over how to configure your data sources for caching.

    Links
    Article: Caching data

  • Total Time: 1 minutes and 39 seconds

    This demo will show you how to connect Dundas Dashboard to your Microsoft SQL Server data source.

    Links
    Dundas How-to: Connect to SQL Server

  • Total Time: 2 minutes and 22 seconds

    This video shows you how to connect Dundas Dashboard to your Microsoft SQL Server Analysis Services (SSAS) data source.

    Links
    Dundas How-to: Connect to SSAS
    Article: Connecting to SSAS

  • Total Time: 2 minutes and 3 seconds

    In this tutorial, you will learn how to connect Dundas Dashboard to your Oracle 10g or 11g data source.

    Links
    Article: Data Provider – Oracle

  • Total Time: 4 minutes and 20 seconds

    In this tutorial, you will learn how to connect Dundas Dashboard to your Microsoft Excel data source.

    Links
    Dundas How-to: Connect to Excel

  • Total Time: 3 minutes and 9 seconds

    This tutorial will show you how to connect Dundas Dashboard to the hundreds of data sources that support ODBC connectivity.

    Links
    Article: Data Provider – ODBC


3. Virtual Tables
  • Total Time: 2 minutes and 22 seconds

    This video introduces the concept of Virtual Tables in Dundas Dashboard. Virtual Tables are used to retrieve the necessary data from the database that you will need to build your dashboard.

    Links
    Article: Virtual Tables

  • Total Time: 5 minutes and 7 seconds

    This demo shows you how to create a Standard Virtual Table in Dundas Dashboard. This type of virtual table allows users to retrieve data from their database without needing to write their own SQL queries.

    Links
    Article: Creating Standard Virtual Tables

  • Total Time: 2 minutes and 10 seconds

    This video demonstrates how to create a Programmatic Virtual Table in Dundas Dashboard. This type of virtual table allows user to retrieve data directly from existing stored procedure and functions within your own database.

    Links:
    Article: Creating Programmatic Virtual Tables

  • Total Time: 1 minutes and 33 seconds

    This video demonstrates how to create a Manual Virtual Table in Dundas Dashboard. This type of virtual table allows users to write their own SQL Query to determine what data will be retrieved for their Dashboards.

    Links
    Article: Creating Manual Virtual Tables


4. Virtual Cubes
  • Total Time: 3 minutes and 24 seconds

    This video explains the concept of virtual cubes, and the role they play in sourcing data from OLAP based sources such as SSAS and Essbase.

    Links
    Dundas How-to: Create a Virtual Cube in OLAP
    Article: Creating Virtual Cubes

  • Total Time: 6 minutes and 32 seconds

    This video introduces the definition tab of the virtual cube designer. This tab is used to define the structure of the cube for use in later phases of the dashboard development process.

    Links
    Article: Virtual Cube Designer – Definition

  • Total Time: 3 minutes and 12 seconds

    This tutorial shows you how to define new measures for use on a dashboard – without modifying the original structure of the underlying cube.

    Links
    Dundas How-to: Creating Calculated Measures
    Article: Virtual Cube Designer – Calculations

  • Total Time: 6 minutes and 9 seconds

    This video introduces how to properly leverage date based dimensions on the underlying cube for use in visualizations on a dashboard.

    Links
    Dundas How-to: Date Mapping in OLAP
    Article: Virtual Cube Designer – Date Mapping

  • Total Time: 6 minutes and 11 seconds

    In this video, we introduce how to create analytical dashboards reports and leverage those in our analytical dashboards.

    Links
    Article: Virtual Cube Designer – Creating Reports


5. Dimensions
  • Total Time: 2 minutes and 19 seconds

    This video goes over the concept of dimensions in Dundas Dashboard. Dimensions are used to allow consistent, reusable hierarchies used in metrics, filters, and drill down interactions.

    Links

    Dundas How-to: Dimensions
    Article: Dimensions

  • Total Time: 7 minutes and 43 seconds

    This tutorial demonstrates how to create a regular dimension in Dundas Dashboard. A regular dimension allows you to create a hierarchy based on data found within your data source.

    Links

    Dundas How-to: Dimensions
    Article: Creating Regular Dimensions

  • Total Time: 4 minutes and 51 seconds

    This tutorial shows you how to create a time dimension in Dundas Dashboard. A time dimension defines the grain levels available for drill down, filtering, and interaction on your metrics.

    Links
    Dundas How-to: Dimensions
    Article: Creating Time Dimensions


6. KPIs
  • Total Time: 2 minutes and 37 seconds

    This video introduces the concept of KPIs in Dundas Dashboard. In order to be shown as a chart, you need to add the business logic that explains things such as what you’re measuring, what the user can filter, and what constitutes good performance. It is in KPIs and Datasets where you add this logic.

    Links
    Article: Defining KPIs

  • Total Time: 2 minutes and 7 seconds

    When creating a new KPI, this demo walks you through a four-step wizard to help you quickly establish the essentials for defining a new business metric.

    Links
    Article: Defining KPIs – General

  • Total Time: 3 minutes and 31 seconds

    This video goes over the Measure and Contextual Metrics Tab of the KPI designer. The measures and contextual metrics tab are where you define the measures and calculations in a KPI.

    Links

    Article: Defining KPIs – Measures

  • Total Time: 3 minutes and 41 seconds

    This video introduces the Dimensions Tab of the KPI designer. The dimensions tab is where the filtering and axis properties of a KPI are modified.

    Links
    Article: Defining KPIs – Dimensions

  • Total Time: 2 minutes and 23 seconds

    In this video, you will learn how to define states that are static and states that are dynamic, through the introduction of the State Group Tab of the KPI designer. This will allow you to define what constitutes as good or bad in your KPI.

    Links
    Article: Defining KPIs – States

  • Total Time: 1 minutes and 37 seconds

    This video introduces the Ordering and Sorting Tab of the KPI designer. You will learn how you can change the sorting logic and columns order of a KPI.

    Links
    Article: Defining KPIs – Ordering and Sorting

  • Total Time: 1 minutes and 10 seconds

    This video will teach you how to manage annotations on a KPI, through the Annotations Tab of the KPI designer. Annotations are useful for adding a narrative to data points where data values alone do not provide a complete story.

    Links
    Article: Defining KPIs – Annotations

  • Total Time: 1 minutes and 16 seconds

    This video will show you how to use the different parts of the Preview Tab of the KPI designer. The preview tab shows you the summary of the characteristics of a KPI.

    Links
    Article: Defining KPIs – Previewing


7. Datasets
  • Total Time: 1 minutes and 59 seconds

    This video introduces the concept of Datasets in Dundas Dashboard, and how Datasets differ from KPIs. Just like with KPIs, Datasets are where you add the business logic that explains things such as what you’re measuring, what the user can filter, and what constitutes as good performance.

    Links
    Article: Datasets

  • Total Time: 1 minutes and 1 seconds

    In this video you will learn about the setup wizard for Datasets in Dundas Dashboard, and what each step within the wizard does.

    Links
    Article: Using the Dataset Setup Wizard

  • Total Time: 1 minutes and 24 seconds

    This video introduces the Columns tab of the Dataset designer. The columns tab combines the functions of the measures tab and the dimensions tab from the KPI editor.

    Links
    Article: Defining Dataset Columns


8. Dashboard Design
  • Total Time: 6 minutes and 15 seconds

    The video provides an overview of the dashboard designer interface of Dundas Dashboard, as well as the key areas developers and designers will use to define new dashboard content.

    Links
    Article: Designing Dashboards
    Article: Creating a New Dashboard

  • Total Time: 6 minutes and 53 seconds

    This video introduces the Element Explorer menu in the Dundas Dashboard designer interface. You will learn about the benefits of using the Element Explorer when managing your dashboard content, including grouped objects and interaction scripts using DundasScript.

    Links
    Article: Using the Element Explorer

  • Total Time: 7 minutes and 15 seconds

    This tutorial will guide you through the Data Information Wizard in the Dundas Dashboard designer interface, as well as how and why you would use the different steps within the wizard.

    Links
    Article: Data Settings Wizard

  • Total Time: 8 minutes and 26 seconds

    This tutorial introduces the project resources section in the in the Dundas Dashboard designer interface. You will learn where you can manage some of the resources that are used in the Dundas Dashboard design interface, including images, maps, and templates.

    Links
    Article: Project Item Properties


9. Data Visualization
  • Total Time: 5 minutes and 58 seconds

    This demo introduces the concept of the visual control and how it is used in Dundas dashboard. The video explains the difference between data and general controls, as well as cover simple data binding, alignment, distribution, spacing, and general manipulation of appearances using properties.

    Links
    Article: Data Visualization Controls
    Article: General Controls

  • Total Time: 6 minutes and 8 seconds

    This video introduces several common properties that are available for most of the visual controls in Dundas Dashboard, allowing you to begin customizing the look and feel of your dashboards.

    Links
    Article: Design Elements
    Article: Chart Properties

  • Total Time: 7 minutes and 2 seconds

    The tutorial explains how to create charts on a dashboard canvas inside Dundas Dashboard. It talks about the transition from the logical structure of a KPI to the visual structure of a chart, and use a KPI to create multiple charts.

    Links
    Dundas How-to: Data flow

  • Total Time: 6 minutes and 22 seconds

    This video will help you understand how you need to structure a KPI in order to work with multidimensional charts types like bubbles, and funnels.

    Links
    Article: Bubble Chart
    Article: Funnel Chart

  • Total Time: 13 minutes and 19 seconds

    This video introduces the chart control in Dundas Dashboard and describe the common properties used to customize chart appearance.

    Links
    Article: Chart – Dashboard Control

  • Total Time: 8 minutes and 3 seconds

    This video introduces the gauge controls available in Dundas Dashboard. We discuss how to structure a KPI for use on a gauge and explore the common properties of all gauges.

    Links
    Article: Gauges – Dashboard Control

  • Total Time: 8 minutes and 1 seconds

    This tutorial introduces the map control available in Dundas Dashboard, and shows you how to structure a KPI or dataset for use on a map, and how to bind data to the shapes contained inside a map.

    Links
    Article: Map – Dashboard Control
    Article: Map – Using the Map Control

  • Total Time: 7 minutes and 0 seconds

    This video explores two additional methods of visualizing on a map control within Dundas Dashboard: path and symbol binding.

    Links
    Article: Map – Dashboard Control
    Article: Map – Using the Map Control

  • Total Time: 8 minutes and 3 seconds

    This tutorial introduces the Data Grid control available in Dundas Dashboard, and shows you how to structure KPIs and Datasets for use on a grid, and explore the key properties of the grid control.

    Links
    Article: Data Grid – Dashboard Control

  • Total Time: 3 minutes and 57 seconds

    This video discusses how to create a single data grid from multiple KPIs when designing dashboards in Dundas Dashboard. This provides designers with the ability to create a single tabular display of multiple metrics.

    Links
    Article: Using the Data Grid Binding Setup Wizard

  • Total Time: 5 minutes and 24 seconds

    This video discusses two of the many visualization controls available in Dundas Dashboard: the state indictor and the data label.

    Links
    Article: State Indicator – Dashboard Control
    Article: Data Label – Dashboard Control


10. Parameters
  • Total Time: 5 minutes and 12 seconds

    This video introduces Dashboard Parameters and their function within the design interface and in deployed dashboards. You will learn about what Dashboard Parameters are used for and how they can enhance the level of user interactivity on your dashboards.

    Links
    Examples of Parameters
    Creating New Parameters

  • Total Time: 6 minutes and 48 seconds

    This video introduces the Filter-type Dashboard Parameter in the Dundas Dashboard design interface. You will learn about when Filter Parameters are typically used, how they are set up and configured, and what things to look out for when using them on your dashboards. You will also see how Filter Parameters are represented on a dashboard interface.

    Links
    Creating New Parameters
    Article: Filter Parameter Scripting

  • Total Time: 5 minutes and 52 seconds

    This video introduces the Grain-Type Dashboard Parameter in the Dundas Dashboard design interface. You will learn about when the Grain Parameter is relevant to a dashboard design, and what conditions are required in order to configure one. You will also learn how to create and configure a Grain Parameter in the design interface.

    Links
    Article: Creating New Parameters
    Article: Scripting a Drill Down
    Article: Scripting Grain Parameters

  • Total Time: 4 minutes and 5 seconds

    This video introduces the Date Offset-Type Dashboard Parameter in the Dundas Dashboard design interface. You will learn about what the Date Offset Parameter is used for on a dashboard. You will also see how to configure this parameter, and what content is required on the dashboard for this to work.

    Links
    Article: Creating New Parameters
    Article: Using Date Offset Parameters
    Article: Scripting Date Offset Parameters

  • Total Time: 4 minutes and 36 seconds

    This video introduces the Script-Type Parameter in the Dundas Dashboard design interface. You will learn about what the Script Parameter is used for, how it is used, and the benefits it offers in the functionality of your dashboard. You will also learn about an alternative to the Script Parameter that provides similar functionality.

    Links
    Article: Scripting Parameters
    Article: Dashboard Scripting
    Article: Global Variable

  • Total Time: 3 minutes and 12 seconds

    This video walks through the set up and configuration of the Parameter Update Button, and outlines the benefits of using this in your dashboards. You will learn about what settings need to be configured in order for use the Parameter Update Button.

    Links
    Article: Parameter Update Button Properties
    Article: Controlling Data Load Through Script


11. Interactions
  • Total Time: 5 minutes and 12 seconds

    In this video we introduce the concept of exposing interactions for the dashboard viewers, demonstrating the types of common available interactions and applicable use cases for each interaction.

    Links
    Article: Dashboard Parameter and Interaction Examples

  • Total Time: 7 minutes and 26 seconds

    This video walks through the set up and configuration of the Drill-Down interaction into different hierarchy levels, and outlines the benefits of using this in your dashboards. You will learn about what settings need to be configured in order for use the Drill-Down and Up interactions.

    Links
    Article: Dashboard Parameter and Interaction Examples

  • Total Time: 6 minutes and 23 seconds

    This video walks through the set up and configuration of the Hover-Over interaction, and outlines the benefits of using this in your dashboards. You will learn about what settings need to be configured in order for use the Hover-Over interactions.

    Links
    Article: Dashboard Parameter and Interaction Examples

  • Total Time: 4 minutes and 13 seconds

    This video walks through the set up and configuration of the Popup interaction, and outlines the benefits of using this in your dashboards. You will learn about what settings need to be configured in order for use the Popup interactions.

    Links
    Article: Dashboard Parameter and Interaction Examples

  • Total Time: 3 minutes and 12 seconds

    This video walks through the set up and configuration of the Drill-Down interaction into different web page, and outlines the benefits of using this in your dashboards. You will learn about what settings need to be configured in order for use the Drill-Down to URL interactions.

    Links
    Article: Dashboard Parameter and Interaction Examples


12. DundasScript
  • Total Time: 5 minutes and 13 seconds

    This video demonstrates the power of the scripting engine built into Dundas Dashboard, and explores a sample dashboard from the Dundas public gallery, and highlights the areas where DundasScript is used to enhance the functionality of the dashboard.

    Links
    Sample Dashboard: Finance
    Article: Scripting in Dundas Dashboard

  • Total Time: 7 minutes and 47 seconds

    This video introduces the interactions within Dundas Dashboard. These events, both user driven and automatic, are the trigger points for your custom DundasScript modules.

    Links
    Article: Interaction and Scripting
    Article: Scripting in Dundas Dashboard
    Article: Dundas Dashboard Script Library

  • Total Time: 7 minutes and 15 seconds

    This tutorial shows you how you can use DundasScript to influence the appearance of a chart. All data controls have common properties which can be accessed and modified with DundasScript.

    Links
    Article: Change Series Colours using DundasScript

  • Total Time: 4 minutes and 1 seconds

    This demo shows you how to access the data values from a KPI or Dataset behind any control in Dundas Dashboard. This is used to complete in-memory calculations and add calculated series, data points, and otherwise influence the appearance of your dashboard.

    Links
    Article: Reading Data From a Control

  • Total Time: 7 minutes and 47 seconds

    This video demonstrates how to write DundasScript against parameters in Dundas Dashboard. Using script you can retrieve or set parameter values for any parameter used on a dashboard – influencing any control tied to the parameter.

    Links
    Dundas How-to: Parameter Scripting
    Article: Scripting With Parameters
    Article: Advanced Scripting with Parameters

  • Total Time: 13 minutes and 7 seconds

    This video shows you some of the common features added to Dundas Dashboard through DundasScript. Here you will learn about the desired functionality for the control, and how to build the script to complete the action.

    Links
    Article: Dundas Dashboard Script Library


13. Analytical Dashboards
  • Total Time: 6 minutes and 21 seconds

    This video introduces the concept of analytical dashboards and the role they play in analyzing data from OLAP based sources such as SSAS and Essbase.

    Links
    Article: Dashboard Design – Analytical Dashboard

  • Total Time: 4 minutes and 35 seconds

    This tutorial will show you how to create standard analytical dashboards and leverage those in our dashboard solution.

    Links

    Article: Dashboard Design – Analytical Dashboard

  • Total Time: 7 minutes and 24 seconds

    In this video, we introduce how to create custom analytical dashboards and leverage those in our dashboard solution.

    Links
    Article: Dashboard Design – Analytical Dashboard

  • Total Time: 3 minutes and 20 seconds

    In this video, we introduce how to add end user parameters (data filters) to analytical dashboards.

    Links
    Article: Dashboard Design – Analytical Dashboard


14. Administration
  • Total Time: 5 minutes and 37 seconds

    This video describes the high level architecture for Dundas Dashboard, and also introduces the concept of using Dundas Dashboard in a multiple server environment.

    Links
    Article: Installing and Administering Dundas Dashboard
    Article: Data Source Requirements
    Article: Using the Dashboard Viewer
    Article: System Requirements
    Article: Using Windows Logon

  • Total Time: 4 minutes and 23 seconds

    This video introduces the installation process for Dundas Dashboard, and describes the process and discuss a few of the decision points along the way.

    Links

    Dundas How-to: Installation
    Dundas How-to: Scheduler Service
    Dundas How-to: Configure Email Provider
    Article: Dundas Installation

  • Total Time: 4 minutes and 14 seconds

    This video talks about the additional services available to increase the functionality of Dundas Dashboard. This includes the Image Creation Service and the SharePoint web part.

    Links
    How-to: Image Creation Service
    Article: Viewing Dashboards in SharePoint

  • Total Time: 2 minutes and 31 seconds

    This video demonstrates the Add-ons available within Dundas Dashboard. These add-ons introduce new visual controls, new data export formats, and support for additional data sources.

    Links
    Article: Dundas Dashboard Add-ons

  • Total Time: 3 minutes and 12 seconds

    The configuration file allows administrators of a Dundas Dashboard instance to manage the behavior of the application and customize the appearance. This video introduces the config file and the key groups that are available for modification.

    Links
    Article: Dundas Dashboard Config File

  • Total Time: 7 minutes and 21 seconds

    This video introduces the Administration tab found within Dundas Dashboard and describe the functionality available to administrators.

    Links
    Dundas How-to: Administration
    Dundas How-to: Custom Attributes
    Article: Dundas Dashboard Administration

  • Total Time: 4 minutes and 19 seconds

    Dundas Dashboard supports multiple languages. This video describes the three areas of focus for localizing the application and your dashboards.

    Links
    Article: Multi Language Support in Dundas Dashboard

  • Total Time: 4 minutes and 42 seconds

    This video introduces the project manager tool packaged with Dundas Dashboard. This tool allows you to create backups of your dashboard projects to save, share, and restore to other environments.

    Links
    Dundas How-to: Import
    Dundas How-to: Export
    Article: Project Manager

  • Total Time: 1 minutes and 52 seconds

    This video talks about the utility tools packaged with Dundas Dashboard.

    Links

    Dundas How-to: Reset Admin Password
    Dundas How-to: Install a License File


15. Viewing and Integration
  • Total Time: 6 minutes and 25 seconds

    In this video we describe how end users can interact with any dashboard that they view.

    Links
    Article: Viewing Dashboards

  • Total Time: 2 minutes and 3 seconds

    In this video we describe how to use the Viewer.aspx page as a way for user to view your dashboards.

    Links
    Article: Using Viewer.ASPX:

  • Total Time: 3 minutes and 44 seconds

    In this video we talk about creating DashBlocks and Mashups. DashBlocks allow you to build dashboards in individual segments. Mashups allow users to take these DashBlocks to build their own Dashboards using the metrics that are important to them.

    Links
    Article: DashBlocks and Mashups

  • Total Time: 3 minutes and 38 seconds

    In this video we describe the process of embedding dashboards into your own SharePoint pages

    Links
    Article: Dundas Dashboard for SharePoint


16. Mobile Dashboards

Did we get your questions answered?

Contact us for more information training@dundas.com

Love these resources?

Share them with others.