Data Analyst with AI Bootcamp
SQL, dashboards and AI-assisted analysis that answer a manager's question with evidence.
Data Analyst with AI Bootcamp is a 12-week live online bootcamp, taught on Zoom by one instructor at about 15 hours a week, with 6 deployed projects and a one-to-one every week. The founding price is A$200, down from A$400. Live sessions run on weekday evenings from 5:30 PM Sri Lanka and India time, with full-day sessions at weekends.
- Week 1Spreadsheet to TableA messy spreadsheet cleaned and loaded into a SQL table with five answered queries
- Weeks 1–2Spreadsheets to SQLA cleaned dataset and ten answered business questions in SQL, published
- Week 3Cleaning LogA pandas notebook that cleans one dataset and logs every change it makes
- Weeks 3–4Cleaning and exploringAn exploratory analysis of a real public dataset with a cleaning log, published
- Weeks 5–6DashboardsA dashboard a manager can use without you in the room, deployed
- Week 7Sample Size CalculatorA small calculator that works out the sample size an A/B test needs
- Weeks 7–8Statistics that matterAn A/B test analysis with a recommendation, published
- Week 9Copilot Analysis DraftA first-pass analysis of a dataset drafted with Microsoft Copilot and checked line by line
- Weeks 9–10AI-assisted analysisThe capstone: an end-to-end analysis from raw data to a recorded presentation
- Weeks 11–12Employer brief and hiring sprintThe employer brief shipped, and demo day
- weeks, live on Zoom
- 12
- hours a week
- 15
- projects to build
- 10
- minutes 1-1, every week
- 30
Who it is for, and what you receive.
People who live in spreadsheets, or want to, and are changing career into data analysis. No code or SQL needed to start; you finish writing both with an AI pair and checking its work.
Comfortable with spreadsheets; no code or SQL needed.
- Live on Zoom
- 4h
- Set reading and exercises
- 6h
- The project
- 5h
- 1
Six deployed projects
Each graded by Nova against a published rubric and signed off by the instructor at the gate.
- 2
The twelve-week plan
Every week has its theme, its topics and what you build, published before you apply and taught live by your instructor.
- 3
Live on Zoom every week
A 90-minute live code review, a 60-minute squad lab, 60 minutes of office hours, and a 30-minute 1-1 with your instructor.
- 4
Your hiring plan
Opened in week 1 and reviewed in every 1-1: target roles, the gap map, the proof list, weekly actions, an interview log, the outcome.
- 5
The record
Every grade and every project with its repository at square1ai.com/u/{handle}, and the recording of your viva, verifiable by any employer.
- 6
The certificate
A credential ID that resolves at square1ai.com/verify to the real completion.
- 7
The hiring sprint
Weeks 11 and 12: CV and portfolio from graded work, applications, mock interviews scored against the role, demo day.
- 8
Nova for twelve weeks
A tutor with every submission of yours in its memory, at 2am as well as in class.
Twelve weeks in six parts.
Each part teaches for a week, then you build and deploy a project, then a gate checks it before the next part opens. The project and its gate are the part's entry on your record.
Live time each week on Zoom: a 90-minute class where the instructor reviews real submissions, a 60-minute squad lab, 60 minutes of office hours, and your own 30-minute 1-1. Nothing is lectured live; the recorded lessons do that.
- Key skillsAsking the question before the dataSpreadsheets done properlySQL from SELECT to joinsWeek 1
Spreadsheets to SQL
- Asking the question before the data
- Spreadsheets done properly
- SQL: SELECT, WHERE, ORDER BY
You build: Ten questions answered in a spreadsheet
Week 2Project 1: answered in SQL
- Joins and grouping
- Checking your answer
You build: A cleaned dataset and ten business questions answered in SQL
Project 1 · the gate at week 2Answered in SQL
A cleaned dataset and ten answered business questions in SQL, published
You hand in- Cleaned dataset
- Ten SQL queries
- A one-page answer sheet
The gateEvery answer matches the withheld answer key.
What you can do by week 12.
Six published analyses and dashboards that show you can take a business question to an answer a manager acts on, using SQL, Power BI and AI assistants you have learned to check.
- 1
Turn a vague business question into a question data can answer.
- 2
Write SQL from SELECT to joins, grouping and window functions.
- 3
Clean messy data with a log anyone can rerun.
- 4
Build dashboards in Power BI or Looker Studio that a manager can use alone.
- 5
Run and read an A/B test and know when a difference is real.
- 6
Use Python and AI assistants for analysis, and verify every AI answer against the source.
- 7
Present a finding and defend each number back to the raw rows.
No placement rate is shown, because there are no graduates to count yet. The roles above are what the projects are built for.
Your record at week 12.
Every exercise and project is graded by Nova against a rubric you can read, and every grade is kept on one page an employer can open and run. This is what the programme writes to it.
- Graded, line by line
- Nova reads every submission against the brief and the rubric and returns a score, what you did well and what to fix.
- Six gates
- A block does not open until the previous project passes its gate. You always know where you are and what is next.
- A weekly 1-1
- Thirty minutes with your instructor, who has already read your code before the call.
- One page an employer can run
- Every grade, project and the viva recording at /verify. An employer opens it, runs the code and watches you defend it.
- Week 2Graded, gate signed
Answered in SQL
Every answer matches the withheld answer key
- Week 4Graded, gate signed
Exploration
Every cleaning step is logged and reproducible
- Week 6Graded, gate signed
The dashboard
A test user answers five questions from it unaided
- Week 8Graded, gate signed
The experiment
The conclusion survives the instructor's challenge
The entries, not the grades: those are yours to earn. The page lives at /verify and an employer needs no account to open it.
8 entries, twelve weeks. Reserving a spot holds the founding price.
Reserve a seatHow we help you find a job.
The last block is not curriculum. It is the hiring sprint, and the proof you built in the ten weeks before it.
The whole plan on a few pages: the parts, the projects, the gates and the price. We email it to you.
Get the booklet- 1
Your hiring plan, from week 1
Six parts you and your instructor keep: target roles, the gap map from real postings, the proof to send, weekly actions, an interview log, the outcome. Read before every 1-1.
- 2
The hiring sprint
Weeks 11 and 12: CV, portfolio, applications, mock interviews, and demo day in front of hiring partners.
- 3
A record an employer can run
Your deployed projects and the recorded viva on /verify. An employer opens it, runs the code and watches you defend it.
- 4
The career agent
Paste a real job posting at /career and it maps the role to your graded work and what to do next.
- 5
The roles directory
Every role we prepare people for, what it pays and what it asks, at /roles.
Questions people ask.
About Data Analyst with AI Bootcamp, answered from the plan on this page.
- Data Science Bootcamp · 12-week live bootcamp
- Analytics Engineer Bootcamp · 12-week live bootcamp
- Data Engineering with AI Bootcamp · 12-week live bootcamp
One cohort, one instructor. Hold your spot.
A cohort of 25, one instructor, 12 weeks, six things you ship. Spot holders hear the start date first, and nothing is charged before you confirm.
- Six published analyses and dashboards
- A recorded viva
- Your record on /verify
About a minute. No account, no card, and nothing is charged until you confirm.