{"id":3908,"date":"2023-11-10T05:14:45","date_gmt":"2023-11-10T05:14:45","guid":{"rendered":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/?p=3908"},"modified":"2025-11-18T08:12:08","modified_gmt":"2025-11-18T08:12:08","slug":"modern-data-architecture-and-reporting-merchants-fleet","status":"publish","type":"post","link":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/","title":{"rendered":"Merchants Fleet Fuels Growth With Modern Data Architecture and Reporting"},"content":{"rendered":"

Merchants Fleet, North America\u2019s fastest-growing fleet management company, provides customized fleet management, fleet leasing, and mobility solutions to organizations across the United States. They recognized the value of a data- and analytics-focused partner with end-to-end expertise and sought a consulting partner to improve the quality of their data and analytics initiatives. Merchants Fleet selected Wavicle as a forward-looking partner to help them build future-proof data architecture, reporting, and data models to support their business.<\/p>\n

A growing organization with the need to modernize and scale<\/span>\u00a0<\/span><\/h2>\n

In recent years, Merchants Fleet has experienced massive growth. They needed to rapidly scale operations to keep up with high demand, overcome supply chain challenges that have impacted their ability to bring in new vehicles, and find new ways to leverage their data to maintain their competitive edge in the fleet management industry. Simultaneously, they needed to demonstrate their strong financial standing to investors and internal finance teams, which must be done in compliance with strict regulatory standards.<\/p>\n

Merchants Fleet engaged with Wavicle to modernize their data infrastructure and reporting capabilities. Throughout this process, the Merchants Fleet team has had several key priorities:<\/p>\n

    \n
  • To ensure reliable, secure reporting for investors and internal finance teams that is compliant with financial regulations<\/span><\/li>\n
  • To streamline data infrastructure with standardized pipelines and reporting for smoother operations and faster insights<\/span><\/li>\n
  • To achieve their data goals in a cost-effective way by leveraging Wavicle\u2019s flexible onshore and offshore consulting model<\/span>\u00a0<\/span><\/li>\n<\/ul>\n

    Modernized data infrastructure and reporting<\/h2>\n

    Wavicle\u2019s data and analytics consultants have executed the hands-on work to build and maintain Merchants Fleet\u2019s analytics and reporting layer as they migrate to the latest version of Odessa\u2019s lease management system. Because the migration has impacted all of Merchants Fleet\u2019s data pipelines, Wavicle\u2019s team has focused heavily on building pipeline data architecture into Snowflake. This also includes migrating all of their SQL Server Reporting Services (SSRS) reporting landscape to Power BI to provide more flexibility and scalability in the reporting processes.<\/p>\n

    Wavicle\u2019s consultants also executed several additional projects to track and report on all aspects of Merchants Fleet\u2019s last-mile rental business, accurately track vehicle availability, and provide greater insight into financial data by building reports for profit KPIs, sales commissions, and toll violation billing. These reports have given Merchants Fleet\u2019s leadership greater insight into the business, allowing them to stay ahead of challenges and continue to grow their business in a responsible manner.<\/p>\n

    One added bonus of Merchants Fleet\u2019s new, deeper reporting capabilities is the opportunity to develop and sell new telematics products to their customers, generating additional revenue for the business. Wavicle\u2019s consultants have built new data models and reports for Merchants Fleet\u2019s TotalConnect solution, which provides their customers with additional analytics that help them better manage their fleets and drivers. For example, Wavicle\u2019s team created driver behavior analytics dashboards that allow fleet managers to monitor telematics data for their drivers. These dashboards enable them to track driver behaviors \u2013 including seatbelt use, speeding, harsh breaking, and taking severe corners \u2013 and offer incentives to top drivers. With tools like this, Merchants Fleet can provide a better service to their customers and increase their revenue streams.<\/p>\n

    A modern data environment that facilitates continued growth\u00a0<\/span>\u00a0<\/span><\/h2>\n

    With Wavicle as a partner at every step along the way, Merchants Fleet is in a better position to meet their data and analytics goals, as well as their business goals. With a deep data and analytics focus, Wavicle has been the partner Merchants Fleet needed \u2013 which led to them increasing their scope with Wavicle\u2019s team by 10x after the first year of the partnership.\u00a0\u00a0<\/span>\u00a0<\/span><\/p>\n

    \"Merchant's<\/em><\/h4>\n

    While supporting Merchants Fleet\u2019s modernization, Wavicle has managed the organization\u2019s data pipelines to ensure they have secure, accurate reporting that complies with regulatory requirements. This has been critical for their investor activities and has enabled them to continue company growth and investment while undergoing a complex platform migration.\u00a0<\/span>\u00a0<\/span><\/p>\n

    Wavicle has also enabled the company to make more informed decisions for order management and their mobility business by arming them with comprehensive and reliable reports that include third-party data. This is a new level of visibility for Merchants Fleet, allowing them to continue to propel their business forward by identifying trends and opportunities across both demand and supply streams. With new data products in their inventory, they also have the opportunity to increase revenue and profits while providing better service to their customers.\u00a0<\/span><\/p>\n

    Through this ongoing partnership, Merchants Fleet has found the forward-looking data and analytics partnership they were initially seeking and has made significant progress towards their data analytics goals, supporting their business growth and profitability now and into the future.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    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":5237,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[77,88,83,54,72,117,110,101,73,95],"tags":[],"class_list":["post-3908","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-architecture-engineering","category-bi-reporting-visualizations","category-business-intelligence-insights","category-case-studies","category-data-management","category-matillion","category-power-bi","category-snowflake","category-data-strategy-assessments","category-technology","entry"],"acf":[],"yoast_head":"\nMerchants Fleet Accelerates Growth with Modern Data Architecture<\/title>\n<meta name=\"description\" content=\"See how Merchants Fleet leveraged modern data architecture and reporting to fuel growth and operational performance.\" \/>\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=\"Merchants Fleet Accelerates Growth with Modern Data Architecture\" \/>\n<meta property=\"og:description\" content=\"See how Merchants Fleet leveraged modern data architecture and reporting to fuel growth and operational performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/\" \/>\n<meta property=\"og:site_name\" content=\"Wavicle Data Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-10T05:14:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-18T08:12:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.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\/modern-data-architecture-and-reporting-merchants-fleet\/\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/\",\"name\":\"Merchants Fleet Accelerates Growth with Modern Data Architecture\",\"isPartOf\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.jpg\",\"datePublished\":\"2023-11-10T05:14:45+00:00\",\"dateModified\":\"2025-11-18T08:12:08+00:00\",\"author\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e\"},\"description\":\"See how Merchants Fleet leveraged modern data architecture and reporting to fuel growth and operational performance.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#primaryimage\",\"url\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.jpg\",\"contentUrl\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.jpg\",\"width\":1065,\"height\":930},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Merchants Fleet Fuels Growth With Modern Data Architecture and Reporting\"}]},{\"@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":"Merchants Fleet Accelerates Growth with Modern Data Architecture","description":"See how Merchants Fleet leveraged modern data architecture and reporting to fuel growth and operational performance.","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":"Merchants Fleet Accelerates Growth with Modern Data Architecture","og_description":"See how Merchants Fleet leveraged modern data architecture and reporting to fuel growth and operational performance.","og_url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/","og_site_name":"Wavicle Data Solutions","article_published_time":"2023-11-10T05:14:45+00:00","article_modified_time":"2025-11-18T08:12:08+00:00","og_image":[{"width":1065,"height":930,"url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.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\/modern-data-architecture-and-reporting-merchants-fleet\/","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/","name":"Merchants Fleet Accelerates Growth with Modern Data Architecture","isPartOf":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#primaryimage"},"image":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#primaryimage"},"thumbnailUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.jpg","datePublished":"2023-11-10T05:14:45+00:00","dateModified":"2025-11-18T08:12:08+00:00","author":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/#\/schema\/person\/dd7976fcb051bcb40f39bb51c8fbdd9e"},"description":"See how Merchants Fleet leveraged modern data architecture and reporting to fuel growth and operational performance.","breadcrumb":{"@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#primaryimage","url":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.jpg","contentUrl":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-content\/uploads\/2023\/11\/15295.jpg","width":1065,"height":930},{"@type":"BreadcrumbList","@id":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/case-studies\/modern-data-architecture-and-reporting-merchants-fleet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/"},{"@type":"ListItem","position":2,"name":"Merchants Fleet Fuels Growth With Modern Data Architecture and Reporting"}]},{"@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\/3908","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=3908"}],"version-history":[{"count":1,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3908\/revisions"}],"predecessor-version":[{"id":3910,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/posts\/3908\/revisions\/3910"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media\/5237"}],"wp:attachment":[{"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/media?parent=3908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/categories?post=3908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta74.thewebsitepreview.com\/wavicle\/dev\/wp-json\/wp\/v2\/tags?post=3908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}