Dundas BI is a business intelligence and data visualization software that includes customizable dashboards, reporting, and visual data analytics. Dundas BI can be integrated into users’ existing business applications and its visualization and reporting tools can be customized to their needs.
N/A
Grist
Score 9.6 out of 10
N/A
Grist enables users to transform spreadsheets into a custom database where data is actionable. Build a relational spreadsheet with no code. Customize each page of a Grist database into an app-like dashboard. Transform tables into data cards or colorful charts, or create a custom widgets. Drill into data with dynamic charts and reports that update as data is acted upon. Tame large data sets into summaries that highlight key…
For all the scenarios I have so far worked on or I am currently working on, Dundas BI has proved to be more than adequate and apt to handle all of those. It is a very easy-to-use tool with quick shortcuts enabling you to prepare ad-hoc reports or dashboards in a matter of minutes.
This is well suited to someone (or a team) who are technically minded and have a dataset that they need to be able to use in many ways. It's less appropriate for a team who isn't technically minded and/or don't have the data they need to manipulate. It would be useful for things that you could use a database or spreadsheet for such as CRM, Advertising database, Business tracking, Health tracking etc.
Project organization from Development to Production, you get a production and development license but I think the best way to do it is with DEV and Prod project in the Production box. Use the development box for testing updates and really crazy things. With the Dev and Prod projects on the same box, you just publish from Dev to Prod and you are done. Users only have access to the Prod projects so no one can mess up what you are working on.
Security - If you have a hierarchy (subsidiaries, divisions, department, teams) and you want each group to see only their data, then Security hierarchies are for you!
Dependent filters! What's this you ask? Here is an example of how it can be used, in your company you have departments and who works for what department is in your database. You make a dashboard that has a department filter (only show these departments), a managers filter, and employee filter. Not every manager or employee is in multiple departments usually only one. With dependent filters you can say that the manager and employee filter are dependent on what is selected in the departments filter so when you go to filter them they only show the managers or employees that are part of that department, and you can even it do so employees are not only dependent on department but on manager as well. Then it gets even better as it can be done in reverse as well so when you select a manager then go to the department it only shows the departments he works for (there are better situations where this is more useful).
It is scriptable! From calculate columns, null replacements, button actions, load actions, hover over events there a way to do what you want.
They are constantly improving and listens to your suggestions.
Not too many cons for how we use the application. It really is easy and powerful. Very powerful.
Licensing is one thing that could be looked into. It is simple, but a little confusing. For example, if I get a license today, but a new release comes out tomorrow, it seems that the license doesn't work with the new release. Maybe that is by design, but it would be nice to clearly understand.
We are still in the implementation phase, but so far we are finding it to be easy to use and learn. The eLearning courses that they have made available for free, as well as User Forums and other training videos have made even difficult concepts easier to understand.
We have bi-weekly calls with our Success Manager, as well as access to support as needed. Any question that I have had, multiple people have been willing and able to jump on a call to talk me through it, or send an email with the solution
Per dollar spent, it offers the widest range of features of the tools that we evaluated. It offers lots of options for how to configure your environment, though they are not always intuitive to figure out. Having an ETL layer was a must have for us, as well as the ability to host to secure HIPAA compliance. It is not a replacement for ad hoc reporting, but does a great job of creating parameterized reports and dashboards that look great.
It's saved a lot of time in both creating an advertising database and managing it week to week effectively. I had previously created in others that haven't worked, and this does, saving me a good 1 hour weekly, and 5 hours or more each time I had problems with the last ones
Being able to stay on track with this has meant I'm following up at the right time (advertisers) and keeping a professional manner and not losing business due to missed communication
Saving me $ from buying a program like Access (or Airtable monthly) and then the learning curve that that has. This has a much easier learning curve to say the least.
