Get insights of your data on the fly with DBI
Updated November 25, 2020

Get insights of your data on the fly with DBI

Luis Silva | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Review Source

Overall Satisfaction with Dundas BI

We use Dundas BI to monitor and act based on the state of a set of defined KPI's. It's used across various departments: finance, public works, provision services, organization workflow. As an example, some workflow tasks have a due time, so we track the ratio of the overdue tasks and act upon it, adjusting man power if needed or change the task execution time in order to optimize this ratio. We also use ad-hoc analysis to get a better understanding of the quality of the data being produced by our ERP's.
  • Creating data analysis on the fly is very easy! You only need to create a data connector and from there you can start analysing your data just by draging and droping atributes from tables to the canvas!
  • For executives with little time for viewing dashboards, you can create scheduled or data driven notification that can send the dashboard by email!
  • At any time you can revisualize your data with different visualization, e.g., a bar chart can change to a line chart with just two clicks!
  • DBI version 4 has introduced some awesome features: data correction, what-if-analysis, some new types of data visualizations like sankey chart, correlation matrix, support for svg files.
  • I felt the need to create a calculated metric based on metrics from different metric sets
  • We did manage to sell the solution implemented with Dundas easily
The ETL for DBI is much more easy than what I experienced when I used QlikView! The QlikView language for ETL was somehow different from anyother languages I used before, on the other side DBI ETL is workflow based, with nodes to perform joins, aggregations, filter and sorting! You may also used plain SQL to query your data!
With the ETL of DBI you can create and relate data from disparate data sources, like Oracle, Google Analytics, SqlServer, Excel worksheet and more!
The workflow like ETL makes it very easy to combine multiple sources of data!
The authentication and authorization are very versatile! You have the concept of groups and users, permissions by application features! You have various forms of sharing content: Excel worksheet, image, pdf and powerpoint. You can collaborate with other application users using data point annotations that can be viewed and commented by them!
In DBI 4 there has been an improvement in the ways you can authenticate with the introdution of Federated Authentication.

Do you think Dundas BI delivers good value for the price?

Yes

Are you happy with Dundas BI's feature set?

Yes

Did Dundas BI live up to sales and marketing promises?

Yes

Did implementation of Dundas BI go as expected?

Yes

Would you buy Dundas BI again?

Yes

I did manage to accelerate time to market of my BI projects using Dundas BI, thanks to the rich user interface, easy to use and rich set of features.
Dundas BI is constantly evolving, adding new features to the set every year. The support responding time is more than acceptable. The tool knowledge and creativity of the support team helped me a lot!
In my experience and regarding the projects that I worked with Dundas BI it suites perfectly well. Connecting to Oracle and SQL Server databases and making data analysis with dashboards, scorecards and reports is very efficient and performant! Even when the size of the data being analysed is quite big, you can benefit from the cache feature that it offers!

Dundas BI Feature Ratings

Pixel Perfect reports
9
Customizable dashboards
9
Report Formatting Templates
8
Drill-down analysis
9
Formatting capabilities
9
Integration with R or other statistical packages
9
Report sharing and collaboration
9
Publish to Web
10
Publish to PDF
10
Report Versioning
10
Report Delivery Scheduling
10
Delivery to Remote Servers
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
8
Predictive Analytics
8
Multi-User Support (named login)
10
Role-Based Security Model
9
Multiple Access Permission Levels (Create, Read, Delete)
10
Single Sign-On (SSO)
Not Rated
Responsive Design for Web Access
10
Dashboard / Report / Visualization Interactivity on Mobile
8
REST API
8
Javascript API
9
iFrames
9
Themeable User Interface (UI)
9

Using Dundas BI

2 - We use Dundas BI to provide a BI solution for our clients. We develop ERP's solutions for Portuguese Local Governments and we needed a BI platform to complement our solution. So, all of the people involved have a solid understanding of Local Government business rules.
3 - First of all, they have a solid knowledge of the business and some of them have SQL and development skills. However, the most import of the skills which we all have is a deep understanding of Dundas BI features and capabilities.
  • Create more analysis: Dahboards and reports.
  • Use it to access the quality of our data
  • Automate report delivery, using the collaboration features of the product
  • Easy of use
  • Rich set of features
  • Data cache
  • Easy to integrate with existing solutions
  • We use it to provide a vertical solution for all of our clients

Evaluating Dundas BI and Competitors

I needed a BI tool easy to use and at the same time with a broad set of features! It should have features like reporting, collaboration, rich data visualizations integration and data security. After exploring some BI tools, I've chosen Dundas. The elegance of the user interface, the drag and drop features turns simple the creation of dashboards and reports.
I wouldn't do anything different as I am extremely satisfied with the tool I elected for my projects.

Dundas BI Implementation

Providing that you have the client's needs well known, creating BI content using Dundas BI is a walk in the park!
Yes - As the solution implemented covers various areas of Local Government management, we had to get into this business areas to understand it well, this was the first phase. In the second phase, we have made several discussion with the client's experts in this areas to access the needs they had for analysis. The last phase, was the creation of reports and dashboards based on the knowledge we gather in the previous phases.
  • Some bad client's data quality
  • Difficult in understanding what they really want

Dundas BI Support

ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
None
Yes - I did report some bugs and they were considered and resolved in a minor version of the product being deployed soon enough!
I do remember a time when I needed to have information privacy for some users (I needed that the information seen by the user would be filtered by the user logged in), and given that at the time there wasn't an out of the box feature to do this, they did provide me a get around solution that solved my problem and afterwards they created a feature for this, this feature is now known as "Secure Hierarchy".

Using Dundas BI

ProsCons
Like to use
Relatively simple
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • Ad-hoc data analysis just by drag and drop a data set into the canvas
  • Creation of dashboards and reports are easy to create
  • ETL layer is amazing as it can provide you a cache for you information and improve your views performance
  • Integration using the API may be cumbersome if you don't have a solid grasp of the API
Yes - Dundas BI is implemented using the last innovations in web development, like CSS3 and HTML5. So you can make your visualizations responsive and adaptable to the user device easily!