This project aims to analyze and visualize data on fatalities in the Israeli and Palestinian conflict using various tools and techniques. The dataset used for this analysis is sourced from [fatalities_isr_pse_conflict_2000_to_2023.xlsx], and the analysis is performed using tools SQL, and visualization tools Power bi.
The dataset used for this project provides information on fatalities in the Israeli and Palestinian conflict over a specified time period. It includes details such as date, location, age, gender, and other relevant attributes of each recorded fatality. The dataset is available at [(https://github.com/marwabkr/Fatalities-in-the-Israeli-Palestinian_Visualization-with-PowerBI_SQL/blob/main/fatalities_isr_pse_conflict_2000_to_2023.xlsx)].
The project utilizes the following tools and technologies:
- SQL: SQL queries are employed for data extraction, transformation, and loading tasks.
- Power BI: Power BI is used for data visualization and creating interactive dashboards and reports.
The analysis process consists of the following steps:
- Data Extraction: The dataset is acquired from [fatalities_isr_pse_conflict_2000_to_2023.xlsx] and imported into a suitable database management system.
- Data Preprocessing: The data is cleaned, transformed, and prepared for analysis. Missing values, duplicates, and inconsistencies are handled during this stage.
- Data Analysis: SQL queries are utilized to extract meaningful insights from the dataset. Various analytical techniques can be applied to explore patterns, trends, and relationships within the data.
- Visualization: Tableau is employed to create interactive visualizations, charts, and dashboards to effectively communicate the findings of the analysis.
- Interpretation: The results and visualizations are interpreted to gain a better understanding of the fatalities in the Israeli and Palestinian conflict and identify key patterns or insights.
To replicate this project, follow these steps:
- Download the dataset from (https://github.com/marwabkr/Fatalities-in-the-Israeli-Palestinian_Visualization-with-PowerBI_SQL/blob/main/fatalities_isr_pse_conflict_2000_to_2023.xlsx)].
- Set up a suitable database management system (e.g., MySQL, PostgreSQL) and import the dataset.
- Use SQL queries to extract and analyze the data, generating insights based on your research questions.
- Install Power BI and import the cleaned dataset.
- Create interactive visualizations and dashboards in Power BI to represent the findings of the analysis.
The results of the analysis, including visualizations, insights, and interpretations, can be found in the [(https://github.com/marwabkr/Fatalities-in-the-Israeli-Palestinian_Visualization-with-PowerBI_SQL/blob/main/FREE%20PALESTINA.pdf)].
This project provides a comprehensive analysis of fatalities in the Israeli and Palestinian conflict, leveraging data processing, SQL querying, and visualization techniques. The generated insights and visualizations can contribute to a better understanding of the conflict's impact and help inform discussions and decision-making processes.