8.2 Chart Types & Visualization Selection

Databricks Certified Data Analyst Associate Exam

Track your progress as you read

Finished sections get a check mark.

1 Platform Overview & Unity Catalog Foundations

1.1 Databricks Architecture & Compute Concepts 1.2 Databricks Marketplace & Data Sharing Basics 1.3 Unity Catalog Namespace & Object Hierarchy 1.4 Governed Asset Discovery & System Tables

2 Managing & Cleaning Governed Data

2.1 Dataset Discovery & Asset Tagging 2.2 Lineage Inspection & Data Traceability 2.3 SQL Data Cleaning & Transformation Techniques

3 Data Ingestion & Import Patterns

3.1 Workspace Uploads & Cloud File Ingestion 3.2 Incremental File Ingestion with Auto Loader 3.3 Ingesting Data via Delta Sharing & External Connections

4 Databricks SQL Warehouses & Core Querying

4.1 Databricks SQL Interface & SQL Assistant 4.2 SQL Warehouses Sizing & Management 4.3 Table Creation & Data Modification in Databricks SQL

5 Advanced SQL Authoring & Time Travel

5.1 Advanced Aggregations, Window Functions & Analytics 5.2 Complex Joins, CTEs & Set Operations 5.3 Views, Materialized Views & Delta Time Travel

6 Query Performance Analysis & Photon Engine

6.1 Photon Engine Architecture & Acceleration 6.2 Query History & Execution Profile Inspection 6.3 Delta Lake Audit History & Commit Logs

7 Liquid Clustering, Caching & Performance Troubleshooting

7.1 Caching Hierarchy in Databricks SQL 7.2 Data Layout Optimization: Liquid Clustering vs Partitioning & Z-Ordering 7.3 Troubleshooting Slow & Failing Queries

8 AI/BI Dashboards & Visualization Design

8.1 AI/BI Dashboards Overview & Canvas Layout 8.2 Chart Types & Visualization Selection 8.3 Notebook & SQL Editor Visualizations

9 Dashboard Interactivity, Publishing & Alerts

9.1 Dashboard Parameters & Interactive Filtering 9.2 Publishing, Sharing & Access Control 9.3 Scheduled Refresh, Email Subscriptions & Alerts

10 Developing & Maintaining AI/BI Genie Spaces

10.1 AI/BI Genie Architecture & Space Setup 10.2 Curation via Instructions, Descriptions & Sample Questions 10.3 Trusted Assets & Parameterized Functions 10.4 Monitoring, Benchmarks, Feedback & Maintenance

11 Data Modeling & Medallion Architecture

11.1 Dimensional Modeling Fundamentals 11.2 Medallion Architecture for Analytics 11.3 Constraint Enforcement & Relationships in Unity Catalog

12 Securing Data & Unity Catalog Governance

12.1 Unity Catalog Privilege Model & Grants 12.2 Ownership, Inheritance & Access Control Patterns 12.3 Fine-Grained Security: Row Filters & Column Masks

8.2 Chart Types & Visualization Selection

Key Takeaways Explain This Topic AI

Choosing appropriate visualization types depends on data dimensionality: Bar charts for discrete categorical comparisons, Line/Area charts for continuous time-series trends, and Scatter plots for continuous two-variable correlation analysis.

Pie and Donut charts must be limited to 5 or fewer slices to maintain legibility; categories beyond this threshold should be grouped into an 'Other' bin or converted into a horizontal bar chart.

High-cardinality continuous plots in Databricks AI/BI enforce client-side rendering caps (such as 10,000 data points for scatter plots and line charts) to maintain browser responsiveness, requiring server-side SQL binning or aggregation for larger datasets.

Counter and KPI widgets display single-value scalar metrics with optional reference targets, trend direction indicators, and percentage variance comparisons against historical baselines.

Pivot tables and Data tables support conditional formatting rules, column reordering, cell highlighting, and client-side sorting for deep tabular inspection of structured records.

Last updated: July 2026

8.2 Chart Types & Visualization Selection

Exam Focus: Selecting the correct chart type based on data dimensionality, business questions, and performance constraints is heavily tested on the Databricks Data Analyst certification. Candidates must understand visual design principles, pie chart slice thresholds, dual-axis configuration, and server-side aggregation strategies required when dataset size exceeds visual rendering limits ( 10,000 data points ).

Visualization Design Framework for Databricks Analysts

Effective visualization design transforms complex SQL query outputs into intuitive, actionable insights. In Databricks AI/BI Dashboards, visualization widgets receive data from defined dataset SQL queries. Selecting an inappropriate chart type can obscure data trends, mislead decision-makers, or degrade browser rendering performance. Analysts must evaluate three primary criteria when selecting a visualization:

Data Dimensionality: Continuous numeric variables, discrete categorical variables, or temporal (time-series) dimensions.

