Tableau Case Study

Business Challenges

  • Connecting real-time data to Tableau is imperative due to the external Immuta system which manages row-level security.
  • Tableau’s performance issues with live connections, are largely attributable to the substantial volume of data we manage.
  • Multiple dashboard migrations have been necessitated by frequent system changes stemming from security breaches and performance issues in our legacy systems.
  • Ensuring ongoing data governance and compliance has proven to be a persistent challenge requiring a delicate balance between security, accessibility, and performance considerations.

Key Solutions

  • Query Optimization: Enhanced query performance by adjusting data granularity and segregating executive and detailed views using separate data sources.
  • Performance Improvement: Implemented backend logic migration, query result transformation into physical tables, and incremental refresh, resulting in an impressive 86% runtime reduction.
  • Dashboard Standardization: Introduced standardized templates for consistent appearance and user experience across all analytics assets which helped development time drastically.

Business Benefits

  • Enhanced Data Security: Maintaining a live Immuta connection ensures top-tier data security.
  • Improved Performance: Our optimizations led to an 86% runtime reduction for faster analytics.
  • Efficient Migrations: Standardized dashboards cut migration time and resource costs.
  • SmartData Governance: Balancing governance, compliance, and performance meets regulations while optimizing access and speed.

Client

IT that sells Customer Experience & Call Center Technology

Partners

Snowflake & Tableau

Challenge

Snowflake is a single place for data. The project is to maintaining or creating the Snowflake accounts, creating the objects, Data migration, creating Snowflake service accounts and the organization uses tools like AWS, Boomi, Tableau, Talend etc. for Snowflake integration.