Refocus is a fast-growing EdTech startup that provides online courses about digital careers. It’s currently expanding its global reach by actively attracting Asian students.
To set up the infrastructure of raw data processing (students, their progress, payments, and other data), as well as to build an easy-to-comprehend, data-rich dashboard for informed decision-making.
Python-based scripts allow for regular, real-time data collection
The data is visualized in Tableau Online for the Client to improve sales and product-related decisions.
You need custom analytics if
While starting to work on the project, we had to struggle through a technical challenge: Refocus’s team modified data sources and didn’t notify us, which caused a lot of trouble for our data analysts. How did we rule this out? We had to ask Refocus not to alter anything that may be streamed into the data pipeline.
After analyzing the Client’s business goals and data collection requirements (i.e., data sources, the required attributes), we came up with a tech stack that included:
With the help of Airflow and Python scripts, the data is exported, processed, and stored in the database via API. Hence, all the data collected from tables is in Google BigQuery. Airflow, which is based on a virtual machine, manages the workflows.
All the data is then visualized in the Tableau reports.
The Client can build both generic and specialized reports to make data-driven decisions.
For example, here is an SLA report.
We analyzed various lead funnels and reallocated them to increase the conversion rate from X% to Y%. This allowed the Client to speed up the conversion from a new deal to a sale.
The dashboard for students’ refund requests determines the most common reasons for refunds. Now, the Client can work them through to minimize the amount, thus profiting from the data available to them.
By analyzing dashboards that illustrate students’ performance, the Client managed to monitor the progress of each student as well as discover the most difficult tasks and lessons. The insights allow for data-based product development, which may increase course completion rates in the future.
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
This website uses cookies to ensure you get the best experience on our website. Learn more >