Transforming your syndicated data into business insight
The bar chart is probably the most commonly used type of graph and this post talks about what kind of data this works well for. In this post I’ll talk about using bar charts to compare various products and geographies but for one fact and one time period. This is part of a series of […]
Here’s something fun that I came across this week, as movies were in the news due to the announcement of Oscar nominations: Click here to see Famous Movie Quotes as Charts, from the website Flowingdata.com (January 16, 2014). Note the wide variety of graph types used! This shows that you don’t have to have numerical data […]
As mentioned in a previous post, how you present your analysis is at least as important as the numbers themselves. Using the right graphs is an essential element that helps you tell a story with your data, rather than just report a bunch of numbers. In this older post I talked about market share and […]
How you present your analysis is at least as important as the numbers themselves. One of the most basic measures to gauge how well your business is doing is share, what portion of category sales your brand accounts for. Of course, higher is better and the sum of shares for all brands in […]
For a quick refresher on which time periods you can get on your database, see this previous post: Timing is Everything, Part I. Given all the possible time periods that you may have access to, it is important to first determine what business question you are trying to answer. There are 2 ways to think […]
Did you check out my post about automating reports in Excel? I showed the right way to set up reports (so you won’t have to reformat when you get new data). Now I want to share more about two handy Excel functions: RIGHT and PROPER. I used these for the retailer name, date and […]
