Microsoft Certified: Fabric Analytics Engineer AssociateExplore and analyze data (15-20%)Easy
A data analyst is designing a Power BI report using data from a Lakehouse SQL endpoint in Microsoft Fabric. They want to create a visual that shows the correlation between `marketing_spend` and `sales_revenue` for different product categories. Which Power BI visual type is most effective for displaying the relationship between two numerical variables and identifying potential outliers?
- ALine chart
- BTable
- CBar chart
- DScatter chart
Show answer & explanationAnswer & explanation
Correct answer: D. Scatter chart
A scatter chart is specifically designed to display the relationship between two numerical variables. Each point on the chart represents an observation, with its position determined by the values of the two variables, making it excellent for visualizing correlation and identifying outliers.
Why the other options are wrong
- A. A line chart is primarily used to show trends over time or across ordered categories, not for the correlation between two independent numerical variables.
- B. A table displays raw data and aggregated numbers but does not visually represent the relationship or correlation between variables.
- C. A bar chart is best for comparing discrete categories or showing a single measure per category, not for showing the relationship between two continuous numerical variables.
Scatter Chart for Correlation
A Power BI visual type that plots individual data points on a two-dimensional plane, where each axis represents a numerical variable, used to display the relationship or correlation between the two variables.
- Shows relationship between two numerical variables.
- Each point represents an observation.
- Helps identify patterns, clusters, and outliers.
- Can be enhanced with trend lines or regression lines.
Memory trick: Scatter points for relationships, each dot tells a story.