BYU Student Author: @IWillyerd
Reviewers: @Jonathan_Weston, @Jae
Estimated Time to Solve: 15 Minutes
We provide the solution to this challenge using:
- Power BI
Need a program? Click here.
Overview
You’re the personal assistant to a wise and powerful financial analyst. She wants to figure out the “code” to becoming a billionaire, but she’s worried the cards are stacked against her. So, your task is to make some PowerBI visualizations to help your financial analyst boss feel better about her chances.
Instructions
- Open PowerBI Desktop or PowerBI Online and create a new report.
- Create the following visualizations with the data provided:
- Clustered column chart that displays each billionaire’s net worth on the y-axis and their name on the x-axis.
- A basic card that shows the average net worth of the billionaires.
- A basic card visualization to display the average age of the billionaires.
- A tree map visualization that shows the number of billionaires in each industry.
- Organize the visualizations in a visually cohesive manner. Edit the titles of the visualizations as needed.
- Format the visualizations to make them visually distinct:
- Add data labels to the clustered column chart.
- Add a visual border to each visualization.
- Add a grey background to the age card.
- Answer the following questions using the report to see how the data relates:
- What is the average net worth of billionaires in the technology industry?
- What is Christy Walton’s net worth and age?
- How many billionaires made their money in the service industry?
- Which industry has produced the most billionaires?
Data Files
Suggestions and Hints
Hover over the following buttons to see the visualization type names (Card, Stacked Bar Chart, etc.)
Solution
Solutions to the Questions
- What is the average net worth of billionaires in the technology industry?
– 6.59 - What is Christy Walton’s net worth and age?
– 7.90 Billion and 73 years old - How many billionaires made their money in the service industry?
– 51 - Which industry has produced the most billionaires?
– Finance & Investments
Challenge20_Solution.pbix
Solution Video: Challenge 20|POWERBI – Forbes Billionaires