EVERKING-bit/HIV_PREVALENCE_ANALYSIS_2004-2014

Ghana HIV Prevalence Analysis using Excel Power BI and SQL # 📊 GHANA HIV PREVALENCE ANALYSIS (2004–2014) Comprehensive Regional, Gender, Age, Site, and Mortality Insights This project presents an in-depth analysis of HIV trends in Ghana using five major datasets covering prevalence, gender distribution, regional distribution, age patterns, site-level data, and AIDS-related deaths. All analyses were visualized through multi-dashboard Power BI reports. ## INTRODUCTION HIV remains one of the most significant public health challenges in Ghana, affecting individuals, families, and entire communities across the country. Understanding the prevalence and distribution of HIV is essential for guiding national health policies, allocating resources, and implementing targeted interventions. By analyzing trends across regions, age groups, and years, stakeholders can identify high-risk areas, monitor progress toward national health goals, and strengthen prevention and treatment strategies. This analysis provides valuable insights into how HIV cases are evolving over time, helping health authorities, researchers, and policymakers make informed decisions that support a healthier and more resilient nation. ## PROBLEM STATEMENT HIV continues to pose a significant public health challenge in Ghana, affecting individuals, families, and communities across all regions. Despite ongoing interventions, variations in prevalence still exist between regions, age groups, and genders, making it necessary to conduct detailed and data-driven assessments. Understanding these patterns is essential for guiding national strategies, improving resource allocation, and strengthening prevention and treatment programs. However, existing HIV-related data in Ghana is often scattered across multiple reports and datasets. This makes it difficult to gain a complete and unified view of national trends. To address this gap, this study brings together five key datasets to analyze HIV prevalence, demographic patterns, regional distribution, and AIDS-related deaths. By …