Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Data Visualisation for Managers

﴾INFS6023﴿

Shop Online

Case Study: ShopOnline

ShopOnline

Ecommerce companies like Amazon, Alibaba, and eBay have changed the way the retail industry

does business. ShopOnline is an Ecommerce business that operates globally and focuses  primarily on gift items. ShopOnline collects data about every transaction made on its web shop.

Your Task

You have been hired as a consultant of ShopOnline to provide data‐driven insights to the senior management of the Ecommerce company.

Dataset information

The dataset provided contains data collected by ShopOnline in a one‐year period. The dataset is available on Canvas ﴾ShopOnline Data.xlsx﴿. The dataset consists of the following attributes:

Attribute

Description

InvoiceNo

A 6‐digit integral number uniquely assigned to each transaction. If this code starts with letter ’c’ it indicates a cancellation.

StockCode

A 5‐digit integral number uniquely assigned to each distinct product.

Description

Product item﴿ name

Quantity

The quantities of each product ﴾item﴿ per transaction

InvoiceDate

The day and time when each transaction was generated

UnitPrice

Product price per unit in AUD

CustomerID

A 5‐digit integral number uniquely assigned to each customer

Country

The name of the country where each customer resides