MentorShow is a French startup that offers exclusive online masterclasses on different fields by successful speakers. The company is involved in producing and distributing courses via a website. In the future, another distribution channel – a mobile app – will be added.
The Client’s data processing processes were inefficient. They wanted the data analytics logic to be revised and updated, the KPI accuracy to be checked, and informative dashboards to be generated.
We delivered refined data processing and set up Python and SQL scripts.
New comprehensive reports allow for enhanced data accuracy. As a result, the Client gained meaningful insights about user behavior: for example, the reasons for subscription cancellations.
You need custom analytics if
MentorShow, an Edtech provider of exclusive online courses, had already set up data processing and analytical processes. However, the quality and accuracy of the calculations left much to be desired. The client set several project objectives:
The EdTech startup lacked the expert internal resources needed to complete the task. Hence, they turned to Valiotti, a Tableau expert with extensive experience in setting up SQL and ETL processes.
1. Refined data processing
After Valiotti’s team immersed itself in the Client’s subject area, we got acquainted with the available data, processes, and product features. At this stage, we worked both independently and together with the startup’s team.
We developed new raw data processing logic without using legacy code and created Python and SQL scripts. They run daily and allow the Client to obtain the necessary data for analysis (business KPIs and data tables). We also revised and updated the existing scripts for seamless performance.
2. A variety of data-rich dashboards for comprehensive decision-making
After schematization of data obtained from new sources, we built several dashboards with accurate calculations. They are regularly updated and allow for a comprehensive outlook. Previously, the Client needed to gather data from several reports manually. Now, the Client can track changes in indicators effectively to promptly make decisions on product development strategies based on meaningful insights.
Here are some examples of dashboards:
And Retention analysis report
If you need help with selecting or creating data analytics tools, feel free to contact us.
You can write directly to our CEO or submit a request on the site. We are looking forward to our collaboration!
Learn more about our case studies
EdTech, FranceRead case study
Marketing, AustriaRead case study
EdTech, PhillipinesRead case study
Telephony, FranceRead case study
Telecom, USARead case study
Mobile apps, USARead case study