sarahdelight2017/Gdp-analysis-In-Nigeria-

The analysis and visualization of gdp data from 2020-2023 # Analysis and Visualization of Gross Domestic Product (GDP) in Nigeria (2020 - 2024) ## 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 peformance and potential growth area within a country. This analysis focuses on the GDP of Nigeria from 2020 to 2024, prooviding a comprehensive overview of its performance during this period. ## Objective - Analyze Quarterly GDP Trends: Examine the quarterly variations in Nigeria's GDP from Q1 2020 to Q2 2024, identifying significant changes and trends in both nominal and real GDP values. Examine GDP trends by sector and subsector. - Assess Quarterly Growth Rates: Calculate and interpret the quarterly GDP growth rates to understand the economic momentum from one quarter to the next and 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 percentage 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 thr quarterly trend of GDP and abr charts to display the percentage change in real GDP for preceeding years. - Provide Contextual Analysis: Offer contextual explanations for observed GDP trends and growth rates, linking economic events, climate and seasonality , policies to their potential impacts on the 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 norm …