LATEST WAR NEWS
Loading latest headlines...
Back to Home
Project Methodology

MethodologyFrom raw data to insight.

Overview of data sources, cleaning pipeline, analytical approach, and tools used in this project.

Data-drivenReproducibleTransparentBI-ready
Analysis Workflow

Methodology Roadmap

A structured workflow from raw conflict data to cleaned datasets, analytical insights, and interactive visualizations.

01

Data Sources

Collect datasets from documented public sources.

02

Data Pipeline

Organize raw, cleaned, and BI-ready files.

03

Clean & Transform

Standardize fields, handle missing values, and derive variables.

04

Analyze

Explore trends, demographics, and comparative KPIs.

05

Visualize

Build charts and interactive Tableau dashboards.

06

Extract Insights

Present findings with transparent limitations.

Foundation

1. Data Sources

Russia – Ukraine

  • Uppsala Conflict Data Program (UCDP) – Georeferenced Event Dataset
  • Our World in Data – War & Peace (aggregated conflict deaths)

Israel – Palestine

  • Tech for Palestine – Gaza Daily Casualties
  • Tech for Palestine – West Bank Daily Casualties
  • Tech for Palestine – Killed in Gaza (individual demographic records)
Organization

2. Data Pipeline

RawOriginal CSV files stored in data/raw/
CleanedStandardized and cleaned files saved in data/processed/
BI-ReadyAnalysis-ready files prepared in data/bi_ready/
DashboardInteractive Tableau Public dashboard + static charts
Transformation

3. Data Cleaning & Transformation

  • Standardized date formats across all datasets
  • Converted death counts to numeric types and handled missing values
  • Filtered UCDP data to Russia-Ukraine related events only (45,830 events retained)
  • Created derived fields: daily killed, age groups, conflict labels, location
  • Generated monthly aggregates for Russia-Ukraine data
  • Built a combined daily master file for Israel-Palestine (Gaza + West Bank)
  • Cleaned demographic records (sex standardization + age group binning)
Analysis

4. Analytical Approach

  • ✓Exploratory Data Analysis (EDA) using Pandas, Matplotlib, and Seaborn
  • ✓Time-series analysis of daily and monthly casualty trends
  • ✓Demographic breakdown by age group and sex (Gaza)
  • ✓Comparative KPIs between the two conflicts
  • ✓Preparation of clean, analysis-ready files for BI tools
  • ✓Interactive dashboard created in Tableau Public
Stack

5. Tools & Technologies

Python, Pandas, NumPy
Matplotlib & Seaborn
Tableau Public
Power BI (optional)
Next.js + Tailwind CSS
Vercel (Deployment)
Transparency

Limitations & Notes

Casualty figures, especially during active conflict periods, may be incomplete or revised later by the original data providers. This project treats all numbers as reported figures from the cited sources. No political interpretation or judgment is applied — the focus remains strictly on data patterns, trends, and demographic distribution.

Transparent methodology and source-aware reporting