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

Question 1

What type of chart did you use to visualize Loyalty Points by Country?

✅ Clustered bar chart
❌ Line chart
❌ Pie chart

Explanation:
A Clustered bar chart is ideal for comparing values across categories. It clearly shows Loyalty Points by Country, where each bar represents a country and its length reflects the loyalty points value.

Question 2

True or False: The UAE has the highest loyalty points among the listed countries, leading the chart with 151 loyalty points.

❌ True
✅ False

Explanation:
This statement is False.
The UK leads the chart with 315 loyalty points, indicating stronger customer engagement and a more mature loyalty program compared to other countries.

Question 3

Which of the following metrics did you use to create a Card visual? (Select all that apply)

✅ Quantity Purchased
✅ Median Sales
❌ Loyalty Points
✅ Stock

Explanation:

• Quantity Purchased was shown using a Card visual to highlight overall sales volume.

• Median Sales was displayed as a Card to represent the central value of sales while reducing the effect of outliers.

• Stock was also tracked using a Card to provide a quick snapshot of inventory levels.

• Loyalty Points were visualized using a bar chart, not a Card.

🧾 Summary Table