Problem:
The problem addressed in this analysis is the profitability of an e-commerce company in India before and after October 2018.
Objective:
The objective of this analysis is to identify profitable and unprofitable product categories and cities and to develop a strategy for increasing profits.
Method:
The analysis uses PowerBI for data visualization and identifies product categories and cities with high profitability and loss. It also explores product-specific and city-specific factors affecting profitability and proposes remedial measures.
Summary:
The analysis of an e-commerce company in India identified six key findings. It found that Electronics and Furniture are the most profitable product categories and that profitability improved after six months. However, some city negative profits, indicating the need for in-depth analysis of specific products and cities. To avoid significant losses, the analysis suggests focusing on profitable products and cities, monitoring competition, and conducting detailed analysis of product and city-specific factors affecting profitability.