Data Warehouse Modernization
Tableau Report Migration to Amazon QuickSight
A leading provider of robotics and automation technologies for fulfillment and logistics operations needed to migrate its existing Tableau reports to a modern, cloud-based Business Intelligence (BI) platform to establish a scalable solution capable of tracking critical, large datasets and supporting future reporting needs.
Client Challenges and Requirements
- Migrate existing Tableau reports to the new cloud BI platform.
- Develop new reports and enhancements within the cloud BI platform and manage ongoing change requests.
- Scalable architecture capable of handling the analysis of critical and large datasets.
Bitwise Solution
- Accelerate delivery and stay on budget by applying best practices and AWS cloud-native services to redesign and enhance the end-to-end data solution.
- Leverage YAML-based framework for defining ETL job configurations like job parameter and logic. The framework dynamically generates python DAG for Apache Airflow, enabling easy orchestration, scalability and maintainability.
- Apply a SQL-based approach for developing ETL jobs and develop optimized SQL queries, focusing on minimizing join operations by leveraging appropriate indexing strategies to handle large volumes of data.
- Integrate data integrity checks into YAML-based framework by defining validation rules such as schema validation, row counts, column match and data type checks.
- Identify business requirement and complexity of the dashboards. Build new Tableau dashboards by adopting iterative and modular approach.
- Create dynamic visualizations in Tableau using advanced metrics and KPIs. Integrate optimized SQL queries to ensure performance.
Tools & Technologies We Used
Amazon QuickSight
Amazon Redshift
Tableau
Key Results
Smarter decision-making with better tracking of strategy and business plans
Effective dataset versioning capabilities
Scalable, budget-friendly solution that cuts infrastructure and maintenance costs
Seamless, secure integration with the existing cloud infrastructure
