Self-review: Create a Profit report :Deploy and Maintain Power BI Assets and Capstone project (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

Which features in Power BI did you utilize to enhance the Profit report’s effectiveness? (Select all that apply)

❌ Forecasting in Area Charts
✅ Sorting axis in bar charts
❌ Data drilling in visuals
✅ Detailed labels in donut charts

Explanation:
Sorting the axis in bar charts helps quickly compare products based on net revenue. Detailed labels in donut charts clearly display yearly profit margins by country, making insights easier to understand at a glance. Forecasting and data drilling were not primary features used in this report.

Question 2

True or False: The area chart for Yearly Profit Margin over Time was primarily created for forecasting future sales volumes.

❌ True
✅ False

Explanation:
The area chart was used to analyze historical profit margin trends over time. It was not designed for forecasting future sales volumes.

Question 3

Which visuals did you create to help analyze profit data in the Profit Report? (Select all that apply)

❌ A line chart for Median Sales over Time
✅ A bar chart for Net Revenue by Product
✅ A donut chart for Yearly Profit Margin by Country
❌ A column chart for Quantity Sold by Product

Explanation:
The bar chart helps analyze product-wise net revenue, while the donut chart shows how profit margins are distributed across countries. These visuals directly support profitability analysis.

🧾 Summary Table