Syllabus/Module 7/7.1 Data Analysis
Module 7 • Data Analysis

Stop Fighting With Excel

You don't need to know VLOOKUP. You just need to know how to ask.

The Problem

Messy data. Duplicates. Wrong formats.
Usually, you spend hours fixing this manually.

John Doe, 555-1234, 2024-01-01
JOHN DOE, (555) 123-4444, Jan 1st
Jane Smith, ,, 2024/02/02

The Fix

Upload the CSV to Gemini and say:

"Clean this data."
Gemini Data Analyst Simulation
Sales_Data_Q3.csv
Read-Only
⚠️ Raw Data (Messy)
Name
Date
Amount
John Doe
JOHN DOE (Dup)
Jane Smith
NULL

📊 The "Talk to Data" Prompt

"I am uploading a sales report.

1. Clean it: Remove duplicates and fix date formats.
2. Analyze: Which product category has the highest growth month-over-month?
3. Visualize: Create a bar chart showing sales by region."