This project uses SQL, matplotlib and seaborn in drawing insight from a supermarket data in order to make data-driven decisions.

The questions answered are as followed:

Problem Statement

i. What is the average sales and profit per market?

ii.Plot a stacked bar chart showing the sales and profit per market.

iii.Which market brings more sales on the average?

i. What are the best 10 performing products with regards to sales in 2013?

ii.What are the least 10 performing products with regards to sales 2013?

i. Extract the days and months from the Order Date and add them to the data frame with the name "Days" and "Months" respectively?

ii.Show the trend of profit from January to December with a line plot.

iii. Which month does the company make more profit and what 5 products are sold most in that month? iv. which day does the company make high sales on the average?

i. By analyzing the data, what is the correlation between sales and discount?

ii. Use a scatter plot to show the relationship between sales and profit.

i. Plot a grouped bar chart showing the total profit for the different product category for each market. ii. From your graph, which product category performs well in each market?

i. Which customer spent the most in the whole year? ii. What product does the customer in (i) buy the most? iii. Which month did the customer spent the most? iv. How much did this customer spend in the whole year?

Can you do any other analysis to draw more insight? Feel free to do it.