{"id":3925,"date":"2022-11-10T09:55:55","date_gmt":"2022-11-10T09:55:55","guid":{"rendered":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?p=3925"},"modified":"2025-11-18T08:28:22","modified_gmt":"2025-11-18T08:28:22","slug":"cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator","status":"publish","type":"post","link":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/","title":{"rendered":"Travel Center Operator Migrates to Cloud Data Warehouse for Accelerated Data Visualization"},"content":{"rendered":"<h4>On-premises data warehouse causes data traffic jam<\/h4>\n<p>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.<\/p>\n<p>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\u2019s on-premises data warehouse solution could no longer keep up with executives\u2019 growing appetite for analytics.<\/p>\n<p>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\u2019t getting data when they needed it.<\/p>\n<p>They knew it was time to shift to a \u201cfuture-ready platform\u201d that could be used for multiple types of workloads, from data ingestion and analytics to data science and machine learning.<\/p>\n<h4>Snowflake data warehouse fuels faster insights<\/h4>\n<p>The company teamed up with Wavicle Data Solutions, a Snowflake partner, to evaluate cloud data warehouse solutions and then help drive the cloud migration.<\/p>\n<p>The new environment includes an AWS S3 data lake, which now houses the ETL process, and a Snowflake data warehouse, which drives reporting.<\/p>\n<p>Wavicle delivered a four-part solution that included:<\/p>\n<ul>\n<li><b style=\"font-size: 20px;\">Proof of concept and benchmarking:<\/b><span style=\"font-size: 20px;\"> 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.\u00a0\u00a0<\/span><\/li>\n<li><b style=\"font-size: 20px;\">Data migration:<\/b><span style=\"font-size: 20px;\"> 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.\u00a0\u00a0<\/span><\/li>\n<li><b style=\"font-size: 20px;\">Data ingestion:<\/b><span style=\"font-size: 20px;\"> Migration of data ingestion jobs from original data warehouse into Snowflake environment.\u00a0\u00a0<\/span><\/li>\n<li><b style=\"font-size: 20px;\">Dashboard migration: <\/b><span style=\"font-size: 20px;\">Migration of 200+ Tableau dashboards from the original data warehouse environment to Snowflake.\u00a0<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>New solution paves the way for fast insights and data science use cases<\/h4>\n<p>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.\u00a0For 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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Migrated 550+ Tableau dashboards to QuickSight using EZConvertBI, achieving 80% automation, 60% time savings, and seamless collaboration under tight timelines and data constraints.<\/p>\n","protected":false},"author":2,"featured_media":5244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[145,77,141,88,76,87,83,54,69,72,64,101,99,95],"tags":[],"class_list":["post-3925","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-amazon-s3","category-architecture-engineering","category-aws","category-bi-reporting-visualizations","category-build-migrations","category-business-analytics","category-business-intelligence-insights","category-case-studies","category-cloud-infrastructure-modernization","category-data-management","category-platform-management","category-snowflake","category-tableau","category-technology","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Travel Operator Boosts Visualization with Cloud Migration<\/title>\n<meta name=\"description\" content=\"Travel center operator cuts dashboard load times from 40 to 5 minutes with cloud data warehouse migration.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Travel Operator Boosts Visualization with Cloud Migration\" \/>\n<meta property=\"og:description\" content=\"Travel center operator cuts dashboard load times from 40 to 5 minutes with cloud data warehouse migration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/\" \/>\n<meta property=\"og:site_name\" content=\"Wavicle Data Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-10T09:55:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-18T08:28:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1065\" \/>\n\t<meta property=\"og:image:height\" content=\"930\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Data Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Data Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/\",\"name\":\"Travel Operator Boosts Visualization with Cloud Migration\",\"isPartOf\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg\",\"datePublished\":\"2022-11-10T09:55:55+00:00\",\"dateModified\":\"2025-11-18T08:28:22+00:00\",\"author\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e\"},\"description\":\"Travel center operator cuts dashboard load times from 40 to 5 minutes with cloud data warehouse migration.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#primaryimage\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg\",\"contentUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg\",\"width\":1065,\"height\":930},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Travel Center Operator Migrates to Cloud Data Warehouse for Accelerated Data Visualization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/\",\"name\":\"Wavicle Data Solutions\",\"description\":\"and analytics consulting solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e\",\"name\":\"Data Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g\",\"caption\":\"Data Team\"},\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/author\/data-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Travel Operator Boosts Visualization with Cloud Migration","description":"Travel center operator cuts dashboard load times from 40 to 5 minutes with cloud data warehouse migration.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Travel Operator Boosts Visualization with Cloud Migration","og_description":"Travel center operator cuts dashboard load times from 40 to 5 minutes with cloud data warehouse migration.","og_url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/","og_site_name":"Wavicle Data Solutions","article_published_time":"2022-11-10T09:55:55+00:00","article_modified_time":"2025-11-18T08:28:22+00:00","og_image":[{"width":1065,"height":930,"url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg","type":"image\/jpeg"}],"author":"Data Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Data Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/","name":"Travel Operator Boosts Visualization with Cloud Migration","isPartOf":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#primaryimage"},"image":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#primaryimage"},"thumbnailUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg","datePublished":"2022-11-10T09:55:55+00:00","dateModified":"2025-11-18T08:28:22+00:00","author":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e"},"description":"Travel center operator cuts dashboard load times from 40 to 5 minutes with cloud data warehouse migration.","breadcrumb":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#primaryimage","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg","contentUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2022\/11\/9100.jpg","width":1065,"height":930},{"@type":"BreadcrumbList","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/cloud-data-warehouse-fuels-faster-insights-for-travel-center-operator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/"},{"@type":"ListItem","position":2,"name":"Travel Center Operator Migrates to Cloud Data Warehouse for Accelerated Data Visualization"}]},{"@type":"WebSite","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/","name":"Wavicle Data Solutions","description":"and analytics consulting solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e","name":"Data Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e23491a3af11f4a98f6410b9023b80c0675cb87552af0094392cf966c0311a96?s=96&d=mm&r=g","caption":"Data Team"},"url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/author\/data-team\/"}]}},"_links":{"self":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/comments?post=3925"}],"version-history":[{"count":1,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3925\/revisions"}],"predecessor-version":[{"id":3926,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3925\/revisions\/3926"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media\/5244"}],"wp:attachment":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media?parent=3925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/categories?post=3925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/tags?post=3925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}