Problem Solving and Digital Operations Analysis 2022

Data Analysis, Problem
Solving and Digital
Operations

 Data quality seems good
◦ Reasons
 Incidence of missing values is quite minimal which
makes it easier to deal with the same
 Data set includes a large sample size which enables
better understanding of inter-relationships between
variables.
 The data includes key variables such as sales, profit
along with other likely variables which can impact the
above two variables
 The data contains a healthy mix of both qualitative
and quantitative variables thereby allowing a host of
tools to be used
Data Quality

 Given dataset comprises of information on
8399 customer purchases
 Information relates to use of various
qualitative variables and quantitative
variables
 Qualitative variables (Order Priority, product
category, sub-category, Ship Mode,
Province
 Quantitative variables (Profit, Unit price,
Shipping Cost, Sales, Order quantity,
Discount)
Summary of content

 Key factors to consider
◦ Order quantity – Positive relationship but weak in
strength
◦ Sales – Positive relationship and moderately strong
in strength
◦ Shipping Mode – Delivery truck seems to have
highest profitability but may be linked to product
type as well
◦ Product category – Average profit seems to be the
highest in technology
◦ Produce sub-category – Copies and faxes have
significantly higher unit profit
Insights regards
profitability