JMP vs. Microsoft Power BI

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
JMP
Score 9.6 out of 10
N/A
JMP® is statistical analysis software with capabilities that span from data access to advanced statistical techniques, with click of a button sharing. The software is interactive and visual, and statistically deep enough to allow users to see and explore data.
$1,320
per year per user
Microsoft Power BI
Score 8.5 out of 10
N/A
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
$168
per year per user
Pricing
JMPMicrosoft Power BI
Editions & Modules
JMP
$1320
per year per user
Power BI Pro
$14
per month (billed annually) per user
Power BI Premium
$24
per month (billed annually) per user
Offerings
Pricing Offerings
JMPMicrosoft Power BI
Free Trial
YesYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsBulk discounts available.Power BI Desktop is the data exploration and report authoring experience for Power BI, and is available as a free download.
More Pricing Information
Community Pulse
JMPMicrosoft Power BI
Considered Both Products
JMP
Chose JMP
It is great because it has UI menus but it costs money whereas the other programs are free. That makes it ideal for beginners but I think that RStudio and Python are going to make someone a lot more marketable for future opportunities since most companies won't pay for the …
Microsoft Power BI

No answer on this topic

Features
JMPMicrosoft Power BI
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
JMP
-
Ratings
Microsoft Power BI
8.3
197 Ratings
1% above category average
Pixel Perfect reports00 Ratings8.3168 Ratings
Customizable dashboards00 Ratings8.7196 Ratings
Report Formatting Templates00 Ratings8.0179 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
JMP
-
Ratings
Microsoft Power BI
8.0
195 Ratings
0% below category average
Drill-down analysis00 Ratings8.3192 Ratings
Formatting capabilities00 Ratings7.8192 Ratings
Integration with R or other statistical packages00 Ratings7.4143 Ratings
Report sharing and collaboration00 Ratings8.4190 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
JMP
-
Ratings
Microsoft Power BI
8.0
188 Ratings
3% below category average
Publish to Web00 Ratings8.3178 Ratings
Publish to PDF00 Ratings8.0173 Ratings
Report Versioning00 Ratings7.7145 Ratings
Report Delivery Scheduling00 Ratings8.3148 Ratings
Delivery to Remote Servers00 Ratings7.9111 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
JMP
-
Ratings
Microsoft Power BI
7.8
188 Ratings
2% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.3182 Ratings
Location Analytics / Geographic Visualization00 Ratings8.1167 Ratings
Predictive Analytics00 Ratings7.4137 Ratings
Pattern Recognition and Data Mining00 Ratings7.438 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
JMP
-
Ratings
Microsoft Power BI
8.5
179 Ratings
0% above category average
Multi-User Support (named login)00 Ratings8.7169 Ratings
Role-Based Security Model00 Ratings8.4147 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.4159 Ratings
Report-Level Access Control00 Ratings8.348 Ratings
Single Sign-On (SSO)00 Ratings8.6141 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
JMP
-
Ratings
Microsoft Power BI
8.0
161 Ratings
3% above category average
Responsive Design for Web Access00 Ratings7.8151 Ratings
Mobile Application00 Ratings7.6132 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.9154 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
JMP
-
Ratings
Microsoft Power BI
7.8
115 Ratings
1% above category average
REST API00 Ratings8.0103 Ratings
Javascript API00 Ratings7.684 Ratings
iFrames00 Ratings8.055 Ratings
Java API00 Ratings7.068 Ratings
Themeable User Interface (UI)00 Ratings7.690 Ratings
Customizable Platform (Open Source)00 Ratings8.444 Ratings
Best Alternatives
JMPMicrosoft Power BI
Small Businesses
IBM SPSS Statistics
IBM SPSS Statistics
Score 8.2 out of 10
Yellowfin
Yellowfin
Score 8.7 out of 10
Medium-sized Companies
Alteryx Platform
Alteryx Platform
Score 9.1 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Alteryx Platform
Alteryx Platform
Score 9.1 out of 10
Kyvos Semantic Layer
Kyvos Semantic Layer
Score 9.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
JMPMicrosoft Power BI
Likelihood to Recommend
9.6
(30 ratings)
8.5
(197 ratings)
Likelihood to Renew
10.0
(16 ratings)
9.5
(3 ratings)
Usability
8.6
(7 ratings)
8.3
(113 ratings)
Availability
10.0
(1 ratings)
-
(0 ratings)
Performance
10.0
(1 ratings)
-
(0 ratings)
Support Rating
9.2
(7 ratings)
10.0
(52 ratings)
Online Training
7.9
(3 ratings)
-
(0 ratings)
Implementation Rating
9.6
(2 ratings)
9.0
(1 ratings)
Product Scalability
10.0
(1 ratings)
-
(0 ratings)
User Testimonials
JMPMicrosoft Power BI
Likelihood to Recommend
JMP Statistical Discovery
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
Read full review
Microsoft
Has significantly improved collation of data and visualisation especially with business across Europe. Has given me the ability to see the Site availability at the click of a button to see which Site is in the "money" and seize opportunities based on Market data
Read full review
Pros
JMP Statistical Discovery
  • 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.
Read full review
Microsoft
  • Options for data source connections are immense. Not just which sources, but your options for *how* the data is brought in.
  • Constant updates (this is both good and bad at times).
  • User friendliness. I can get the data connections set up and draft some quick visuals, then release to the target audience and let them expand on it how they want to.
Read full review
Cons
JMP Statistical Discovery
  • 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.)
Read full review
Microsoft
  • It would be easier for users could Microsoft Power BI and Excel used the same programming languages.
  • Would like to see the online version of Microsoft Power BI be as powerful as the desktop version.
  • Publishing a Microsoft Power BI file online and then having to save the file is somewhat redundant.
  • Would like to export each page or chart as an image.
Read full review
Likelihood to Renew
JMP Statistical Discovery
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.
Read full review
Microsoft
Microsoft Power BI is an excellent and scalable tool. It has a learning curve, but once you get past that, the sky is the limit and you can build from the most simple to the most complex dashboards. I have built everything from simple reports with only a few data points to complex reports with many pages and advanced filtering.
Read full review
Usability
JMP Statistical Discovery
The GUI interface makes it easier to generate plots and find statistics without having to write code. The JSL scripting is a bit of a steep learning curve but does give you more ability to customize your analysis. Overall, I would recommend JMP as a good product for overall usability.
Read full review
Microsoft
Automating reporting has reduced manual data processing by 50-70%, freeing up analysts for higher-value tasks. A finance team that previously spent 20+ hours per week on Excel-based reports now does it in minutes with Microsoft Power BI's automated Real-time dashboards have shortened decision cycles by 30-40%, enabling leadership to react quickly to sales trends, operational bottlenecks, and customer behavior.
Read full review
Support Rating
JMP Statistical Discovery
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.
Read full review
Microsoft
It is a fantastic tool, you can do almost everything related with data and reports, it is a perfect substitutive of Power Point and Excel with a high evolution and flexibility, and also it is very friendly and easy to share. I think all companies should have Power BI (or other BI tool) in their software package and if they are in the MS Suite, for sure Power BI should be the one due to all the benefits of the MS ecosystem.
Read full review
Online Training
JMP Statistical Discovery
I have not used your online training. I use JMP manuals and SAS direct help.
Read full review
Microsoft
No answers on this topic
Implementation Rating
JMP Statistical Discovery
No answers on this topic
Microsoft
It was integrated with our erp easily and was accessible on cloud.
Read full review
Alternatives Considered
JMP Statistical Discovery
MS Excel with AnalysisToolPak provides a home-grown solution, but requires a high degree of upkeep and is difficult to hand off. Minitab is the closes competitor, but JMP is better suited to the production environment, roughly equivalent in price, and has superior support.
Read full review
Microsoft
Microsoft Power BI is free. If I didn't want to create a custom platform (i.e. my organization insisted on an existing platform that I *had* to use), I'd use Microsoft Power BI. For any start-up or SMB, I'd just use Claude & Grok to build it quickly, also for free. Would not pay for Tableau or Sigma anymore. Not worth it at all.
Read full review
Return on Investment
JMP Statistical Discovery
  • 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).
Read full review
Microsoft
  • Power BI usage reduced the effort of analytical reports creation by about 80%
  • Empowered all the level of employee to be more vigilant of the data and business insights, gained the profit of 8% overall.
  • AI-powered predictive analytics improved forecasting accuracy by 17%, that topped the overall sales.
Read full review
ScreenShots

JMP Screenshots

Screenshot of in JMP, how all graphical displays and the data table are linked.Screenshot of a few designed experiments, for more understanding and maximum impact. Users can understand cause and effect using statistically designed experiments — even with limited resources.Screenshot of an example of Predictive Modeling in JMP Pro's Prediction Profiler, used to build better models for more confident decision making.Screenshot of example outputs, built with tools designed for quality and reliability.

Microsoft Power BI Screenshots

Screenshot of Microsoft Power BI - Turns insights into impact for business usersScreenshot of Power BI integrates easily with Microsoft 365Screenshot of Microsoft Power BI - AI-Powered CapabilitiesScreenshot of Microsoft Power BI - Copilot can be used to create reportsScreenshot of Microsoft Power BI - Data HubScreenshot of Microsoft Power BI - Scales as organizational needs grow