All courses

Course

Data Analytics

An 8-week, AI-supported learning journey for aspiring analysts, researchers, students, and curious professionals. Learn to use frontier AIs alongside Excel, Power Query, pivot tables, and Python, then apply the same tools to academic research, writing, presentations, speaker notes, and voiceovers.

  • 25 video lessons
  • Marked assignments
  • Learn at your own pace
Enrol and pay by bank transfer

Syllabus

Week 1: Orientation and Excel foundations
  • Course outcomes, responsible AI use, and your independent learning system
  • The modern data analyst roadmap
  • Excel concepts that support reliable analysis

Week 2: Excel with ChatGPT and Claude
  • ChatGPT as an Excel copilot
  • Claude inside Excel: formulas, cleaning, analysis, and reports

Week 3: Power Query, pivot tables, and AI-assisted analysis
  • Repeatable data preparation with Power Query
  • Pivot tables and an Excel dashboard
  • Analysing a dataset with ChatGPT while verifying every result

Week 4: Python with AI
  • Google Colab setup
  • A focused Python and pandas class
  • Data analysis with Claude Code in VS Code

Week 5: Claude skills and research workflows
  • Build, run, and share Claude skills
  • Claude for researchers
  • A transparent AI literature review workflow

Week 6: Academic writing with integrity
  • Drafting and revising research papers with AI
  • Your own academic writing skills and plugin in Claude
  • Citation checking and academic integrity

Week 7: Presentations with AI
  • Gamma AI
  • Building and improving PowerPoint decks with Claude and other AI tools

Week 8: Speaker notes, voiceover, and next steps
  • Speaker notes and scripts that sound like you
  • Recording a voiceover in PowerPoint and with an AI voice
  • Your independent 90-day plan

All students follow the same sequence. Learning patterns highlight the lessons most useful to each learner without hiding or reordering prerequisites. Every lesson links to practice files or tools, either in the video description or in the DeeNexus Resource library. Paid AI plans are optional upgrades, not a course requirement.

What you will cover

Skill

  • 02The Data Analyst Roadmap for 2026
  • 03Useful Excel Concepts for Data Analysis
  • 04Use Excel with ChatGPT as a Copilot
  • 05Claude for Excel: Complete Beginner Guide
  • 06Clean, Transform, and Analyse Data with Claude inside Excel
  • 07Power Query for Repeatable Data Preparation
  • 08Build an Excel Dashboard with Pivot Tables
  • 09Analyse Data with ChatGPT

Implementation

  • 10Google Colab for Python Beginners
  • 11Python and pandas for Data Analysis in 20 Minutes
  • 12Data Analysis with Claude Code in VS Code
  • 13Claude Skills: Build, Run, and Share
  • 14Claude for Researchers
  • 15A Practical AI Literature Review Workflow
  • 16Write and Improve Research Papers with AI
  • 17Build Your Academic Writing Skills and Plugin in Claude
  • 18Check Citations and Protect Academic Integrity

Packaging

  • 19Create a Presentation with Gamma AI
  • 20Build a PowerPoint with Claude
  • 21Improve a PowerPoint Presentation with AI
  • 22Write Speaker Notes and a Script with ChatGPT
  • 23Record a Voiceover in PowerPoint
  • 24Create an AI Voiceover with ElevenLabs

Full lesson notes, video links and the AI angle for each lesson unlock once your enrolment is approved.