Download PDF
Case Study: CARTO for Media & Agencies - Tecnilógica Uses Location Intelligence for A Viral Visualization
Technology Category
- Application Infrastructure & Middleware - Data Visualization
Applicable Functions
- Sales & Marketing
Services
- Data Science Services
The Challenge
Tecnilógica, a digital agency, wanted to leverage a timely, newsworthy event to generate brand awareness and drive traffic to their platform. The Ashley Madison data leak provided an opportunity to create a data-driven visualization that would attract a global audience. However, the challenge was to clean up the dataset, removing any identifying information to protect users, and then find a way to visualize the data in a compelling and insightful manner.
About The Customer
Tecnilógica is a digital agency based in Spain that specializes in the design and development of websites, mobile and web applications. The company helps brands use the internet to engage prospects, customers, leads, and advocates. Tecnilógica's unique blend of strategy, creative, and programming capabilities enables them to provide business-critical technical solutions to their clients. The company sought to leverage a timely, newsworthy event to generate brand awareness and drive traffic to their platform.
The Solution
Tecnilógica chose to use CARTO’s platform to create a data-driven visualization of the Ashley Madison data leak. The team spent about six hours cleaning up the dataset, removing any identifying information like names, email, and home addresses. The remaining data contained only the gender, sign-up data, and city locations of users. They began to experiment with a subset of data, analyzing only three million records out of over 30 million, while setting up a database server to handle the full dataset. The visualization was represented on a map with two layers. The first layer, a heat map, detailed the distribution of users across the world. The second layer visualized the male/female ratio per city.
Operational Impact
Quantitative Benefit
