a$.$ Data Import and Transformation:

$$ Task: Import a dataset from a Productorder.xlsx file containing order and product data.

$$ Exercise: Use Power BI's query editor to clean and transform the data. Tasks may include renaming columns, removing duplicates or formatting type for column.

b$.$ Data Visualization:

$$ Task: Create a dashboard that visualizes the quantity order performance across different product categories.

Exercise: Design a dashboard using Power BI that includes:

A bar chart showing total order by product category.

A line chart illustrating the trend of sales over time for each category.

A slicer or dropdown menu for users to select specific categories for comparison.

Conditional formatting to highlight top$-$performing categories or identify areas for improvement.