Affordable, flexible solution for manufacturing operations BI

We needed a self-service BI solution that would cover manufacturing operations dashboards and use cases. We wanted a tool that would allow for the distribution of centralized common dashboards but also allow for self-service customization. It needed to connect to multiple disparate data sources, and provide native ETL. It also needed to allow for real-time refresh capability. Finally, it needed to be affordable and scalable to our global operations footprint. DundasBI was the only solution that checked all of these boxes, and so far the tool has been a great help to reducing external spend and internal, custom-coded solutions.

Pros

-Real-time dashboard refresh capability -Built-in ETL -Flexible seat types and affordable licensing -Superior flexibility and customization, without the need for coding -Out of the box performance and usage tracking

Cons

Customization and flexibility come at the cost of a steeper learning curve compared to other solutions.

Amazing Experience for Your Dashboard's Users

The Creation GUI is very quirky, but the results are well worth putting up with it. I have never had an idea that I could not eventually create (sometimes, some java script is needed). The fact that they expose all of their API tools to the end user is amazing, and allows you to create some awesome things.

Pros

- Support team is very helpful with basic use cases. - After a dashboard has been created, it looks great and works well for the end user. - People with zero programming experience are able to create dashboards.

Cons

(All very minor things, which might be addressed in future updates) - Data cube creation, metric sets, and dashboards must be created using their GUI- they cannot be generated using scripts or edited as script. - You cannot copy and paste sections of one dashboard or datacube to another. - Data cube nodes cannot be copied. - All programming scripts are stored in an sql database, which means you cannot use version control systems (such as Git Hub).

Promising, good and high potential but not there yet

Dundas BI is a very good contender in the BI segment and has great potential. At the moment it is a tool for developers proficient with JavaScript and not recommended for end users. There are great potential with DBI. Unfortunately v4 got the wrong focus on non-essential upgrades thus put the bar high for version 5. To compete with Power BI, Tableau and QlikView DBI need much improvement on user-friendliness. If DBI can be really improved on administration and formatting and keeping the flexibility it will surpass most of it's competitors.

Pros

Relatively easy to get started and creating visualizations and dashboards. The scorecard, which is a kind of repeating panel is brilliant and undervalued. The report is a great addition which makes DBI an all-in-one BI tool. Dashboard layers and pop-ups enhances the experience. Data driven notification adds to a useful experience. ETL cube with data warehouse has powerful transformations and much capabilities. The open API with JavaScript makes it flexible beyond expectations.

Cons

Project and file and content management is amongst the worst in class! This need to be completely changed in v5! It's a frustrating experience to organize content. Auto save is okay, but need to be able to decide where. Check in /out is over-used and add frustration to developing dashboards. Poor cube management; need option to process multiple cubes and have incremential processing as option. Need an equation writer for those who is not proficient in JavaScript. Need more formulas for metric sets. Hidden metric sets in dashboards are a bad idea. Properties tab need complete re-organization.

Great BI tool

Since Dundas BI is fairly new compared to it's competitors expect a steep learning curve, especially on using the API's. With that said, it is quite worth it as you will be rewarded with a product that could deliver a great user experience whether using it as a stand-alone platform or embedding it to your existing ones.

Pros

Dundas BI is very easy to use and intuitive. For simple reports, almost everything works right out of the box. For advanced usage, the API's available are astounding. You can control the application without using their UI. (Great for automating certain routine admin tasks!)

Cons

They would have to look into deeper support for OLAP sources. Also, they would have to improve on their documentation, sometimes there are amazing features that are not going to be used because the user would not even know it's there.

Highly Customizable BI Software

Its Awesome product.

Pros

Dundas BI is very good software having lots of features and it is highly customizable BI Product.

Cons

Dundas BI dashboard performance should be improved for large data and also needs to improve Report PDF export look and feel.Also It needs more efforts to design from scratch.