{"id":3915,"date":"2023-10-30T09:29:39","date_gmt":"2023-10-30T09:29:39","guid":{"rendered":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?p=3915"},"modified":"2025-11-18T07:59:35","modified_gmt":"2025-11-18T07:59:35","slug":"accelerating-store-level-insight-pilot-company","status":"publish","type":"post","link":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/","title":{"rendered":"Accelerating Store-Level Speed to Insight for Pilot Company"},"content":{"rendered":"<h2 aria-level=\"2\">Pilot Company demands fast access to store-level inventory data<\/h2>\n<p><span data-contrast=\"none\">Pilot Company serves 1.3 million road warriors across the country each day with a mission to make the driving experience the best it can be. It is essential that this leading supplier of fuel and operator of travel centers optimizes the inventory in each of its locations to satisfy every customer profile, from the professional truck driver to the family traveler.<\/span><\/p>\n<p><span data-contrast=\"none\">That\u2019s why Pilot Company teamed with\u00a0<a href=\"https:\/\/wavicledata.com\/aws-cloud-migration-and-data-analytics-consulting\/\" target=\"_blank\" rel=\"noopener\">AWS Advanced Consulting Partner<\/a>\u00a0Wavicle Data Solutions to modernize its store-level reporting. Together, Wavicle and Pilot optimized the company\u2019s reporting solutions using Amazon Web Services (AWS) to provide store managers with the most updated information possible to track and manage inventory and ensure the right products are available when they are needed.<\/span><\/p>\n<h2 aria-level=\"2\">Slow data detours store managers<\/h2>\n<p><span data-contrast=\"none\">Pilot processes more than 30 different types of transactional files from point of sale (POS) systems at gas pumps, restaurants, and markets across more than 750 locations every day.<\/span><\/p>\n<p><span data-contrast=\"none\">Each night, this data was consolidated in an on-premises data warehouse so store-level reports could be sent back to store managers. These reports were needed to identify store trends, understand supply and demand, and make shelf-stocking decisions. However, the system was slow, and store managers didn\u2019t receive the reports quickly enough. In many cases, they would have already manually assessed inventory by the time they received the reports.<\/span><\/p>\n<h2 aria-level=\"2\">AWS powers fast data integration\u00a0\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"none\">Pilot Company knew that an AWS infrastructure would deliver the scalability and speed it needed. Pilot partnered with Wavicle, an AWS Advanced Tier Consulting Partner with a focus on cloud data and analytics solutions, for expert assistance to architect an improved solution.<\/span><\/p>\n<p><span data-contrast=\"none\">Wavicle worked with Pilot to architect a \u201cfuture-proof\u201d two-pronged solution built in the cloud from the ground up, giving store managers rapid access to insights through daily batch reports.<\/span><\/p>\n<p><span data-contrast=\"none\">The solution leverages an Amazon Aurora database along with AWS Glue, Amazon Kinesis, AWS Lambda, and Amazon Elastic Container Service (ECS), which deliver faster processing and self-service insights.<\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:60,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<h2 aria-level=\"2\">Results\u00a0<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"none\">This new solution accelerates Pilot\u2019s access to data and insights for decision-making and provides the scalability Pilot needs to bring new stores into the environment easily.<\/span><\/p>\n<p><span data-contrast=\"none\">Store managers now have two ways of managing store inventory and operations. A daily batch reporting solution provides inventory data delivered shortly after store closing time. In addition, a dashboard solution provides fast, self-service insights about store sales so managers can identify trends and anomalies quickly.<\/span><\/p>\n<p><span data-contrast=\"none\">Using AWS Managed Services, Pilot Company minimizes the maintenance demands and cost of the solution.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<h4 aria-level=\"2\">About Pilot Company<\/h4>\n<p aria-level=\"2\"><span data-contrast=\"none\">Pilot Travel Centers LLC (\u201cPilot Company\u201d) keeps North America\u2019s drivers moving as one of the leading suppliers of fuel and the largest operator of travel centers. Founded in 1958 and headquartered in Knoxville, Tennessee, Pilot Company has grown its network to more than 870 locations serving an average of 1.3 million guests per day and providing over 70,000 fleet customers with solutions for fuel, credit, factoring, services and rewards. Pilot Company has the third largest tanker fleet in North America with over 1,500 trucks that supply approximately 14 billion gallons of fuel per year and provide hauling and disposal services to the oil field sector. As a fuel and energy leader, Pilot Company is the largest provider of biodiesel and renewable fuels and is paving the way to the future by developing an EV charging network and low carbon fueling alternatives. Its Pilot and Flying J travel center network includes over 750 locations in 44 states and six Canadian provinces with more than 790 restaurants, 77,000 truck parking spaces, 5,500 deluxe showers, 6,300 diesel lanes and truck maintenance and tire service with Southern Tire Mart at Pilot Company. The One9 Fuel Network provides smaller fleets and independent professional drivers with a variety of fueling locations that offer everyday value, convenience, credit and perks. More information on locations and rewards is available in the myRewards Plus app.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p aria-level=\"2\"><span data-contrast=\"none\">Pilot Company is a majority owned subsidiary of Berkshire Hathaway. For additional information about Pilot Company, its 30,000 team members and commitment to giving back, visit\u00a0<a href=\"http:\/\/pilotcompany.com\/\" target=\"_blank\" rel=\"noopener\">pilotcompany.com<\/a>.<\/span><\/p>\n<h4 aria-level=\"2\">About Wavicle<\/h4>\n<p><span data-contrast=\"none\">Wavicle Data Solutions provides award-winning cloud data and analytics solutions that accelerate value, reduce risk, and empower our clients to make smart, data-driven decisions. We combine deep technical expertise and industry knowledge with proprietary automation tools to support the rapid shift to modern data architectures and real-time insights. Today\u2019s executives need more visibility into their businesses, faster than ever, and we help them get it. Founded in 2013 and headquartered in Chicago, Wavicle has been recognized as an Inc. 5000 company four years running and is a multi-year recipient of the Chicago Tribune\u2019s Top Workplace award. Wavicle is also an NMSDC-certified MBE. For more information, visit <a href=\"http:\/\/wavicledata.com\">wavicledata.com<\/a>.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><\/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":5228,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[148,146,145,144,77,141,133,76,54,72,55,95],"tags":[],"class_list":["post-3915","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-amazon-qldb","category-aws-redshift","category-amazon-s3","category-amazon-sagemaker","category-architecture-engineering","category-aws","category-aws-lambda","category-build-migrations","category-case-studies","category-data-management","category-industry","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>Pilot Company Boosts Store-Level Speed to Insight<\/title>\n<meta name=\"description\" content=\"Explore how a pilot company accelerated store-level insights to improve operational responsiveness and decision-making.\" \/>\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=\"Pilot Company Boosts Store-Level Speed to Insight\" \/>\n<meta property=\"og:description\" content=\"Explore how a pilot company accelerated store-level insights to improve operational responsiveness and decision-making.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/\" \/>\n<meta property=\"og:site_name\" content=\"Wavicle Data Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-30T09:29:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-18T07:59:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.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=\"4 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\/accelerating-store-level-insight-pilot-company\/\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/\",\"name\":\"Pilot Company Boosts Store-Level Speed to Insight\",\"isPartOf\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.jpg\",\"datePublished\":\"2023-10-30T09:29:39+00:00\",\"dateModified\":\"2025-11-18T07:59:35+00:00\",\"author\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e\"},\"description\":\"Explore how a pilot company accelerated store-level insights to improve operational responsiveness and decision-making.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#primaryimage\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.jpg\",\"contentUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.jpg\",\"width\":1065,\"height\":930},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Accelerating Store-Level Speed to Insight for Pilot Company\"}]},{\"@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":"Pilot Company Boosts Store-Level Speed to Insight","description":"Explore how a pilot company accelerated store-level insights to improve operational responsiveness and decision-making.","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":"Pilot Company Boosts Store-Level Speed to Insight","og_description":"Explore how a pilot company accelerated store-level insights to improve operational responsiveness and decision-making.","og_url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/","og_site_name":"Wavicle Data Solutions","article_published_time":"2023-10-30T09:29:39+00:00","article_modified_time":"2025-11-18T07:59:35+00:00","og_image":[{"width":1065,"height":930,"url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.jpg","type":"image\/jpeg"}],"author":"Data Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Data Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/","name":"Pilot Company Boosts Store-Level Speed to Insight","isPartOf":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#primaryimage"},"image":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#primaryimage"},"thumbnailUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.jpg","datePublished":"2023-10-30T09:29:39+00:00","dateModified":"2025-11-18T07:59:35+00:00","author":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e"},"description":"Explore how a pilot company accelerated store-level insights to improve operational responsiveness and decision-making.","breadcrumb":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#primaryimage","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.jpg","contentUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/10\/15629.jpg","width":1065,"height":930},{"@type":"BreadcrumbList","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/accelerating-store-level-insight-pilot-company\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/"},{"@type":"ListItem","position":2,"name":"Accelerating Store-Level Speed to Insight for Pilot Company"}]},{"@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\/3915","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=3915"}],"version-history":[{"count":1,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3915\/revisions"}],"predecessor-version":[{"id":3918,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3915\/revisions\/3918"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media\/5228"}],"wp:attachment":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media?parent=3915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/categories?post=3915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/tags?post=3915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}