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
Share This Case Study
Share on linkedin
Share on twitter
Share on whatsapp
Share on telegram
Download Case Study
Bitwise provides comprehensive solution for all your data projects
Related Solution
Data Warehouse and
Business Intelligence
Modernize and transform Enterprise Data Warehouse reporting systems to become more competitive for meeting today’s business challengesÂ
Ready to start a conversation?
