Too much information is almost as bad as too little. If you cannot see the information you care about, because it is hidden among a data deluge, you cannot use it.
We want to strip away that unnecessary information, but we know one person’s unnecessary information is essential for someone else.
And just as importantly, the data must be organized in the right way for the person using it.
By Country
James needed to gather and organize a lot of chocolate sales information for the company’s own products and competitors.
The regional teams “owned” this data in spreadsheets for each country, so the data had to be organized by country.
By Brand
The key decision makers and marketing analysts all worked at a global level and focused on specific brands, so the data had to be organized by brand.
Have It Both Ways
How could James do both? He realized there was a way he could eliminate the tedious copying of data by getting everyone to work off one single dataset.
The trick would be ensuring both groups could work with the same data but have the data be simultaneously organized by brand and by country.
See how James managed this feat.