Data Analysis using PowerBI
Using Power BI, complete the following steps:
1.Ingest the Excel file into Power BI (use your starter file)
2.Examine the data to make sure it was properly ingested
3.Create one visualization for each of the questions below. Add each visualization to a new page and rename the page to the corresponding question number.
Number |
Type of Query or Visualization |
Business Question Example |
1. |
Bar |
What is the average income of customers by the type of credit card they possess? |
2. |
Column |
How many customer service emails were received from each state? |
3. |
Column with filter |
How many PA customers had their first purchase each month in 2018? |
4. |
Clustered column |
How many products did female and male customers from each state buy? |
5. |
Clustered column with filter |
What is the average household size among male vs. female customers that made their first purchase in 2016 vs. 2017 vs. 2018? |
6. |
Stacked |
Which state has the highest total number of cars and which gender within each state has highest number of cars? |
7. |
Line |
How many new customers were recorded each year? |
8. |
Scatter |
What is the relationship between customer income and number of products bought by the customers? |
9. |
Word Cloud |
What is the most common job title? |
10. |
Map |
Which geographical location (state) has the highest average income? |
SAMPLE ASSIGNMENT
