Process Flow

  1. Perform the data cleaning and transformation using Power Query -Change life_exp column data type to Decimal Number -Replace Errors, and enter the value null -Replace Errors of life_exp to null -Remove g77 column -Rename 'ife_exp' column to 'Life Expectancy' -Rename 'Name' column which contains country names to 'Country'

1 error load data.png

  1. Transform the Dataset

3 Transform Data Create new column year month.png

  1. Design a Dashboard -Visualization of Life Expectancy and GDP Variation Over Time

2 Life expectancy dashboard.png