Instiq
Chapter 4 · Enhance and analyze·v1.0.0·Updated 7/17/2026·~13 min

What's changed: Created PL-300 Chapter 4 (domain: Visualize and analyze, part 2 = enhance and analyze): usability and storytelling (bookmarks, custom tooltips, edit interactions, sync slicers, selection pane, drillthrough, navigation, mobile), accessibility and personalization (alt text/tab order/contrast, Personalize visuals, automatic page refresh), and identifying patterns and trends (Analyze feature, binning/clustering, key influencers/decomposition tree, reference lines/forecasting, anomaly detection).

4.3Identify patterns and trends

Key points

Understand the Analyze feature, grouping/binning/clustering, AI visuals (key influencers/decomposition tree), reference lines/forecasting, anomaly detection, and Copilot summaries.

Beyond showing data, find patterns and drivers. Power BI’s analysis features and AI visuals help.

4.3.1Analyze feature and grouping/clustering

The Analyze feature (e.g., right-click "explain the increase/decrease") auto-analyzes which factors drove a change. Grouping bundles values, binning splits numbers into fixed-width intervals, and clustering auto-groups similar data points (binning = manual intervals, clustering = automatic classification).

4.3.2AI visuals

Key influencers show "the factors that most affect an outcome (e.g., churn)." A decomposition tree drills down to break a measure into contributors by dimension, with AI suggesting "the next dimension to split by." Smart narrative turns key points into text. Use "what most influences" = key influencers, and "drill down to decompose" = decomposition tree.

4.3.3Reference lines, forecasting, anomaly detection

Add reference lines/error bars to lines to show baselines, and forecasting to estimate future values (requires a time series). Anomaly detection auto-detects outliers in a time series and suggests explanations. These appear as analytics in the Analytics pane.

Exam point

Cues: "auto-explain why it changed" = Analyze feature. "split numbers into fixed widths" = binning. "auto-group similar points" = clustering. "factors that most affect an outcome" = key influencers. "drill down to decompose by dimension" = decomposition tree. "estimate future values" = forecasting. "outliers in a time series" = anomaly detection.

Warning

Watch the mix-ups: (1) Binning (manual intervals) vs clustering (auto classification). (2) Key influencers (factor impact) vs decomposition tree (decompose by dimension). (3) Forecasting vs reference lines (future estimate vs baseline). (4) Forecasting/anomaly detection require a time series.

Diagram: the Analyze feature (auto-explain increases/decreases); binning (manual fixed-width intervals) vs clustering (auto-classify similar points); key influencers (top factors for an outcome) vs decomposition tree (drill down to decompose by dimension); reference lines/forecasting (future estimate on a time series) and anomaly detection (outliers in a time series).
Find the drivers

4.3.4Section summary

  • Analyze auto-explains changes; binning (manual) vs clustering (auto)
  • Key influencers = top factors; decomposition tree = decompose by dimension
  • Forecasting/anomaly detection need a time series; reference lines show baselines

Sign in to track progress — Log in.

Quick check

(just a quick review)

Q1. You want to auto-identify the factors most strongly influencing churn. Best AI visual?

Q2. You want to drill a sales measure down by region→product→channel to decompose drivers. Best AI visual?

Q3. You want to estimate future values from a sales time series. Best feature?

Q4. You want to split continuous age into fixed-width intervals like 0–9, 10–19. Best operation?

Q5. For a month where sales spiked, you want to auto-explain which factors contributed. Best feature?

Check your understandingPractice questions for Chapter 4: Enhance and analyze

Keep track of your progress

The full study guide is free to read. Sign up free to practice with the question bank, track what you have read, review your mistakes, and highlight passages.