The Petcare division of Mars had three years of dog and cat data based on age, breed, condition and zip codes. With over 2 million data points plotting this on a normal map simply would not work.
The design lead, Clarke, had created a beautiful concept to plot the data; however, on closer review it was clear the data wouldn't actually display in the chosen manner, and the shear scope of data would make it too slow to use.
Sourcetop's solution entailed creating a separate database crunching the numbers to each map zoom level and corresponding values. For instance, on initial view users choose either cats or dogs by state in the current year requiring only 51 data points on initial load. As the user zoomed to specific regions, narrowed by condition (e.g. obesity) and age (e.g. puppy) the data tables got more complex but still pulled from a pre-parsed table easily plotted within the constraints of a normal browser viewport.
To display the data, we built a highly customized Google Map with a toned-down theme with custom cluster logic and icons and changed transparency values based on zoom level allowing overlapping data to show rather than obscure at zoomed out levels. Data was also mapped to DMAs to show local market trends compared to national data.
We developed the prototype with a fixed set of data and later worked with the in-house team to tie directly to the master Kinship database. A script is triggered whenever the master database is updated to reflect the latest changes allowing the platform to change and scale without further development.
This is available as a secured in-house website but for launch Kinship took over a room with two large touchscreen displays. Marketing managers where brought in to fully immerse themselves in the data letting them filter, zoom and explore their regions to find new opportunities in their markets.