The latest articles on DEV Community by Oluwanifemi Fakorede (@niffyspecial). https://dev.to/niffyspecial https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3301570%2Ff332a151-8c4d-433e-9d05-d3b7783916c1.JPEG https://dev.to/niffyspecial en Oluwanifemi Fakorede Sat, 28 Jun 2025 06:48:22 +0000 https://dev.to/niffyspecial/child-mortality-analysis-with-sql-2j31 https://dev.to/niffyspecial/child-mortality-analysis-with-sql-2j31 <p>This project marks my first official step into health data science. I leveraged SQL to explore and analyze global child mortality trends using real-world data from Our World in Data.</p> <p><strong>Dataset</strong></p> <ul> <li>Source: <a href="https://ourworldindata.org/child-mortality" rel="noopener noreferrer">Our World in Data - Child Mortality</a> </li> <li>Format: CSV</li> <li>Fields: ‘entity’, ‘code’, ‘year’, ‘mortality_rate’</li> </ul> <p><strong>Objectives</strong></p> <ul> <li>Analyze historical and recent child mortality trends globally</li> <li>Identify highest and lowest performing countries by year</li> <li>Compare rates across regions and income groups</li> <li>Practice SQL querying and data analysis fundamentals</li> </ul> <p><strong>Tools Used</strong></p> <ul> <li>MySQL Workbench</li> <li>Visual Studio Code (for cleaning)</li> <li>SQL</li> </ul> <p><strong>Key Insights</strong></p> <ul> <li>Global child mortality has significantly declined since the 1960s</li> <li>African countries still report the highest rates in recent years</li> <li>Income level is a major determinant of child survival</li> <li>Decline in child mortality rate in Nigeria from 1964</li> </ul> <p><strong>Next Steps</strong></p> <ul> <li>Visualize results with Tableau, Power BI, Python (Matplotlib, Seaborn)</li> <li>Explore additional health metrics</li> <li>Build predictive models</li> </ul> <p><strong>Author</strong><br> This project was completed by a transitioning pharmacist turned aspiring health data scientist. Connect with me:</p> <ul> <li>LinkedIn : [<a href="https://www.linkedin.com/in/oluwanifemi-fakorede-b4a789248?)utm_source=share&amp;utm_campaign=share_via&amp;utm_content=profile&amp;utm_medium=ios_app" rel="noopener noreferrer">https://www.linkedin.com/in/oluwanifemi-fakorede-b4a789248?)utm_source=share&amp;utm_campaign=share_via&amp;utm_content=profile&amp;utm_medium=ios_app</a>]</li> <li>Medium : [<a href="https://medium.com/@Specialwrites" rel="noopener noreferrer">https://medium.com/@Specialwrites</a>]</li> </ul> <p>Every dataset tells a story. This one tells of children who lived and those who did not. Let's keep asking better questions.</p> sql datascience data