aa-ryan/sales_analysis

AbinBev_Assignment

Task

• 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.