Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DESCRIPTION Use 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

DESCRIPTION

Use 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 ID Unique Order ID of a product
Order Date Order Placement Date
Ship Date Shipment Date of the placed order
Aging Used to Create Histogram Bin
Ship Mode Shipment mode of placed order
Product Category Product Category
Product Name of the Product
Sales Sales Amount
Quantity The amount or number of a material
Discount A deduction from the usual cost of something
Profit A financial advantage or benefit
Shipping Cost The amount required to ship the placed order
Order Priority Precedence of placed order
Customer ID Unique Customer ID
Customer Name Name of the Customer
City Unique City Name
State Unique State Name
Country Unique Country Name
Region Especially the part of a country
Months The monthof placing the order

The following project tasks are required to be performed in Excel:

  • Use the saved Sample E-Commerce database
  • Prepare a table of Sales and Profit month-wise in a working sheet
  • Prepare the sales table region-wise in the working sheet
  • Create User Control Combo box for Product Category
  • Create a Column Chart of the month-wise table and region-wise table
  • Link the table with a combo box
  • Create 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Construction Project Management A Complete Introduction

Authors: Alison Dykstra

2nd Edition

0982703430, 978-0982703434

More Books

Students also viewed these General Management questions

Question

Explain how to reward individual and team performance.

Answered: 1 week ago