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
Qlik Analytics Platform
Score 7.3 out of 10
N/A
The Qlik Analytics Platform (QAP) is a developer platform for building custom analytic applications based on rich frontend and backend APIs. It gives full API access to the Qlik associative engine to build rich data-driven analytic applications, for example when building web applications for extranet and Internet deployment.
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.
Qlik Analytics Platform has helped us track turnaround time as well as sales volumes. We can display metrics in a multitude of ways and can then slice it up in even more ways by adding filters. It is nice that you can filter down the data by essentially "Qliking" anywhere to find insights. Qlik Analytics Platform has been extremely beneficial in reducing manual reports. We are able to automate numerous reports in addition to setting up alerts, through Nprinting, that will notify users when certain metrics are hit. For example, if our turnaround time exceeds a certain number, we can alert business stakeholders so they can take a closer look. We can also send notifications to sales representatives when their territories are underperforming.
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
Customer support is provided through resellers, and finding the right reseller for your context can be a challenge. However our support from our last two resellers/partners has been largely very good. The online community is strong, though obviously doesn't replace having local technical experts working with the product and managing it.
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.
Qlik is a platform with more scaling ability and functionality compared to PowerBI. PowerBI is the prior step before passing to Qlik, however, Qlik provides more functions and abilities to the business domain unit with better management capabilities for the IT team that set it up. In the end, we implemented Qlik for functionality and scalability.