Analytical Objective: Categorical comparison, part-to-whole decomposition, trend identification, correlation analysis, or single-value KPI tracking.

Cardinality & Scale: The number of unique categories or total data points returned by the query.

• Categorical & Part-to-Whole Visualizations
• Bar and Column Charts

Bar and column charts are the workhorses of categorical data analysis:

Vertical Column Charts: Best suited for comparing discrete categories across ordinal time intervals (e.g., quarterly revenue across 4 quarters).

Horizontal Bar Charts: Recommended when category names are long (e.g., product titles or URL paths) or when dealing with numerous categories. Horizontal alignment allows readable text labels without truncation.

Stacked Bar Charts: Display total category volumes while showing the relative contribution of sub-categories. However, comparing sub-category segments above the baseline becomes difficult due to varying starting points.

100% Stacked Bar Charts: Normalize category totals to 100%, focusing strictly on relative percentage composition rather than absolute volumes.

Pie and Donut Charts: The 5-Slice Rule

Pie and donut charts display part-to-whole relationships where all categories sum to 100% of a single total.

CRITICAL EXAM RULE: Pie and Donut charts must never exceed 5 slices . When a categorical dimension contains more than 5 slices, human visual perception fails to accurately compare relative slice angles and areas.

When dealing with high-cardinality categorical data (e.g., 15 sales regions), analysts must apply one of two remediation techniques:

SQL Grouping: Use a SQL CASE statement to group minor categories into a consolidated 'Other' bucket, ensuring total slices remain ≤ 5 \le 5 ≤ 5 .

Chart Conversion: Convert the visualization into a horizontal bar chart sorted in descending order by value. -- SQL Strategy: Binning minor categories into 'Other' for Pie Chart compliance

• SELECT
• CASE WHEN rank <= 4 THEN region ELSE 'Other' END AS display_region,
• SUM(sales_amount) AS total_sales
• FROM (
• SELECT region, sales_amount, DENSE_RANK() OVER (ORDER BY SUM(sales_amount) DESC) AS rank
• FROM main.sales.gold_orders
• GROUP BY region, sales_amount
• )
• GROUP BY 1;
• Time-Series, Dual-Axis & Correlation Visualizations
• Line and Area Charts

Line charts represent continuous time-series data, enabling quick identification of trends, seasonality, and sudden anomalies. Area charts shade the region below the line, emphasizing cumulative volume over time.

Dual-Axis Line Charts

When comparing two continuous metrics measured in completely different units or magnitudes (e.g., Total Monthly Revenue in Millions of USD versus Customer Churn Rate % ), plotting them on a single Y-axis makes the percentage line appear flat at zero. Analysts must configure a Dual-Axis Line Chart , placing Revenue on the primary left Y-axis and Churn Rate % on the secondary right Y-axis.

Scatter Plots and Bubble Charts

Scatter plots display relationships between two continuous numeric variables (e.g., Marketing Spend vs. Conversion Count ), revealing linear correlation, clustering, or outliers. Bubble Charts extend scatter plots by introducing a third continuous variable encoded as bubble diameter, and an optional fourth categorical variable encoded by color.

Summary Metrics & Tabular Displays

Chart Type Primary Use Case Required Input Dimensions Key Formatting Option

Counter / KPI Executive summary scalar metrics 1 numeric metric (+ optional 1 target) Color-coded % delta indicator

Data Table Granular record inspection N N N columns (text, numeric, dates) Conditional cell formatting & search

Pivot Table Multi-dimensional cross-tabulation Rows (category), Columns, Values Aggregation functions (SUM, AVG, COUNT)

Heatmap 2D matrix density visualization 2 categorical axes + 1 numeric value Color gradient scale intensity

Counter (KPI) widgets highlight critical business metrics at a glance. They display a prominent primary scalar value (e.g., $12.4M ), an optional secondary comparison metric (e.g., Target: $10.0M ), and an automated variance indicator ( +24% vs Q1 ). Data tables and pivot tables provide detailed multi-column breakdowns, supporting client-side column sorting, conditional formatting (highlighting cells in green/red based on value thresholds), and searching.

Visual Rendering Limits & Server-Side Aggregation

To ensure web browser stability and responsive rendering, Databricks AI/BI enforces a maximum visual rendering threshold of 10,000 data points for high-cardinality line charts and scatter plots.

If a SQL dataset returns 500,000 raw rows to a line chart widget, the client browser cannot efficiently render 500,000 SVG DOM elements. Databricks will either downsample the points or truncate the visualization, resulting in misleading trend lines. To prevent data truncation, data analysts must execute server-side SQL aggregation on the SQL Warehouse before sending data to the visualization layer:

Group raw timestamp data using DATE_TRUNC('hour', event_timestamp) or DATE_TRUNC('day', event_timestamp) .

Apply numeric binning using ROUND() or WIDTH_BUCKET() for scatter plot variables.