This dataset provides an in-depth look at the profitability of e-commerce sales. It contains data on a variety of sales channels, including Shiprocket and INCREFF, as well as financial information on related expenses and profits. The columns contain data such as SKU codes, design numbers, stock levels, product categories, sizes, and colors. In addition to this we have included the MRPs across multiple stores like Ajio MRP, Amazon MRP, Amazon FBA MRP, Flipkart MRP, Limeroad MRP Myntra MRP, and PaytmMRP along with other key parameters like amount paid by the customer for the purchase, rate per piece for every individual transaction Also we have added transactional parameters like Date of sale months category fulfilled by B2b Status Qty Currency Gross amt. Dataset Link: E-Commerce Sales Dataset (kaggle.com) -Amazon Sale Report data only. Outline for the report: Module Code: Assignment report Title: Student Enrollment Number: Date (when the work is completed): Actual hours spent on the assignment: 1. Introduction (5 Marks) Introducing the problem domain where your assignment falls in. For this given context and resources, briefly describe how your knowledge of data visualization might be helpful in extracting information from raw data. 2. Analyzing the sales data by adopting Exploratory Data Analysis (EDA) (25 Marks) Using the Amazon Sale Report.xls datasheet, define a story (i.e., a context) for analyzing the dataset, and Design a star schema for populating all the dimensions. 3. Create a dashboard using Amazon Sale Report.xls (25 Marks) Design a dashboard that visualizes: Quantity of shipment of a particular category by month, Quantity of sales by category in a particular month, Amount of sales in category by month, Top 10 states about the amount of sales in category for ship service level. 4. Recommendation to improvement of sales performance (20 marks) Analyze the dashboard and provide recommendations to the business areas of concern, e.g., how sales performance can be improved. 5. Conclusion and Future Improvement (5 Marks) Concluding remarks about your findings and discussions in this report, and

Attachments:

data-visualis....pdf