Intermediate Guide Generic ChatGPTClaudeKaggleGoogle Sheets
How to Use AI to Learn Data Analysis and Visualisation
Use AI as your personal tutor to learn Excel, Python, and SQL, then build dashboards for employers.
AI Snapshot
- ✓ Learn Excel functions, pivot tables, and formulas with AI explaining each concept
- ✓ Master SQL for querying databases through interactive AI tutoring
- ✓ Write Python scripts for data cleaning and analysis with AI reviewing your code
- ✓ Create professional dashboards and charts that impress hiring managers
Why This Matters
Deep work requires uninterrupted focus, but most days are fractured by administrative overhead. Emails, scheduling, status updates, minor decisions: none of this adds value, yet all of it consumes your attention and energy. When you're constantly switching between these small tasks and real work, neither gets your best effort. AI tools handle the administrative layer entirely, removing that context-switching tax. The result is longer uninterrupted blocks for the work that matters, lower cognitive load, and measurably better output because you're not mentally exhausted by the time you start the important stuff.
How to Do It
1
Start with Excel Fundamentals
Ask AI to explain VLOOKUP, INDEX-MATCH, pivot tables, and statistical functions. Request example datasets relevant to your industry, then practise transforming raw data into summaries.
2
Learn SQL Basics
Progress to SELECT statements, WHERE clauses, and JOIN operations. Use AI to explain SQL logic and review your queries on sample datasets.
3
Write Your First Python Script
Learn pandas and matplotlib for importing, cleaning, and visualising data. Ask AI to explain each line and suggest improvements.
4
Create Professional Visualisations
Build charts, heatmaps, and dashboards using Tableau or Power BI. Use AI to advise on which chart type suits different data stories.
5
Build a Portfolio Project
Find a public dataset relevant to your industry. Apply Excel, SQL, and Python to analyse it, visualise findings, and document insights.
What This Actually Looks Like
The Prompt
Example Prompt
**Scenario:** You're a marketing professional in Bangkok with no data experience, wanting to build skills for senior analyst roles.
Prompts to Try
Learning Plan
Create a [weeks]-week learning plan for data analysis. I want to learn [Excel/SQL/Python] from zero. I work in [industry]. Include weekly concepts, datasets, and mini-projects.
Code Review
I've written this Python script: [paste code]. Review for errors, explain each section, suggest more efficient approaches, and recommend best practices.
Visualisation Choice
I have data showing [describe dataset]. What chart type would best tell this story? Why? How would I build this in [Excel/Python/Tableau]?
Common Mistakes
Trying to learn Python and SQL simultaneously as a complete beginner
Master Excel first, then SQL (easier syntax), then Python. Each builds on the previous.
Building dashboards that look impressive but don't answer business questions
Before visualising, define the insight you're communicating. What decision does this dashboard help someone make?
Practising only on toy datasets
Use Kaggle or industry public datasets early. Real data has missing values and inconsistencies that teach cleaning skills.
Tools That Work for This
Claude or ChatGPT
Google Sheets or Excel
Kaggle
Frequently Asked Questions
Can I really learn data analysis with AI if I'm not technical?
Absolutely. Start with Excel, not Python. AI can explain concepts at your pace and answer questions repeatedly. Most people learn faster with AI tutoring than traditional courses.
How long to become job-ready?
2-3 months with 5-7 hours weekly. You'll be employable (Excel, SQL basics, simple dashboards) in this timeframe. Start applying once you've completed a portfolio project.
Next Steps
- Ask AI to create a 12-week learning plan for your industry and goals
- Download a free Kaggle dataset and spend 2 hours this week practising Excel pivot tables
- Set up Google Sheets and build your first IF formula guided by AI
- Download a free Kaggle dataset and spend 2 hours this week practising Excel pivot tables
- Set up Google Sheets and build your first IF formula guided by AI
Choose one recurring task to automate first—something that takes 15 minutes or more weekly. Once that's gone, identify your next time-sink.