Let's Talk

Amazon S3
AWS

Travel Center Operator Migrates to Cloud Data Warehouse for Accelerated Data Visualization

On-premises data warehouse causes data traffic jam

A nationwide operator of truck stops and travel centers is getting smarter about its business by accelerating the delivery of data and insights to its leadership.

This data-driven organization relies on hundreds of dashboards to inform decision-making in all areas, from finance to store management to logistics. But as the company and its offerings grew, so did the data volumes. The company’s on-premises data warehouse solution could no longer keep up with executives’ growing appetite for analytics.

The data warehouse was used for both ETL and reporting purposes, which competed for resources and connections. Data ingestion performance suffered when running concurrently with analytics jobs. As a result, dashboards took longer and longer to render, and executives weren’t getting data when they needed it.

They knew it was time to shift to a “future-ready platform” that could be used for multiple types of workloads, from data ingestion and analytics to data science and machine learning.

Snowflake data warehouse fuels faster insights

The company teamed up with Wavicle Data Solutions, a Snowflake partner, to evaluate cloud data warehouse solutions and then help drive the cloud migration.

The new environment includes an AWS S3 data lake, which now houses the ETL process, and a Snowflake data warehouse, which drives reporting.

Wavicle delivered a four-part solution that included:

Proof of concept and benchmarking: A 4-week POC evaluated two cloud data warehousing platforms for their ability to run ingestion and analytical jobs concurrently, meet runtime and workload performance SLAs for big SQL queries, and improve performance of ingestion jobs. We presented findings that pointed to Snowflake as the best option when balancing cost and performance priorities.
Data migration: Migration of 40 Terabytes of historical data from the cloud data lake into 400+ data warehouse tables in Snowflake, most of which are synced three to four times per day.
Data ingestion: Migration of data ingestion jobs from original data warehouse into Snowflake environment.
Dashboard migration: Migration of 200+ Tableau dashboards from the original data warehouse environment to Snowflake.

New solution paves the way for fast insights and data science use cases

By migrating to a cloud solution and separating the data ingestion and analytics jobs into different environments, this solution meets business SLAs for performance, run times, and data delivery. For example, dashboards that once took 40 minutes to render now are ready within five minutes. Across the organization, business leadership gets analytics and insights when they need it.

SERVICES

SOLUTIONS

PARTNERS

FEATURED SOLUTIONS

RETAIL

Retail​

HEALTH & WELLNESS

Healthcare

MANUFACTURING

Manufacturing​

COMPANY

News

Behind the Badge: A New Milestone in Our Microsoft Data & AI Journey

CAREERS

CASE STUDIES

INSIGHTS

Travel Center Operator Migrates to Cloud Data Warehouse for Accelerated Data Visualization

On-premises data warehouse causes data traffic jam

Snowflake data warehouse fuels faster insights

New solution paves the way for fast insights and data science use cases

Related Posts

Global Packaging Material Manufacturer Streamli...

Global QSR Chain Strengthens Data Governance by...

Modernizing ESG Data for Resilience and Compliance

Healthcare Company Optimizes Cloud Costs in Pre...

Seamlessly Migrating 550+ Dashboards from Table...

Seamlessly Migrating 550+ Dashboards from Table...

Global Digital Platform Migrates from Tableau t...

Manufacturer Transforms Forecasting Process Wit...

Ensemble Health Partners Modernizes Data Govern...

Standards Body Centralizes Supply Chain Data to...

U.S. Air Force Leverages Wavicle’s EZConvertBI ...

International Manufacturer Leverages Wavicle’s ...

Greenhouse Grower Improves Yield Predictions Th...

Rail Technology Services Provider Upgrades Anal...

Global Automotive Supplier Modernizes Reporting...

Retail Company Overhauls Data Strategy for Cent...

Greenhouse Grower Modernizes Data and Insights ...

Major Home Builder Leverages Snowflake to Catal...

Home Builder Leverages Data Strategy and Govern...

QSR Improves Sustainability Initiatives With Ac...

Pharmaceutical Company Leverages a Strategic Da...

International Coffee Chain Modernizes Business ...

Hotel Chain Enhances Customer Insights With Dev...

How Pilot Company is Reducing Costs, Accelerati...

Pilot Company Transforms Data Ecosystem to Unif...

Healthcare Product Supplier Launches Feature St...

Merchants Fleet Fuels Growth With Modern Data A...

Medical Equipment Manufacturer Saves Millions o...

Accelerating Store-Level Speed to Insight for P...

Automotive Supplier Leverages Data Modernizatio...

Increasing Production by 100x Through Digital T...

QSR Maximizes Franchise Performance Using BI Vi...

Manufacturer Unlocks Growth With Unified Custom...

Automotive Retailer Modernizes Data Management ...

Global Manufacturer Gets Faster Insights With S...

Global Electronics Manufacturer Saves Millions ...

Global Manufacturer Overhauls Data Practices wi...

Auto Retailer Uses Azure Cloud-Native Applicati...

Accelerated Data Validation With Wavicle’s Data...

Major Insurer Transforms Operations With Modern...

Retail/CPG Leader Accelerates Data Pipeline to ...

Vyaire Medical Gets Global Sales, Inventory, an...

Travel Center Operator Accelerates Access to Da...

Managed Services Organization Modernizes its Da...

New Ordering System Uses Machine Learning to Op...

Global QSR Uses Micro-Segmentation to Improve C...

Modernizing ESG Data for Resilience and Compliance

Master Data Management Delivers Single View of ...

For a Global Quick-Service Restaurant, Improvin...

Electronics Manufacturer Optimizes Global Logis...

Modernizing ESG Data for Resilience and Compliance

Global QSR Accelerates Migration from Legacy ET...

Integrated Procurement Analytics Platform Drive...

Cloud Migration Brings Agility and Innovation t...

Intuitive POS Data Mart Drives Smarter Analyst ...

Post-Merger Data Consolidation Reduces Reportin...

Global QSR Orders Up Fast Data-Driven Solutions

A Major QSR Optimizes Food Delivery Performance...

Retail

Manufacturing