Chuck Pirrello is Product Manager for JMP, a business unit of SAS. He helps direct the development and marketing of JMP’s interactive data visualization and exploration capabilities. Before joining the JMP division, Pirrello was responsible for marketing Business Scorecard and Dashboard solutions for SAS. Earlier, he worked for Hyperion and Comshare, vendors of financial and business intelligence software. He has more than 20 years of experience in finance, consulting and product management.
I am of Italian descent from the greater New York City area, so it should be no surprise that I love pizza. My interest was piqued when my niece Samantha recently posted a ranking of the “101 Best Pizzas in America," according to the Daily Meal® website, which conducted the
Last week, I showed how the Excel Add-In for JMP can bring more value to Excel spreadsheets for what-if analysis and optimization. Today, we’ll look at how using that same data from within JMP alone is more elegant. First, let’s look at the Excel spreadsheet from last week's post (see
Over the past few weeks, we’ve looked at the rise of Excel’s usage and popularity, and I've noted that Excel has made forays into analytics. Today, we’ll look at one type of analysis: scenario-based planning and optimization. Using Excel add-ins, you can create what-if analysis and scenario-based planning using Monte
Last week, we looked at the first scenario in our example showing some guesswork that Excel performs when adding to existing data that are included in a formula. This week, we’ll look at Scenarios 1b and 2, which further show the behavior of Excel after rows are inserted within a
Last week, I shared some of the many stories about errors in Excel spreadsheets that led to misinformation and to a path toward incorrect decisions. Today, we’ll explore why such errors can be potentially pervasive. The power of the spreadsheet has always been its interactive ease of use. It allows
In 2010, esteemed Harvard professors Carmen Reinhart and Kenneth Rogoff published the paper “Growth in a Time of Debt.” It soon became powerful supporting evidence for those who argued against growing government spending, even in times of needed economic stimulation. The paper looked at the debt levels of many different
As I looked over Monday morning’s news headlines, this story caught my eye: Wow, I thought, the Windows phone system is really catching on. But then I looked at the numbers displayed in news article: It’s true that the Windows numbers have significantly increased, from minuscule to small. But does
For those of you who haven’t tired of election results (can the three of you please gather around this blog post?), I came upon voting data by state from the inception of the Republican Party (1850s) to today. I thought I’d first take a look and see how each state has
The Guardian, a London newspaper, recently published a blog post, "What's the Real Price of the Olympic Games?" that showed the sources of funding and use of those funds for the 2012 Games. The blog post included an interactive graph, shown below: A viewer could click on one of the
Recently, I came across a question posted to the JMP discussion forum. The person who posted the question had the following sample file: He wanted a count of each unique field in Column 1 shown on every row. So the result would look like this: The first reply he got