IBM SPSS Statistics vs. Power BI For Office 365 (discontinued)

SPSS is well-suited for the following: 1) User Behavior Analysis: SPSS handles large datasets to analyze user behavior data. 2) Customer Satisfaction / Foundational Surveys: SPSS facilitates analysis of quant data from satisfaction surveys, keeping us informed about customer needs and preferences. 3) A/B test analysis: SPSS statistical tools for A/B test analysis, which helps optimize user experience of our products. Scenarios where SPSS are less appropriate: 1) Qualitative Data Analysis: I do not use SPSS for open-ended survey responses/qual data. 2) Live/in-vivo data analysis: SPSS is not ideal for real-time data processing. 3) Complex Data Integration: SPSS isn’t the best fit for complex data integration tasks

Incentivized

If you want to create a visual dashboard or report that utilises various data sources then PowerBI can do this. It is great in that it takes your on-premises data and stores it on Microsoft servers where it can interact with it faster, reducing load on your own servers, while being efficient in what it transfers out. We have found it not well suited if you wanted to publish a simple report to many staff as they may all need a Pro license which can get expensive. Even if embedding the report onto a shared platform like SharePoint, it will not display if the users doesn't have a PowerBI Pro license.

Incentivized

• SPSS has been around for quite a while and has amassed a large suite of functionality. One of its longest-running features is the ability to automate SPSS via scripting, AKA "syntax." There is a very large community of practice on the internet who can help newbies to quickly scale up their automation abilities with SPSS. And SPSS allows users to save syntax scripting directly from GUI wizards and configuration windows, which can be a real life-saver if one is not an experienced coder.
• Many statistics package users are doing scientific research with an eye to publish reproducible results. SPSS allows you to save datasets and syntax scripting in a common format, facilitating attempts by peer reviewers and other researchers to quickly and easily attempt to reproduce your results. It's very portable!
• SPSS has both legacy and modern visualization suites baked into the base software, giving users an easily mountable learning curve when it comes to outputting charts and graphs. It's very easy to start with a canned look and feel of an exported chart, and then you can tweak a saved copy to change just about everything, from colors, legends, and axis scaling, to orientation, labels, and grid lines. And when you've got a chart or graph set up the way you like, you can export it as an image file, or create a template syntax to apply to new visualizations going forward.
• SPSS makes it easy for even beginner-level users to create statistical coding fields to support multidimensional analysis, ensuring that you never need to destructively modify your dataset.
• In closing, SPSS's long and successful tenure ensures that just about any question a new user may have about it can be answered with a modicum of Google-fu. There are even several fully-fledged tutorial websites out there for newbie perusal.

Incentivized

• Ease of use. Most people have experience working with Excel. If you know how to create pivots, you can use Power BI.
• Data extraction and transformation (ETL). ETL is a joy with Power Query. It is intuitive, simple and a magical experience to transform poor data into something useful.
• Visuals. Power BI is beautiful to behold, especially Power View.
• Maps. The interactive maps are great built-in tools.
• Cost You cannot find anything cheaper than Power BI, unless you want to give it to every user in your company.

Incentivized

• Lots of finicky work to do simple tasks
• Usability is atrocious [in my opinion]. No ability to customize.
• Would love to see product enhanced with interpretation features or citation tools (e.g., report results APA style)
• Bulk editing variables would be an improvement
• UI looks like its straight out of AOL days

Incentivized

• Like many Microsoft products, you can get by with a small understanding of the product, but to truly realize the entire potential does take a while to learn.
• Hooking up SQL databases to the cloud version is a more complex than just querying right into the database from the desktop version.

Incentivized

It's super easy to use for newbies and super powerful for power users! It does EVERYTHING you are usually asked to do analytically. Their Help Desk is PHENOMENAL. And I find the upgrade and renewal price to be a good deal.

Incentivized

If I were a small business owner, I would likely use Power BI for Office 365 for the sheer fact that I would get the Office licensing I need, along with powerful capabilities. As a Microsoft Partner, we continue to see Microsoft invest heavily in the Power BI capabilities, and will continue to implement and support BI solutions around this product, as we believe this is in the best interest of our clients.

SPSS is beginner friendly and user-friendly for beginner analysts and simple statistical tests. It's "click and go" interface does take some learning, but overall this is much easier than other programs I have used and seen. Compared to SAS software, SPSS takes a great deal less familiarizing and it not a matter of learning a coding language like SAS and RStudio.

Incentivized

We are satisfied with the functionality and capabilities of Power BI. Product is cost effective and full-fill the reporting requirements of the organization. You can perform most of the report level complex analysis with the help of DAX which makes Power BI very powerful analytic tool. Power BI for Office 365 has gone away and Power BI is the next evolution of it. Power BI comes with your Office 365 E5 subscription or you can purchase licensing for it separately.

Incentivized

SPSS can tend to crash when I am trying to do a lot of data. This can slow me down when I need to do a lot of data

Incentivized

SPSS does the job, but it can be slow. I do have to plan a lot of time to get through a huge amount of data.

Incentivized

I have not contacted IBM SPSS for support myself. However, our IT staff has for trying to get SPSS Text Analytics Module to work. The issue was never resolved, but I'm not sure if it was on the IT's end or on SPSS's end

as of now there is strong community for Power BI, you can get solution for most of your problems from there. Also you can send your error to Microsoft as well. After every 15 days they release updates to overcome all the issues of defects.

Incentivized

Have a plan for managing the yearly upgrade cycle. Most users work in the desktop version, so there needs to be a mechanism for either pushing out new versions of the software or a key manager to deal with updated licensing keys. If you have a lot of users this needs to be planned for in advance.

Incentivized

If you have made it this far, you should have a very good idea of how SPSS stacks up the competition (data processing and analytics tools). Even the free ones, such as r Studio or Stata, are leaps and bounds ahead of SPSS. IBM is resting on a reputation developed nearly 30 years ago and has shown no desire to improve.

Incentivized

One main competitor of Power BI is Tableau. Tableau has been around longer than Power BI so it can feel a little more refined in areas, however Power BI is catching up quickly. Tableau can be more expensive than Power BI. If you want more features and more refinement, and don't mind extra cost, then Tableau may be a better choice. But if you want something that's integrated with many things in O365, and are satisfied with fewer bells and whistles, Power BI may be the better option.

Incentivized

I am neutral because I have not had to look into scalability since I am using as a student.

Incentivized

• I found SPSS easier to use than SAS as it's more intuitive to me.
• The learning curve to use SPSS is less compared to SAS.
• I used SAS, to a much lesser extent than SPSS. However, it seems that SAS may be more suitable for users who understand programming. With SPSS, users can perform many statistical tests without the need to know programming.

Incentivized

• As a Microsoft Partner implementing Business Intelligence solutions, Power BI has removed the barrier for our clients to begin the "BI journey". So often, projects get hung up in that early phase of procuring and installing/configuring expensive hardware and software. Just simply getting started and designing a beginning solution has allowed our clients to see results in 1-2 weeks using their data that might have taken months to achieve otherwise.
• One significant ROI example is process improvement. In many cases, individuals or teams are spending days each month gathering data from multiple sources for reporting to their constituents. We are reducing these times to minutes by automating many of the data collection and integration processes that were previously manual.