Flagship program
AI-Powered Data Analyst Program
Build the practical skills to analyse data, communicate insights, automate workflows and use AI as a professional analytics assistant. Live instructor-led classes with recordings, 5+ real-world projects, a capstone and a virtual internship.
Who it’s for
A good fit if you are
- A career changer or graduate moving into a data or BI role
- A professional who reports in Excel and wants Power BI, SQL and AI
- An analyst who wants to add Python and AI to your workflow
Probably not for you if
- You want a recorded course to watch on your own
- You cannot set aside about 7–8 hours a week in total (classes, practice and projects) for about 6 months. One-on-one learning, paced around you, may suit you better
Before you start
- Comfortable with a computer and basic Excel
- No coding needed
- About 7–8 hours a week in total, including live classes, guided practice and project work
- A laptop with Microsoft Excel (Power BI Desktop needs Windows; we help Mac users set up)
What you’ll learn
Twelve modules, in the order the skills build on each other. AI is used, and checked, in every one.
By the end you can
- Clean and analyse data in Excel and Power Query
- Write SQL from SELECT to window functions
- Build modelled Power BI dashboards with DAX, or Tableau dashboards
- Analyse data in Python with Pandas and visualise it with Seaborn
- Use Claude, ChatGPT and Copilot with a verification habit
- Explain an analysis to a manager in five lines
Module 1Data analytics foundations
- The analyst role in UK, Australian and global teams
- Business question → data → analysis → insight → recommendation
- KPIs: definition, grain, targets
- The accuracy habit: control totals and row counts
Module 2Excel for data analytics
- Cleaning, tables, IF/IFS, SUMIFS, COUNTIFS
- XLOOKUP and INDEX/MATCH
- Dynamic arrays: FILTER, SORT, UNIQUE, LET
- PivotTables, Power Query and dashboards
- Copilot and Claude for formulas, tested against known totals
Module 3SQL and MySQL
- SELECT, WHERE, GROUP BY, HAVING
- Joins and row-count checks
- Subqueries, CTEs and views
- Window functions: ROW_NUMBER, RANK, LAG, LEAD, running totals
- Indexes, transactions and query optimisation
Module 4Python for data analytics
- Python essentials for data work
- Files, Excel, JSON and APIs
- NumPy and Pandas: cleaning, GroupBy, merge, pivot
- Matplotlib and Seaborn for exploratory analysis
Module 5Power BI
- Power Query, star schema, date tables
- DAX: CALCULATE, FILTER, iterators, time intelligence
- Report design, drill-through, bookmarks
- Power BI Service and row-level security
- Copilot for DAX, with a known-total test
Module 6Tableau (alternative BI track)
- Calculated fields, parameters, sets
- LOD expressions
- Dashboards, actions and stories on Tableau Public
Module 7Business analytics
- Problem framing and KPI design
- Sales, marketing, finance, operations, HR and product analytics
- Funnels and cohorts
- Writing recommendations: action, owner, metric to watch
Module 8AI for data analysts
- How large language models work and fail
- Claude, ChatGPT, Gemini and Copilot: when to use which
- Prompt and context engineering
- Privacy and anonymisation
- The verification log
Module 9Generative AI for analytics
- Reusable prompt templates
- Executive summaries and data storytelling, fact-checked
- Automated documentation
Module 10Automation
- Scheduled refresh and emailed reports
- A Python script that cleans a folder of files
- AI-assisted workflows with a human review step
Module 11Machine learning foundations
- AI vs ML vs deep learning
- Supervised and unsupervised learning; train and test
- Regression, trees and clustering
- Baselines, and when ML is the wrong tool
Module 12Career, capstone and virtual internship
- Portfolio on GitHub and Power BI or Tableau Public
- CV and LinkedIn for analyst roles
- Interview practice: SQL, dashboard walkthrough, case question
- Virtual internship tasks and capstone presentation
Want only one skill? SQL, Python and Power BI + Tableau are also available as specialist courses that join the same live cohort for those modules.
Tools you will use
- Excel
- Power Query
- SQL
- MySQL
- Python
- pandas
- NumPy
- Matplotlib
- Seaborn
- Jupyter
- Power BI
- Tableau
- ChatGPT
- Claude
- Gemini
- Microsoft Copilot
- GitHub
- Git
What you’ll build
Five business assignments and an end-to-end capstone. Each has a brief, realistic data, deliverables a manager would expect, and written feedback.
Project 01 · Sales Performance Intelligence
A company wants to understand revenue by product, region, customer and month, and why the last quarter fell short. Deliverables: SQL analysis, data cleaning, dashboard, executive summary, business recommendations.
Project 02 · Customer Intelligence
Who are the high-value customers, which segments are growing, and who is at risk of leaving? Deliverables: Customer segments, revenue by segment, retention cohorts, behaviour patterns, targeting recommendations.
Project 03 · Marketing Performance Analytics
Which campaigns and channels bring customers profitably, and where does the lead funnel leak? Deliverables: Campaign performance, lead funnel and conversion, cac by channel, marketing roi, budget recommendation.
Project 04 · Workforce & HR Analytics
Where is attrition highest, how is hiring performing, and what is linked to performance? Deliverables: Attrition analysis, hiring funnel, workforce demographics, performance trends, retention actions.
Project 05 · E-Commerce Analytics
Orders are up but margin is down. What is happening with products, returns and repeat customers? Deliverables: Order and revenue trends, product mix, returns analysis, customer behaviour, margin recommendations.
Capstone · End-to-end AI-powered analytics
Business problem → Data → Cleaning → SQL → Python → EDA → Power BI / Tableau → AI-assisted analysis → Business insights → Recommendations → Executive presentation.
Virtual internship
In the final weeks you complete tasks for Harbourline, a fictional retailer, the way a junior analyst would: tickets from “stakeholders”, deadlines, review and a final presentation. It is simulated work experience, not employment.
How the virtual internship worksHow it’s delivered: live + recorded
Taught live by an instructor in small online groups. Every class is recorded, so you can revise, catch up on a class you missed, or go over a hard topic again.
Live classes
Instructor-led, small groups
Recordings
For revision and catch-up
Weekly office hours
Questions and project help
Practice assignments
With answer keys
5+ real-world projects
Graded, with written feedback
Capstone
End-to-end, presented
Virtual internship
Simulated work experience
Portfolio development
GitHub-ready
CV review
Individual written feedback
LinkedIn review
Profile feedback
Mock interview
With feedback
AI tools & workflows
Used and checked in every module
Community & support
Cohort and alumni group
Career preparation
Applications and interviews
Weekday or weekend
Choose your schedule
Resources
Cheat sheets, datasets, templates
Schedule: weekday live or weekend live
Learn live with an instructor on a schedule that fits your life. Choose weekday or weekend learning to suit your schedule. Contact us to discuss the schedule; we confirm class times with you before you start.
- Weekday live
- Available: schedule confirmed with you before you start
- Weekend live
- Available: schedule confirmed with you before you start
- Office hours
- Weekly, at a time announced with the cohort
- Recordings
- Posted within hours of every class
Support you receive
Live classes
Small groups, time for your questions
Weekly office hour
Drop-in help with exercises and projects
Project feedback
Written rubric feedback on every graded project
Catch-up
Recordings, recaps and a weekly catch-up thread
Community
Cohort group during the course, alumni group after
Career preparation
CV review, LinkedIn review and a mock interview, with feedback
What it costs
Showing USD. Same program price everywhere; your local currency is shown for convenience.
AI-Powered Data Analyst Program
Same price in other currencies
- AUDA$1,299
- GBP£679
- USDUS$899
- INR₹86,499
- NZDNZ$1,599
- AEDAED 3,299
- EUR€799
Same program price in every country. Your local currency is shown automatically for convenience (reference rate of 2 October 2026). How prices work
Enrol nowWhat’s included
- Live instructor-led classes
- Every class recorded
- Weekday cohort option
- Weekend cohort option
- Weekly office hours
- Practice assignments
- Real-world projects (5+ portfolio projects)
- End-to-end capstone
- Portfolio development
- GitHub profile support
- CV / resume review
- LinkedIn profile review
- Mock interview
- Job-search assistance
- Virtual internship (simulated work experience)
- Free career development sessions
- AI workflow training
- Learning resources
- Community and student support
Pay in full, or in 4 interest-free monthly payments. No hidden fees and no countdown timers. The launch price applies to enrolments until 31 March 2027; the standard price applies from 1 April 2027.
Not included: job placement or guarantees, visa advice, software licences (Microsoft Excel).
Prefer to learn this 1:1?
The same program is available 1:1, with a personalized roadmap, flexible scheduling, personalized projects and individual instructor attention. 1:1 AI-Powered Data Analyst: launch price US$2,499, priced separately from the group program.
FAQ
Do I need a technical background?
No. You need basic Excel and about 7–8 hours a week in total for live classes, guided practice and project work. Module 1 starts with analytics foundations.
Weekday or weekend: can I switch?
Choose one when you enrol. If your circumstances change, ask us; we will move you to the other cohort if it has space and covers the same module.
What if I miss a class?
Every class is recorded and posted within hours. Bring questions to the weekly office hour.
Is there more than one package?
No. One group program, one price, everything listed above included. 1:1 mentorship is a separate service with its own price.
Why is the price different in my currency?
It isn’t. There is one program price (US$899). We convert it to your currency at a stated reference rate and round it to a clean figure, so learners everywhere pay the same underlying price.
Is the virtual internship a real job?
No. It is simulated work experience using a fictional company. You do realistic tasks, to deadlines, with review, and present your work.
Will I get a job?
No training provider can honestly guarantee that. You finish with skills, a portfolio, a virtual internship case and interview practice.
Is the certificate accredited?
It is a certificate of completion listing the hours and projects. It is not a nationally recognised (AQF) or regulated qualification.
Can I pay monthly?
Yes: four interest-free monthly payments, one at enrolment and three monthly, with no extra fees.
Ready to start?
Choose a weekday or weekend cohort, or talk to a mentor first. The first call is free.