Data-Driven Insights for UN Policy Formulation

To leverage data analytics to support the United Nations in policy formulation and enhance decision-making in critical areas such as women’s empowerment and children’s welfare.

Data Extraction and Cleaning:

•Utilized SQL to extract structured and unstructured data from multiple sources, including internal UN databases and external datasets

•Cleaned and preprocessed the data using advanced Excel techniques (e.g., pivot tables, advanced formulas, and macros) to ensure data accuracy and consistency.

Analysis and Visualization:

•Conducted exploratory data analysis to identify patterns and trends related to key policy areas such as women’s empowerment, children’s welfare, and socio-economic indicators.

•Designed interactive graphs and visualizations using Tableau to present data insights tailored for various departments within the UN.

Insight Generation:

•Analyzed demographic, economic, and social indicators to uncover actionable insights, including identifying regions requiring urgent intervention and areas of potential policy impact.

•Delivered insights that influenced UN strategies and policy priorities.

Recommendations and Dashboard Development:

•Developed actionable recommendations for policy changes addressing emerging needs in women’s empowerment and children’s welfare.

•Built an interactive Tableau dashboard that allowed department heads to explore insights dynamically, streamlining decision-making processes.

Impact:

•Provided meaningful insights that supported efficient policymaking and resource allocation.

•Contributed to the formulation of new initiatives, specifically addressing pressing issues like gender equality and child welfare.

Tools: Python, SQL, Excel ,Tableau