WM9QA-15 Supply Chain Digitisation and Data Analytics Report Individual Assignment Brief 2025 | University of Warwick

WM9QA-15 Assessment brief

General Instructions:

1. You must include relevant visual information and Tableau output where applicable.
2. You should state your assumptions and justify your choice of distributions and tests you have used.
3. You should use Tableau for Tasks 1-4. You are free to confirm your analysis with more sophisticated tools, BUT extra marks will NOT be awarded.

Overview

Critically analyse the dataset of US_1_Retail.xlsx to derive insights into supply chain performance, identify key trends, and make data-driven recommendations for improving supply chain efficiency and effectiveness.

WM9QA-15 Task 1: Data Cleaning and Preparation (10%)

Q.1 The dataset “US_1_Retail.xlsx” includes sales data, inventory levels, and other relevant information. The data set will contain noise and missing values.

a.You are required to clean and prepare the data for analysis. 
b.Document the steps you took to handle noise and missing values. 

The deliverable in this aspect is a cleaned data set with a brief report detailing your data-cleaning process.

WM9QA-15 Task 2: Descriptive Analytics (30%)

Q.2 Perform descriptive analytics on the cleaned data set. 

a.Generate summary statistics, visualisations, and key performance indicators (KPIs) relevant to the supply chain. 
b.Interpret the findings from task 2a.

WM9QA-15 Task 3: Predictive Analytics and Demand Forecasting (30%)

Q.3

a.From the data set US_1_Retail.xlsx you are required to use at least two methods, including one machine learning technique, to forecast demand. 

b.Compare and contrast the methods used detailing the forecasting methods and results. Provide a critical comparison of their effectiveness. Include visualisations of the forecast results.

WM9QA-15 Task 4: Customer Analysis and Digital Transformation Implementation Plan (30%)

Q.4

a.Based on your understanding of the module and your completion of tasks 1,2, and 3, you are required to critically discuss the expected benefits and potential advantages and challenges/risks of implementing digital technologies in the selected organisation’s supply chain.

b.You are required to develop a comprehensive plan for implementing digital technologies in the organisation’s supply chain. 

Module Learning Outcomes of WM9QA-15:

L1. Demonstrate comprehension of technologies shaping supply chain digitisation, including but not limited to blockchain, artificial intelligence, machine learning, and the Internet of Things (IoT).

L2. Align digital strategies with organisational goals, manage change effectively, and foster innovation within the supply chain context.

L3. Evaluate the choice of analytical tools depending on the specific needs and scale of the complexity of supply chain analytics tasks.

L4. Apply data analytics techniques to solve complex supply chain challenges to enhance operational efficiency, mitigate risks, and capitalise on emerging opportunities.

L5. Present and communicate complex data insights and analytical findings and suggest actionable recommendations to diverse stakeholders in a supply chain.