IBM Cognos Analytics vs. Microsoft BI (MSBI) vs. Cyfe, by Traject

Well suited: Financial reporting - It can handle complex, pixel perfect, muti-page reports with scheduled delivery to stakeholders (like sales report by region on quarterly periodicity) Operational dashboard across departments - It can combine multiple data sources (ERP, CRM, excels etc) with filters, and embedded AI insights Less appropriate: Live dashboards - As stated earlier as well, IBM Cognos Analytics doesn't suit well for live dashboards or event driven data. For ex: live web traffic data or IOT device data, etc Data science - Although IBM Cognos Analytics is great tool for data exploration but it should not be used as a substitute for Python or R, which has edge over advanced modelling and stats based workflows like predictive modelling or clustering

Incentivized

Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.

Incentivized

Cyfe might be for you if you are looking for a cost-effective way to display all of your marketing metrics in one place. If you are looking for a detailed, fine-tuned, niche, or extremely specific metrics, this might not be the best solution. Cyfe is good for a general health check-up of marketing, but not a finely tuned examination.

Incentivized

• We can make dozens of dispatchers all focusing on different types of workloads.
• Friendly user interface, without the need for coding or complicated editing.
• Highly functionality reporting tools.
• We can easily create trigger when a certain threshold are met sending reports or alerts to needed parties.

Incentivized

• Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
• Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
• Transfer of data from one application to another via Excel and comparison of data attributes between applications
• Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

Incentivized

• Has preset metric groups that pull similar stats together in one "bucket" saving you the time of setting up each stat-line one by one
• Allows you to easily adjust the timeframe for what stats you want to see, so you can find YOY stats or just last month's stats rather quickly
• Colored visualizations of stats make it easy to notice when campaigns are taking off

Incentivized

• IBM Cognos Analytics enables customer data segmentation, which is essential for marketing, improving and streamlining purchasing behavior and preferences. This helps companies create more targeted and effective marketing campaigns.
• Our clients Through data analysis, we can identify and observe trends in the behavior of other clients, allowing us to anticipate needs and adjust strategies to avoid consequences.

Incentivized

• MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
• It would be a lot better if it is a little low on cost.
• it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

• I'd love to see additional functionality to customize colors. The light/dark option is very nice, but a little more flexibility in the colors would go a long way, especially if it was possible at the dashboard level rather than just the account level. Along the same lines, being able to customize the charts a little more, for example being able to show an x-axis on single data type graphs, could make them easier to read in some cases.
• Being able to choose to report on converted clicks or conversions in AdWords would be helpful.
• Needs the ability to show the date range on the shared URL dashboards. Would be even better if the date range was adjustable on that view, too.

For an existing solution, renewing licenses does provide a good return on investment. Additionally, while rolling out scorecards and dashboards with little adhoc capabilities, to end users, cognos is very easily scalable. It also allows to create a solution that has a mix of OLAP and relational data-sources, which is a limitation with other tools. Synchronizing with existing security setup is easy too.

Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.

It has become a part of our internal tools so unless a competitor comes out with similar functionality as a similar price point it is unlikely that we would not renew. One area that would cause us not to renew would be if a competing service came out with more third-party integrations that match our needs. Price at this point is no longer an issue as it would allow us to automate a somewhat manual process that we have now connecting Cyfe widgets to Google Sheets.

We have a strong user base (3500 users) that are highly utilizing this tool. Basic users are able to consume content within the applied security model. We have a set of advanced users that really push the limits of Cognos with Report and Query Studio. These users have created a lot of personal content and stored it in 'My Reports'. Users enjoy this flexibility.

The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.

Incentivized

I gave it a rating of 7 because it does a good job at what it does, but there are missing that are missing which I would have benefited from. For instance, if I was able to drill down more on the specific metrics I was able to see, that would have been helpful.

Incentivized

