felixokafor/AnalystLab-Africa-Week-8

# AnalystLab-Africa-Week-8 Technology and Internet Adoption Trends in Africa (1997–2024) Overview This project analyzes technology adoption trends across 48 African countries between 1997 and 2024 using data from the World Bank Development Indicators (WDI). The analysis focuses on three key indicators: - Mobile Cellular Subscriptions (per 100 people) - Individuals Using the Internet (% of population) - Fixed Broadband Subscriptions (per 100 people) The project was completed as part of a Data Analytics Capstone Internship Project using Microsoft Power BI. --- Project Objectives The goal of this project is to: - Examine technology adoption trends across Africa. - Compare mobile, internet, and broadband adoption rates. - Identify leading countries in digital connectivity. - Analyze historical trends from 1997 to 2024. - Provide data-driven recommendations for improving digital inclusion. --- Dataset Information Source: World Bank Development Indicators (WDI) Coverage: - 48 African Countries - Years: 1997–2024 Indicators Analyzed Indicator| Description Mobile Cellular Subscriptions| Mobile subscriptions per 100 people Internet Users| Percentage of individuals using the internet Fixed Broadband Subscriptions| Broadband subscriptions per 100 people --- Tools Used - Microsoft Power BI - Power Query - DAX (Data Analysis Expressions) - Microsoft Excel - Microsoft Word - Microsoft PowerPoint --- Data Cleaning Process The following data preparation steps were performed: - Removed unnecessary columns - Checked for missing values - Verified data types - Standardized field names - Validated country and indicator records - Created calculated measures using DAX --- Dashboard Features The main dashboard includes: - KPI Cards - Technology Adoption Trend Analysis - Top 10 Countries Ranking - Geographic Distribution Map - Interactive Filters Country Deep Dive Page The second dashboard page allows users to: - Select individual countries - Select technology in …