Interactive Dashboard with Metabase

Created on December 16, 2025

2025   ·   metabase   docker   data-analytics   postgreSQL   render

VIEW CODE

🎯 Project Overview

An interactive dashboard showing global journalist fatalities from 1992-present, leveraging UNESCO’s official dataset to uncover critical insights about press safety worldwide. This project demonstrates end-to-end data analytics capabilities from data sourcing to deployment.

Key Achievement: Transformed raw UNESCO data into an interactive dashboard serving journalists, researchers, and press freedom organizations with actionable insights about media safety trends.

📊 Key Findings & Insights

  • The number of journalist fatalities is increasing over time since 1992.
  • Most of the journalist killed are middle-aged.
  • About 1/4 of the fatalities are in Asia and 1/4 in Latin America.
  • Most of the journalist killed are males.
  • Being in a conflict zone does not significantly increase the risk to get killed.
  • The media most exposed to fatalities are print and TV.

🛠️ Technical Implementation

  • Database Architecture: PostgreSQL
  • Interactive dashboard: Metabase
  • ETL Pipeline: Data processing workflows from CSV to production database
  • Cloud Deployment: Containerized deployment on Render platform

🏗️ Project Architecture