Goal path for analysts

Data and SQL With AI

Spreadsheets, pandas and SQL with an AI assistant, then a chat-with-your-database agent and dashboards.

Steps
5
Lessons
31
Time
7 h 33 min
Done
0 / 31

Already know some of this? Start at step 1 (beginner), step 4 (intermediate), step 5 (advanced).

  1. Office and Productivity

    Track 1: Using AI Tools, 4 lessons

    1. 1. AI in Excel and Google Sheets Beginner, 13 min
      Coming soon
    2. 2. AI for Email, Docs, Meetings and Slides Beginner, 11 min
      Coming soon
    3. 3. Analyse Real Spreadsheets With ChatGPT and Claude Advanced, 14 min
      Coming soon
    4. 4. AI Browsers and Agent Modes: What Works Today Advanced, 13 min
      Coming soon

  2. Notebooks and Google Colab

    Track 3: Python for AI, From Zero, 8 lessons

    1. 5. Colab Basics: Notebooks, Runtimes, Files, Sharing Beginner, 15 min
      Coming soon
    2. 6. Python and Data in Colab: Sheets, Drive, Charts Beginner, 20 min
      Coming soon
    3. 7. Gemini Inside Colab: Generate, Explain, Fix Code Intermediate, 15 min
      Coming soon
    4. 8. Colab GPUs: T4, L4, A100 and What Costs Units Intermediate, 15 min
      Coming soon
    5. 9. Run Open AI Models on Colab Without Breaking It Advanced, 25 min
      Coming soon
    6. 10. Colab Reliability: Version Clashes, Secrets, Disconnects Advanced, 15 min
      Coming soon
    7. 11. Share an AI Demo From Colab With Gradio Advanced, 15 min
      Coming soon
    8. 12. Colab Capstone: PDF or Recording to Summary and Actions Advanced, Project, 15 min
      Coming soon

  3. Python Fundamentals

    Track 3: Python for AI, From Zero, 6 lessons

    1. 13. Variables, Strings, Lists and Dictionaries Beginner, 12 min
      Coming soon
    2. 14. If, Loops and Conditions Beginner, 12 min
      Coming soon
    3. 15. Functions, Modules and Debugging Beginner, 12 min
      Coming soon
    4. 16. Files and Folders With pathlib Intermediate, 11 min
      Coming soon
    5. 17. Type Hints and Pydantic Models Advanced, 12 min
      Coming soon
    6. 18. Async Python for AI Apps Advanced, 13 min
      Coming soon

  4. Data, JSON and APIs

    Track 3: Python for AI, From Zero, 7 lessons

    1. 19. JSON for AI Developers Beginner, 11 min
      Coming soon
    2. 20. Call an API From Python Beginner, 12 min
      Coming soon
    3. 21. Environment Variables and API Keys, Safely Beginner, 10 min
      Coming soon
    4. 22. pandas Basics for AI Work Intermediate, 14 min
      Coming soon
    5. 23. Quick Interfaces: Streamlit and Gradio Intermediate, 12 min
      Coming soon
    6. 24. Build an API With FastAPI Advanced, 14 min
      Coming soon
    7. 25. Testing With pytest Advanced, 12 min
      Coming soon

  5. Data and SQL With AI

    Track 3: Python for AI, From Zero, 6 lessons

    1. 26. Clean and Explore Messy Spreadsheets With AI Intermediate, 13 min
      Coming soon
    2. 27. pandas With an AI Assistant: Ask, Check, Run Intermediate, 14 min
      Coming soon
    3. 28. Text-to-SQL: Ask Your Database in Plain English Intermediate, 15 min
      Coming soon
    4. 29. Build a Chat-With-Your-Database Agent Intermediate, 18 min
      Coming soon
    5. 30. AI-Built Dashboards in Streamlit and Looker Studio Intermediate, 15 min
      Coming soon
    6. 31. Project: Sales Insights Assistant Intermediate, Project, 35 min
      Coming soon

Ticks and “you are here” are saved only in this browser.

Other paths

Changing goals is fine. Lessons you finish count on every path that includes them.