Entries by Diane Rich

Growth in US Music Industry Revenue

Music industry revenues in the U.S. were up $1B in 2018 according to the  2018 Year-End Music Industry Revenue Report released last week by the Recording Industry Association of America (RIAA). Streaming continued to be the dominant channel, reaching 50M subscribers and representing 75% of industry revenues. All other channels have been declining, especially digital […]

Net Promoter Score

The Net Promoter Score (NPS) was developed by Fred Reichheld from Bain as a simple measure of customer loyalty. It measures the likelihood, on a 1-10 scale, that a customer would recommend you to a friend. Survey responses are grouped into 3 categories: Promoters (score of 9-10), Passives (score of 7-8) and Detractors (score of […]

Wine Customer Segmentation

I was intrigued by a recent Forbes article that described the U.S. wine market as the “most populous wine market on the planet.” The article was based on data from the Wine Intelligence 2018 portrait of the U.S. wine market. The report reveals that there are 84M regular wine drinkers in the U.S. and it […]

Spend Less Time Preparing Your Data

Do you spend a lot of time cleaning up your data before you create a chart? You can save time by utilizing the chart data sheet more effectively. Horizontal Stacked Bar Chart Example This chart from our Chart of the Week series shows the largest over-budget construction projects. It's a good example of how to use […]

How to Create a Marimekko Chart in Excel

If you’re new to the marimekko chart type, you’re in for a real treat. The marimekko is a visualization gem that allows you to break down a measure, like revenue or cost, into its components to understand each component's relative size. The marimekko combines data typically found in multiple charts (pie or bar) into a […]

10 Excel Tips You Should Know

The HBR article, 10 Excel Functions Everyone Should Know, inspired this list of 10 of the most useful features for creating Mekko Graphics charts in Excel. 1. Format All Labels The default chart size in Excel is smaller than in PowerPoint, so you may have less space for labels. You can make the chart larger, […]

Funding for Higher Education Around the World

The OECD recently released a state of education report, which was referenced in the Forbes article, The Crazy Amount Americans Spend on Higher Education, In One Chart. The article showed a spending comparison per student by country and concluded that tuition is so high in the U.S. due to high per student spending. Another dataset from […]

Comparing Wealth and Cost of Living by State

If I asked you “Which state has the highest % of millionaires?” the first state that comes to mind is likely California. So, you may be surprised to see that Maryland has the highest percentage of millionaires (7.87% of population), followed closely by New Jersey.  The data is from an Inc article and millionaire is […]

Growth in U.S. Wine Consumption

I found some interesting data about the U.S. wine market in a recent report published by the consulting firm, LEK. The report showed that consumption is expected to increase at a 6% CAGR over the next 5 years, bringing the market for wine to $43B in 2022. When you look at the forecasted consumption by […]