rachelbirma-jpg/3MTT-Nigeria-2023-Election-Analysis

3MTT NextGen Data Analysis Capstone Project – Nigeria 2023 Presidential Election Turnout Analysis # Nigeria 2023 Presidential Election Turnout Analysis ## 3MTT NextGen Data Analysis Capstone Project **Project ID:** DA-10 – Election Turnout by State **Track:** Data Analysis & Visualization **Prepared by:** Rachel Nuhu Birma **Programme:** 3MTT NextGen --- ## Project Overview This project analyses voter turnout across states in Nigeria during the 2023 Presidential Election using open election data. The analysis compares registered voters, eligible voters, total valid votes and valid vote rates across states, while also presenting the performance of the major presidential candidates. An interactive Power BI dashboard was developed to make the election data easier to explore, compare and understand at both national and state levels. --- ## Project Objective The objectives of this project are to: - Prepare and analyse the 2023 Presidential Election data. - Compare registered voters, eligible voters and valid votes across states. - Examine differences in valid vote rates across states. - Present neutral, data-driven election insights. - Build an interactive dashboard for exploring state-level election results. --- ## Data Source The election datasets used for this project were sourced from **Kaggle**. The analysis uses state-level information covering registered voters, eligible voters, candidate votes and total valid votes. --- ## Tools Used - **Microsoft Power BI** – Data modelling, analysis and dashboard development - **Power Query** – Data cleaning and transformation - **DAX** – Measures and calculations --- ## Data Preparation The datasets were imported into Power BI and prepared for analysis. The preparation process included: - Reviewing and cleaning the datasets. - Checking column names and data types. - Checking state names for consistency. - Combining relevant election and state-level information. - Creating measures required for the analysis. - Validating state-level and national figures before visualization. --- ## Dashboard Structu …