This is a comprehensive Global

This is a comprehensive Global War Conflict Analysis Dashboard focused on tracking the heavy humanitarian impact of global conflicts. The objective of this project was to organize historical data and highlight critical figures regarding casualties, civilian suffering, and human displacement.

Here is how I worked on this sensitive dataset:

Data Wrangling: Cleaned and structured large volumes of raw historical records in Excel, sorting out timeline gaps and making sure the massive numbers are completely accurate.

Tracking Key Metrics: Extracted high-level global indicators, including Total Conflicts (27), Total Deaths (13.54 Crores), Civilian Deaths (8,87,115), and Displaced Populations (5.16 Crores).

Visualizing Impact: Built specialized bar charts and trend lines to show refugee distributions, top displaced populations by conflict, and a comparison between deaths and wounded individuals.

I chose a professional deep blue layout to suit the research theme of the data. I also included active slicers on the side so anyone can filter the visuals by specific war phases or years instantly.

Tools used: Advanced Excel (Data Organization, Pivot Tables, Complex Formulas, Dashboard Layout)