- Convert the data files to csv.
- Cleaning of Data
- Shape of Data
- Check for NAs
- Date format
- Check Data Info
- Check for Duplicate data
- Check for Outliers
- Joining of tables, primary key as OrderID
- Finding profit based on OrderID, States or other params.
- Profit over a period (monthly)
- Profit Trend Analysis by category, date.
- Customer focusing
- Analysis by heirarchy, Ex - Country, State, City
- Amount vs category bar chart sales target
- Which months they hit the sales target.
- Amount vs Quantity
- Correlation matrix for Order Details.