Doing data analysis on e-commerce data which saved in relational databases by processing up to data visualization. This analysis uses some assists of libraries such as Pandas, Seaborn etc.
- Product
- The company wants to know which category of products are sold the most and which product category that is less desirable to buyers.
- Sales
- The company wants to know the time series of sales during the 2017 and 2018 period based on this acquisition, and the analysis of the year with the highest sales.
- Customer
- Where the locations for buying the most customer orders are and the lowest states in making orders.
- The customer payment methods while shopping using what kind of payment method during the data period.