Built A Unified Tableau Dashboard Migrated From DOMO

Learn how we Re-engineered & Migrated DOMO dashboards to Tableau in Snowflake, reducing 80% of Compute Time & 45% of TCO

Highlights

80%
Compute Time saved by using incremental refresh time.
2–4x
Improvement in visualization load times
60%
of Project delivery time saved by detailed pre-assessment
99%
Data Redundancy removed
4x
Increased database query speed

Client Profile

Our client is one of the best-known media entertainment companies in the world. It operates a valuable portfolio of news and entertainment television networks, a premier motion picture company, significant television production operations, a leading television station group, world-renowned theme parks, and a premium ad-supported streaming service.

Business challenges

  • To Build a Unified Business Intelligence Dashboard that fits the need of the one of the largest media houses in the world
  • The primary challenge was to Migrate 220 + DOMO dashboards to Tableau, which involves huge On-Prem data to Tableau Cloud.
  • Helped customers create & move 550+ Diversified Datasets to a single source Snowflake database system.
  • To enable a holistic Data Visualization experience performance across DTC (Direct-to-Consumer) Business Units.
  • To reduce DOMO Licence Cost and help customer to simplify the reporting modules.

Agilisium Solution

  • Migrated huge data from DOMO dashboards, created tables and portable datasets to snowflake by reviewing SQL logic and converting DOMO tables.
  • By using incremental refresh and using tables instead of custom SQL, we saved around 80% on compute time.
  • Software Utilization has been reduced by removing the ETL(Magic ETL) process involved in DOMO, as the transformations are converted into SQL and directly loaded into tables/views.
  • Redesigned table architecture in snowflake tables to avoid using custom SQL, APIS, S3, and other data sources.
  • Implemented data security techniques like data masking to avoid data breaches, and exposing PIA data.
  • Overall 2x times increase in support activity as Tableau is user friendly.
  • Increased performance by publishing the data sources to the server.
  • Our Best practices helped BI reporting performance increase its efficiency by 40%
  • Around 90% of calculation logic has been translated into Tableau from DOMO with zero issues.

Tech-stacks Used

AWS – S3
EC2

Business outcome

  • $1 million was saved by rightsizing instance types and reducing computing time.
  • 80% compute time saved by using incremental refresh time.
  • 220+ Dashboards rebuilt and migrated to Tableau as a Unified BI Solution that fits the need of the different teams across DTC (Direct-to-Consumer) Business Units.
  • 550+ Diversified Datasets created & moved to single source Snowflake database in 2 months.
  • 60% of Project delivery time saved by detailed pre-assessment and extensive up-to-date resource planning and helped to complete it in just 5 Months.
  • Reverse engineering Domo dashboards and recreating them to Tableau helped reduce 50% of the Licence Cost.
  • ETL Tool usage has been removed, and reduced the technical expertise.
Get the Most Out of Embedded Analytics with Amazon Opensearch
From data rich visual analytics to interactive dashboards that make data fetching a piece of cake, Team Agilisium is with you, every step of the way.
Talk to Us
Got a question? Don’t hesitate to give us a call today or shoot us an email. 
Please enter a business email
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.