---
# Data integration & standardization on Google cloud improves time to insight by 25%
**URL:** https://www.sigmoid.com/case-studies/data-integration-standardization-on-google-cloud/
Date: 2023-04-04
Author: Sigmoid
Post Type: page
Summary: Data integration & standardization on Google cloud improves time to insight by 25% Sigmoid developed a centralized and scalable data warehouse on...Read More...
Featured Image: https://www.sigmoid.com/wp-content/uploads/2023/04/Data-integration-thumbnail.jpg
---
# Data integration & standardization on Google cloud improves time to insight by 25%
[fluentform id="90"]
Sigmoid developed a centralized and scalable data warehouse on Google Cloud to optimize data-driven decision-making. A single source of truth for multiple data sources was created to address legacy data warehouse challenges of data discoverability, governance, and security.
### Business Challenge
The client is a technology-based digital ecosystem company located in Indonesia, and is one of the five companies with the largest market capitalization on the Indonesia Stock Exchange. They cater to a wide range of services including transport, payments, food delivery, and logistics. Their legacy data warehouse was facing challenges in handling data from various systems belonging to the above-mentioned business divisions and also exhibited data administration, quality, and security issues. They wanted to improve data processing speed, reduce storage costs, and make data more accessible for enterprise BI reports that can be effectively used by various business units.
### Sigmoid Solution
Sigmoid provided a comprehensive approach to data management by implementing efficient, reusable, and scalable data ingestion pipelines on the new [data warehouse architecture](/ebooks-whitepapers/guide-to-cloud-data-warehouse/). The solution was completed in two phases. In phase 1, we identified the dependent source tables that needed to be migrated to the new data warehouse and created the necessary schemas and tables. For enhanced querying capabilities, queries and views were refactored to access tables, followed by unit and regression testing. Phase 2 was an extension of phase 1, with the migration of 100+ tables, 45+ views, and 68+ Tableau views. The solution was implemented by validating the test results and comparing the outputs of the legacy and the modern data warehouses’ queries/views.
[Download case study](#case-study-download)
### Business Impact
A consolidated and standardized data warehouse helped the client store, retrieve, and process data from different business divisions such as transport, payments, and food delivery across multiple locations in the Asia Pacific region. Query optimization improved the data processing and performance of the updated data warehouse. Additionally, the migration of data to the new GCP architecture resulted in significant savings in storage costs. Faster availability of data for users enabled them to perform analytics and generate actionable insights from the reports.
20%
savings in storage costs
25%
faster availability of the data
20%
improvement in DWH performance
## Relevant Case Studies
#### [Enabling Data Standardization and Error-free Reporting to Track Data Anomalies for Operational Efficiency](/case-studies/automated-global-bi-reporting/)
[Read case study](/case-studies/automated-global-bi-reporting/)
#### [Faster analysis on 250TB+ data and creation of a SSOT](/case-studies/single-source-of-truth-creation/)
[Read case study](/case-studies/single-source-of-truth-creation/)
#### [Centralized Data Lake for Faster Analytics and Reporting](/case-studies/centralized-data-lake-for-faster-analytics-and-reporting/)
[Read case study](/case-studies/centralized-data-lake-for-faster-analytics-and-reporting/)
[lc_get_post post_type="lc_section" slug="find-out-footer-common-cta"]
---
## Navigation
- [Company](/about-sigmoid)
- [Newsroom](/newsroom)
- [Life at Sigmoid](/careers)
- [Takshashila](/takshashila)
- [Contact Us](/contact-us)
- [AI Strategy Blueprint your AI advantage](/enterprise-ai-strategy/)
- [Generative AI Drive innovation with Generative AI](/generative-ai/)
- [Responsible AI Build trust with ethical AI practices](/responsible-ai-in-enterprise/)
- [Agentic AI Reshape business with scalable agentic systems](/agentic-ai-solutions/)
- [AI Managed Services Ensure reliable AI performance](/ai-managed-services/)
- [Advanced Analytics Transform your business with data-driven insights](/advanced-data-analytics-solutions/)
- [Start Assessment](/agentic-ai-readiness-index/)
- [Data Strategy Strong data foundations for scalable AI](/data-analytics-strategy/)
- [Data Management Leverage data as a strategic asset](/ai-data-management-services/)
- [Data Ops Automate data for speed and quality](/data-devops/)
- [Data Engineering Deliver insights faster with scalable pipelines](/data-engineering/)
- [Cloud Transformation Modernize data to maximise efficiency](/cloud-migration/)
- [Download Whitepaper](/ebooks-whitepapers/building-data-products-in-a-data-mesh-to-drive-business-value/)
- [Data Modeling Structure data for better decisions](/data-modeling-services/)
- [Data Visualization Transform data into actionable stories](/data-visualization-service/)
- [BI Migration Enhance decision making with modern BI tools](/bi-migration/)
- [Data Observability Build trust with healthy, accurate data](/data-observability/)
- [Automated Insights Make smarter decisions with auto-generated insights](/automated-insights/)
- [Download Whitepaper](/ebooks-whitepapers/power-bi-hacks/)
- [CPG & Retail End-to-end analytics for planning, operations, and commercial excellence](/industries/cpg-analytics/)
- [Life Sciences Trusted intelligence across clinical, commercial, and operational workflows](/industries/life-sciences/)
- [Financial Services AI-powered analytics for risk, compliance and customer experience](/industries/banking-financial-analytics-services/)
- [Read case study](/case-studies/data-clean-room-enables-real-time-insights-to-improve-operational-efficiency/)
- [MediaIQ Advanced platform for in-flight marketing measurement](/accelerators/sigmoid-mediaiq-multi-touch-attribution-tool/)
- [CampaignIQ AI-driven platform for optimized campaign budget allocation](/accelerators/sigmoid-campaigniq/)
- [AssistBot GenAI email assistant that automates human-like responses](/accelerators/sigmoid-assistbot-for-ai-email-assistant/)
- [CreativeBot GenAI tool for personalized and brand-aligned creative design](/accelerators/sigmoid-creativebot/)
- [SocialBot GenAI platform to analyze digital conversations and trends](/accelerators/#marketing|socialbot)
- [DemandIQ Predict trends accurately and optimize inventory management](/accelerators/sigmoid-demandiq/)
- [NetworkIQ Track and optimize logistics operations in real-time to quickly address disruptions](/accelerators/sigmoid-networkiq/)
- [SupplyIQ End-to-end platform to optimize supply chain operations](/accelerators/sigmoid-supplyiq/)
- [ProcurementIQ Automated procurement operations for maximum savings, compliance and efficiency](/accelerators/sigmoid-procurementiq/)
- [RapidML Accelerated deployment for machine learning models](/accelerators/sigmoid-rapidml/)
- [DataGuard Comprehensive platform for proactive data quality management](/accelerators/data-quality-tool-sigmoid-dataguard/)
- [CloudPulse Cloud cost optimization platform with multi-cloud management](/accelerators/sigmoid-cloudpulse/)
- [RAPID GenAI foundation with built-in governance and cost clarity](/accelerators/sigmoid-rapid/)
- [AnalyticsBot GenAI based platform to streamline decision-making in analytics](/accelerators/sigmoid-analyticsbot/)
- [DataConnect Seamlessly ingest, integrate and harmonize data from diverse sources](/accelerators/sigmoid-dataconnect/)
- [Reconica AI-powered data harmonization and reconciliation engine](/accelerators/sigmoid-reconica/)
- [ConverseBot GenAI driven insights generation for automated insights from reports](/accelerators/#sales|conversebot)
- [iNRM Cross-lever revenue growth optimization platform](/accelerators/sigmoid-inrm/)
- [AssortmentIQ Optimize shelf layouts and assortment mix at scale with AI-based insights](/accelerators/sigmoid-assortmentiq/)
- [Read Whitepaper](/ebooks-whitepapers/building-agentic-ai-chatbots-for-business-process-transformation/)
- [Listen Podcast](/events/podcast/how-jack-in-the-box-is-redefining-personalization-and-supply-chain-with-ai/)
- [Blogs](/blogs/)
- [White Papers](/ebooks-whitepapers/)
- [Case Studies](/case-studies/)
- [Podcast](/events/podcast/#Podcasts)
- [Read Blog](/blogs/the-genai-adoption-triad-responsibility-ethics-and-explainability/)
- [ConverseBot](/accelerators/#sales|conversebot/)
---
## Footer Links
- [Talk to our AI experts](/contact-us/)
- [AI Strategy](/enterprise-ai-strategy/)
- [Agentic AI](/agentic-ai-solutions/)
- [Generative AI](/generative-ai/)
- [AI Managed Services](/ai-managed-services/)
- [Responsible AI](/responsible-ai-in-enterprise/)
- [Advanced Analytics](/advanced-data-analytics-solutions/)
- [Data Strategy](/data-analytics-strategy//)
- [Data Engineering](/data-engineering/)
- [Data Management](/ai-data-management-services/)
- [Cloud Transformation](/cloud-transformation/)
- [Data Ops](/data-devops/)
- [Data Visualization](/data-visualization-service/)
- [Automated Insights](/automated-insights/)
- [BI Migration](/bi-migration/)
- [Data Modeling](/data-modeling-services/)
- [Data Observability](/data-observability/)
- [CPG & Retail](/industries/cpg-analytics/)
- [Financial Services](/industries/banking-financial-analytics-services/)
- [Life Sciences](/industries/life-sciences/)
- [Case Studies](/case-studies/)
- [Thought Leadership](/ebooks-whitepapers/)
- [Blogs](/blogs/)
- [Company](/about-sigmoid/)
- [Newsroom](/newsroom/)
- [Accelerators](/accelerators/)
- [Careers](/careers/)
- [Privacy Policy |](/privacy-policy/)
- [Cookie Policy](/cookie-policy/)