Free 30-minute call with the engineer who builds your software. Book a time

All projects

New Era Learning: Snowflake dashboards and a lesson translation tool

Client
New Era Learning
Sector
Online education company
Location
United Arab Emirates
Status
In use
Platforms
Web, Snowflake
Stack
Snowflake, Streamlit, React, TypeScript, AWS
Diagram: data from PostgreSQL, PostHog and ClickHouse flows into derived tables in Snowflake and on to Streamlit dashboards; a translation tool moves lesson videos between Cloudflare and HeyGen AI translation and keeps a copy in Google Drive.

The situation

New Era Learning is an online education company in the United Arab Emirates. It develops programs for the digital economy, taught through practitioner-led mentorship and learning applications, and runs its own learning platforms.

We helped New Era Learning build its online learning platform. Around it we built a data setup in Snowflake and a tool that translates the platform's video lessons into other languages.

What we built

The first is the Snowflake data setup. Every night, scheduled jobs export data into Snowflake from the checkout database in PostgreSQL, product analytics in PostHog and message reaction events in ClickHouse. A monthly load runs as well, with recovery procedures.

Inside Snowflake, the raw data becomes derived tables: monthly payment value, each account's status history, retention cohorts, and movement between programs.

On those tables we built Streamlit dashboards that run inside Snowflake. They show monthly and daily performance, retention curves, how members move and overlap between programs, weekly student journeys, direct-message usage, and revenue: refunds, disputes, paid monthly recurring revenue, lifetime value, cancellations and acquisition. Each dashboard has an "About this app" panel and a glossary of its terms. A daily digest email is rendered from the same figures.

The client's owner, staff and instructors open the dashboards in Snowflake's web interface, with view-only access limited to the dashboards.

The second is the lesson translation tool. It fetches each lesson video from Cloudflare, stores a copy in Google Drive and tracks it in a database. A person submits each video to HeyGen's AI video translation by hand. The tool then pulls each translated version back and publishes it to Cloudflare. Its web front end, behind a login, shows the lessons and the translation status of each one.

The front end is React with Material UI and a Clerk login. The backend is TypeScript on Bun, with Elysia, MongoDB, Redis and scheduled jobs. It runs in Docker on AWS EKS together with AWS Lambda, and GitHub Actions deploys it to staging and to production.

The result

The platform's data now becomes customer and revenue insights that the client's team reads inside Snowflake. The dashboards refresh on schedules: overnight, weekly or monthly.

The translation tool runs in production.

See also

Want something like this built for your business?

Book a free 30-minute call

Last updated: