Study guide
9.1 The Analyze Feature and AI Visuals
Microsoft Power BI Data Analyst PL-300
Track your progress as you read
Finished sections get a check mark.
1 Introduction
About the PL-300 Exam The Power BI Ecosystem
2 Chapter 1: Get or Connect to Data
1.1 Data Source Types and Connections 1.2 Storage Modes: Import, DirectQuery, and Direct Lake 1.3 Data Source Settings and Parameters
3 Chapter 2: Profile and Clean the Data
2.1 Data Profiling in Power Query 2.2 Resolving Errors, Nulls, and Data Quality Issues 2.3 Data Types and Type Detection
4 Chapter 3: Transform and Load the Data
3.1 Column Transformations and Data Types 3.2 Grouping, Aggregating, Pivoting, and Unpivoting 3.3 Merge Queries, Append Queries, and Relationship Keys 3.4 Query Folding and Load Performance
5 Chapter 4: Design and Implement a Data Model
4.1 Star Schema Design 4.2 Relationships, Cardinality, and Cross-Filter Direction 4.3 Table and Column Properties 4.4 Calculated Columns and Calculated Tables
6 Chapter 5: Create Model Calculations with DAX
5.1 DAX Fundamentals and Measures 5.2 The CALCULATE Function 5.3 Time Intelligence Measures 5.4 Statistical Functions, Semi-Additive Measures, and Calculation Groups 5.5 Essential DAX Patterns and Functions Reference
7 Chapter 6: Optimize Model Performance
6.1 Performance Analyzer and DAX Query View 6.2 Model Size Reduction and Cardinality Management 6.3 DAX Optimization Patterns
8 Chapter 7: Create Reports
7.1 Visual Types and Selection 7.2 Visual Formatting and Conditional Formatting 7.3 Copilot in Power BI Reports 7.4 Report Page Configuration and Slicers
9 Chapter 8: Enhance Reports for Usability and Storytelling
8.1 Bookmarks, Navigation, and Drillthrough 8.2 Sorting, Selection Pane, Mobile Layout, and Accessibility 8.3 Export Settings and Automatic Page Refresh
10 Chapter 9: Identify Patterns and Trends
9.1 The Analyze Feature and AI Visuals 9.2 Using Copilot to Summarize the Semantic Model 9.3 Advanced Analytics Patterns
11 Chapter 10: Create and Manage Workspaces and Assets
10.1 Workspaces, Apps, and Content Distribution 10.2 Subscriptions, Alerts, and Semantic Model Refresh 10.3 Dashboards and Advanced Distribution
12 Chapter 11: Secure and Govern Power BI Items
11.1 Row-Level Security (RLS) 11.2 Sensitivity Labels, Item Access, and Governance 11.3 Deployment Pipelines and Content Lifecycle
9.1 The Analyze Feature and AI Visuals
Key Takeaways Explain This Topic AI
Analyze (right-click -> Explain the increase/decrease) auto-decomposes a change into ranked contributing categories via a waterfall.
Key Influencers ranks individual factors and (Top segments tab) factor combinations that drive a continuous or categorical target.
Decomposition Tree does interactive AI root-cause drilling using High value / Low value lightbulb splits.
Grouping combines discrete categories, binning creates equal-width numeric/date ranges, and clustering applies k-means to scatter points.
Forecasting (line chart, date axis) sets length, confidence interval, and seasonality; anomaly detection flags out-of-range points on time-series line charts with contributing-factor explanations.
Last updated: June 2026
Quick Answer: Power BI ships built-in AI/analytics that the PL-300 tests heavily. The Analyze right-click menu explains an increase/decrease automatically. Key Influencers ranks what drives a metric up or down. Decomposition Tree does interactive AI root-cause drilling. Q&A answers natural-language questions with auto-generated visuals. Supporting features — grouping/binning/clustering , forecasting , anomaly detection , reference lines/error bars — round out the analytics toolkit. Knowing which tool fits a stated goal is the recurring exam pattern.
The Analyze feature
Right-click a data point and choose Analyze -> Explain the increase (or decrease ). Power BI scans related dimensions, ranks the categories that contributed most to the change, and renders a waterfall decomposition you can swap to other visual types. Example for a Q3 vs. Q2 revenue jump: Electronics +$500K, West region +$300K, Enterprise segment +$200K. The related Analyze -> Find where the distribution is different highlights sub-categories whose distribution diverges from the overall pattern.
Key Influencers visual
The Key Influencers visual uses logistic/linear analysis to find which factors most move a target. Drag the target to Analyze and the candidate factors to Explain by . It has two tabs:
Tab Purpose
Key influencers Individual factors ranked by impact, e.g., "When Region is West, the likelihood of a High Rating increases 2.5x"
Top segments Combinations of factors that together form notably high or low segments
When the target is continuous , it explains what increases/decreases the value; when categorical , it explains what makes a record fall into a chosen category. The Count setting sets the minimum data points required for a factor to count as significant.
Decomposition Tree
The Decomposition Tree is interactive AI root-cause analysis. Drag the measure to Analyze and dimensions to Explain by . At each level you can click a category manually, or click the lightbulb (AI split) to let Power BI pick:
- AI split Behavior
- High value Expands the category with the highest measure value
- Low value Expands the category with the lowest measure value
Example: Analyze -> High value finds Electronics, then West region, then Q4 — surfacing the dominant contribution path automatically. You can expand multiple branches to compare paths.
Q&A visual
Insert -> Q&A lets users type natural-language questions ("total revenue by region", "top 10 products by profit", "revenue trend last 12 months") and Power BI generates the appropriate visual. Authors improve accuracy via Q&A setup : add synonyms (Revenue = Sales = Income), define suggested questions , teach Q&A new terms, and review the questions users ask. Q&A also has a built-in linguistic schema so it understands relationships and measures in the model.
Grouping, binning, and clustering
Technique What it does How
Grouping Combine discrete values into custom groups (US + Canada -> North America) Right-click values -> Group, or right-click field -> New group
Binning Create equal-width ranges for numeric/date fields (ages 0-18, 19-35...) Right-click field -> New group -> Bin type = Bin size or Number of bins
Clustering AI (k-means) grouping of scatter points into natural clusters Scatter chart -> More options -> Automatically find clusters
Reference lines, error bars, and forecasting
Use the Analytics pane on a visual:
Reference lines: constant line (e.g., target = 1,000,000), or statistical lines (Min/Max/Average/Median/Percentile).
Error bars: show variability via fixed value, percentage, percentile, standard deviation, or upper/lower-bound measures.
Forecasting: on a line chart with a continuous (date) axis, enable Forecast and set forecast length , confidence interval (e.g., 95%), seasonality (auto or a period like 12 for monthly), and Ignore last N points to hold out recent data. Power BI extends the line with a shaded confidence band.
Anomaly detection
On a line chart with a time axis , enable Analytics pane -> Find anomalies . Power BI builds an expected-value model, flags points outside the expected range, and — when you click an anomaly — shows the expected vs. actual value, the dimensions that contributed most, and a sensitivity setting (higher sensitivity flags more anomalies). For scatter-based outlier work, combine reference lines (average +/- standard deviation) with clustering.
Choosing between the AI visuals (the decision the exam loves)
Three AI visuals overlap enough that the exam tests the distinction directly:
Goal Best tool Why not the others
"What attributes make a record High vs. Low?" Key Influencers It ranks drivers statistically; Decomposition Tree only sums contributions
"Walk me down the biggest contributors interactively" Decomposition Tree It is hierarchical drill-down of a measure, not driver analysis
- "Explain the jump from last month" Analyze -> Explain the increase One-click waterfall; no setup needed
- "Let a non-technical user ask in English" Q&A Generates the visual from a typed question
A useful mental model: Key Influencers answers "why is the value what it is?" (driver attribution), while Decomposition Tree answers "where is the value concentrated?" (contribution drill-down).
Forecasting details that get tested
Forecasting requires a line chart with a continuous date/time axis (a categorical text axis won't work) and enough historical points for the chosen seasonality. Key settings: Forecast length (periods ahead), Confidence interval (default 95%; lower it for a tighter band), Seasonality (leave at automatic, or set a period — 12 for monthly data, 7 for daily-with-weekly-pattern), and Ignore last N points , which holds out recent actuals so you can visually compare the forecast against known values (a quick accuracy sanity check).
Forecasting uses exponential smoothing under the hood; it is prediction from history , which is why the exam contrasts it with what-if parameters (you-chosen scenario assumptions).
Anomaly detection vs. outlier finding
Anomaly detection is built for time series : it learns the expected pattern and flags points outside an expected band, with a Sensitivity slider (higher = more anomalies flagged) and an explanation pane showing which dimensions contributed. For non-time outliers (e.g., a revenue-vs-profit relationship), use a scatter chart plus reference lines at the mean and standard-deviation boundaries, or clustering to separate the outlier group. Knowing that anomaly detection is line-chart/time-axis-only is a frequent trap answer.
On the exam
The PL-300 maps scenarios to tools: "what factors drive satisfaction" -> Key Influencers; "interactively find where revenue is concentrated / root cause of a drop" -> Decomposition Tree; "explain the increase since last quarter" -> Analyze menu; "predict next 6 months with 95% confidence" -> Forecasting; "age brackets from a numeric field" -> Binning; "combine countries into regions" -> Grouping; "flag unexpected spikes in a time series" -> Anomaly detection; "let users ask questions in plain English" -> Q&A.