Exploratory Data Analysis (EDA) with Hex

Exploratory data analysis (EDA) is the foundation of effective data work—but many analysts lack structured, end-to-end practice in a single environment. This course builds that foundation in Hex, where AI assists with SQL and Python so you can focus on understanding your data—not writing code.

Data analyst Chris French has you begin by connecting to a dataset and using the Hex AI agent to generate your first queries. Then, examine the structure of your data, including rows, columns, time ranges, and categories, and assess its quality through summary statistics and distributions. As you explore, slice the data in different ways to uncover patterns, differences, and trends across time and categories. Test your assumptions against the data and investigate results that challenge your expectations. Throughout the process, create charts and summary views that clearly communicate your findings, helping you move from raw data to confident, well-supported insights.

Learning objectives
Connect to a dataset in Hex and navigate the notebook interface to begin analysis.
Use the Hex AI agent to query and explore data without writing SQL or Python.
Examine dataset structure, including rows, columns, time ranges, and categories.
Profile data to assess quality, distributions, and completeness.
Analyze patterns and trends across time and categories to generate insights.
Test assumptions by comparing expected results with actual data outcomes.
Create charts and summary tables in Hex to clearly communicate findings.