Transaction ID Product Category Date Sales Revenue Cost

$1001$ Electronics $2021-01-05$ $$1,200\mathrm{.}00$ $$300\mathrm{.}00$

$1002$ Clothing $2021-01-08$ $$450\mathrm{.}00$ $$50\mathrm{.}00$

$1003$ Electronics $2021-01-12$ $$980\mathrm{.}00$ $$100\mathrm{.}00$

$1004$ Books $2021-01-15$ $$250\mathrm{.}00$ $$30\mathrm{.}00$

$1005$ Home & Garden $2021-01-20$ $$700\mathrm{.}00$ $$200\mathrm{.}00$

$1006$ Clothing $2021-02-02$ $$580\mathrm{.}00$

$1007$ Electronics $2021-02-05$ $$1,350\mathrm{.}00$ $$300\mathrm{.}00$

$1008$ Books $2021-02-10$ $$320\mathrm{.}00$ $$50\mathrm{.}00$

$1009$ Home & Garden $2021-02-15$ $$880\mathrm{.}00$ $$100\mathrm{.}00$

$1010$ Electronics $2021-03-01$ $$1,100\mathrm{.}00$ $$300\mathrm{.}00$

$1011$ Clothing $2021-03-05$ $$420\mathrm{.}00$ $$50\mathrm{.}00$

$1001$ Books $2022-01-05$ $$280\mathrm{.}00$ $$100\mathrm{.}00$

$1002$ Home & Garden $2022-01-08$ $$750\mathrm{.}00$ $$200\mathrm{.}00$

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

$1004$ Clothing $2022-01-15$ $$520\mathrm{.}00$ $$50\mathrm{.}00$

$1005$ Books $2022-01-20$ $$310\mathrm{.}00$ $$100\mathrm{.}00$

$1006$ Home & Garden $2022-02-02$ $$890\mathrm{.}00$ $$200\mathrm{.}00$

$1007$ Electronics $2022-02-05$ $$1,320\mathrm{.}00$ $$300\mathrm{.}00$

$1008$ Clothing $2022-02-10$ $$480\mathrm{.}00$ $$50\mathrm{.}00$

$1009$ Books $2022-02-15$ $$290\mathrm{.}00$ $$100\mathrm{.}00$

$1010$ Home & Garden $2022-03-01$ $$720\mathrm{.}00$ $$200\mathrm{.}00$

$1011$ Electronics $2022-03-05$ $$1,560\mathrm{.}00$ $$300\mathrm{.}00$ For your descriptive report dataset, your sales price per unit for all your product categories is $$50.$ requirement$-$profit$=???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.