🎯 𝑨𝒃𝒐𝒖𝒕 𝒕𝒉𝒆 𝒑𝒓𝒐𝒋𝒆𝒄𝒕 -
- 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.