Business Intelligence

Migration of dashboards to Apache Superset

How Capmo replaced Looker with Apache Superset, saving over €50,000 a year while gaining full control over branded, embedded analytics.

Capmo is a construction technology company offering software for project planning, documentation, and quality assurance for general contractors, positioned as Europe's leading operating system for construction sites.

Website

Industry

Construction

Location

Munich, Germany

Stack

dbt · Snowflake · Apache Superset

Background

Seeking a cost-effective alternative to Looker

Capmo, a fast-growing provider of construction management software, integrated dashboards into their application for real-time insights, initially using Looker.
However, Looker's high annual fee, along with the need for a seamless, branded analytics experience, scalability, and secure data access, led Capmo to seek a more cost-effective, open-source solution.


The solution

Replacing Looker with a fully embedded Superset platform

Capmo partnered with Astrafy to design and implement a modern, cost-effective alternative to Looker using Apache Superset, a powerful open-source business intelligence platform. We delivered:

  • Dashboard Migration: We faithfully replicated all existing Looker dashboards into Superset, matching Capmo's corporate branding and user experience expectations.

  • Row-Level Security: We implemented robust RLS to ensure each user could access only their own data, maintaining strict data isolation across clients.

  • Embedded Integration: Our team supported Capmo throughout the integration of Superset dashboards within their web application, ensuring a seamless user experience for their customers.

  • Knowledge Transfer: We enabled Capmo's internal team to maintain and extend the platform autonomously by delivering hands-on training and documentation.
    Flow: Transformation (dbt, Snowflake) → Insights (Apache Superset)


Results

Key achievements


01

Cost Savings

Immediate annual savings of €50,000+ by switching to Apache Superset.


02

Dashboard Replication

Migrated key dashboards with no loss in performance or functionality.


03

Secure Analytics

Seamless, secure RLS enabled confident scaling of embedded analytics.


04

Increased Autonomy

Capmo's team can now independently manage and extend their Superset-based platform.


Business Impact

Lower costs and full control over embedded analytics

The transition to Apache Superset enabled Capmo to:

  • Reduce BI Tooling Costs by over €50,000 per year, reallocating budget to other high-priority initiatives.

  • Retain Full Control over their analytics stack with open-source flexibility.

  • Deliver Branded, Embedded Dashboards to customers, with improved performance and zero vendor lock-in.

  • Scale securely thanks to built-in Row-Level Security and user-specific data access controls.


“Switching from Looker to Apache Superset with Astrafy's support has been transformative. We reduced costs, gained full control over our embedded analytics, and ensured seamless data insights for our customers. Astrafy flawlessly integrated Superset into our app, giving us the confidence to scale."

Andre Geimer

“Switching from Looker to Apache Superset with Astrafy's support has been transformative. We reduced costs, gained full control over our embedded analytics, and ensured seamless data insights for our customers. Astrafy flawlessly integrated Superset into our app, giving us the confidence to scale."

Andre Geimer

Latest case studies

Turn your scattered data & AI initiatives into a coherent strategy

Turn your scattered data & AI initiatives into a coherent strategy

Turn your scattered data & AI initiatives into a coherent strategy