Analyzing data with Excel involves following specific steps
- Done Sorting,filtering and remove duplicate values from data
- Used Pivot table and draw combo chart ,waterfall chart, Pie chart, Map Chart, KPI, TOP5
- Used Slicers for Years, Region, Segment
- Finally Created a dashboard using Pivot tables and various analysis
Final Dashboard:
