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:
