Data Visualization

10月 112016
 

This is a continuation of a series of blog posts on interactive HTML for Graph Builder reports in JMP 13. Here, I'm discussing support for Points, Box Plots, Heat Maps and Map Shapes. These Graph Builder elements are highlighted in the figure below.

toolbar-2

Since this blog post describes interactive web pages output from JMP, images and animations below were captured from a web browser.

Points

Points exist in many graphs in JMP where you can customize the point color, shape, and size, usually by opening a dialog box. Graph Builder’s drag-and-drop interface makes it easy to create colorful graphs with points of all shapes and sizes. The example below using Diamonds Data from the sample data library in JMP sets the following point attributes:

  • Size based on the Table column data
  • Color based on the Depth column data
  • Shape based on the Clarity column data

In addition to these attributes, Price versus Cut and grouping by Carat Weight was employed to understand what influences diamond prices the most. Of course, JMP provides capabilities that specifically target this question, but that’s a topic for another blog post.

DiamondsPoints

This combination of attributes made supporting Graph Builder point plots in Interactive HTML challenging because there are now more ways to determine the size, shape and color of each point. The challenge was increased additionally by the fact that each point in Graph Builder can represent a statistical summary of multiple rows of data.

In the following Interactive HTML example, each point represents diamonds of a given Cut and Clarity. Although the legend is rearranged, the shape and color are still determined by Clarity and Depth respectively. To  accentuate the difference between the diamonds' Table dimensions, a column transform named Relative Table was used in the Size role rather than the raw Table column data. DiamondsPointsMean

Box Plots

The summarized points above may provide too little information and the raw points may be too busy, so how about a compromise using box plots? In this graph, we see the distribution of prices for each Cut, Clarity, and Carat Weight combination. The legend was moved to the bottom and drawn horizontally to match the arrangement of box plots in each group.

DiamondsBoxPlots

Heat Maps

So far, it might be difficult to see what influences diamond prices the most. We’ve only covered three of the four C’s in diamond quality. So, here’s a heat map including all four. Maybe now it’s easier to make some conclusions.

DiamondsHeatMap

Adding support for heat maps in Graph Builder gave us a bonus outside of Graph Builder: The Uplift graph in the Uplift Platform is now interactive and can display X Factors and X/Y ranges.

Uplift

Map Shapes

Map shapes can be used in Graph Builder for location-based data, like population data. Grouping can help the viewer focus on one region at a time. With the ‘Show Missing Shapes’ option enabled, the region of interest can be seen in context of the whole country.

CanadaPopulationByReagion

Map Shapes can be scaled according to a size variable (Population) while being colored by another variable (Vegetable Consumption).

SizedMap

Combinations

To see that some of the interactive power of JMP is available in Interactive HTML, it helps to interact with combined graphs. In JMP this can be accomplished with Combined Windows, Application Builder, or Dashboard Builder. Below are some combination examples using the graph types described above.

This example explores Crime data with a Heat Map and geographical Map Shapes.

CrimeHeatMapsLinkedSelection

The following example uses Points, Box Plots, a Heat Map, and a custom Map Shape to explore office temperatures.

OfficeDashboard

One new feature for Points and Map Shapes in Interactive HTML is the ability to display images in tooltips.

ImagesInTips2

Note that these are just animations. You can interact with the Interactive HTML files shown in this blog here: http://www.jmp.com/jmphtml5/PointsAndMoreBlogExamples.html

tags: Data Visualization, Graph Builder, Interactive HTML, JMP 13

The post Interactive HTML: Points, box plots and more for Graph Builder appeared first on JMP Blog.

10月 032016
 

By now you may have heard that in JMP 13, the most frequently used features of reports created in Graph Builder can be saved as interactive HTML, which can then be viewed using just a web browser.

Getting Graph Builder output to work for the web in JMP 13 involved bringing new features to several graphical elements that had been available in interactive HTML output since JMP 11. Areas and lines can be used to display some of the same information as points but in a different way. Exploring these stacked areas in interactive HTML, you can now see the values along the edge of the area.

SmartphoneOSArea

The tooltips for lines display the rows that are included in each point along the line as well as information about the values. Graph Builder gives you the ability to customize various attributes of the lines. The example below combines lines using different drawing styles with annotations and the gray reference ranges to create a rich graph.

MarriageDivorceRatesLines

While the most heavily used graph types and options are exported as interactive HTML, the remaining ones are exported as static images. Contour plots are exported as static images; however, if your data is categorical, Graph Builder produces violin plots, which are exported as interactive HTML. Below you can see the close relationship between the violin plot and another Graph Builder element, the box plot.

IrisViolinPlot

What if you want to bin data into categories to explore their distribution? There are a number of ways to do this in Graph Builder. The histogram is available in Interactive HTML in the Distribution platform (as well as options in several other JMP platforms), but now can also be exported to the web after exploring your data in a drag-and-drop manner in Graph Builder in JMP. Below is an example created using Titanic passenger data to examine the distribution of ages.

TitanicHistogram

A mosaic plot is used to examine the relationship between two categorical variables. Cells give informative tooltips regarding the share and number of rows associated with each cell, and cells can be selected with rows being linked to other related charts in the report.

TitanicMosaic

In JMP, you can use Dashboard Builder to create reports with several types of Graph Builder output in the same page -- so people who do not have JMP yet can interactively explore your data. Here, a mosaic plot, bars and histograms are combined to analyze the importance of different goals to schoolchildren.

GraphBuilderDashboard

These are just a few examples of the powerful graphs you can create to explore your data in Graph Builder and share with others using interactive HTML. The graphs shown here as well as a few other examples are available as live interactive HTML files to explore on the web at http://www.jmp.com/jmphtml5/, but be sure to try your own Graph Builder creations!

tags: Dashboard, Dashboard Builder, Data Visualization, Distribution, Graph Builder, Interactive HTML, JMP 13

The post Interactive HTML: Lines, mosaic plots and more for Graph Builder appeared first on JMP Blog.

9月 282016
 

“Every morning in Africa, a gazelle wakes up. It knows it must run faster than the fastest lion, or it will be killed. Every morning a lion wakes up. It knows it must outrun the slowest gazelle, or it will starve to death. It doesn't matter whether you are a […]

Our world is flat, but our employees aren’t: How to manage and hire with analytics was published on SAS Voices.

9月 272016
 

In JMP 11, we built interactive HTML technology into JMP to enable customers to share results. You can publish JMP results to the Web, post them to a corporate intranet or shared drive, or share them with colleagues via e-mail.

In JMP 12, we added support for Bubble Plots, Profilers, and Mobile devices.  Unlike Flash applications, the interactive HTML reports in JMP can run on iPads and similar devices.

In JMP 13, we've added support for reports created with Graph Builder.  The most frequently used features are enabled, for Points, Smoothers, Ellipses, Lines, Bars, Areas, Box Plots, Histograms, Heatmaps, Mosaic Plots, Caption Boxes, and Map Shapes. These Graph Builder elements are highlighted in the figure below.

toolbar

In addition, we've received a number of feature requests from customers over the years. You know who you are ;-)  So beyond Graph Builder, we've added the following in JMP 13:

  1. Dashboard Support
  2. More Profilers
  3. Reference Ranges
  4. Value Labels
  5. Value Ordering
  6. Pinned Tooltips
  7. Hover Pictures

In this post, I'll give a high-level overview of some of these features.

Graph Builder Bar Charts

Bar charts are among the most frequently used graphs. Graph Builder provides a dozen different styles of bar charts, of which six are supported in interactive HTML.

The example below shows the same data drawn with stacked and side-by-side bars.  For this market share example, the bar sections all sum to 100%, so arguably the stacked style communicates more clearly.

Interactive HTML

Bullet charts provide a highly space-efficient presentation. These charts were developed specifically for use in dashboards. The example below shows a dashboard for a hospital interested in patients' and doctors' wait times and emergency room occupancy.

BulletBars

Range bars are useful for showing two values. In the stock market example below, hover tips display the high and low prices for each date.

Interactive HTML

Graph Builder supports many combinations of layouts for grouping. The example below shows diamond prices vs. carat weights, grouped by cut, in a wrapped layout.  The larger diamonds are more expensive, and the cut also matters. The ideal cut is considered to give the most brilliant sparkle to the diamond, so it generally fetches higher prices.

WrappedBars

Bar Charts Outside Graph Builder

Implementing bar charts for Graph Builder gave us a bonus: Bar charts are now also supported in all other JMP reports. In the Partial Least Squares analysis, for example, bar charts interactively display X and Y coordinates.

Interactive HTML

Improved Dashboard Support

Dashboards combine related information in custom layouts for efficient communication. Dashboards are popular on the web, so we've improved support for custom layouts in Interactive HTML. The dashboard below uses a particularly efficient layout with tab controls to show profits per employee for different types of companies.

Tabs

Besides improving layout, we can support many more kinds of dashboards in JMP 13, because we support many more kinds of graphs. This dashboard of regional air quality combines four separate Graph Builder reports. Along with Bar Charts, Heatmaps, Mosaic Plots and Map Shapes are all new graph types supported in JMP 13. My colleagues John Powell and Josh Markwordt will describe these new graphs in future blog posts.

Dashboard

Interactive Examples

In this blog post, I've shown static images and simple animations, but that is no substitute for interacting with the web pages themselves. All of our examples are available as Interactive HTML pages at http://www.jmp.com/jmphtml5/.

 JMP 13 HTML5 Examples

We built these examples with our colleague Michael Goff's excellent new web report generator, available in JMP 13 under the View menu "Create Web Report."

We hope our work helps you, and we look forward to your comments and suggestions!

tags: Data Visualization, Graph Builder, Interactive HTML, JMP 13

The post Interactive HTML: Graph Builder and more appeared first on JMP Blog.

9月 042016
 

You might say I love sports. I began swimming at a very early age and participated on swim teams for many years. Gymnastics, volleyball, softball, basketball and even track teams were all part of my life, and I loved playing and competing. So maybe that is why I always love […]

The post Looking at Summer Games data with JMP appeared first on JMP Blog.

8月 302016
 

Do you ever need to visualize more than three dimensions in your graphs? If so, you likely know about parallel plots, or parallel coordinate plots. They’ve been available in JMP for a long time. In the new version of JMP, parallel plots are even easier and more fun to use […]

The post JMP 13 Preview: New Parallel Plot option in Graph Builder for visualizing any number of variables appeared first on JMP Blog.

8月 172016
 

Graph Builder is one of the most-used parts of JMP. As a result, the drag-and-drop graph creation platform receives a large number of customer requests for features and changes. The next version of JMP includes many Graph Builder improvements that directly resulted from these requests. One big example are the […]

The post JMP 13 Preview: Customer-driven Graph Builder improvements appeared first on JMP Blog.

8月 052016
 

The Summer Games are over, and here's one thing that surprised me. I had assumed that since Rio is in the southern hemisphere, where it’s currently winter, the Games would be shifted a couple months, as they were for Sydney. I’ve since learned that Rio is very pleasant in the winter […]

The post When are the Summer Games, historically? appeared first on JMP Blog.

8月 032016
 

Montgomery County, Maryland, publishes all traffic violations since 2013, now totaling more than 780,000 incidents. Besides the location and details of the violations, the table also contains information about the vehicles involved, such as make, model, year and color. It’s car colors that I want to explore here. Even though […]

The post Exploring 30 years of car colors appeared first on JMP Blog.

7月 132016
 

Reporting can reveal last year’s graduation rates or this semester’s completion rates at a local community college. But drilling further into that data to ask why students aren’t graduating or why they aren’t enrolling requires more complex analysis. At Sinclair Community College in Dayton, Ohio, college administrators and professors are […]

Community college answers complex ‘why’ questions with data visualization and analytics was published on SAS Voices.