This repo contains all the files used in E-Commerce Project. This project is completed end to end on Microsoft Excel.
E-commerce (electronic commerce) is the buying and selling of goods and services, or the transmitting of funds or data, over an electronic network, primarily the internet. These business transactions occur either as business-to-business (B2B), business-to-consumer (B2C), consumer-to-consumer or consumer-to-business.
Business Scenario The Analytics team of an Online E-Commerce Company wants to design a Sales dashboard to analyze the sales based on various product categories. The company wants to add user control for product category, so users can select a category and can see the trend month-wise and product-wise accordingly. The Analytics team also wants to create a histogram to analyze number of shipping days.
Overview ✓ Use the Saved Sample – E-Commerce database.
✓ Prepare a table of Sales and Profit month-wise in working sheet.
✓ Prepare the sales table region-wise in the working sheet.
✓ Create User Control Combo box for Product Category.
✓ Create Column Chart of month-wise table and region-wise table.
✓ Link the table with combo box.