What is most valuable?
The most valuable feature is the ability to quickly build cubes with Cognos Transformer. Transformer has enabled us to consolidate millions of rows of detailed data into multi-dimensional cubes. It enable business users to drill down, and slice and dice data by key business dimensions, such as product, region, customer, and time.
How has it helped my organization?
It has provided visibility into our customers; specifically, it has given us insight into high-value customers.
What needs improvement?
The Cognos Suite needs improvement in a number of areas. First, the products must be made more user friendly for casual users. Next, business users need the ability to quickly pull in data from non-structured sources without the need for IT to model the data. Another area for improvement is advanced charting and graphical elements that you can use in reports and dashboards.
For how long have I used the solution?
I have been using IBM Cognos since 2012.
What do I think about the scalability of the solution?
PowerCubes has limits and thresholds. Developers need to be aware of these when designing a cube, and take into consideration the cube performance versus the physical size.
Report Studio for operational reporting against relational data sources is very dependent on the underlying database performance and the design of your metadata model in Framework Manager. Report designers and modelers must analyze the generated SQL and tune the Framework Model and reports.
How are customer service and technical support?
The technical support is good.
Which solution did I use previously and why did I switch?
I did not use any other solution previously.
How was the initial setup?
Setup for a multi-server environment is of average complexity. Tuning the environment takes time.
What's my experience with pricing, setup cost, and licensing?
Negotiate on licensing and support costs.
Which other solutions did I evaluate?
We have often reviewed the BI landscape. For Enterprise BI, we have looked at Cognos, SAP Business Objects and MicroStrategy. These tools are very similar and leapfrog each other with each release. Newer tools such as QlikView, Tableau, and Spotfire have gained momentum and taken market share from the enterprise BI vendors. You need to analyze your needs and determine whether an enterprise BI suite is right for you, or if you need multiple tools for different capabilities.
What other advice do I have?
Plan your reporting strategy. Do you intended to implement self-service reporting so that end users are creating reports? Do you need structured operational and management reporting? Cognos often requires IT resources for metadata modelling. Will you have the bandwidth and time to move at the speed your business requires?
Which version of this solution are you currently using?