To start this segment, watch the video in which Vivek walks you through the dataset, explaining each column and outlining the main objective of the analysis.
From the video, you learned that the main variables for analysis are cost and delivery time. The dataset contains detailed information about the orders.
The dataset used in this demonstration is provided below. There are a few questions embedded within the segment, so it is recommended that you explore the dataset alongside the video to attempt these questions effectively.
Below is another dataset containing sales information from the Superstore. It includes details about customers and product categories for each order. This dataset will also be used to solve the in-segment questions in this module.
We also have logistics data from an e-commerce company. The data dictionary explained in the video is provided below for reference.
Each combination of origin and destination cities represents a unique shipping route. The goal is to optimise both the average logistics cost and the average delivery time for these routes. Direct optimisation is not possible with the existing columns, so additional columns will need to be derived and aggregations performed to address this problem.
In the next segment, you will learn how to use sorting and filtering techniques in Excel.