Optimised supply chain performance visibility with Tableau
PACCAR Parts Europe
- Customer case
- Data projects
- Data Analytics
PACCAR Parts Europe (PPE), a sister company of DAF Trucks, is responsible for supplying truck parts to all DAF Trucks dealers across Europe. To achieve this, PPE operates a sophisticated supply chain network throughout Europe. Currently, PPE is developing a Supply Chain Control Tower—a platform that provides full transparency of all logistical movements from supplier to dealer.
Recently, PPE took significant steps toward achieving comprehensive visibility in their supply chain. The initial step involved mapping out transport routes and assessing carrier performance from distribution centers to dealers. While the system to generate these insights was technically implemented with the help of an external service provider, PPE also needed a tool to visualise carrier performance through intuitive dashboards.
PPE sought our assistance to visualise the transport process using Tableau dashboards, integrate the data into their existing systems, and create a comprehensive solution.
Approach
To address PPE’s needs, we collaborated closely with the Logistics Innovation and Operations Support department, specifically joining forces with the Reporting & Analytics team. Our goal was to develop a set of five dashboards in Tableau that would display crucial performance metrics, tracking each package from a high-level overview down to the individual package details.
Here’s how we approached it:
Forming the structure: We worked with the AWS team to design the structure of the dashboards, discussing how to organise the data effectively. This ensured real-time updates and a consolidated view of all parts in transit.
Defining requirements: We conducted detailed discussions with stakeholders from the Transport department to refine their rough requirements into essential, actionable needs.
Connecting data sources: We identified and integrated all necessary data fields to provide comprehensive insights. This involved translating end-user metrics into calculations and graphs, clarifying terms like: delivery timelines, delays, reasons for delays and carrier performance.
Designing the dashboards: We created comprehensive dashboards in Tableau that started with a high-level overview of logistics operations and allowed users to drill down to the performance of individual packages. These dashboards enabled stakeholders to monitor performance effectively and make data-driven decisions.
Continuous feedback: Through iterative demo sessions with end users, primarily the Transportation team, we gathered continuous feedback and made necessary adjustments. This collaborative process ensured the dashboards met user needs effectively.
Result
The dashboards are now live and actively used by PPE’s end users, giving them handy and valuable insights and feedback on their carrier’s performance. Prior to this solution, users relied on Excel spreadsheets and signals from the dealers or carriers for insights. Now, they benefit from:
- Improved visibility of the supply chain to monitor and evaluate the delivery process.
- Ability to dynamically analyse and zoom into details of the carrier’s performance them selves.
- A reliable method to evaluate carrier performance.
- A single, centralised source of truth.
Overall, this solution supports PPE’s strategic goal of achieving comprehensive supply chain visibility: operations can be streamlined and the overall efficiency and reliability of their logistics network is improved.
Future
Looking ahead, PPE plans to become much more data-driven. They want to integrate more data and expand the capabilities of dashboards. In this way, PPE wants to further optimise supply chain management and operational efficiency.
Want to know more?
Jonathan will be happy to talk to you about what we can do for you and your organisation as a data partner.
Account Manager+31(0) 20 308 4390+31(0) 6 4150 4041jonathan.oversteegen@digital-power.com
Receive data insights, use cases and behind-the-scenes peeks once a month?
Sign up for our email list and stay 'up to data':
You might find this interesting too:
Implementation of e-commerce tracking for Google Analytics 4
MS Mode & America Today used Universal Analytics (UA) for analysing their online stores. They had fully implemented e-commerce tracking, with KPIs such as transactions, average order value, and abandoned shopping carts visualised in Looker Studio.
Future-proof migration to GA4
From 1 July 2024, it will no longer be possible to process data in Universal Analytics 360 (hereinafter: UA360). Wehkamp collected data in UA360 and was keen to be prepared in time for the migration. In addition, they wanted to collect at least 1 year of historical data for UA360's sunset. This allowed Wehkamp to compare the data in UA360 and in GA4. A key desire was to migrate the measurements as-is.
Third-party cookies: should I stay, or should I go?
In recent months there has been a lot to do about third-party cookies and their not-so-imminent-anymore end-of-life in the Google Chrome browser. Is this then much to do about nothing or should you brace yourself for a paradigm-changing shift? In this article we will lift the veil over this important topic. Also, we’ll share 7 hands-on tips to prepare yourself for what’s coming.
Transitioning from Universal Analytics 360 to Google Analytics 4 and Streamlining Data Analysis
There are currently a lot of developments surrounding Google Analytics, including user privacy (GDPR) and the sunset of Universal Analytics. For Miele X, the digital branch of Miele, GA4 was also one of the topics on their agenda as part of their bigger plans towards a more privacy-centric and vendor-agnostic way of data collection. They enlisted our help to support them with the transition from Universal Analytics 360 to GA4.
The proven added value for Fietsvoordeelshop
Fietsvoordeelshop has seven physical stores and a webshop. It is one of the most successful bike shops at the moment. In the field of data, the bicycle shop mainly worked with Excel. This means that a lot was done manually, every week. Due to the growth of the organisation and the increasing number of processes, the Excel file became increasingly large and unclear. Fietsvoordeelshop asked us to demonstrate with a data pressure cooker of five days that data-driven work could be of added value.
A standardised way of processing data using dbt
One of the largest online shops in the Netherlands wanted to develop a standardised way of data processing within one of its data teams. All data was stored in the scalable cloud data warehouse Google BigQuery. Large amounts of data were available within this platform regarding orders, products, marketing, returns, customer cases and partners.
Optimisation of marketing activities through an integrated dashboard
Valk Digital, an internet company, aimed to adopt a more data-driven approach. The marketing team was already discussing all the data weekly using an Excel spreadsheet, but due to manual data input, it was time-consuming and more likely to fail. There was a need for an automated, future-proof approach based on reliable data.
Optimal user experience for Memoriam Platform
KWF is a Dutch charity dedicated to fighting cancer. The organisation was working on the development of a Memoriam Platform. This is a new initiative to create personalised memorial pages for the deceased. On these pages, donations can be made to KWF.