Your Privacy

This site uses cookies to enhance your browsing experience and deliver personalized content. By continuing to use this site, you consent to our use of cookies.
COOKIE POLICY

Data & Analytics

Building a Foundation for Turning KPIs Into Powerful Decisions for Western Express

Building a Foundation for Turning KPIs Into Powerful Decisions for Western Express

After a tornado devastated Western Express’s three-building headquarters — and the data they relied on for essential fleet decisions — the company had to act fast. They needed to put disaster recovery plans into action and had to do so against the backdrop of a quickly and severely emerging global pandemic. Facing these disruptions amidst increasing, evolving competition, Western Express recognized the urgency to  improve the robustness around how they capture, manage, and analyze data. Requiring strong foundation, they turned to UDig to help them build a powerful data engine to enable them on their data journey. 

How We Went from Ideas to Impact

  • “They have set up the back end of the KPI dashboard really well! It’s fast and easy to understand, and it helps us build historical data where we previously had none.”

The Idea

Data Rich But Information Poor

For truckload carriers with large fleets, data is central to keeping operations humming. From knowing each truck’s location to tracking efficiency and beyond, data drives a day’s work. Western Express captured vast amounts of data on their fleetswhich were rapidly growingOver the years, a team of highly capable power users were supporting them well by extracting information from their data. However, the loss of their headquarters disrupted this process. Further, the increasingly competitive business environment that the pandemic created was challenging their ability to keep up with information demands.  

The technology team had many pressing obstacles to overcome, such as:  

  • Many manual and time-draining processes that dragged down productivity 
  • Existing reporting tools that burdened production systems 
  • Some key operational metrics that were difficult to monitor 

Since Western Express relied on having near real-time data updates to know crucial details around truck profitability and efficiencythey had no time to waste. They knew they needed a better way to turn their data into information by reducing maintenance burdens and enabling greater agility. Responding to the pandemic’s changing business environment while rebuilding their headquarters and supporting faster, more accurate reporting and analysis was crucial to their future. 

The Process

A Robust, Foundational Data Platform

To start their journey, we analyzed their current data infrastructure to identify what worked and where gaps existed. While Western Express had some direction for an enterprise data warehouse, they now needed help making architectural decisions. The goal was to serve today’s operational information needs  while building a foundation for future growth. To do so, our team began building the data warehouse’s core components. Meanwhile, we worked closely with our client’s data team to ensure that they could deliver key operational reports atop the new warehouse framework.

Our aim was to build from that platform and design:  

  • A data warehouse that creates a foundational structure to support future business decisions 
  • A system to capture historic data and enable faster, more accurate reporting 

Collaboration was central to our delivery model and success. 

The Western Express team included skilled professionals who could do all end-user visual reporting in-house. So, we created a collaborative process: They supported the analytics, and we built the data platform. Together, we were able to build the solution they needed while optimizing everyone’s capabilities. 

Training enabled them to stand on their own. 

Another goal was to ensure that their data team had the capabilities to support, expand, and enhance their new data platform. So, we delivered training sessions that passed on essential knowledge and documentation to educate their team on the platform. Rather than leave Western Express with a bundle of code, this training helped ensure that they gained the knowledge and confidence to support the platform. 

The Impact

A Strong Foundation That Drives Momentum for Tomorrow 

In every step, our goal was to leave them better — and positioned for the future. 

Today, Western Express has a reliable foundation that delivers key operational data in near realtime visualizations directly to their business users for analysisThe current platform informs Western Express’ daily operations and empowers them with the ability to grow it as business needs progress and evolve. They’re now able to do timesensitive tracking of miles by each truck and team, and plan for drivers to get home on schedule. They can also quickly perform analysis on historical data while analyzing crucial operational KPIs to allow for faster, more informed decisionsFrom the devastation of their headquarters amidst a global pandemic, Western Express has emerged as a competitive, data-driven organization prepared for the future. Now, they can drive business forward, no matter what the road brings their way.

  • How We Did It
    Assessment and RoadmapData EngineeringData ModelingDevelopment Process ModernizationWarehouse Acceleration
  • Tech Stack
    SQL ServerSQL Server Integration Services (SSIS)DB2

Digging In

  • Insurance

    Insurtech Insights USA 2024: Recap & Key Takeaways

    This was my first time attending Insurtech Insights USA The Insurance Conference 2024.  With over 5,000 attendees and 120 sessions with speakers from insurtechs, brokers, carriers, and MGA’s, the event highlighted the industry’s readiness to embrace new tech and solve challenging problems. My colleague, Reid Colson, and I were there to meet with clients and industry […]

  • Artificial Intelligence

    Capitalizing the AI Wave to Advance Data Governance

    AI is everywhere and getting a lot of attention, but you can’t successfully leverage AI without good data. You can use the buzz around AI to advance your data governance capabilities. Join us as we explore the intersection of AI and Data Governance.

  • State Government

    NASCIO Midyear Conference | 4 Key Takeaways

    I attended the National Association of State CIO (NASCIO)’s Midyear Conference for the first time in National Harbor, Maryland. It was my first time at a NASCIO event, and what struck me most was how collaborative the NASCIO community is and how passionate these leaders are about serving their state’s constituents and employees.   Each […]

  • Insurance

    Leveraging Data, Analytics, & AI in Insurance

    Join Rob Reynolds, Vice President & Chief Data & Analytics Officer at W.R. Berkley Corporation, Lloyd Scholz, Chief Technology Officer at Markel, and Reid Colson, EVP of Consulting at UDig and former Chief Data & Analytics Officer at Markel, to get an insiders’ view on how insurers are future-proofing their firms through data, analytics and AI. This practical discussion will leave attendees with an understanding of how to drive value through data. While focused on insurance, the perspectives shared in this call apply beyond insurance firms. If you are looking to get more out of your data, this discussion is for you.

  • People

    Digging In with Kevin Cox, Principal Consultant

    Digging In is a regular series of blog posts profiling UDig employees.  We hope this series helps you get to know our team and understand why we dig what we do! Today, we are sitting down with Kevin Cox, Principal Consultant, Data & Analytics.   UDig: Tell us a little bit about your background and your […]

  • Insurance

    Designing a Data Consolidation Strategy for a Fast-Growing Insurance Brokerage Company

    Fast growth made an insurance brokerage company realize they needed a data consolidation strategy to better organize and protect their data.

  • Data & Analytics

    Unlocking the Full Potential of a Customer 360: A Comprehensive Guide

    In today’s fast-paced digital economy, understanding your customer has never been more critical. The concept of a customer 360 view has emerged as a revolutionary approach to gaining a comprehensive understanding of consumers by integrating data from different touchpoints to offer a holistic view.  A customer 360 view is about taking an overarching approach to […]

  • Data & Analytics

    Microsoft Fabric: A New Unified Data Platform

    MicroPopular data services and tools often specialize in specific aspects of the data analytics pipeline, serving teams in the data lifecycle. For instance, Snowflake addresses large-scale data warehousing challenges, while Databricks focuses on data engineering and science. Power BI and Tableau have become standard tools for business intelligence tasks. So, where does Microsoft Fabric create […]

  • Artificial Intelligence

    How Prompt Engineering Impacts the Deployment of AI

    The integration of artificial intelligence (AI) within enterprise operations marks a significant shift towards more efficient, informed decision-making processes. At the heart of this transformation is prompt engineering — a nuanced approach that plays a pivotal role in optimizing AI model interactions. This post explores the intricate framework of prompt engineering, outlines the structures of […]