Dundas Dashbord 圖表開發工具

 

Dashboards

Dundas BI is an enterprise-level business intelligence, data analytics and dashboard software for building and using interactive dashboards, reports, scorecards, and more.

There are different types of views in Dundas BI that all display data using data visualizations which are connected to metric sets.

Customizable Dashboards

Our enterprise-level, self-service dashboards in Dundas BI let you monitor and measure performance and business metrics in real-time. You can visualize and analyze data from across the organization on your dashboard, helping you gain valuable insight and drive accurate decision making.

With easy, smart and intuitive design tools using drag and drop you can quickly design dashboards and reports.

• Easy, smart drag and drop design tools
• Fully customizable visualizations to create personal and professional dashboard views
• Wide range of visualizations, styles and themes
• Responsive design options

On the Dundas BI dashboard, you can add data visualizations, or components and arrange them anywhere on the canvas. Our dashboards allow you to filter, sort, group, re-visualize, drill-down and perform advanced calculations through an easy to use interface. Our Drag and Drop interface allows you to browse all of your measures and dimensions, and then plot them onto a chart, grid or other advanced visualizations for instant analysis. Dundas BI provides an array of predefined best practice data visualization configurations you can simply use to compose your dashboard.

Our dashboards are web-based and mobile optimized, which enables users to access any data, anywhere with a web connection. You can build, share and view fully interactive dashboards directly in your HTML5 browser without any additional desktop application. With many dashboard properties, scripting options and a full open API, Dundas BI is the most customizable and extensible dashboard creation platform for data visualization.

Communication and Collaboration Tools

You know that numbers don't always tell the full story. Sometimes there's a reason why your business metrics are distorted. Dundas offers dashboard solutions that allow you to tell the proper story with not only data, but also text notifications and notes.

Dundas BI lets you annotate any metric with questions and comments, respond to another user's comments, and view conversations so that your data is always presented in the proper context.

Slideshows

Similar to a PowerPoint presentation, slideshows allows users to define their own selection of dashboards or other views in sequence. There are two main use cases for slideshows:

• Storytelling – Slideshows can be used to present certain insights via a series of views forming a logical business story during a business meeting presentation or discussion. For example, you can start with the high-level view of the sales results and then show a second view with more visualization and analysis about a certain region leading to a conclusion and set of required actions. The advantage of using the slideshow mode for this use case is that the slideshow is directly connected to the live view, allowing for answers to other questions that may come up during the discussion using the live views and latest data rather than having to "park" that question and answer it later if you were to use a static PowerPoint presentation.
• Large Screen Automated Displays - A slideshow lets you display a dashboard or other view for a configurable duration before it is swapped out with the next view in the sequence hence automating the display loop. This provides an easy way to display important dashboards on a flat panel in a corporate hallway setting, operations centers, kiosks, etc. Large screen displays are a good way to engage users and encourage a certain behavior by providing informative views and creating healthy competition.

---

Data Visualizations

We're famous for our visualizations

Our customizable and powerful data visualizations are famous in the industry, and represent nearly 20 years of technology leadership and innovation. You will be amazed by the power and flexibility of our data visualizations.

Our data visualizations help you to create best practice, interactive dashboards and rich reports for complete data insight.

Superb Interactivity

Dundas BI visualizations are extremely interactive, engaging the users and helping to understand data better and faster. While custom interactivity can be easily added, the visualizations already include a great deal of interactivity without requiring any setup, simply out of the box:

• Data Interactions - Drill down/up, changing aggregation level (instead of drilling down on a specific year, view the entire chart at the month level), sorting, filtering, zoom in/out, grouping and expanding are easily available from the right click context menu and don't require any IT assistance for setup.
• Chart Animated Transitions - Dundas BI carefully separates out and smoothly transitions different kinds of changes: changes to data point positions and colors based on values, chart type changes, changes to axis reference points, and advanced interactions such as drill down, drill up, changing level, filtering, sorting, grouping, and zooming in or out to allow viewers to better and more visually understand changes to data points when doing any kind of analysis. Dundas BI also staggers changes to a series of data points to reduce the number of movements viewers see at any one time.
• Re-Visualizing - Changing any visualization into any other visualization of choice is a matter of a simple click and selection. Users can opt to view the data in a bar chart, re-visualize it to a map visualization and then to a table as they see fit for their data and needs.
• Data Brushing - Automatic brushing allows users to see where the same data is represented in another visualization instantly when moving the mouse over it or interacting with it on a tablet. Identifying relationships and related performance points becomes an easier task when your data responds to your actions.

Rich, Interactive Scorecards

Scorecards display progress over time. They allow you to display state indicators and provide visual feedback linked directly to your KPIs according to pre-determined business rules or thresholds. Having a fast and easy way to determine the status of a business metric makes it far easier to take action and make appropriate decisions more quickly and accurately.

