Steps taken while Analysing data Using Excel

• Through Power Query - Done sorting and formatting, Used Transfer and Add column features

• Create a new column "Size" from "Product_Details"

• Create a new column "Total_Bill" from multiple by "Transcation_qty" & "unit price".

• Create two new columns "Month name" & "Day name" from "transaction date"

• Create two new columns "Month Number" & "Day Number from " Transaction date"

• Trim date from "transaction_time"

• Create charts - bar charts, Pic charts,Line charts,

• KPIs, Used Slicer, set slicer colour, slicer link with charts,Use Pivot.

• Finally Created a dashboard using Pivot tables and various analysis

  Final Dashboard: