Dundas Dashboard: Detailed features
Dundas Dashboard is a feature-rich solution that gives users tremendous power to create sophisticated, interactive, real-time dashboards. Some of the main features of the product are outlined below:
- Data source connectors for SQL Server 2005, SQL Server 2008, MySQL 5, Oracle 10g, Oracle 11g, MS Access and flat files (e.g. CSV, Excel files) to ensure import flexibility when importing data to the system
- Automatic Discovery of relational database tables, views, stored procedures and functions to minimize work during data preparation
- Application-side Data Caching for improved data retrieval
- Data Connectors can be scheduled to provide routine updates to refresh the data
- Data Connector management screen and menus to facilitate common actions (Cut, Copy, Paste, Edit, Add, Delete)
- Data Connector wizard accelerates (by simplifying) the process of connecting to existing data assets
- Virtual Table management screen and menus to simplify common actions (Cut, Copy, Paste, Edit, Add, Delete)
- Virtual Table wizard accelerates the process of building data models (using tables and relationships) to drive KPIs
- Multiple data retrieval mechanisms (stored procedures, functions, manual SQL queries, direct consumption of tables and views) eliminating dependency on data source objects
- Data functions (sum, avg, min, max, stddev, stddevp, var, varp, datetime trimming) and Custom Column Definition functionality (constant values, database/calculated expressions, counter) to allow for quick operations on data sets without modifications to the original source
- Friendly view support (assign human friendly names, hide unneeded columns, group, filter data) to make harvested data more readable/usable to information workers and the KPI designer
- KPI Setup Wizard accelerates the process of building meaningful, dimensionally correct KPIs to drive the visual elements of dashboards
- KPI Management screen and menus to simplify common actions (Cut, Copy, Paste, Edit, Add, Delete)
- Calculated Measures functions to allow for operations based on measure data without altering underlying Virtual Tables and end data source
- Measure and Dimension Filtering capability allows users to select the exact desired subset of data, delivering the most meaningful visual representation of data
- Support for dimension-based aggregations allows for complex data modeling through UI
- KPIs support State Ranges tied to visual elements to clearly show performance
- One-click sorting functionality allows quick ranking of measures
- Data Annotations to add explicit written context to KPI data points
- Dimension Management screen and menus to simplify common actions (Cut, Copy, Paste, Edit, Add, Delete)
- Support for Hierarchical Time Dimension (Gregorian, ISO 8601 and fiscal calendars) and Categorical Dimensions to facilitate any data view for deep visual analysis
- Intuitive graphical Dashboard Designer UI allows for a desktop-like drag and drop design experience
- DundasScript engine runs in the background of each dashboard allowing for total customization of interactions, application behavior and parameter management
- Interactivity implementation wizards facilitate the creation of drill-down and hover-over visualizations with a few mouse clicks and no programming
- Full Suite of Styling Elements and Input Controls, customizable through the simplified property grid
- Rich Set of Data Visualization Components to allow total customization to meet visualization, styling and interactivity needs:
- Dundas Dashboard Chart: Column, stacked column, line, point, range/envelope, bar, stacked bar, pie; configurable axes, major/minor tick marks, major/minor grid, axis labels, series numeric/date/time data binding, customizable appearance
- Dundas Dashboard Gauge: Linear, circular, pointer, marker, thermometer, configurable scales, numeric single-value data binding, customizable appearance
- Dundas Dashboard State indicator: Discrete color, image, customizable appearance
- Data Label
- Silverlight Data Grid: Text cells, horizontal or vertical grid, series data binding, header cells, adjustable column width, scrolling, paging, sort by column
- Dundas Dashboard Legend: Customizable layout and presentation, automatic legend items, re-order legend items
- Silverlight Static controls: Text labels, line, ellipse, rectangle, image
- Silverlight Input controls: Button, hyperlink, drop-down menu, text entry box
- Dundas Dashboards resize to fit a wide variety of viewing conditions allowing information to be portable and readily accessible
- User Defined Selection mechanism (for filtering, grouping, etc.) allows users to augment the default view of dashboard for deeper analysis
- Dundas Dashboard allows users to bookmark and share links to dashboards (preserving context) for effective collaboration
- Dashboard viewers can export data areas of interest to flat files for further analysis in other applications
- Dashboard Viewer control allows instances of Dundas Dashboard to be nested in almost any web setting
- User management system support for:
- Local user management allowing for all dashboard concerns to reside within the application
- Windows Active Directory to integrate with existing user management
- Custom User management - Dundas Dashboard extensibility API allows for users to be authenticated against third party infrastructure to meet stricter security requirements
- Full user interface to create and manage user accounts, user groups and their subsequent privileges
- Dundas Dashboard configuration screen allows users to easily monitor and modify application settings
- Flexible rights management system
- Complete flexibility on access rights for all Dundas Dashboard objects (dashboards, KPIs, Virtual Tables and Data Connections
- Import/export projects allowing for reuse of finished assets as well as effective testing
- Object access control system for safe collaboration amongst multiple concurrent users
- Cut/copy/paste all object types to quickly (partially or fully) reuse assets in development