Dundas BI Version 5, Meeting all your dashboard needs with a smile
May 09, 2018
Dundas BI Version 5, Meeting all your dashboard needs with a smile
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Dundas BI
When I got to this company they had Dundas BI but it was not being fully utilized. I was brought in to solve that issue. The company has lots of useful data that just was not being utilized in a good manner.
We, of course, have some executive financial and Human Resource dashboards. Since I have come along I have added a Board of Directors Quarterly reporting dashboard, an HR Turnover, Labor Utilization set of dashboards that have been broadening out to answer even more reporting needs, one that tracks the status of delivery orders, and an overall main project overview.
I also created inventory abbreviations lookup table.
Our company is getting more exposed to what Dundas can do as I add more dashboards, they are now asking "can Dundas do this for us instead of trying to assemble the data themselves."
We, of course, have some executive financial and Human Resource dashboards. Since I have come along I have added a Board of Directors Quarterly reporting dashboard, an HR Turnover, Labor Utilization set of dashboards that have been broadening out to answer even more reporting needs, one that tracks the status of delivery orders, and an overall main project overview.
I also created inventory abbreviations lookup table.
Our company is getting more exposed to what Dundas can do as I add more dashboards, they are now asking "can Dundas do this for us instead of trying to assemble the data themselves."
- 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.
- Setting up security is easy but reviewing it later could be made easier.
- Dashboard templates - tried to use them but I do not design mine to fit in a box.