Debbie-k07/IHIFIX-DATA-ANALYTICS-AI-CAPSTONE-PROJECT

This project investigates how maternal education and household wealth are associated with childhood anemia in Nigeria using the 2018 NDHS dataset. The analysis was conducted using SQL for data preparation and Power BI for visualization to generate insights that can inform health policies and interventions aimed at reducing childhood anemia. # IHIFIX-DATA-ANALYTICS-AI-CAPSTONE-PROJECT This project investigates how maternal education and household wealth are associated with childhood anemia in Nigeria using the 2018 NDHS dataset. The analysis was conducted using SQL for data preparation and Power BI for visualization to generate insights that can inform health policies and interventions aimed at reducing childhood anemia. Childhood Anemia Analysis in Nigeria Project Description This project explores the relationship between maternal educational level, household wealth index, and childhood anemia among Nigerian children aged 0–59 months using data from the 2018 Nigeria Demographic and Health Survey (NDHS). The analysis investigates whether socioeconomic factors are associated with children's anemia status through data cleaning, descriptive analysis, and interactive visualizations. The goal is to generate evidence-based insights that can inform public health policies and interventions aimed at reducing childhood anemia. Research Questions How does a mother's educational level relate to child anemia? How does household wealth index relate to child anemia? Tools Used Microsoft Excel– Initial data inspection MySQL – Data cleaning, preprocessing, and analysis Power BI– Data visualization and dashboard development Analytical Techniques Data Cleaning Frequency Distribution Cross-tabulation Percentage Analysis nteractive Dashboard Visualization Key Findings Children whose mothers had higher levels of education showed a higher proportion of non-anemic outcomes. Children from wealthier households were more likely to be non-anemic than those from poorer households. The findings suggest that maternal education and household wealth are associated with childhood anemia among Nigerian children. Project Structure ```text Childhood-Anemia-Analysis │ ├── README.md ├── SQL_Analysis.sql ├── Childhood_Anemia_Report.pdf ├── PowerBI_Dashboard.pbix ├── Dashboard_Screenshots/ └── Dataset/ ``` Dataset Source: Nigeri …