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: