Description
Using the data in the attached four files (customer.xlsx, order_detail.xlsx, order_header.xlsx, and product.xlsx), complete the following:
A.Ingest all four files into one copy of your Power BI starter file
B.Create three relationships among the four tables customer to order_header, order_header to order_detail, and order_detail to product
C.Identify the parameters in each of the business questions below by changing their text colors as follows (the first question is already done for you):
a.Filter or sorting parameter = red text
b.Field parameter = blue text
c.Aggregation parameter = green text
D.In Power Query Editor, create a query that answers each of the following business questions. Name the queries using the numbers shown in the table below.
E.Record the answer to each query in the table below using a screen shot of your query in Power BI (screen shot just the query, not the menus in Power BI).
|
# |
Business Question Example |
Answers |
|
1. |
What is the full name of the customer that placed the most recent order? |
|
|
2. |
How many customers are from Maryland (abbreviated MD)? |
|
|
3. |
What products have the word cream in the name? |
|
|
4. |
What products cost $5 or more? |
|
|
5. |
What products in the cake category cost more than $12? |
|
|
6. |
What customers live in OH or are male? |
|
|
7. |
How many products have been sold in total? |
|
|
8. |
How many of each product have been sold? |
|
|
9. |
How many products are in each category? |
|
|
10. |
How many different states are represented in the customer information? |
|
|
11. |
What is the average price of products in the bread category? |
|
|
12. |
What customers from Ohio have purchased Ciabatta buns? |
