The objective of this assignment is to demonstrate proficiency in creating an Excel dashboard that utilizes pivot tables, advanced formulas, and data visualization techniques. Additionally, students are required to write a descriptive report that interprets the data and communicates insights derived from the dashboard.For your descriptive report dataset, your sales price per unit for all your product categories is $$50$ 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.

can you creat excel dashboard with Descriptive Report to me $?$