Transforming your syndicated data into business insight
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 […]
Every company and every analyst wants to looks at their retail data a little differently. And Nielsen and IRI are both happy to deliver customized views of their information (for a price). This is the option chosen by most large CPG companies: a custom database. But to provide a cost effective option, Nielsen and IRI […]
Does it seem nerdy to worry about data structure when your goal is business insight? It’s not (I promise). Understanding the nitty gritty of your IRI or Nielsen data will ensure you buy the right information and interpret it correctly. The 4 Dimensions are the grammar of the scanner data language. They impact the price […]
Basis Points (bps) is a term sometimes used to represent percentage point changes. It’s usually seen in finance rather than marketing contexts. It historically referred to changes in interest rates but you’ll sometimes see analyst reports using it when referring to share point changes or, really, any metric that involves a percent change. 1 basis […]
Buying Rate is a panel data measure. It is the average amount of product purchased by one buying household over a whole time period (usually a year). It can be expressed in dollars, units or EQ volume. In Nielsen the fact is called Item Sales per Item Buyer. In IRI the fact is Sales per […]
