Module Quiz: Designing Powerful Report Pages :Creative Designing in Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

What programming languages can you use to create custom visuals in Microsoft Power BI reports? (Select all that apply)

❌ DAX
✅ R
❌ SQL
✅ Python

Explanation:
Custom visuals in Power BI can be created using R and Python.
DAX is used for calculations, and SQL is used for querying data sources—not for building visuals.

Question 2

What additional elements are often included in a KPI visual to provide context for the metric? (Select all that apply)

✅ Trend axis
❌ Hierarchy
❌ Location information
✅ Target value

Explanation:
KPI visuals usually include a trend axis (to show change over time) and a target value (to compare actual vs goal).

Question 3

Which chart best shows correlation between sales and profit for each product category?

❌ Scatter chart
✅ Bubble chart
❌ Dotplot chart

Explanation:
A Bubble chart shows correlation between two numeric values (sales & profit) and can also represent category size.

Question 4

Comparing a large number of data points is common to Scatter, Bubble, and Dot plot charts.

✅ True
❌ False

Explanation:
All three charts are designed to compare many data points and identify patterns, trends, or correlations.

Question 5

Which feature helps visually impaired users understand chart content?

✅ Adding Alt text to the chart
❌ Turning data labels on
❌ Adding a descriptive heading

Explanation:
Alt text is read by screen readers and is essential for accessibility compliance.

Question 6

You cannot plot geographical information without latitude and longitude.

❌ False
✅ True (correct answer is ❌ False)

Explanation:
Power BI can plot maps using country, state, city names, even without latitude/longitude.

Question 7

Which map type allows visualization of country boundary information?

❌ 3D Map
✅ Shape Map
❌ Filled Map

Explanation:
Shape Maps are used to display custom boundaries like countries, regions, or states.

Question 8

Which map visual is best when data is hosted on Microsoft Cloud and includes franchises and sales?

❌ 3D custom maps
❌ Shape maps
✅ Azure maps

Explanation:
Azure Maps integrates well with Microsoft Cloud and supports rich geospatial analysis.

Question 9

You can format Python visuals using the Format visual pane in Power BI.

❌ False
✅ True (correct answer is ❌ False)

Explanation:
Python visuals are formatted inside Python code, not via Power BI’s Format pane.

Question 10

Which chart best highlights areas with most and least website clicks?

❌ Donut chart
❌ Treemap
✅ Heatmap

Explanation:
A Heatmap visually highlights intensity using color, making it ideal for click distribution analysis.

🧾 Summary Table