How Data Visualization Allowed an Ed-Tech Startup to Boost Conversions: Refocus Case

The Challenge

Refocus, a fast-growing EdTech startup offering online courses about digital careers, was expanding globally with a particular focus on the Asian market. Their growth was outpacing their ability to make data-informed decisions. Student data, progress tracking, payment information, and marketing metrics were all scattered across different systems with no centralized analytics infrastructure.

The team recognized they needed to become data-driven to sustain their growth trajectory — better understanding which courses performed best, which marketing channels delivered the highest-quality students, and where in the student journey they were losing conversions. But they lacked both the internal expertise and the resources to build this infrastructure from scratch.

The challenge was especially urgent given Refocus’s expansion plans. They were entering multiple Asian markets simultaneously, each with different student demographics, pricing sensitivities, and marketing channel effectiveness. Without data infrastructure, the team couldn’t compare market performance, identify which geographies were reaching product-market fit, or allocate their limited expansion budget to the highest-potential markets. Every week of operating without analytics meant decisions were being made that could waste tens of thousands of dollars in misallocated marketing spend.

Our Approach

We designed a complete analytics infrastructure tailored to Refocus’s specific needs as a fast-scaling EdTech company:

• Data Collection & Processing: We built Python-based scripts for automated, real-time data collection from Refocus’s student management system, payment processor, and marketing platforms. These scripts ran on a scheduled basis, ensuring data freshness without manual intervention.
• Data Warehouse Design: We structured the collected data into an analytical warehouse with data models specifically designed for EdTech metrics: student cohort analysis, course completion funnels, payment lifecycle tracking, and marketing attribution.
• Visualization in Tableau Online: We built a suite of Tableau dashboards accessible to the entire leadership team. Key dashboards included: student enrollment funnel (from lead to active learner), course performance analytics (completion rates, NPS by course), revenue and payment analytics, and marketing channel efficiency.

A critical aspect of our approach was designing the analytics with Refocus’s international expansion in mind. Dashboard logic handled multiple currencies, time zones, and regional cohort comparisons — essential for a company actively entering new Asian markets.

We also built a predictive analytics component that identified “at-risk” students — those showing engagement patterns correlated with dropout. This early warning system enabled the student success team to intervene proactively with targeted outreach, improving overall completion rates. The analytics infrastructure was designed to be self-documenting, with clear data lineage from source to dashboard, enabling Refocus’s growing team to understand and trust the numbers without needing to consult the engineering team for every question.

Results

• Python-based automated data collection running in real-time, replacing all manual data processing.
• Centralized data warehouse combining student, financial, and marketing data in one queryable source.
• Tableau Online dashboards enabling the leadership team to make data-driven decisions about sales strategy, product investment, and marketing allocation.
• Student lifecycle visibility from first touch to course completion, revealing key drop-off points where targeted interventions improved conversion.
• International expansion analytics supporting data-driven market entry decisions.

Technologies Used

Python, SQL, Tableau Online, REST APIs, automated ETL pipelines.

Project Screenshots