Self-Review: Adventure Works Quarterly Report :Creative Designing in Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

You have presented a story as a Power BI report for the sales team. Your manager needs a QR code for the entire report for easy distribution. What is the best option?

❌ Publish report to Power BI service and generate a QR code of the report.
❌ Publish report to Power BI service, create a dashboard and pin report visuals to the dashboard and generate QR code.
✅ Publish report to Power BI service, pin entire report to dashboard and generate QR code.

Explanation:
QR codes can be generated only for dashboards, not directly for reports.
To share the entire report, you must pin the live report to a dashboard and then generate the QR code.

Question 2

Based on the visualizations, Adventure Works has ____________ in sales amount for the second quarter of 2020.

❌ 0.41M
❌ 0.14M
✅ 0.19M

Explanation:
The Q2 2020 sales total shown in the exercise visuals is 0.19M, as derived from the quarterly sales chart.

Question 3

Based on the story presented to the executive board, what is the primary concern revealed?

❌ The 1st quarter sales of 2020 is lower than the same period last year.
✅ Despite an increase in the sales, the profit margin is negligible.
❌ Australia has no sales for the first quarter of 2020.

Explanation:
The key insight from the story is that sales increased, but profit did not grow proportionally, which is a serious business concern.

Question 4

Alternative way to present year and quarter measures without slicers and filters in Power BI?

❌ By using SQL queries.
✅ By using DAX logic.
❌ By using Power Query editor.

Explanation:
DAX measures (using CALCULATE, FILTER, time-intelligence functions) allow dynamic calculations without slicers.

Question 5

True or False: Tsvi Reiter is the top-performing salesperson of Adventure Works for the first quarter of 2020.

❌ True
✅ False

Explanation:
The visual analysis shows that Tsvi Reiter is not the top performer for Q1 2020.

Question 6

What alternative chart types can be used to visualize sales by country without losing clarity? (Select all that apply)

✅ Map visual
✅ Bar chart
❌ Waterfall chart
❌ Line chart

Explanation:

• Map visuals are ideal for geographic comparisons

• Bar charts clearly compare values across countries

• Line charts are better for trends, not country comparison

• Waterfall charts show incremental changes, not comparisons

🧾 Summary Table