The dataset used consists of information from a retail store that aims to create metrics to monitor its performance. Two datasets were utilized: sales data and customer data.
Metrics:
Best-selling departments. Average price with shipping by department name. Sales quantity per month. Average income for each sales channel. Average age of customers by brand. Business Assumptions:
For purchases without a state (UF), consider the state of MS. Price cannot be higher than the price with shipping.