Problem

V+ (a dummy company), a bike-sharing company, launched in early 2022 and their marketing team needed to gain customer insight and optimize their marketing budget. They hired our team of consultants to create a dashboard that would aid them in deep diving into a sample of their data and redefine their strategy for the coming months. The data they shared with us included user data, subscription details, ride details per week, and campaign details.

We quickly realized that the data was scattered across different platforms and needed to be consolidated before we could start analyzing it. Additionally, we had to ensure that the dashboard was user-friendly so that the marketing team could easily access the insights they needed without requiring technical expertise.

Solution

Our team started by consolidating all the data from different platforms into one database. We then used Google Looker Studio to create a dashboard that would display all relevant information in an easy-to-understand format. We also ensured that the dashboard was interactive so that users could filter information based on specific criteria.

To make sure that the dashboard was user-friendly, we conducted several rounds of testing with members of the marketing team. We incorporated their feedback into our design and made adjustments accordingly until we had a final product that met all their requirements.

Impact

Increased efficiency of the marketing team
Improved accuracy of customer insights

Team

JAIN Sanjana
LI Xuan
MATHUR Nimish
SUJITH Rahul
YU Andy

Credits: emlyon business school

Bikesharing Company Optimizes Marketing with Dashboard