Reports can typically be viewed through any browser that can access the server, so the availability is ultimately up to what the company utilizing it is comfortable with allowing, though report development tends to be more picky about browsers and settings as mentioned above. It also has an optional iPad app and general mobile browsing support, but dashboards lack the mobile compatibility. What keeps it from getting a higher score is the desktop tools that are vital to the development process. The compatibility with only Windows when the server has a wide range of compatibility can be a real sore point for a company that outfits its employees exclusively with Mac or Linux machines. Of course, if they are planning on outsourcing the development anyways, it's a rather moot point

The product has been reliable.

Overall no major complaints but it doesn't handle DMR (Dimensionally Modeled for Relational) very well. DMR modelling is a capability that IBM Cognos Framework Manager provides allowing you to specify dimensional information for relational metadata and allows for OLAP-style queries. However, the capability is not very efficient and, for example, if I'm using only 2 columns on a 20-column model, the software is not smart enough to exclude 18 columns and the query side gets progressively larger and larger until it's effectively unusable.

SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.

Why is their web application not working as fast as you think it should? They never know, and it is always a a bunch of shots in the dark to find out. Trying to download software from them is like trying to find a book at the library before computers were invented.

Incentivized

MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.

Incentivized

Because I had a very minor question and I was able to speak directly to the founder through LinkedIn and through email. I know that as they grow this may not always be an option but the fact that he made himself available to answer my questions said a lot about his passion for the product.

Onsite training provided by IBM Cognos was effective and as expected. They did not perform training with our data which was a bit difficult for our end-users.

This training was more directed toward what the product was capable of rather than actual programming.

The online courses they offer are thorough and presented in such a way that someone who isn't already familiar with the general design methodologies used in this field will be capable of making a good design. The training environments are provided as a fully self contained virtual machine with everything needed already to create the environments. We've had some persisting issues with the environments becoming unavailable, but support has been responsive when these issues arise and straightening them out for us

I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.

Make sure that any custom tables that you have, are built into your metadata packages. You can still access them via SQL queries in Cognos, but it is much easier to have them as a part of the available metadata packages.

We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.

Cyfe is a 15 minutes implementation, then some time to get your data sources created. This is an easy one person job that will not result in down time or unnecessary wasted man hours.

Power BI is stronger for quick ad-hoc analysis and dashboards, but IBM Cognos Analytics is better when consistency, precision, and mass distribution matter. Tableau is best for interactive analysis, while IBM Cognos Analytics is better for standardized, repeatable enterprise reporting. Sigma shines for customizable dashboards and drill-down analysis while IBM Cognos Analytics holds an edge in data discovery and visualization.

Incentivized

We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.

Incentivized

The Salesforce dashboard is comparably flexible and intuitive, but designed more to its internal CRM focus. SumAll shares the social media dashboard capabilities, but lacks all others. Its interesting feature is side-by-side graph analysis for cross-channel performance. Cyfe might borrow from SumAll's default weekly email summary of performance from the dashboard, but implementation could be too complex. Nuvi dashboard is exclusively for social media marketing, but lacks Cyfe's flexibility for third party integration and window customization settings.

The Cognos architecture is well suited for scalability. However, the architecture must be designed with scalability in mind from day one of the implementation. We recently upgraded from 10.1 to 10.2.1 and took the opportunity to revamp our architecture. It is now poised for future growth and scalability.

• We use the tool for data modeling as it helps in predictive data analysis for complex data, which is very similar to real-life scenarios.
• Options of customizing & scheduling reports as per our requirements basis.
• Has mobile application which works seamless.
• API integration is not upto the mark with very limited options.
• Licensing & Maintenance can go from cheap to expensive depending on the scope.

Incentivized

• As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
• However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.

Incentivized

• Cyfe allows us to provide real time data to our clients
• Cyfe allows us to provide detailed analytics to our clients showing actual results
• Cyfe reduced our need to provide monthly "reports" to our marketing clients
• Cyfe allows us to have better situational awareness and know what is going on throughout our multiple organizations