BI Modernization

Tableau Report Migration to Looker

An American ticketing company that sells movie tickets via their website as well as through their mobile app required a solution to migrate its Tableau reporting to Looker.

Client Challenges and Requirements

  • Reduce maintenance cost
  • Retain the look and feel of dashboards
  • Retain feature and functionalities of the report
  • Data should be identical and accurate in Looker reports as compared to the Tableau reports
  • Report performance should be intact or improved

Bitwise Solution

    • Migration of Tableau reports to Looker
    • Used existing Tableau Dashboards as a source of truth for Looker reports
    • Setup and Configured required data connections in Looker
    • Implemented generic Models on top of the Redshift in Looker using LookML language
    • Built dashboards in Looker using generic Models and Derived tables
    • Implemented Role based security to control dashboard access on server
    • Scheduled the Monthly/Daily/Weekly task to send dashboard output to the various business person/studios through email
    • Implemented and scheduled (triggered) PDT tables to optimize the dashboard performance
    • Created Tableau specific features (Ex- FIXED, Blending) in Looker using a LookML

 

Tools & Technologies We Used

Looker
Tableau Desktop
Tableau Server
Redshift

Key Results

Reduced development and maintenance cost

Performance optimization

Custom SQL replaced by generic Models

Ease of Adhoc reporting for end users

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?