66 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100
205 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100

Likelihood to Recommend

JMP Statistical Discovery Software from SAS

It is perfectly suited for statistical analyses, but I would not recommend JMP for users who do not have a statistical background. As previously stated, the learning curve is exceptionally steep, and I think that it would prove to be too steep for those without statistical background/knowledge
No photo available

Power BI For Office 365

If you're already using Office 365, Power BI for O365 is an easy choice. Start playing around with the free version and then easily add individual Pro licenses with little risk. However, if you anticipate using this with many users, it can get expensive quickly.
Jeremiah Miller profile photo

Feature Rating Comparison

BI Standard Reporting

JMP Statistical Discovery Software from SAS
9.4
Power BI For Office 365
8.7
Pixel Perfect reports
JMP Statistical Discovery Software from SAS
10.0
Power BI For Office 365
8.3
Customizable dashboards
JMP Statistical Discovery Software from SAS
8.7
Power BI For Office 365
9.0
Report Formatting Templates
JMP Statistical Discovery Software from SAS
Power BI For Office 365
8.9

Ad-hoc Reporting

JMP Statistical Discovery Software from SAS
8.8
Power BI For Office 365
8.7
Drill-down analysis
JMP Statistical Discovery Software from SAS
8.9
Power BI For Office 365
8.0
Formatting capabilities
JMP Statistical Discovery Software from SAS
9.0
Power BI For Office 365
8.0
Integration with R or other statistical packages
JMP Statistical Discovery Software from SAS
8.0
Power BI For Office 365
10.0
Report sharing and collaboration
JMP Statistical Discovery Software from SAS
9.1
Power BI For Office 365
8.9

Report Output and Scheduling

JMP Statistical Discovery Software from SAS
8.6
Power BI For Office 365
8.5
Publish to Web
JMP Statistical Discovery Software from SAS
7.9
Power BI For Office 365
8.9
Publish to PDF
JMP Statistical Discovery Software from SAS
9.6
Power BI For Office 365
8.9
Report Versioning
JMP Statistical Discovery Software from SAS
7.0
Power BI For Office 365
9.0
Report Delivery Scheduling
JMP Statistical Discovery Software from SAS
10.0
Power BI For Office 365
8.0
Delivery to Remote Servers
JMP Statistical Discovery Software from SAS
Power BI For Office 365
7.5

Data Discovery and Visualization

JMP Statistical Discovery Software from SAS
8.9
Power BI For Office 365
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
JMP Statistical Discovery Software from SAS
8.9
Power BI For Office 365
9.1
Location Analytics / Geographic Visualization
JMP Statistical Discovery Software from SAS
9.0
Power BI For Office 365
9.0
Predictive Analytics
JMP Statistical Discovery Software from SAS
8.7
Power BI For Office 365
8.4

Access Control and Security

JMP Statistical Discovery Software from SAS
Power BI For Office 365
9.2
Multi-User Support (named login)
JMP Statistical Discovery Software from SAS
Power BI For Office 365
9.5
Role-Based Security Model
JMP Statistical Discovery Software from SAS
Power BI For Office 365
9.6
Multiple Access Permission Levels (Create, Read, Delete)
JMP Statistical Discovery Software from SAS
Power BI For Office 365
8.3
Single Sign-On (SSO)
JMP Statistical Discovery Software from SAS
Power BI For Office 365
9.6

Mobile Capabilities

JMP Statistical Discovery Software from SAS
Power BI For Office 365
8.0
Responsive Design for Web Access
JMP Statistical Discovery Software from SAS
Power BI For Office 365
8.4
Dedicated iOS Application
JMP Statistical Discovery Software from SAS
Power BI For Office 365
8.0
Dedicated Android Application
JMP Statistical Discovery Software from SAS
Power BI For Office 365
8.0
Dashboard / Report / Visualization Interactivity on Mobile
JMP Statistical Discovery Software from SAS
Power BI For Office 365
7.5

Application Program Interfaces (APIs) / Embedding

