DVT Project Ru
ic
Problem Statement:
The "Billionaire detailed.csv" dataset contains information on the net worth, source of wealth, industry, and geographic location of over 2,000 billionaires worldwide, as of 2014. The data was collected by Fo
es and includes both self-made and inherited billionaires, as well as those who made their fortune through a combination of both.
Consider that you are a Lead Data Analyst and you are provided with a billionaire detailed dataset. You have been given a task to explore the data, create different plots and interpret useful insights/findings. Your end goal here will be to create a few dashboards and a story that you have to present to the respective team, make sure they follow a logical flow to display that you are heading towards achieving the end objective. Make sure to have minimum clutter in the plots, follow a consistent color scheme across all the plots, and use proper colors to highlight a specific insight. Moreover, your plots should be interactive and responsive.
Using the billionaires dataset, understand the data variable description and answer the following questions accordingly.
· Create a calculated field on Total Net Wealth to remove the special characters in the data. Name the calculated field as Net Wealth. (2 marks)
· Using a Word Cloud, find the industry sources which have the highest number of billionaires. (3 marks)
· Using a bar chart, find the top N Billionaires. Use a parameter to customize the input. (5 marks)
10.0Â pts
Display the age distribution of the billionaires. Find the youngest and oldest billionaire
5.0Â pts
Create a calculated field to differentiate the marital status as Ma
ied or not Ma
ied. Create a donut chart display on marital status. Use country and industry filters to customize the view.
1.0Â pts
Create a map chart using the billionaire dataset. Display the count of billionaires in each country. Find the count of Billionaires with self made status.
4.0Â pts