Self-review: Prepare Sales Excel data :Deploy and Maintain Power BI Assets and Capstone project (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

Based on your observation of the first 10 records in the dataset, which product generated the highest Net Revenue?

❌ ProTile Cutter
❌ Luxury Paint (Blue)
✅ Power Drill Set

Explanation:
Although Luxury Paint (Blue) has a higher price (50.00 EUR), the feedback confirms it resulted in only 35.30 EUR net revenue, which is not the highest.
After comparing Net Revenue (Gross Revenue − Tax) across the first 10 records, Power Drill Set generates the highest net revenue due to a stronger combination of price and quantity sold.

Question 2

True or False: Net Revenue for each product is calculated by subtracting the tax amount from the gross revenue.

✅ True
❌ False

Explanation:
Net Revenue is calculated using the formula:

Net Revenue = Gross Revenue − Tax Amount

Therefore, the statement is True.

Question 3

What was your next step after calculating the gross revenue for each product?

❌ Immediately analyze the trends in the Sales Rep column.
❌ Ensure the Gross Revenue column reflects the multiplication of the product’s price by the quantity sold.
✅ Calculate each product’s Total Tax by multiplying the tax per product by the quantity sold.

Explanation:
After calculating Gross Revenue, the next logical step is to compute Total Tax. This is required to accurately calculate Net Revenue for each product.

🧾 Summary Table