Cognos Analytics vs Dundas BI

IBM Cognos Analytics is an excellent BI tool and rates very highly with users on all major counts. Users are unanimous in their praise of its data management and data analysis capabilities to provide a single source of truth. Having ventured into AI-powered tools with the 11.1.3 version in 2018, IBM is making bold strides to incorporate augmented intelligence into the platform. IBM has astutely combined this solution with the capabilities of one of its other offerings, Watson Analytics, for natural language processing - a game-changer for empowering non-technical users to create a vast range of dashboards. With AI-enabled exploration, users can review key drivers of metrics and identify gaps in data, though some users feel that more tools are needed for content store exploration through its relational database. It also rates excellently with users for its data integration and ad-hoc reporting capabilities, efficient metadata management and extensive data modeling features. Several strong features of this platform, as noted by reviewers, include Jupyter notebooks, regular updates to the platform and enhancements to data modules, though when it comes to integrating with Online Analytical Processing (OLAP) data sources and IBM Planning Analytics in particular, it comes up short. Version 11 of the platform comes with over-the-top installs for upgrades, which reduces time to set up; though some users feel that integrations built with the current SDK solution can be tedious to implement and maintain. Being part of the IBM software suite, it connects seamlessly to other IBM products under the same umbrella. However, integration with MS-Sharepoint is not supported; this can be managed with workarounds, but only for on-premise setups, not cloud-based deployments. The platform has a rich reporting repertoire with report burst capabilities, pivots and Cognos Event Studio for event-driven reports. However, many users feel that Report Studio should provide the write back capability, which is crucial for business. As for the cost, a majority of users feel that its licensing models are restrictive, especially when compared to other BI solutions; though the vendor seems to address pricing and ease of use with version 11.1.3. In summary, Cognos Analytics is among the best BI solutions in the market today and IBM, with its ear to the ground, is delivering enhanced data analysis and reporting capabilities at scale.

Dundas BI is a web application that stands out for placing the buyer first with built-in ETL, shared licenses and unlimited refreshes. It surpasses market leaders like Power BI and Qlik Sense in native functionality. It’s feature-rich, with 77% of capabilities available out of the box.About 72% of users reviewing the interface praised the platform, whereas others felt it was confusing. An open API architecture might be one reason for the UI's clutter, but the vendor offers a way out. You can make onboarding easier by removing components that seem complex.Usually, reporting is a loose term for dashboards and static reports and not much else. However, the vendor packs these tools into a neat package at no extra cost. Dashboards are usually static, single-screen views, but Dundas allows embedding reports in them to complement your KPIs. The support team is responsive with clear SOPs and quick responses, and the documentation is detailed.On the downside, many users felt it slowed when handling heavy workloads. Performance is critical in business, but every data tool has accompanying tradeoffs, and sadly, it’s often speed. That said, keep in mind that many factors are at play here — the hardware, internet speed, data complexity and database efficiency. Consider them for your use cases when evaluating performance, as they significantly impact how a program responds to user interactions.Ultimately, it boils down to this — how much lag can you accept before it impacts your business? A proof-of-concept or, even better, a trial would be your best bet to assess how the platform fares.Due to its rich scripting options, the learning curve can be steep. Users felt the feature documentation should cover more information on Javascript and APIs. Most reviewers were satisfied with the pricing, saying it offers value for money.In summary, Dundas BI is a powerful tool if you need a high degree of customization, scalability and flexibility. It can handle complex data environments and supports many users concurrently. It would be a good fit for mid to large-sized enterprises as they have diverse data needs and are open to investing in training.Organizations with simple data requirements may find the tool a bit over the top and the cost excessive. In such a case, opting for a tool with basic functionality might be a good start. One non-negotiable would be frequent, stable updates. It'll ensure the tool grows with your business over time.