Global Terrorism Data Analysis and Interactive Power BI DashboardGlobal Terrorism Data Analysis and Interactive Power BI Dashboard
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Sabbir's avatar
Sabbir Hossain
• Oct 4
Global Terrorism Data Analysis & Power BI Dashboard
Project Description
An end-to-end data analytics project focused on analyzing global terrorism data to identify trends, patterns, and regional variations across countries and time periods.
What I did:
• Cleaned and explored the dataset using Python
• Performed data transformation and analysis using Python & SQL
• Stored and queried structured data using PostgreSQL
• Conducted analytical queries to identify trends and patterns
• Built an interactive Power BI dashboard
• Created KPI cards, maps, trend analysis, and comparative visualizations
• Added dynamic filters for decade, year, country, region, and attack type
Key Areas Analyzed:
🌍 Attacks by country and region
📅 Yearly and decade-wise trends
⚠️ Attack severity distribution
🎯 Attack type analysis
📊 Regional comparisons
🗺️ Geographic distribution of attacks
Tools: Python • PostgreSQL • SQL • Power BI
Workflow: Raw Data → Python → PostgreSQL → SQL Analysis → Power BI → Interactive Insights
Outcome: The project demonstrates an end-to-end analytics workflow, transforming a large and complex dataset into an interactive dashboard that makes trends, geographic patterns, attack types, and severity levels easier to explore and understand.
Data AnalysisData VisualizationMicrosoft Power BIData ModelingPostgreSQLPython
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started