endorsedCompleted

Google Cloud Migration Consultation for Aviation Analytics Firm

Services Covered:

Cloud Consulting and Services • Cloud-Native Application Development • Big Data Analytics and Business Intelligence • DevOps

Industry

Aviation

1 month

Budget

Less than 10K

Start Date

1 February 2021

Team Size

1-5

Engagement Model

Offshore

Project Capability Score (PCS)

71/100

Good

Project Capability Score (PCS) estimates how capable D3V Technology Solutions is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Visual Approach Analytics

McKinney, United States of America

Project Summary

An aviation analytics firm engaged D3V Technology Solutions for guidance on migrating growing data warehouses and ETL pipelines to Google Cloud. D3V’s consultant (Steve) provided architecture and best-practice recommendations for BigQuery, Python-based data loading, ETL processes, hosting options, and budgeting. The client launched several new ELT processes based on those recommendations; the engagement was described as seamless, cost-effective, and productive.

Key Challenges

Move growing data warehouses and ETL pipelines to the cloud
Obtain expert insight and architecture design for cloud migration and ETL best practices

Project Deliverables

Cloud architecture and ETL design recommendations
Best-practice guidance for BigQuery and Python-based data loading
Recommendations for hosting (Flask app vs. virtual server) and budgeting
Implementation guidance enabling new ELT processes

Project Solution

D3V provided in-person consultation and architecture guidance focused on migrating data workflows to Google Cloud. The consultant reviewed the client's existing BigQuery usage and custom Python loading scripts, advised on BigQuery best practices and ETL design, discussed hosting options for a potential Flask app versus a virtual server, and offered budgeting recommendations. The engagement consisted primarily of expert recommendations and implementation guidance delivered by a senior consultant (Steve).

Project Outcome

Launched several new ELT processes based on recommendations
ELT processes proved cost-effective and productive
Seamless collaboration that improved the client's understanding of architecture and limitations

Platforms

Cloud
Web

Tech Stack

Python
Flask
Google Cloud Platform (GCP)

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

Following suggestions from D3V Technology Solutions, we got several extract/load/transform (ELT) processes up and running. Working with them was smooth, cost-effective, and productive. We also noticed how much they cared about making sure we understood each other.
Courtney Miller
Managing Director & CEO
Date: 05/11/2021