The Road to Better Data

The Challenge: Data Availability You Can Drive Home

BigQuery Data Migration

Miles ahead of the competition, our customer is always seeking new ways to improve—it’s part of the reason why their customers keep coming back. What fuels their best-in-class service? Their data, including all the details of orders, shipments and loads supporting the supply chain. They were ready to improve the availability, accuracy and security of their data.

By migrating from an on-premises enterprise data warehouse to a cloud data warehouse like BigQuery, we could give better visibility and service to their customers and partners by:

• Providing near-real-time data to end users
• Pulling information into multiple reporting tools
• Scaling up storage to hold volumes of information
• Reducing latency time
• Enabling faster refreshes to under two hours
• Protecting personally identifiable information with row-level security

The resolution needed to optimize costs and security details and eliminate duplicate records while identifying useful data. They sought a serverless alternative capable of processing terabytes of data in seconds and petabytes within minutes. All without losing access to files on their legacy platform while transitioning. Enter TEKsystems.

Our Solution: Revving the Engine to Race Forward

Data Migration Plan and Testing for Google Cloud

During a pilot phase with the customer, they identified what they wanted in their data migration and data analytics. And we listened. Because of our 15-year relationship with the customer and our expertise as a Google Cloud Premier Partner, we rolled up our sleeves and got right to work. With a strategy driven by BigQuery, optimization and data modeling, we reviewed their enterprise data warehouse and performed an analysis to ensure all resources were available. We prepared a project backlog and a migration plan, including a migration pilot to test our theories.

BigQuery would boost their processing speed, as a column-based storage service would eliminate evaluating data, row by row. Instead, our customer could look at specific columns they wanted to target. Another benefit? Cost optimization. By implementing BigQuery, they could assess use cases to avoid redundant storage, have additional backup of data sets and use streaming to assist in real-time analytics.

Powerful Partnership: Keeping Our Customer in the Driver’s Seat

Communication, Collaboration and Troubleshooting for Better Data

Productivity, focus, optimization—we’re in it together. We worked in tandem with our customer through daily standup meetings and monthly steering committee meetings. We provided them flexibility to ensure the results met their needs. Our close collaboration enabled our customer to organize and transfer data quickly and efficiently with no downtime for end users.