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.
Flexible Mobile BI
The user interface of Dundas BI was designed to be touch friendly so you can even design dashboards, reports and perform data analysis directly on a tablet without having to reconnect to your desktop.
Dundas BI offers Pinch to Zoom capabilities allowing users to focus on the different visualizations. Within a specific visualizations such as a bar chart, Dundas BI offers the ability to select data points and zoom in to that selection or out of the selection to see all points again. In addition, it supports tap actions to drill down/up into the different hierarchy levels of the displayed data points or apply any other data interaction. Tap and hold can also be used to expose additional information such as custom tooltips.
Aside from the touch gestures, there are also built in capabilities that support automatic resize based on the available screen size.
Scale – zoom in to maximize the available screen size without compromising the aspect ratio
Resize – dynamically show more or less data points based on the device available screen size. The difference between scale and resize is that scale could produce a very "small view" of the charts and other visualization data points if the screen size is very small while resize will show less data points but they will be readable even on a smaller screen
Business users can view, create, interact with, monitor and share key business metrics, without having to involve their organization's technical team. With our data exploration process, users can easily turn their data insights into their own powerful dashboards and reports and share those with others. Users can create data connectors, metric sets, hierarchies, dashboards and reports, and use established data cubes and cube perspectives for simplified data discovery.
From the interactive designer screen in Dundas BI, you can easily explore available data sources and use intuitive operations to arrange dashboard, report or scorecard views of your data. For further analysis, you can easily apply period over period comparison or formula calculations to data using a familiar expression interface. Smart defaults and automatic data preparation are used throughout Dundas BI to provide a streamlined workflow, which means there are fewer steps needed to progress from your data to desired visuals.
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.
Explore Your Data
Right from the home screen, users can access a blank canvas where they can start creating a dashboard. They can easily see which data and metric sets are available to them in their project. A Metric Set is like a slice of a multi-dimensional data cube. It specifies a set of measures as well as which dimensions are on which axis, and which filters are available. By simply dragging the Metric Set on the dashboard, the user will be presented with the default view (i.e. a table or a chart).
Users can also drag data directly from their PC right onto the dashboard (i.e. Excel file or diagrams), and then perform various actions including copy, move and edit. They can also easily see their data structures including database table fields and cube measures and dimensions, and then drag and drop them onto the dashboard for further data discovery, filtering, sorting, grouping and drill downs to learn more about their data. Explore, analyze and visualize all your data, with Dundas BI business intelligence and data analytics software.
Interact and Analyze Your Data
Dundas BI advanced data analytics auto-detects hierarchies and time dimensions that enable powerful drill-down/up.
Hierarchies – easily interact with multi-dimensional hierarchies including geographic and product hierarchies. Very intuitive process with enhanced filtering, sorting, grouping and drill downs
Time Dimensions – automatically aggregate your date based data into years, half years, quarters, months, weeks and days
Metric Sets – easily refine the available data for quick development and ease of use
Data Tools – setup contextual metrics to support your data analysis including period over period, states setup and formulas
Formula Visualizations - generate new visualizations out of formula calculations or automatically summarize your data distribution via one click box plots setup
Analyze your data faster and thoroughly, and improve performance in all areas of your business with Dundas BI, visual data analytics software.
Extract, Transform, Load (ETL) capability is built directly into Dundas BI via our data cube layer. Simply add transform nodes to a data cube and connect them together to perform data cleansing or join tables sourced from different databases. The output of a data cube can be stored within the Dundas BI data warehouse for improved performance. Users can also build an in-memory analytical model of the data to enable even faster results for analytical queries. With data cubes, even non-technical users can easily discover and analyze data.