Applied AICollège Unica
2.4SpecializationSession 2 · Data Engineering & Machine Learning

Exploratory data analysis

20classes60htotalTH2 · PR2 · PNW2weighting per class

Class-by-class breakdown

20 classes

TH = theory · PR = practical · PNW = personal work. These are ministry weighting codes (not hours) used to split each class's minutes. Class length = course hours ÷ class count; the three time-boxes below always sum to that length.

0%

Quiz progress

0 of 0 classes attempted

First 2 classes free with a referral 19 more with enrollment180 min per classTheory 60mPractical 60mPersonal Work 60m
1

EDA in the Age of Agents — Why Exploration Still Matters

FreeTH2PR2PNW2

A Data/Business Analyst who feeds clean, well-explored data into an agent gets trustworthy answers — agents amplify bad data as easily as good.

Theory60m
  • The EDA mindset reframed: question, inspect, question again — now with GenAI as a reasoning partner
  • Where LLMs help EDA (profiling, summarizing, narrating) vs where they hallucinate (counts, exact stats)
  • The agent-ready EDA workflow: collect → clean → explore → document for retrieval
Practical60m
  • Open a sample CSV in a notebook and paste its head into an LLM, asking three exploratory questions
  • Note one answer the LLM got right and one it got wrong
Personal Work60m
  • Write a one-page 'first questions' list for a sample dataset, marking which you'd ask an LLM vs compute yourself
  • Micro-task: submit your questions
2

Loading Data for Agents — CSVs, Excel and the pandas DataFrame

LockedTH2PR2PNW2

Locked class preview

An AI Integration Manager who loads data into a clean DataFrame can hand it to an agent's tools — structured input is what makes tool-calling reliable

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
3

Profiling with GenAI — dtypes, Columns and Structure

LockedTH2PR2PNW2

Locked class preview

A Data/Business Analyst who pairs info() output with an LLM profile gets a plain-English data dictionary in seconds — faster onboarding for every stakeholder

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
4

Missing Data — Finding Gaps an Agent Would Silently Ignore

LockedTH2PR2PNW2

Locked class preview

A Project Manager who ignores missing data approves agent answers built on holes — agents rarely volunteer that their input was incomplete

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
5

Cleaning with LLM Assistance — Drop, Fill or Flag

LockedTH2PR2PNW2

Locked class preview

A Data/Business Analyst who chooses the right missing-data strategy keeps results honest — and now can have an LLM draft the cleaning code to review

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
6

Cleaning Text and Categories — Whitespace, Case and Typos

LockedTH2PR2PNW2

Locked class preview

A Digital Marketing Strategist cleaning audience labels knows messy categories break every segment report — and break RAG retrieval when categories are the lookup keys

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
7

Duplicate and Outlier Detection — Guarding the Numbers

LockedTH2PR2PNW2

Locked class preview

An E-commerce Director whose sales data has duplicates double-counts revenue — and an agent summarizing that data would report the wrong total with confidence

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
8

Descriptive Statistics — Mean, Median and Mode (Computed, Not Generated)

LockedTH2PR2PNW2

Locked class preview

A Data/Business Analyst who computes stats themselves — instead of trusting an LLM's memory — keeps the numbers honest

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
9

Spread and Shape — Variance, Std Dev and Quartiles

LockedTH2PR2PNW2

Locked class preview

A Sales and Marketing Manager who understands spread knows whether 'average' sales are reliable — and whether an agent's confident summary is hiding wild variation

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
10

Grouping and Aggregation — Summarizing by Category

LockedTH2PR2PNW2

Locked class preview

A Data/Business Analyst who groups sales by region instantly answers 'where's the revenue?' — and can feed that grouped summary to an agent for deeper drill-downs

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
11

Filtering and Sorting — Slicing Data for Agent Context

LockedTH2PR2PNW2

Locked class preview

A Project Manager who filters data to a specific slice can give an agent just the relevant rows — focused context means better, cheaper agent answers

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
12

Visualizing Distributions — Histograms and Box Plots

LockedTH2PR2PNW2

Locked class preview

A Digital Marketing Strategist who visualizes a distribution spots skew and outliers instantly — and can describe the chart to an LLM for a written takeaway

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
13

Visualizing Categories — Bar Charts and Count Plots

LockedTH2PR2PNW2

Locked class preview

An E-commerce Director comparing product categories uses bar charts — and can turn the ranked list into an LLM-generated executive summary

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
14

Visualizing Relationships — Scatter Plots and Correlation

LockedTH2PR2PNW2

Locked class preview

A Data/Business Analyst who plots two variables against each other spots relationships — and can ask an LLM to hypothesize causes (without trusting them as fact)

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
15

Quick EDA in Excel — Pivot Tables and Agent-Ready Summaries

LockedTH2PR2PNW2

Locked class preview

A Sales and Marketing Manager often explores in Excel before any Python — pivot tables answer business questions in seconds and can be turned into agent context

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
16

EDA Output as RAG Context — Preparing Data for Retrieval

LockedTH2PR2PNW2

Locked class preview

An AI Integration Manager building a RAG system needs clean, summarized data chunks — EDA output becomes the retrievable knowledge an agent answers from

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
17

Telling the Story — From Charts to LLM-Assisted Narrative

LockedTH2PR2PNW2

Locked class preview

An AI Integration Manager who turns charts into a clear narrative gets decisions made — and an LLM can draft that narrative from computed findings for you to edit

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
18

EDA Ethics — Bias, Privacy and Honest Reporting with GenAI

LockedTH2PR2PNW2

Locked class preview

A Data/Business Analyst who reports honestly avoids cherry-picked charts — and must hold LLM-generated narratives to the same honesty standard

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
19

Putting It Together — A Full Agent-Ready EDA

LockedTH2PR2PNW2

Locked class preview

A Project Manager who runs a full EDA end to end — producing clean data, charts and a retrievable summary — proves the skill is real and agent-ready

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions
20

Present and Reflect — Your EDA Findings and GenAI Workflow

LockedTH2PR2PNW2

Locked class preview

A Data/Business Analyst who presents EDA findings clearly — and is honest about where GenAI helped — earns trust in an AI-augmented workplace

Enroll to unlock every class in this course — the full agenda, the AI tutor, and the quiz.

Talk to admissions

Unlock all 20 classes

Get the full agenda, AI tutor, and quiz for every class in 2.4 · Exploratory data analysis.

Apply via admissions

Online checkout not yet live — contact admissions to enroll.

Previous course

2.3 · French for the office and entrepreneurship

Next course

2.5 · Structured programming (Python)

Back to Session 2