DESCRIPTION Use Excel to analyze the sales based on various product…

Question Answered step-by-step DESCRIPTION Use Excel to analyze the sales based on various product… DESCRIPTIONUse Excel to analyze the sales based on various product categories. Description:The dataset in file E-Commerce Dashboard dataset.xlsx contains sales data for different product categories. The following are the features in the dataset:Order IDUnique Order ID of a productOrder DateOrder Placement DateShip DateShipment Date of the placed orderAgingUsed to Create Histogram BinShip ModeShipment mode of placed orderProduct CategoryProduct CategoryProductName of the ProductSalesSales AmountQuantityThe amount or number of a materialDiscountA deduction from the usual cost of somethingProfitA financial advantage or benefitShipping CostThe amount required to ship the placed orderOrder PriorityPrecedence of placed orderCustomer IDUnique Customer IDCustomer NameName of the CustomerCityUnique City NameStateUnique State NameCountryUnique Country NameRegionEspecially the part of a countryMonthsThe month of placing the orderThe following project tasks are required to be performed in Excel:Use the saved Sample E-Commerce databasePrepare a table of Sales and Profit month-wise in a working sheetPrepare the sales table region-wise in the working sheetCreate User Control Combo box for Product CategoryCreate a Column Chart of the month-wise table and region-wise tableLink the table with a combo boxCreate a dashboard. Tools required: Microsoft Excel, Data Analysis Add-in Expected Deliverables:  Design a sales dashboard that analyzes the sales based on various product categories. The company wants to add user control for product category so that users can select a category and can see the trend month-wise and product-wise accordingly.   Business Management Project Management Share QuestionEmailCopy link Comments (0)