JMP Statistical Discovery Software from SAS
Power BI For Office 365
8.3
REST API
JMP Statistical Discovery Software from SAS
Power BI For Office 365
6.0
Javascript API
JMP Statistical Discovery Software from SAS
Power BI For Office 365
9.0
Themeable User Interface (UI)
JMP Statistical Discovery Software from SAS
Power BI For Office 365
9.0
Customizable Platform (Open Source)
JMP Statistical Discovery Software from SAS
Power BI For Office 365
9.0

Pros

JMP Statistical Discovery Software from SAS

  • JMP is designed from the ground-up to be a tool for analysts who do not have PhDs in Statistics without in anyway "dumbing down" the level of statistical analysis applied. In fact, JMP operationalizes the most advanced statistical methods. JMP's design is centred on the JMP data table and dialog boxes. It is data focused not jargon-focussed. So, unlike other software where you must choose the correct statistical method (eg. contingency, ANOVA, linear regression, etc.), with JMP you simply assign the columns in a dialog into roles in the analysis and it chooses the correct statistical method. It's a small thing but it reflects the thinking of the developers: analysts know their data and should only have to think about their data. Analyses should flow from there.
  • JMP makes most things interactive and visual. This makes analyses dynamic and engaging and obviates the complete dependence on understanding p-values and other statistical concepts(though they are all there) that are often found to be foreign or intimidating.
  • One of the best examples of this is JMP's profiler. Rather than looking at static figures in a spreadsheet, or a series of formulas, JMP profiles the formulas interactively. You can monitor the effect of changing factors (Xs) and see how they interact with other factors and the responses. You can also specify desirability (maximize, maximize, match-target) and their relative importances to find factor settings that are optimal. I have spent many lengthy meetings working with the profiler to review design and process options with never a dull moment.
  • The design of experiments (DOE) platform is simply outstanding and, in fact, the principal developers of it have won several awards. Over the last 15 years, using methods broadly known as an "exchange algorithm," JMP can create designs that are far more flexible than conventional designs. This means, for example, that you can create a design with just the interactions that are of interest; you can selectively choose those interactions that are not of interest and drop collecting their associated combinations.
  • Classical designs are rigid. For example, a Box-Benhken or other response surface design can have only continuous factors. What if you want to investigate these continuous factors along with other categorical factors such as different categorical variables such as materials or different furnace designs and look at the interaction among all factors? This common scenario cannot be handled with conventional designs but are easily accommodated with JMP's Custom DOE platform.
  • The whole point of DOE is to be able to look at multiple effects comprehensively but determine each one's influence in near or complete isolation. The custom design platform, because it produces uniques designs, provides the means to evaluate just how isolated the effects are. This can be done before collecting data because this important property of the DOE is a function of the design, not the data. By evaluating these graphical reports of the quality of the design, the analyst can make adjustments, adding or reducing runs, to optimize cost, effort and expected learnings.
  • Over the last number of releases of JMP, which appear about every 18 months now, they have skipped the dialog boxes to direct, drag-and-drop analyses for building graphs and tables as well as Statistical Process Control Charts. Interactivity such as this allows analysts to "be in the moment." As with all aspects of JMP, they are thinking of their subject matter without the cumbersomeness associated with having to think about statistical methods. It's rather like a CEO thinking about growing the business without having to think about every nuance and intricacy of accounting. The statistical thinking is burned into the design of JMP.
  • Without data analysis is not possible. Getting data into a situation where it can be analyzed can be a major hassle. JMP can pull data from a variety of sources including Excel spreadsheets, CSV, direct data feeds and databases via ODBC. Once the data is in JMP it has all the expected data manipulation capabilities to form it for analysis.
  • Back in 2000 JMP added a scripting language (JMP Scripting Language or JSL for short) to JMP. With JSL you can automate routine analyses without any coding, you can add specific analyses that JMP does not do out of the box and you can create entire analytical systems and workflows. We have done all three. For example, one consumer products company we are working with now has a need for a variant of a popular non-parametric analysis that they have employed for years. This method will be found in one of the menus and appear as if it were part of JMP to begin with. As for large systems, we have written some that are tens of thousands of lines that take the form of virtual labs and process control systems among others.
  • JSL applications can be bundled and distributed as JMP Add-ins which make it really easy for users to add to their JMP installation. All they need to do is double-click on the add-in file and it's installed. Pharmaceutical companies and others who are regulated or simply want to control the JMP environment can lock-down JMP's installation and prevent users from adding or changing functionality. Here, add-ins can be distributed from a central location that is authorized and protected to users world-wide.
  • JMP's technical support is second to none. They take questions by phone and email. I usually send email knowing that I'll get an informed response within 24 hours and if they cannot resolve a problem they proactively keep you informed about what is being done to resolve the issue or answer your question.
