gbenga4ayo/demo-gdp-analysis-in-nigeria

This repository details the analysis and visualization of GDP growth in Nigeria from 2020 to 2024 # demo-gdp-analysis-in-nigeria ## Introduction The Gross Domestic Product (GDP) of a country is a critical indicator of its economic health, reflecting the total value of all goods and services produced over a specific time period. Understanding the trends and changes in GDP can provide valuable insights into the economic performance and potential growth areas within a country. this analysis focuses on the GDP of Nigeria from 2020 to 2024 providing a comprehensive overview of its performance during this period. ## Objectives - Analyze quarterly GDP trends: Examine the quarterly variations in Nigeria's GDP from Q1 2020 to Q3 2024, identifying significant changes and trends in both nominal and real GDP values. Examine GDP trends by sector and sub-sector. - Assess quarterly growth rates: Calculate and interpret the quarterly GDP growth rates to understand the economic mommentum from one quarter to the next,a nd compare it to the same quarter in the previous year. - Highlight key metrics: Focus on critical metrics such as the real GDP values, percentage change this quarter versus last quarter, and the precentage change this quarter versus the same quarter last year to provide a clear picture of economic performance. - Visualize data for better understanding: Utilize Excel and Power BI to present the GDP data effectively , including line charts to show the quarterly trend of GDP and bar charts to display the percentage change in real GDP for preceding years. - Provide contextual Analysis: Offer contextual explanations for observed GDP trends and growth rates, linking economic events, climate and seasonality, and policies to their potential impacts on th GDP. ## Tools - Power BI - Excel ## Techniques and Skills - Data normalization - Data transformation with Power Query - Data modelling - Bookmarks - Report automation - Data visualization ## Datasource National bureau of statistics ## Data Model The data was first normalized in excel before being transformed i …