What do you like best?
Dundas BI allows us to combine data from numerous different data sources (SQL Server, Oracle, SAP BW, Excel, etc.) into combined data cubes allowing the data to be presented in cohesive dashboards and reports that are not broken up by where the data is stored. Our staff can store their data wherever makes the most sense for them based on their systems and we can bring it all together in simple, effective manner.
What do you dislike?
The key areas that we have run into issues have mainly been around small user interface and formatting areas. For example our organization uses a two year format when reporting fiscal years (ie. FY 2016-2017) but the Dundas BI system only allows for single year representation; therefore FY 2016-2017 has to be reported as FY 2016 or FY 2017 which can be confusing to some users.
The issue we have on user interface is that some of the screens we can get ourselves into do not have an option to get out of them without finishing the configuration. This often happens when we are building a data cube and we open up a join to define the details and realize that one side of the data in the join is missing the field required to make the join. We currently have to define a join before we can close the interface, then come back in and fix the join once the correct fields are being returned. Minor issue that we can get around easily.
Recommendations to others considering the product
Reach out to their tech support any time you are stuck on something. They have a great team of support staff who provide top notch support; even to those who are only using the trial version.
What business problems are you solving with the product? What benefits have you realized?
Where the data for our programs are stored in numerous different data systems it was not possible for staff to see the complete picture about the programs they are leading and managing; it was also hard to report on the effectiveness of programs and pilots in a consistent, quick manner. Using Dundas BI we have managed to create a suite of dashboards and reports that bring this data together in an easy to understand manner; allowing decisions to be made quicker; based on facts.
Getting the data into the hands of people who need it in a manner that is useful to them has allowed us to make budget and program related decisions in a more timely manner.