Overview

The US-based company Zirexa modernized its legacy BI platform by migrating to Apache Superset with centralized Keycloak SSO. This enabled secure access, scalable analytics and faster data-driven decision-making across departments. The transformation helps them to improve system reliability and provide a future-ready cloud-native BI architecture.

Technologies Used

Apache Superset
Keycloak
python
postgrad-sql
Docker
aws

Project Highlights

checkmark

Apache Superset BI Modernization

checkmark

Keycloak-Based Single Sign-On

checkmark

Role-Based Access Control

checkmark

Cloud-Native Analytics Architecture

The Challenges

1

Migrating legacy BI dashboards without disrupting ongoing enterprise reporting workflows.

2

Implementing centralized authentication across multiple analytics teams and departments.

3

Ensuring strict policy-driven secure role-based access for sensitive enterprise data sources.

4

Scaling BI infrastructure to handle increasing concurrent users and data volume.

Solutions by Bacancy

1

Bacancy helped to migrate legacy BI reports into Apache Superset while preserving dashboard logic and improving visualization performance.

2

We integrated Keycloak SSO to enable centralized authentication and seamless access across enterprise BI users.

3

Our Apache Superset developers implemented fine-grained role-based access control. This ensures secure and compliant data visibility.

4

Deployed containerized Superset architecture on AWS to support scalable, high-availability analytics workloads.

Core Features

checkmark

Apache Superset Dashboards

checkmark

Single Sign-On with Keycloak

checkmark

Role-Based Access Control

checkmark

Scalable BI Reporting

No. of Resource

04

No. of Resource

Time Frame

May 2025 – October 2025

Time Frame

Project Snapshot

Zirexa

Outcomes

Centralized BI access with secure SSO

Improved dashboard performance

Simplified user management across teams

Scalable analytics for enterprise users

Reduced BI infrastructure maintenance

Enhanced data-driven decision-making

Technical Stack

Frontend Apache Superset UIReact.js
Backend PythonFlask
Database KeycloakOAuth 2.0
Authentication AWSAmazon EC2Amazon S3
Architecture Containerized MicroservicesRESTful APIs
Deployment DockerDocker Compose
Project & Issue Tracking JiraGitHub

Experience With Bacancy

2500+ Projects Experienced Innovation with Bacancy!

Get access to an experienced team of developers and engineers from Bacancy, handpicked to ace your goals. Kickstart within 48 hours, no-risk trial.

Book a 30 min call

14+

Years of Business Experience

1458+

Happy Customers

12+

Countries with Happy Customers

1050+

Agile Enabled Employees

How Can We Help?