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
- Migration of Tableau reports to Looker
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