Wayne Levin profile photo

Power BI For Office 365

  • Easy to make visual dashboards from SQL queries. Previously we had to use a third party application that had to run on a web server that was so complex to setup and run. PowerBI removes all that.
  • Ability to control who/which group has access to each dashboard or report. Ties in well with the rest of the Office 365 ecosystem.
  • Has many connectors to allow pulling data from various systems, both onsite (via gateway) or external (via APIs), and join the data to create a report/dashboard.
  • Ability to show data but also export the data, if permitted.
  • Easy to show PowerBI dashboards on SharePoint or on other websites via embedded code.
No photo available

Cons

JMP Statistical Discovery Software from SAS

  • In general JMP is much better fit for a general "data mining" type application. If you want a specific statistics based toolbox, (meaning you just want to run some predetermined test, like testing for a different proportion) then JMP works, but is not the best. JMP is much more suited to taking a data set and starting from "square 1" and exploring it through a range of analytics.
  • The CPK (process capability) module output is shockingly poor in JMP. This sticks out because, while as a rule everything in JMP is very visual and presentable, the CPK graph is a single-line-on-grey-background drawing. It is not intuitive, and really doesn't tell the story. (This is in contrast with a capability graph in Minitab, which is intuitive and tells a story right off.) This is also the case with the "guage study" output, used for mulivary analysis in a Six Sigma project. It is not intuitive and you need to do a lot of tweaking to make the graph tell you the story right off. I have given this feedback to JMP, and it is possible that it will be addressed in future versions.
  • I've never heard of JMP allowing floating licenses in a company. This will ALWAYS be a huge sticking point for small to middle size companies, that don't have teams people dedicated to analytics all day. If every person that would do problem solving needs his/her own seat, the cost can be prohibitive. (It gets cheaper by the seat as you add licenses, but for a small company that might get no more than 5 users, it is still a hard sell.)
Eric Burton profile photo

Power BI For Office 365

  • Licensing: Currently, Microsoft has a fixed pricing model for Office 365 users, regardless of role/function of the user. Most organizations have a small number of "power users" that create usable content and many more "consumers" that simply view/run reports created by power users. Microsoft does not differentiate between these users, and thus the pricing limits organizations from large deployments of the software.
  • Version incompatibility: Excel 2010 and 2013 workbooks are compatible with each other. However, workbooks created in 2010 that include PowerPivot databases must be upgraded to 2013 format to run in 2013. Subsequently, you cannot open these upgraded PowerPivot workbooks in 2010. This requires ALL users to be on the same version.
  • Visualization: Excel charting with PowerPivot workbooks is adequate for many users. Power View also contains a number of GREAT visualizations, including animated bubble charts and a very flexible dashboard/report design canvas. However, compared to some of the other self-service BI solutions, it is still limited in its visualization capabilities.
Ken Raetz profile photo

Likelihood to Renew

JMP Statistical Discovery Software from SAS

JMP Statistical Discovery Software from SAS 10.0
Based on 16 answers
JMP has been good at releasing updates and adding new features and their support is good. Analytics is quick and you don't need scripting/programming experience. It has been used organization wide, and works well in that respect. Open source means that there are concerns regarding timely support. Cheap licensing and easy to maintain.
No photo available

Power BI For Office 365

