Transaction ID Product Category Date Sales Revenue Cost

$1001$ Electronics $1/5/2021$ $$1,200\mathrm{.}00$ $$300\mathrm{.}00$

$1002$ Clothing $1/8/2021$ $$450\mathrm{.}00$ $$50\mathrm{.}00$

$1003$ Electronics $1/12/2021$ $$980\mathrm{.}00$ $$100\mathrm{.}00$

$1004$ Books $1/15/2021$ $$250\mathrm{.}00$ $$30\mathrm{.}00$

$1005$ Home & Garden $1/20/2021$ $$700\mathrm{.}00$ $$200\mathrm{.}00$

$1006$ Clothing $2/2/2021$ $$580\mathrm{.}00$

$1007$ Electronics $2/5/2021$ $$1,350\mathrm{.}00$ $$300\mathrm{.}00$

$1008$ Books $2/10/2021$ $$320\mathrm{.}00$ $$50\mathrm{.}00$

$1009$ Home & Garden $2/15/2021$ $$880\mathrm{.}00$ $$100\mathrm{.}00$

$1010$ Electronics $3/1/2021$ $$1,100\mathrm{.}00$ $$300\mathrm{.}00$

$1011$ Clothing $3/5/2021$ $$420\mathrm{.}00$ $$50\mathrm{.}00$

$1001$ Books $1/5/2022$ $$280\mathrm{.}00$ $$100\mathrm{.}00$

$1002$ Home & Garden $1/8/2022$ $$750\mathrm{.}00$ $$200\mathrm{.}00$

$1003$ Electronics $1/12/2022$ $$1,250\mathrm{.}00$ $$300\mathrm{.}00$

$1004$ Clothing $1/15/2022$ $$520\mathrm{.}00$ $$50\mathrm{.}00$

$1005$ Books $1/20/2022$ $$310\mathrm{.}00$ $$100\mathrm{.}00$

$1006$ Home & Garden $2/2/2022$ $$890\mathrm{.}00$ $$200\mathrm{.}00$

$1007$ Electronics $2/5/2022$ $$1,320\mathrm{.}00$ $$300\mathrm{.}00$

$1008$ Clothing $2/10/2022$ $$480\mathrm{.}00$ $$50\mathrm{.}00$

$1009$ Books $2/15/2022$ $$290\mathrm{.}00$ $$100\mathrm{.}00$

$1010$ Home & Garden $3/1/2022$ $$720\mathrm{.}00$ $$200\mathrm{.}00$

$1011$ Electronics $3/5/2022$ $$1,560\mathrm{.}00$ $$300\mathrm{.}00$

Part $1$: Excel Dashboard Creation

Dataset: You will be provided with a sample dataset containing sales data for a fictional retail company. The dataset will include information such as sales transactions, product categories, dates, and sales revenue. In this dataset:

$$ "Transaction ID$"$ represents a unique identifier for each sales transaction.

$$ "Product Category" denotes the category to which the product belongs.

$$ "Date" indicates the date of the sales transaction.

$$ "Sales Revenue" represents the revenue generated from each transaction.

Requirements:

$1.$ Import the provided dataset into Excel.

$2.$ Create a pivot table that summarizes sales data by product category and month. Include columns for total sales revenue and the number of transactions.

$3.$ Design a user$-$friendly dashboard using Excel features like slicers, charts, and tables.

$4.$ Include the following elements in your dashboard:

$5.$ A slicer to filter data by year.

$6.$ A pivot chart $($e$.$g$.,$ bar chart or line chart$)$ that visualizes monthly sales trends by product category for the selected year.

$7.$ A pivot table that displays the top$-$selling products for the selected year, including product names, sales revenue, and units sold.

$8.$ A calculated field that calculates the average transaction value $($sales revenue divided by the number of transactions$)$ for each product category.

$9.$ Ensure that the dashboard is well$-$organized, visually appealing, and easy to navigate.