Part $1$: Excel Dashboard CreationDataset: 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$\mathrm{.}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$\mathrm{.}3.$ Design a user$-$friendly dashboard using Excel features like slicers, charts, and tables$\mathrm{.}4.$ Include the following elements in your dashboard:$5.$ A slicer to filter data by year$\mathrm{.}6.$ A pivot chart $($e$.$g$.,$ bar chart or line chart$)$ that visualizes monthly sales trends by product category for the selected year$\mathrm{.}7.$ A pivot table that displays the top$-$selling products for the selected year, including product names, sales revenue, and units sold$\mathrm{.}8.$ A calculated field that calculates the average transaction value $($sales revenue divided by the number of transactions$)$ for each product category$\mathrm{.}9.$ Ensure that the dashboard is well$-$organized, visually appealing, and easy to navigate.