Transforming your syndicated data into business insight
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 […]
Nielsen and IRI applications make it easy to create spreadsheet based reports that can be refreshed every month. But in their older systems like Nielsen Nitro and IRI XLerate, there is minimal formatting. Their newer web-based systems like Nielsen Answers and IRI Liquid Data apply more formatting but that formatting doesn’t necessarily look […]
