Powering Data-Driven Growth for Increased Customer Retention

Rubin is an education company that provides online curriculum and resources to help students develop professional communication and employability skills, such as writing emails, networking, and preparing for the modern workplace.

Learn more about RUBIN

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%

Challenge – Rubin

Needed deeper insight into student engagement
Existing SQL data lacked actionable visualization
Hard to demonstrate program impact to school partners

Our Solution

Built automated dashboards using existing SQL infrastructure
Visualized user activity and engagement metrics
Enabled data-driven storytelling to strengthen partnerships and boost retention

What We Did

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.