Powering Data-Driven Growth for Increased Customer Retention

Industry

Education, Technology

Goal

Develop automated dashboards to fuel decision-making and customer retention

Contractor

Sheng Ang

Challenge

Rubin, a leader in online curriculum focused on enhancing student employability skills, wanted deeper visibility into how students engage with their platform. Being a forward-thinking company, Rubin had already invested in an organized data infrastructure in a SQL database. Building on this strong foundation, Rubin aimed to create an intuitive dashboard to better understand user activity and showcase program impact to strengthen partnerships with school networks. This will further aid the team’s effort in customer retention.

Solutions

  • Real-Time User Activity Dashboards using Power BI

    We developed custom Power BI dashboards to provide immediate visibility into how users engage with Rubin’s online curriculum. These dashboards empowered stakeholders to monitor performance, identify usage patterns, and respond quickly to user needs.

  • Cross-Platform Data Integration

    We integrated all of Rubin’s critical data sources - from CSV files to SQL databases - into a unified analytics ecosystem. This comprehensive data foundation enabled a more holistic performance evaluation.

  • Optimized SQL Queries and Views

    Our team refined SQL queries to improve efficiency. As a result, Power BI dashboard refresh times were significantly reduced, allowing teams to access insights with less delay.

  • Robust Documentation for Scalability and Knowledge Transfer

    To ensure long-term sustainability, we provided clear, user-friendly documentation outlining dashboard functionality, data source mappings and query logic. This empowers Rubin’s internal teams to manage, troubleshoot, and scale their reporting systems with confidence.

Results

Students nationwide spent 1.3 million minutes in Rubin’s Emerge curriculum for employability skills during the 23-24 academic year. As a comparison, students logged 375,000 minutes in the 22-23 academic year.

The automate dashboard further convinced existing customers to continue investing in their children’s professional future alongside Rubin.

year-over-year customer retention

80%

increase in logged minutes in online curriculum, totalling 1.3 mil minutes in a school year

4x

reduction in dashboard refresh time through query and database optimization

46%

- Danny Rubin, Founder & CEO of Rubin Education

“Akaike is a phenomenal partner. Our company needed to create a visual display of user data (we provide professional development curriculum to K-12 schools). They built our data dashboard from scratch and then helped us modify and improve as customers asked for different data types. We still come back to Akaike for additional improvements. They are responsive, friendly, hardworking individuals and will deliver exactly what you need. We're grateful for Akaike!”

Previous

From Paper to Precision: Revolutionizing Healthcare Insights for Underserved Communities