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.
As you will learn from this Edtech case study, 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.
This Edtech case study includes just a few examples of dashboards:
And Retention analysis report
That's how Léo Dubert, Co-founder | MentorShow, described our work together on this project:
Since about six months, Nikolay and his team are doing tremendous work for us. They’re sharp, professional, efficient, and excellent communicators. They managed to bring clarity in a very complex and chaotic environment, with a patient, yet ambitious pace. Nikolay is also very present when needed, but can rely on his strong team. I definetly recommend!
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
Lifestyle, USARead case study
iGaming, CyprusRead case study
FinTech, SpainRead case study
Ukraine, EdTechRead case study
Betting, AfricaRead case study
EdTech, FranceRead case study