Dundas BI is a web-based BI tool that allows users to connect, interact and visualize their data through interactive dashboards and reports. Known for their beautiful visualizations and out-of-the-box interactivity, Dundas BI is designed on a fully open API architecture that's adaptable to fit anyone's needs.
Dundas BI supports data preparation and integration, reporting, dashboards and analysis exactly the way you need it. Through full API support, plug-ins and in-app scripting, Dundas BI is extensible, in and out, and can be easily integrated and embedded into existing systems, applications and administration. The ability to seamlessly integrate Dundas BI into existing systems and the depth of the capabilities is what allows the platform users to fully achieve their exact vision.
Dundas BI can be easily deployed on-premises or via your preferred cloud hosting provider. Using a best of both worlds approach, Dundas BI combines the strengths of IT-led solutions, such as governance, scheduling and data modeling, and the strengths of Business Self-Service solutions, such as easy-to-use interactive visualizations, collaboration and on-the-fly data blending.
I've been working in Business Intelligence for quite a long time and in the beginning it was hard to explore data and show information in form of data visualizations for the end users. Since I discovered Dundas BI, this task turned to be much more simple and easy to achieve! Dundas Bi has an IDE for developing Dashboards, Reports and Scorecards that uses the last technologies in web applications developments which makes your life simplier. The smart drag and drop design tools, the rich set of data visualizations customizable to the lowermost detail, the style and themes feature, turns possible to create rich and interactive dashboards in a breeze! Dundas BI comes with an ETL (Export , Transform and Load) layer, where you can clean and prepare your data, this is done using a canvas where you can drag your tables from a data source, choose the columns you want, aggregate them, join with other tables, filter and a lot of interesting features regarding the ETL process. It connects to a lot of data sources: Oracle, Microsoft SqlServer, Excel files, ... It is a collaborative tool, with scheduled reports, based on a metric or not, you can even annotate data points, writing a comment on it in a way that others can see and respond to it! Every view can be exported to excel, pdf, image and even powerpoint.
The management of the software is in the form all in one! every thing is done in the application, from user creation object permissions, overall configuration, project exporting/importing and management!
The drag and drop feature for creating views is a very productive feature. The ETL is also great, it's easy to use and, for more advanced users, it evens permits to write direct sql against tha data source you choose. Regarding performance it has two possibilities, you can cache in memory or in DBI data warehouse. The collaborative feature of this tool is a must to have feature, I specially like the data driven notification option that could alert you by email when a specific metric goes behind a threshold or state.
It needs to take a step further and aboard predicted analytics!
Dundas is a conglomeration of expertly coded dashboard development tools and infrastructures. The thing I like most about Dundas is that they are very helpful, the gentleman assigned to me to educate me in the ways of Dundas, was one I will never forget to this day, he was calm, helpful, understanding and with his help I learned Dundas in no time.
I like the way Dundas structure's its Dashboard development, it starts with virtual tables, where the programmer can manually or automatically generate SQL queries, these queries are then used for the basis of adding statistical flavour to the Dashboard, the way this is done is very straight forward. Dundas has a steep unforgiving learning curve, but when you master the fundamentals, the sky really is the limit.
Also their support service is world class, the representatives will assist you in any way they can, they will help you understand what the issue you are facing is and provide a resolution. If they cant help you via email, they will 'WebEx' you, i.e skype call with 2 way screen control.
Everything in Dundas is customizable, charts, graphs and other statistical data can be glossed up and made to look as simple or as plush as the user envisions. You can add formulae, trend analysis and other key statistical methods are employed by Dundas.
They have charts for Finance, Risk analysis and other key statistical methodologies. All of these charts can be jazzed up with scripts so that you can Drill down and filter through the data you want in order to get the right Business Intelligence feel to your work.
Dundas supports the Data Cube, It supports Microsoft, Oracle, MySQL, EXCEL, it has export capabilities onto Excel, so those clients which prefer their data in Spreadsheets can manually export directly from the dashboard. Everything in Dundas is designed to give you the most professional feel possible at all times!
Dundas, for the good of it's users needs to publish more comprehensive educational equipment to train it's users, it is very hard to get to an expert level in Dundas without some help from your Friends in Dundas. I would love to see Dundas publish university style lectures, with step by step guides that show every aspect of the working sphere. With adequate educational material, one would be able to gain adept or even artisan status with the Tool on their own.
I think overall, I would not rule out Dundas, even with it's so called quirks. Dundas staff showed very much that they listen to users, even those that haven't purchased and have taken my criticisms to heart. Since we're not talking about a 2017 Toyota car or whatever, I feel it's important to note the constant evolution of any progressive software company. The complaints stated could be obsolete in a mere few weeks.
Dundas seems to really understand the need of handling big data and the tools needed to process these overwhelming mountains of 1's and 0's into actionable data. While working with the demo of Dundas I was able to create a very helpful tree-map that showed me the dissection of purchases comparatively from vendor to vendor to evaluate our performance or "loyalty" per vendor by item category and so on.
The U.I. of Dundas, while quite robust, seems to concern me in regards to the amount of boxes, checks, and clicks and long clicks I have to make to merely navigate my way through the program. I would rather see more keyboard shortcuts and less "Windows Vista" popups that slow my work. I felt like the settings I would implement would get lost. For instance, I would filter the vendors that weren't pertinent to my particular evaluation, then also the item categories that I wasn't interested in working with. Later on, when in the final building of the dashboard I wanted to add a checkbox filter to allow the end user to select individual item categories and be able to view 1 or all 20-30 at a time. Strangely, even though I filtered (or so I though) this data in the data cube level, I realized that the checkbox list populated with ALL the categories. This was quite frustrating. Also, I have yet to figure out how to go from an unfinished dashboard back to the data metrics screen where I built the KPI to start with. Unless i'm mistaken, it seems you have to go back to your saved metric set and then create a new dashboard after edits. Hopefully I'm wrong in my assessment of this but even so, the answer did not seem to be intuitive .
I used Dundas BI for almost the last two years, Dundas BI is Enterprise end to end solution where you can connect to your data through wide range of data sources available and the ability to add extra data sources through its open API, Dundas BI contain embedded ETL engine to transform the data and it allows for multiple data access options (Datawarehouse, In memory analysis and direct connection to data). by using Dundas BI you can build your dashboards, reports and scorecard with friendly interface and with rich library of visualization charts from bar and pie charts and ending with relationship chart and histogram chart. Also Dundas BI allow business users to do their self service analysis with referring back to IT people, I cannot forget their customer support, they have well trained team to support their customers from incidents and issues and service request like helping us in writing Java codes to do amazing things in the solution.
The tools is completely open and it is build over JS and HTML5, this is so amazing since Dundas BI is fully supported on mobiles with all mobile features like pinch to zoom and others.
As Dundas BI have full Java and .Net APIs then it is very easy to integrated Dundas and embedded it in other portals and it has out the box integration with SharePoint.
Flexible tool where you can do what ever you want, I beleive that 95% of use cases can be build in Dundas BI as quick-wins and the rest is possible through JS and HTML5.
I wish Dundas BI to have out the box integration with web-services as this will be helpful and currently not available but it can be done through programming,
Dundas BI is the most comprehensive BI platform available (trust me, we looked at BI products for almost a year before choosing DBI). Our three main criteria when selecting a BI platform for our clients were visualizations, reports and mobile. DBI covers all three criteria (with a codicil that will show up in the "What I like least" section) and the licensing costs are reasonable. Key features that are crazy cool: 1) DBI is data-source agnostic, 2) the scripting capability allows developers to do just about anything, 3) DBI is based on HTML5 technology (other well-known BI products are based on proprietary and/or outdated technology) and 4) the DBI support team (including the development team) provides excellent customer service.
For us, as a small software company, there is always the chance to second-guess the selection of a BI product. This was a critical decision for us as the BI software we deploy to our clients will directly impact the viability of our organization and our ability to stay relevant in the coming years. It is a testament to the DBI product and the Dundas team that the answer to the question "Did we select the right software?" is always a resounding "Yes".
The one knock on DBI is the lack of a mobile app. User experience is the number one factor for us when delivering products to our clients. Currently, mobile data is delivered via web pages. DBI would be greatly enhanced if the mobile experience was via a mobile app (even if the "app" was simply a wrapper the redirects users to the web page).
Contact Dundas for pricing/quotes.
• Smart Visualizations – Automatically visualize your data in different ways and interact with it without having to go through data preparation steps
• End-to-End Extensibility – One agile application that auto-adapts to the user skills, covering your BI needs from data prep to presentation and self-service, all on open API
• The Platform - Based on HTML5 technology, which allows users to visualize their data from any web browser on desktops or any mobile device.
• Embedded BI and Analytics – Integrate into other applications and create your own multi-tenant white labeled solution, offering your customers a superior experience
• Any Data Source - Users can connect to and integrate any data source such as OLAP, Excel, Big Data sources, relational databases, web services or even simple text files for data analytics.
Below are some frequently asked questions for Dundas BI.
Dundas BI offers the following pricing plans:
Pricing model: One Time License, Subscription
Free Trial: Available
Contact Dundas for pricing/quotes.
Dundas BI offers the following features:
Dundas BI has the following typical customers:
Large Enterprises, Mid Size Business
Dundas BI supports the following languages:
Arabic, Dutch, English, French, German, Hebrew, Italian, Portuguese, Spanish
Dundas BI has the following pricing plans:
One Time License, Subscription
We do not have any information about what devices Dundas BI supports
Dundas BI integrates with the following applications:
Google Analytics, Google Docs, Microsoft Azure, Microsoft Dynamics CRM, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint, Pardot, Salesforce Sales Cloud, SharePoint
Dundas BI offers the following support options:
FAQs, Knowledge Base, Online Support, Phone Support, Video Tutorials