E-Commerce Sales Analysis Project 👩‍💻

🎯 𝑨𝒃𝒐𝒖𝒕 𝒕𝒉𝒆 𝒑𝒓𝒐𝒋𝒆𝒄𝒕 -

• In this project, we have analyzed an Indian Ecommerce store dataset.
• dataset is from Kaggle, and consists of 3 CSV files- List of Orders, Order details, Sales target.
• List of Orders - This dataset contains purchase information including Order ID, Date of Purchase and customer details.
• Order Details - This dataset contains order ID, price, quantity, profit, category and subcategory of product.
• Sales target - This dataset contains sales target amount and date for each product category.

🎯 𝑷𝒓𝒐𝒋𝒆𝒄𝒕 𝑫𝒊𝒓𝒆𝒄𝒕𝒐𝒓𝒚 -

• This Project Repository consists of -
• SQL In Depth Analysis - Analysed the dataset by writing complex SQL Queries to gain insights.
• Power BI Dashboard - live Interactive Dashboard for visualizing the insights.
• Alteryx Workflows - Used in RFM Analysis to calculate score for customer segmentation.