Transforming Dashboard Creation: Indium’s Automation Solution for a Global Ride-Hailing Giant

Client Overview

Timely and accurate data is crucial for making informed decisions. For a global ride-hailing company operating in over 900 metropolitan areas, the challenge of creating complex, data-driven dashboards became increasingly time-consuming and resource-intensive. To overcome this, the company sought a solution to automate the generation of Tableau dashboards, ensuring coherence, scalability, and consistency across the organization. Indium stepped in to provide a game-changing solution

The Challenge:Manual Dashboards, Data Spilled All Over the Place

Indium’s automated solution transformed the way the client generated Tableau dashboards. By automating the process, the client saved valuable time and resources and enhanced the accuracy and consistency of their data visualization efforts. This streamlined approach supports better decision-making through timely, reliable insights, ultimately driving the client’s business forward.

Indium’s expertise in automation and data visualization proved invaluable. We provided the client with a scalable, efficient solution that could adapt to their growing needs.

Indium's Solution:Automated Dashboard Generation with Python and Jinja2

Indium designed an automated solution using Python and Jinja2 to streamline the dashboard creation process. The automation process involved three key components:

Finished Tableau Dashboard Template

A pre-designed template was the foundation for all dashboards, ensuring a consistent structure and layout.

Template Inputs

Metrics and other details were fed into the template via Google Sheets, allowing easy management and updates

Python Script with Jinja2

The Python script dynamically generated Tableau workbooks by parameterizing the XML code underlying the dashboards. This process automated the creation of data sources, views, actions, worksheets, and dashboards, reducing the time and effort required to produce each dashboard.

Implementation and Impact: Dramatic Time Savings, Consistency, and Scalability

The implementation of this automation solution delivered significant business benefits:

Dramatic Time Savings

The time required to create dashboards was reduced from days to minutes, saving over 500 + person-hours to date—a number will only grow as more teams adopt the solution.

Consistency Across Dashboards

Automation ensured that all dashboards maintained a consistent structure and formatting, minimizing errors and improving usability.

Scalability for Diverse Needs

The solution supported the generation of multiple dashboards with varying data sources and metrics, making it highly scalable across different teams and use cases.

User-Friendly Implementation

Even users with basic Tableau knowledge could easily generate complex dashboards using the predefined templates, simplifying the process and reducing the learning curve.