IBM Planning Analytics, powered by IBM TM1®, is an integrated planning solution designed to promote collaboration across the organization and help keep pace with the speed of modern business. With its calculation engine, this enterprise performance management solution is designed to help users move beyond the limits of spreadsheets, automating the planning process to drive faster, more accurate results. Use it to unify data sources into one single repository, enabling users to build…
$825
per month 5 users
Microsoft BI (MSBI)
Score 8.7 out of 10
N/A
Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
$14
per month per user
Sisense for Cloud Data Teams
Score 4.1 out of 10
N/A
Sisense for Cloud Data Teams (formerly Periscope Data) is a data visualization tool that allows users to connect to their SQL databases to create sharable, interactive dashboards. In addition to SQL, its analytics integrate with R and Python, allowing users to prep datasets, perform analysis, and create their own visualizations. Sisense acquired Periscope Data in mid-2019.
Microsoft BI's strength is in dashboarding, whereas IBM Planning Analytics outshines it with its capabilities in budgeting, forecasting, consolidations, scenario modeling and performance.
Periscope's lightweight footprint and customizable SQL-based reports make it a better choice for us than Tableau or Microsoft BI. We deal with millions of rows of transactional data in a SQL Server data warehouse, so having seamless front-end integration makes reporting seamless.
Features
IBM Planning Analytics
Microsoft BI (MSBI)
Sisense for Cloud Data Teams
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
IBM Planning Analytics
7.5
107 Ratings
0% below category average
Microsoft BI (MSBI)
9.0
53 Ratings
9% above category average
Sisense for Cloud Data Teams
7.0
19 Ratings
14% below category average
Pixel Perfect reports
7.494 Ratings
8.646 Ratings
6.010 Ratings
Customizable dashboards
7.4107 Ratings
9.653 Ratings
7.019 Ratings
Report Formatting Templates
7.8101 Ratings
9.051 Ratings
8.017 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
IBM Planning Analytics
7.6
113 Ratings
3% below category average
Microsoft BI (MSBI)
8.6
53 Ratings
7% above category average
Sisense for Cloud Data Teams
4.8
19 Ratings
48% below category average
Drill-down analysis
7.9110 Ratings
8.648 Ratings
6.015 Ratings
Formatting capabilities
7.4111 Ratings
8.353 Ratings
7.018 Ratings
Integration with R or other statistical packages
7.485 Ratings
8.442 Ratings
3.010 Ratings
Report sharing and collaboration
7.8109 Ratings
9.053 Ratings
3.019 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
IBM Planning Analytics
8.0
107 Ratings
0% below category average
Microsoft BI (MSBI)
8.6
52 Ratings
5% above category average
Sisense for Cloud Data Teams
7.6
18 Ratings
7% below category average
Publish to Web
7.9101 Ratings
9.448 Ratings
5.012 Ratings
Publish to PDF
7.9100 Ratings
9.248 Ratings
10.012 Ratings
Report Versioning
8.398 Ratings
7.544 Ratings
8.012 Ratings
Report Delivery Scheduling
7.991 Ratings
8.647 Ratings
5.015 Ratings
Delivery to Remote Servers
00 Ratings
8.626 Ratings
10.06 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Very powerful modeling capabilities. It has a really good OLAP engine memory. Strong scenario planning for what if analysis. Flexibility of integration with ERPs or WM systems for both cloud and on premises. Centralized planning and alignment of governance is also a plus. Having one single system for many different functions.
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.
Sisense for Cloud Data Teams is suited so well for our project that works with lots of data and needs some ways to share data internally or externally with our clients. It's very easy to pull out the data from the sense in best and in a suitable format and moreover a huge number of options are available there to represent the data. All features of this Sisense for cloud data teams software can be taken advantage of if you have a team who are well versed in data analytics, data management, and programming.
Rapid deployment of polished T-SQL-based data visualization charts and dashboards. Periscope supports a variety of database technologies, and allows users to write custom queries to display data.
Included caching to reduce server load.
Outstanding customer service/support, with expert advice as needed.
Constant updates and new features.
Built-in SQL formatters take the pain out of manipulating date/time objects.
Include more appropriate updates in their monthly newsletter as opposed to the general overview that doesn't always have the most pertinent information at the forefront.
There are bugs at times when certain dashboards are down, though not in an overwhelming way.
If you do not tag something it shows up in multiple views and may be accessible to people that it should not be, though that is a user error it may make sense to prompt for a tag and security setting.
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.
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.
IBM Planning Analytics is generally good in terms of functionalities. It can be used reduce time for budget planning, resource planning, demand forecasting, etc. The performance of IBM Planning Analytics is acceptable, but user interface can be improved. It would be good to see new features that allow users to customise the dashboard.
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.
If you know SQL or are somewhat data-savvy, you'll feel right at home with Sisense for Cloud Data Teams. However, like most other BI tools, it is a little challenging to use for users that are non-technical. The graphs and charts are very visually appealing, and there's lots of customization and export options.
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.
IBM support has been very quick to respond and handle the very few issues we've had. We've had a third-party who partners with IBM to be our consulting team which has helped greatly reduce the need for us to contact IBM directly. I highly recommend researching and selecting a well-respected partner to help with an implementation as well as ongoing support as needed.
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.
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.
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.
As it is related to MS Excel, IBM Planning Analytics is a much more robust and complete solution for the CFO or COO in mind. Oracle Hyperion stacks up nicely against IBM Planning Analytics. However, IBM's investment in AI allows Planning Analytics users more options and speed.
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.
Google Analytics works well but it does not have all of the bells and whistles that Periscope Data offers. Google Analytics is best used in a Google environment but if you are using other tools and programs outside of the Google universe, then Periscope Data is a much better option.
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.