Connexis TechnologiesBook an architecture review
← All case studies

Consumer app · San Francisco

Audience business review analytics

Data lake on S3 exposed to Athena via Glue Catalog, a single-source-of-truth table refreshed by Step Functions and Lambda, and a QuickSight CXO dashboard for MAU, DAU, trial-to-subscription and revenue trends.

AWSS3AthenaGlueStep FunctionsRedshift SpectrumQuickSight

The problem

Legacy BI could not deliver near real-time app usage insight; every analysis was a manual data pull.

Our approach

  1. 1Consolidated app event, subscription and billing feeds into a partitioned S3 data lake.
  2. 2Catalogued datasets in Glue and queried them through Athena and Redshift Spectrum.
  3. 3Orchestrated a daily single-source-of-truth refresh with Step Functions and Lambda.
  4. 4Published a CXO QuickSight dashboard covering MAU, DAU, trial-to-subscription and revenue.

Measurable outcomes

Daily
Automated audience and revenue review
0
Manual data pulls per analysis
1
Single source of truth for MAU and DAU

Architecture and workflow

Architecture and workflow
  1. 01

    Sources

    App events · billing · subscriptions

  2. 02

    Lake

    S3 partitioned zones

  3. 03

    Catalog

    Glue · Athena · Spectrum

  4. 04

    Orchestrate

    Step Functions · Lambda

  5. 05

    Consume

    QuickSight CXO dashboard

More work

Packaged snacks · LATAM and Middle East & South Africa retail

Revenue analytics across 12 retail chains, refreshed hourly

Replaced a nightly Excel-and-SSIS revenue pack with a Databricks lakehouse serving trade-spend-adjusted net revenue to 400+ commercial users across LATAM and Middle East & South Africa.

Global BPO / ITeS · France

Operational insights for 400 contact centres

Performance tool exports auto-synced to Azure file storage, staged and loaded by Azure Data Factory into a Synapse warehouse, with Power BI dashboards for occupancy, AUX, handled volumes and shrinkage.

Healthcare ISV

Integrated healthcare and telemedicine platform

HIPAA-compliant AWS platform with IoT device integration, nutrition tracking and a conversational intelligence pipeline using Transcribe Medical and Comprehend Medical over Chime call recordings.

Want a build like this?

We start with a two-week diagnostic and leave you with an architecture and migration plan you own.

Talk to an architect