IBM Cognos Analytics vs. MS SharePoint / SQL

I use predictive analytics techniques, which can help me predict my future sales based on collected data, giving me insight into my market's trends.This market data can be analyzed, giving me the opportunity to gain in-depth insight into my market's competition and positioning it competitively, aided by developing strategies to improve my marketing approach.

Incentivized

As I mentioned in my previous answers, MS SharePoint is very useful as a shared drive for the organization and is very easy to manage. It also helps us import data from SharePoint directly into PowerBI for creating reports. According to my understanding, only share link features should be improved.

Incentivized

• Data Visualization: Plenty of options exist for multiple use cases, and dashboards are easy to implement and customize.
• Integration with IBM Watson: makes it easy to use Watson AI features (NLP etc.) on your data.
• Its advanced analytics functionalities with powerful pattern detection/prediction models.

Incentivized

• Flexible - able to make any changes we would like vs traditional service desk system.
• ROI - We were already using SharePoint for internal intranet, so we are simply getting more use out of licensing we had already committed to.
• Easy to use for end users.

Incentivized

• API integration is not upto the mark with very limited options.
• Laptops get overheated when the tool is used from moderate to heavy use. Also, there is a lag in the tool times.
• Licensing & Maintenance can go from cheap to expensive depending on the scope.
• Lot of scope to improve the customer support & its not upto the industry standards.

Incentivized

• It is hard to setup and nightmare
• It requires a of infrastructure, thus it could be costly because of requirement and licensing required for everything to run smoothly
• If it is not setup and organized properly from the beginning it could be maintenance nightmare
• It is hard to have "test" environment to do patches or similar

Incentivized

It took my BI team one year to become productive at developing useful content on the IBM Cognos platform. After this year, the reports being developed for a client were stale and no longer relative to the ever changing needs of the business client. Given the same opportunity, I would select a platform that allows the team to quickly produce BI content. Fail fast and recover quickly!

This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.

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.

I gave this rating due to MS SharePoint being a big help with our userbase. We have a lot of users that are just old enough to not have much technical skills or they have been in this industry long enough to where they haven't really needed to utilize much technology. MS SharePoint helped us move beyond that barrier without too many bumps and bruises.

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

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.

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

I've only had to call in to support on one occasion but they were able to work though our issue and find a solution that did fully resolve the issue in a timely manner. I can't always say the same about support from other companies so it was a refreshing change to have support that did help.

Incentivized

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.

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

The implementation was handled very well. The initial implementation exposed a lot of disagreement between our campuses and departments as to how we define data. This was not entirely unexpected, but I thought that we did a nice job as a team to work through some of these challenges.

Mo major insight regarding the implementation if very well documented for standard products.

Incentivized

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

At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian Confluence and were successful. Confluence is cheaper than Sharepoint which is why we wanted to bring that in. The enterprise has now made Confluence an enterprise solution as an alternative to SharePoint. After using both I think SharePoint has many more add-ins than Confluence. It has much more customization ability than Confluence. SharePoint is not good for mobile readiness. Confluence is so there is a difference that might lead you to Confluence over SharePoint. I would also say that SharePoint is very document-centric and that Confluence has better KM than SharePoint does. even with the use of SQL Server. We were told that we could not use Google Drive even though it had features we liked.

Incentivized

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.

• The platform can be pretty pricey.
• Convoluted contracts and they fine you for any breach during audits.
• Things are changed between releases without any warning and break.
• It is second to none at being able to customize list and crosstab type reports.
• You can easily set up a report to be emailed out every day and even have it export the report to a shared folder.
• On-prem environments can be scaled up pretty much as much as you would like.

Incentivized

• ROI for ms SharePoint/SQL considering that is the best database engine with excellent features that help you to have all information in your hand.
• Something negative could be license format.
• These are the best relational databases in the market with powerful features that complement your system.

Incentivized