AI & Modern Tools
Data Analysis for Non-Coders
Analyze data and find the story in it, without writing a single line of code
12 lessons4 modules9h 20m durationbeginner level
About this course
This beginner course teaches data analysis entirely through spreadsheets and AI assistants, with zero code. You will move a messy dataset through a full pipeline, ask a question, clean the data, build pivot tables and charts, and use ChatGPT or Claude to interpret results and draft a summary. By the end you can answer real business questions and present them in a one-page brief or dashboard.
Curriculum
Module 1: Thinking Like an Analyst Before You Touch a Spreadsheet
- From Vague Request to Answerable QuestionPreview
- What Your Data Can and Cannot Tell You🔒
- Choosing Your Toolkit: Excel, Google Sheets, and AI🔒
Module 2: Cleaning and Structuring Real Data
- Tidy Data: The Structure Every Analysis Needs🔒
- Fixing the Five Most Common Data Problems🔒
- Using AI to Speed Up Cleaning Safely🔒
Module 3: Summarizing and Finding Patterns
- Pivot Tables: Answer Most Questions Without Formulas🔒
- The Five Functions That Cover 90 Percent of Work🔒
- Interpreting Results With AI Without Getting Fooled🔒
Module 4: Presenting Insights People Act On
- Choosing the Right Chart for the Question🔒
- The One-Page Brief: SCQA and 'So What'🔒
- Building a Simple Dashboard That Updates Itself🔒
Powered by StretchLearn