Likelihood to Recommend I would be likely to recommend IBM Planning Analytics, particularly in scenarios where comprehensive financial and operational planning is essential. For instance, in our construction company, it is awesome for optimizing resource allocation across multiple projects, creating detailed project budgets, and conducting risk analysis to mitigate project uncertainties.
Read full review Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.
Read full review Pros Forecasting after taking into account seasonal trends and exceptional transactions Unlike spreadsheets, there is no fear of an user making changes to the mastercopy accidentally. Each user gets his or her own workspace to analyze. For entities operating in multiple countries, connects seamlessly with IBM Cognos Controller for taking into account variation in currencies Read full review 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. Read full review Cons IBM Planning Analytics was an upgrade from an older version of TM1 that is experiencing some growing pains, some functionality is harder to reach than it has been in the past It is easy to learn as a surface user with created reports, but it does require some technical skills to make advanced calculations and reports if there is no reliable consultant available, much like Excel Read full review The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category. Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups. Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI. Read full review Likelihood to Renew Since IBM Cognos Express is suitable only for medium data warehouse environment, we are not sure if this tool solves the long term need as the business keeps growing rapidly. So its a 50/50 ratio to renew Express license. But having said that, the components of IBM Cognos Express are also available in other Cognos BI suites like Cognos 10.x version. So we will probably upgrade our environment to IBM Cognos 10.x which comes with more new features.
Read full review 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.
Read full review Usability For developers, admins and end users looking for flexibility, IBM Planning Analytics would rate very highly on usability. For example, a developer has access to a highly performant built-in ETL (Extract Translate Load) tool and scripting language called Turbo Integrator that can (among other things) bring in data via flat file or direct connection from many data sources, move data around Planning Analytics, perform batch calculations, export to files or other data stores. In the rare situation where limitations are encountered there is a well documented REST API. Admins and end users benefit from the intuitive PAW (Workspace) interface as well as the rich Excel integration through Planning Analytics for Excel (PAfE). Since flexibility inherently comes with a little more complexity, so an organization with simple and "cookie-cutter" requirements may rate Planning Analytics a little lower.
Read full review 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.
Read full review Reliability and Availability The product has been reliable.
Read full review Performance 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.
Read full review Support Rating Although I find the IBM Planning analytics documentation quite time consuming, their support with email and call is something i can term as very considerate and patient, I have had few calls about the features and how i would want to implement them within my projects, and the teams have been super helpful to resolve my issues
Read full review While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
Read full review In-Person Training This training was more directed toward what the product was capable of rather than actual programming.
Read full review Online Training 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.
Read full review Implementation Rating 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.
Read full review Alternatives Considered Anaplan does not handle sparsity; this is very problematic for large volume data sets (many 0's). There also are limitations to the number of dimensions that can be used in a module. If more dimensions are required, then separate modules need to be built and intertwined. IBM PA does not have these limitations.
Read full review 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.
Read full review Return on Investment One of the advantage is on its ability to ease budget and planning Secondly,the fact that it allows for forecasting means based on such insights means that organisations are able to prepare for future eventualities Thirdly, since it can accommodate data from multiple sources means that one is able to carry out best business practices like planning. Read full review 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. Read full review ScreenShots IBM Planning Analytics Screenshots