Refugees' Needs Analysis Dashboard

*Project Goals:*

Develop a comprehensive and dynamic dashboard to analyze refugee data, providing actionable insights to inform decision-making and enhance support efforts.

*Key Performance Indicators (KPIs):*

- Total Refugees

- Gender Diversity

- Financial Needs

- Educational Needs

- Clothing Needs

- Food Needs

- Total Workforce

- Female and Male Children in Each Country

- Total Families in Each Country

- Total Income in Each Country

- Breadwinner Status

*Power Query Editor:*

- *Data Cleaning:* Removed duplicates, standardized data formats, and ensured data integrity.

- *Data Manipulation:* Transformed data to align with project requirements, facilitating targeted analysis.

*Approach:*

*Data Integration & Transformation:*

- Unified diverse data sources, ensuring consistency and accuracy across all datasets.

*Data Modeling & Relationships:*

- Designed a robust data model that accurately represents relationships within the data, allowing for comprehensive exploration and analysis.

*Interactive Dashboards:*

- Developed visually appealing and intuitive dashboards that allow stakeholders to easily filter data by country or place of living (flat, house, tent, etc.), offering deep insights into the refugee population.

*Key Insights Extraction:*

- Extracted and defined essential KPIs to monitor critical aspects such as gender diversity, financial needs, and total workforce, all of which align with humanitarian objectives.

*Filtering Capabilities:*

- Enabled comprehensive filtering options, allowing users to view insights based on country or place of living without the need for drill-through or forecasting.

*Conclusion:*

This project showcases my expertise in Power BI and data analytics, delivering a powerful tool for humanitarian organizations to understand and address the needs of refugee populations. The dashboard provides a clear, comprehensive view of key metrics, enabling data-driven decision-making and targeted interventions.