Dundas Dashboard Detailed Features
Read more at support.dundas.com:
Dundas Dashboard is a feature-rich solution that gives users tremendous power to create sophisticated, interactive, real-time dashboards. It works in many different application environments, including ASP.NET, Silverlight, SharePoint, and more. Some of the main features of the product are outlined below.
- Data source connectors for MS OLAP, 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 into the system
- Automatic discovery of relational database tables, views, stored procedures and functions to minimize work during data preparation
- Automatic discovery http://staging.dundas.com/dashboard/resources/glossary/index.aspx#DataConnectorof MS OLAP dimensions, measures, members and OLAP KPIs to minimize work during data preparation
- Connect to SharePoint lists and Excel Services to leverage your existing data stored in SharePoint business intelligence portal
- 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
- Data Provider API for creating custom connections to SQL-compliant, tabular or web service sources
- Virtual table and cube 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 and Datasets
- Virtual cube wizard accelerates the creation of selecting the right dimensions and measures for analytic dashboards and KPI creation
- Multiple data retrieval mechanisms (stored procedures, functions, manual SQL queries, direct consumption of tables and views) eliminating dependency on data source objects
- Virtual table 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 datasets without modifications to the original source
- Virtual table 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
- Create Datasets to streamline the development of your dashboards
- Create KPI stubs to facilitate designing dashboards and discovering data behind the KPI at the same time
- 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. It uses a C# syntax, with server side customization done in .NET and client side customization done in Silverlight.
- 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: Numerous chart types (including column, stacked column, line, point, range/envelope, bar, stacked bar/area, 100% stacked bar/area, pie, tree map, bubble, funnel, stock, concentric pie; secondary Y axis, scale breaks, configurable axes, major/minor tick marks, major/minor grid, axis labels, series numeric/date/time data binding, customizable appearance, support for OLAP drill down and slicing and dicing
- Dundas Dashboard Gauge: Linear, circular, pointer, marker, thermometer, configurable scales, numeric single-value data binding, customizable appearance
- Dundas Dashboard Map: Color-coded distributions; ESRI/XAML shape imports, zooming and panning, standard map projections: orthographic, diagram (Cartesian), equirectangular, Mercator
- Silverlight Data Grid: Text cells, horizontal or vertical grid, series data binding, header cells, adjustable column width, scrolling, paging, sort by column, row/column grouping, frozen row/columns, row selection, support for OLAP drill down, slicing and dicing, and creating scorecards using OLAP KPIs
- Dundas Dashboard Legend: Customizable layout and presentation, automatic legend items, re-order legend items
- Other Data Visualizations: State Indicator, Display Indicator, Traffic Light
- 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 analyses
- 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
- Developers can create custom export files for offline purposes using our Export API
- Dashboard viewer control allows instances of Dundas Dashboard to be nested in almost any web setting
- Dashboard viewers can create personalized dashboards using Dundas mashups
- Add annotations to your dashboards allowing you to add context or raise concerns about your KPIs
- Create custom controls such as tabs to navigate through your dashboards using our Navigation API
- View dashboards within SharePoint and create mashups using SharePoint Web Part zones and page designs
- 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
- Install Dundas Dashboard in SharePoint to leverage your existing business intelligence and collaboration portal
- 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