Our scorecard designer in Dundas BI builds a table of data and/or visualizations with a pixel-precise customizable layout, able to combine together any types of visualizations. Scorecards can then be viewed on their own or used as part of a dashboard.

In Dundas BI, scorecards are flexible enough to support any style of table or scorecard and any needed visualizations. Scorecards are great for scenarios where you need to display tabular data with complex visualizations such as sparklines or bullet graphs.

Tables

Our table gives you the ability to visualize your data easier and faster. Use the Dundas BI tables to display lists, rankings or highly detailed information grouped by hierarchies using different types of visuals such as data bars, state indicators, bullet graphs, checkboxes, images and hyperlinks that are not only allowing you to read the detailed cell value but also quickly focus using smart visualizations and interactions.

Charts

Dundas BI's charts offers numerous chart types to choose from such as column/bar, stacked column/bar, multi-level pie, sunburst, line, curved line, scatter plot, bubble, area, curved area, stacked area, 100% stacked bar/area, box plot, range, curved range, range column/bar (Gantt like), candlestick and stock.

Gauges

Gauges visualize dynamic data on an ongoing basis. They are best used when displaying values against targets or historical values allowing for a quick view, so they offer a complementary function to charts that are used for showing more details.

Gauges are often used in dashboard applications for the manufacturing and financial sectors, where KPIs and other critical data are monitored in real time.

Dundas BI's gauge supports linear, radial (circular) and pie gauge types, as well as a wide variety of appearances and styles such as bullet graphs. Circular gauges support semi-circle, quarter-circle, or custom angle layouts, while users can also change visual-element properties like scales, pointers and ranges, which put context to pointer values and can also indicate a particular state.

Maps

Our Dundas BI map provides a level of visualization and interactivity that goes far beyond what can be achieved with a data table or graph. Use our mapping component to enhance your dashboard by displaying (and customizing) a wide variety of maps, making your geographic data far easier to read and interpret. Add custom actions to your maps to control or filter what data is displayed on the dashboard/report by region, city or other map element.

Maps are effective tools for sales or marketing reports, and can be used to show population details, density of material, office locations, etc. The Dundas BI Map visualization includes maps of continents, states, countries, regions and more:

• Supports ESRI shape files that are built in or provided by the user
• Visualizes data via color-coded shapes ("choropleth") and in addition, predefined map element properties can bind to data (i.e. color, border, other visual properties)
• Visualizes data via bubbles or symbols of varying sizes centered above geographic areas
• Plot customizable symbols using geographic coordinates from a data source and use their values to vary their sizes and colors
• Visualizes varying widths and colors of paths such as roads and waterways by their values
• Provides mouse/touch panning and mouse/touch zooming
• Offers standard projections: Equirectangular and Mercator
• Includes legend integration
• Automatic selection of maps and zoom level based on data

Treemap

The treemap is a hierarchical visualization that shows a distribution of values using differently sized and colored rectangles. Since there are two dimensions (size and color), the treemap can convey two pieces of information for each item. Treemaps are great for visually displaying the relative sizes and values of a large number of distinct items.

Data Labels

The Data Label allows you to add a data-driven text label to your data views. The Data Label can be easily customized to support different text states and display styles can be changed dynamically using colors, fonts, symbols and currency. Data labels also support animated highlighting of real-time data changes.

Sparkline

Sparklines are lightweight graphs designed to convey many data trends in a small space. Sparklines can be placed in a report or a scorecard to give historical context to your metrics.

Indicators

Diagrams

Customize your data views by easily adding a diagram (XAML or SVG) to your dashboard/report providing greater context and at-a-glance viewing for quick decision making. Diagram shapes are bound to your data and update dynamically based on your latest data values. Use diagrams to visualize processes or complex parts views (i.e. body, airplane, manufacturing plant map) that are updating their parts color based on the latest values in your database.

---

Reporting

Intuitive reporting in Dundas BI

With Dundas BI, you can create any business intelligence report your organization needs, whether multi-page reports or ad-hoc reports. Our BI and dashboard reporting tool gives you an easy but structured way to create complex views involving repeated visualizations, just by using drag-and-drop operations. All of the required details can be easily combined into a single report and grouped as needed for maximum insight. The reporting tool functionality includes the same drag-and-drop design experience as our dashboards, metric sets, and analysis/data discovery.

Reports are ideal for displaying a lot of data in a multi-page report with a fixed layout. Whether working with a handful of records or thousands, users can access and read the report easily in both cases in Dundas BI. The BI and dashboard reporting tool in Dundas BI provides specific capabilities allowing for automation of the entire reports usage process including email delivery scheduling and printing.

Reports can be interactive just like dashboards but they are often designed to be simply viewed or exported and printed. When using reports in conjunction with dashboards, you can create a far more effective process, and save your organization the time spent preparing reports like routine end of month or end of quarter reports. Using both dashboard and reporting tools allows for greater efficiency, and without compromising the availability of information.

