learn

intermediate

ChatGPT

Claude

Kaggle

Google 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.

9 min read26 February 2026

Excel

Python

SQL

data visualisation

dashboards

career skills

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

How to Do It

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.

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.

Write Your First Python Script

Learn pandas and matplotlib for importing, cleaning, and visualising data. Ask AI to explain each line and suggest improvements.

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.

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

**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

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.

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

Cookie Consent