Self-review: Adventure Works executive summary :Data Analysis and Visualization with Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

Based on your analysis of the column chart, which product category had the lowest Order Total?

✅ BMX Bikes
❌ E-Bikes
❌ Hybrid Bikes
❌ Kids Bikes

Explanation:
The column chart shows that BMX Bikes contribute the lowest total order value compared to other product categories.

Question 2

According to the line chart, which day had the lowest Order Total in the first quarter of 2023?

❌ March 26
❌ January 29
✅ February 10
❌ March 27

Explanation:
The line chart reaches its minimum point on February 10, indicating the lowest Order Total during Q1 2023.

Question 3

Based on your findings from the Q&A visual, which city had the lowest average Order Total?

✅ Baldwin Park
❌ Long Beach
❌ Berkeley
❌ Los Angeles

Explanation:
The Q&A visual analysis shows Baldwin Park has the smallest average order total among the listed cities.

Question 4

Based on your discoveries from the Q&A visual, which product category had the highest average Order Quantity?

❌ Road Bikes
✅ BMX Bikes
❌ E-Bikes
❌ Mountain Bikes

Explanation:
BMX Bikes have smaller individual prices but are often purchased in higher quantities, giving them the highest average order quantity.

Question 5

Which Product Subcategory had the highest Product Weight according to your analysis of the Q&A visual?

❌ Racing
❌ Long Distance
❌ Cross Country
✅ Downhill

Explanation:
Downhill bikes are built for durability and rough terrain, making them the heaviest product subcategory.