Power BI For Office 365 9.2
Based on 4 answers
I will continue to recommend this suite to folks looking for a reporting and analytics solution, as I find in MOST cases, it's great at meeting almost every requirement I've been given by a multitude of clients across a range of industries. I've built Capacity Planning solutions that allowed end user input which was then submitted to SharePoint, Executive Dashboards, custom applications, simple analytical tools for teams to easily slice and dice data, and super simple reports as well as some very complicated ones. If you haven't seen the demos online, do a search, and see for yourself - this is a great BI suite! (I do not work for Microsoft, although I do consult out there from time to time. I do occasionally make a recommendation for a different BI reporting tool, but in general, find Excel can accomplish quite a bit for less money and in less time.)
No photo available

Usability

JMP Statistical Discovery Software from SAS

JMP Statistical Discovery Software from SAS 10.0
Based on 5 answers
The overall usability of JMP is extremely good. What I really love about it is its ability to be useable for novices who have no coding experience, which is not the case with most other, similar, programs. It can output a fast and easy analysis without too much prior coding or statistical knowledge.
Shelby Bowden profile photo

Power BI For Office 365

No score
No answers yet
No answers on this topic

Support

JMP Statistical Discovery Software from SAS

JMP Statistical Discovery Software from SAS 9.3
Based on 8 answers
Support is great and give ease of contact, rapid response, and willingness to 'stick to the task' until resolution or acknowledgement that the problem would have to be resolved in a future build. Basically, one gets the very real sense that another human being is sensitive to your problems - great or small.
No photo available

Power BI For Office 365

No score
No answers yet
No answers on this topic

Online Training

JMP Statistical Discovery Software from SAS

JMP Statistical Discovery Software from SAS 7.9
Based on 3 answers
I have not used your online training. I use JMP manuals and SAS direct help.
Mark Davis profile photo

Power BI For Office 365

No score
No answers yet
No answers on this topic

Alternatives Considered

JMP Statistical Discovery Software from SAS

We selected this as a corporation perhaps it was relatively easily available and thus knowing that if you know a bit of any coding language you can somewhat get by with JMP, makes this an easily scalable software in terms of learning for people. I am not too sure about other alternatives.
No photo available

Power BI For Office 365

Oracle was nice, super expensive to implement if it's not in use already. JobDiva is choppy and heavy on the system while does not give great reports. Salesforce is good; remote access is good however their support is terrible
Daniel J. Lewis profile photo

Return on Investment

JMP Statistical Discovery Software from SAS

  • ROI: Even if the cost can be high, the insights you get out of the tool would definitely be much more valuable than the actual cost of the software. In my case, most of the results of your analysis were shown to the client, who was blown away, making the money spent well worth for us.
  • Potential negative: If you are not sure your team will use it, there's a chance you will just waste money. Sometimes the IT department (usually) tries to deploy a better tool for the entire organization but they keep using the old tool they are used too (most likely MS Excel).
Gabriel Chiararia profile photo

Power BI For Office 365

  • 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.
Ken Raetz profile photo

Screenshots

Power BI For Office 365

Pricing Details

JMP Statistical Discovery Software from SAS

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Power BI For Office 365

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

JMP Statistical Discovery Software from SAS
9.0
Power BI For Office 365
8.7

Likelihood to Renew

JMP Statistical Discovery Software from SAS
10.0
Power BI For Office 365
9.2

Usability

JMP Statistical Discovery Software from SAS
10.0
Power BI For Office 365

Reliability and Availability

JMP Statistical Discovery Software from SAS
10.0
Power BI For Office 365

Performance

JMP Statistical Discovery Software from SAS
10.0
Power BI For Office 365

Support

JMP Statistical Discovery Software from SAS
9.3
Power BI For Office 365

Online Training

JMP Statistical Discovery Software from SAS
7.9
Power BI For Office 365

Implementation

JMP Statistical Discovery Software from SAS
9.6
Power BI For Office 365

Scalability

JMP Statistical Discovery Software from SAS
10.0
Power BI For Office 365

Add comparison