Module quiz: Creating Reports :Data Analysis and Visualization with Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

True or False: While creating predictive visualizations in Power BI, you will use the Format, Data, and Analyze tabs in the Visualizations pane.

❌ True
✅ False

Explanation:
Predictive features like forecasting are accessed from the Analytics pane, not the Data section. Hence, the statement is incorrect.

Question 2

Which visualization is best for comparing many product categories with long labels?

✅ Bar chart
❌ Pie chart
❌ Line chart
❌ Column chart

Explanation:
Bar charts display labels horizontally, making them ideal for long or detailed category names.

Question 3

What are the key steps to create a Power BI report with visualizations?

✅ Connect to, transform, and load the data, create visualizations, and share the report
❌ Select a color scheme, design charts, and update the data regularly
❌ Build a data model, analyze the data, and present findings only
❌ Design charts, share reports, and collect feedback

Explanation:
The standard Power BI workflow includes data connection, transformation, visualization, and sharing.

Question 4

True or False: The main purpose of data visualization is to increase the amount of data collected.

❌ True
✅ False

Explanation:
Data visualization helps in understanding and communicating insights, not collecting more data.

Question 5

Which statement about using report space effectively is true?

❌ Chart type does not impact readability
✅ Treemap charts make more efficient use of space than pie charts
❌ Pie charts are more space-efficient than treemaps
❌ Both use the same space

Explanation:
Treemaps display hierarchical data efficiently, especially when space is limited.

Question 6

Which chart best represents daily closing stock prices over time?

❌ Area chart
✅ Line chart
❌ Pie chart
❌ Donut chart

Explanation:
Line charts are best for showing trends over time.

Question 7

Key differences between line & stacked column and line & clustered column charts
(Select all that apply)

❌ Clustered chart shows no trend
✅ Stacked column shows composition; clustered shows values side by side
✅ Line & clustered column charts can become cluttered with many categories
❌ Stacked charts cannot show negative values

Explanation:
Stacked charts focus on composition, while clustered charts focus on comparison.

Question 8

How can a funnel chart help understand a SaaS customer journey?

❌ Show social media engagement
❌ Display seasonal traffic trends
✅ Depict user drop-off at each stage of the journey
❌ Track stock market value

Explanation:
Funnel charts visualize conversion and drop-off between sequential stages.

Question 9

Which vehicles are outliers?
(Select all that apply)

❌ V5
✅ V6
✅ V7
✅ V10

Explanation:

• V6 → unusually high fuel efficiency

• V7 & V10 → unusually high engine power
  These significantly deviate from the rest of the dataset.

Question 10

True or False: KPI visuals are essential for every organization, regardless of size or industry.

❌ True
✅ False

Explanation:
KPI visuals are use-case dependent and not mandatory for all organizations.

🧾 Summary Table