• Increase efficiency and save time and money by eliminating manual reporting processes
• Better versioning control for routine reports
• Encourage user collaboration through built-in annotations, alert notifications, and scheduled reports
• Keep your dashboards and reports in a single familiar portal rather than navigating to a different tool for reporting

Designing Reports in Dundas BI

On a dashboard, you can add data visualizations, or components and arrange them anywhere on the canvas. You can also do the same on a report, except that the report canvas contains several specialized regions where you drag-and-drop data and visualizations in order to define the content of your report. These regions allow you to specify a set of visualizations, and how you want them repeated.

Building a report in Dundas BI is simple and consists of dragging and dropping items into the header, body and footer regions of the report. Then switch to View mode to see the actual report consisting of repeated elements.

Ad Hoc Reporting Tools

Dundas BI is web-based and provides easy-to-use reporting tools to help create ad hoc reports when you need to quickly drill deeper into your information. With the ad hoc reporting tools in Dundas BI, you can create reports on-the-fly to display information that may be outside your regular BI reporting.

A good reporting tool can easily accommodate the creation of ad hoc reports for both business and technical users. Flexible, ad hoc reporting allows the business user to access critical information for analysis and distribution quickly and with no assistance from IT required. The self-service, real-time analysis with scheduled distribution of reports in Dundas BI streamlines access to the information users need for quick decision making.

---

Mobile

Dundas BI offers a full immersive experience on both desktop and mobile. The entire platform is built with mobile-first in mind using HTML5, and does not require any special apps or downloads. You can create, view and share your Dashboards, Reports and Scorecards on desktop and mobile seamlessly, or even do data analysis on mobile devices.

---

Predictive and Advanced Data Analytics

Use R language to uncover patterns in your data and predict trends. The R Language Analysis transform lets you write scripts using the R programming language to perform statistical and predictive analysis on data. Using R language for advanced statistical computing and Dundas BI to visualize and interact with the results gives you the best of both worlds. In addition to R, Dundas BI features advanced interactivity and intuitive data discovery operations including drag and drop for re-ordering and re-grouping as well as superior data analysis with trend and forecasting, priority ranking and statistics for data manipulation.

---

Design

Dundas BI uses an optional layered approach to bring the data from its original source to your screen. With this unified data layer approach, users can interact with and analyze data irrespective of the data source. At a high-level, the approach includes

• Data Connectors tell the software how to access your data.
• Data Cubes define how the data is broken up into measures and hierarchies (dimensions). Extract, Transform, Load (ETL) process such as data unification, transformation and cleansing operations can also be performed at this level.
• Metric Sets define the aspect of the data which will be viewed, including which dimensions are going on which axis.
• Dashboards, Reports and Scorecards for presenting and analyzing the data in a user-friendly way.

---

Easily Integrates Into Existing Systems and Applications

For a consistent customer experience, Embedded BI software should easily integrate into your existing systems and look and work like your other applications. Dundas BI features one open, flexible BI platform that can consolidate data from any data source, providing seamless data delivery and a consistent user experience.

• With an open, flexible platform and full API support and extended scripting, Dundas BI can be easily integrated and embedded into existing systems, applications and administration
• Dundas BI can be seamlessly embedded into existing systems such as Client Portals, your Intranet or your CRM system
• APIs also allow for easy integration and support for authentication, user management and administration

Authentication

Dundas BI provides optional support for Windows authentication. This means that users can log in to Dundas BI using a Single Sign On (SSO) with their Windows domain credentials. Businesses running non-Windows networks can either use our built-in account management system, or integrate with a custom network using our public authentication API.

Extensibility

For most organizations, Dundas BI provides all of the required functionality out-of-the-box. For the rest, we provide public APIs so developers can customize and extend the platform to your specific needs:

• Authentication API – manage users, change security settings and log users in and out
• Visualization Controls API – add your own visualizations
• Data Providers API – connect to legacy or otherwise unsupported data source
• Export API – export data into new formats
• File System API – manage Dundas BI file system objects
• Formulas API – create new mathematical formulas that users can add to their dashboards
• Accounts Provider API – Sync users, groups and tenants with your existing applications

Multi-Tenancy

Dundas BI has built-in support for multi-tenant deployment scenarios allowing you to easily create and manage tenants in a single instance which are isolated from each other, add accounts for specific tenants and customize the license seats for each tenant individually.

Microsoft Technology Integration

Dundas BI provides end-to-end support for the full Microsoft BI (MSBI) stack and integrates with your entire suite of Microsoft BI technologies, including:

• Microsoft SQL Server (MSSQL)
• Microsoft Analysis Services (SSAS)
• SharePoint lists and Excel Services
• Microsoft Office (Excel, Access)
• Windows Security (authentication and impersonation)
• Microsoft IIS
• Microsoft Dynamics CRM
• Windows Azure
• PowerPivot
• SharePoint and SharePoint Online integration
• Export to Excel and PowerPoint