Suicide Rate in the word (1985-2016)

To complete this project given to me on the side hustle boot camp the steps listed below were taken.

Step1. I found a data set on Kaggle that contained information on the Country,year: from 1985 to 2016,
Sex, Age: Age groups include "5-14", "15-24", "25-34" "35-54", "55-74", and "75+", Number of suicides, Population and GDP.

Step 2. I skimmed through the data in Excel and deleted columns I didn’t need.

Step 3. I needed to add a continent column and the dataset I found didn’t have it. I got a data set that contained countries and their continents. I loaded the dataset in a sheet in the Excel workbook that had the suicide data.

Step 4. I created a new column in the sheet for the suicide data set and used the VLOOKUP function to match the countries to the continent.

Step 5. I loaded my dataset on power bi on which I checked for inconsistencies to ensure my data was clean using the transform data plane.

Step 6. I created new measures to calculate the number of countries, total population, and total number of suicides.

Step 7. Finally went ahead to create visuals comparing different data points.