/
Write
Start a team blog
NEW ✨
Start a team blog, invite your team, and start publishing.

Post hidden from Hashnode

Posts can be hidden from Hashnode network for various reasons. Contact the moderators for more details.

The Journey

HOW IT IS GOING

dorcas ehi's photo
dorcas ehi
·Jun 26, 2022·

2 min read

I remembered the last time I was talking about the start of my journey, so i am still in the journey. This week I tried to get my hands on datasets for practice when I came across the onyx data challenge. This month they are analyzing the Forbes billionaire data, the goal is to get the month philanthropic and the industry that drives the most billionaires. DATA STRUCTURES The data was gotten from Kaggle with the help of onyx data. It is a CSV file which includes list of various billionaires which includes their final worth ,bio ,and the organization. DATA PROCESSING

  • Firstly Imported the data into Power BI with the get data tool which I then transformed using power query. I removed the duplicate data and also set the data in their proper format.

powerbi task 1.png

powerbr task 2.png ANALYSING THE DATA The cleaned data was the loaded into power bi desktop.

data from onyx.png

After which a model was created to help in proper visualization of data

data model 1.png

DASHBOARDING Finally the dashboard was created using a stacked column bar chart, with navy and white,

FORBES DASHBOARD.png

FINAL DASHBOARD.png

From the dashboard it can be seen that Warren Buffet is the most philanthropic billionaire with a final worth of $118B and the Technology industry drives the most billionaires.

Thankyou for reading, till next time.