Data Analytics3 min read
SQL window functions, explained with one small dataset
ROW_NUMBER, RANK, running totals, moving averages and LAG — learned once, on a single orders table, so the pattern sticks instead of the syntax.
Data programme
Go from spreadsheets to SQL, Python and dashboards that change decisions.
Who it's for
The Data Analytics Fellowship is for graduates and professionals in operations, finance, sales, engineering or support who want analyst roles. You will learn to clean and analyse data in Excel, query databases with SQL, explore data with Python and pandas, apply core statistics, build dashboards in Power BI or Tableau, and present findings that lead to decisions.
Curriculum
8 modules, each ending in a piece of real work you keep for your portfolio.
Turn vague business questions into answerable analytical questions.
You'll produce: Analysis plan for a business question
Do serious analysis in the tool every business already uses.
You'll produce: Sales performance workbook
Query relational databases confidently.
You'll produce: Query set answering ten business questions
Answer the questions that make analysts valuable.
You'll produce: Cohort retention analysis
Use pandas to clean, combine and explore larger datasets.
You'll produce: Exploratory data analysis notebook
Know when a difference is real and how confident to be.
You'll produce: A/B test readout
Build dashboards people open every day.
You'll produce: Interactive KPI dashboard
Communicate findings clearly and prepare for analyst interviews.
You'll produce: Capstone presentation and mock interview
Schedule
The live-class schedule is published with each cohort. Your advisor will share it before you enrol.
Interactive classes with practitioners
Every module ends in a deliverable
Written reviews on your work
Critique and study with your cohort
Mentorship
Each cohort is paired with practising analysts who review your queries, notebooks and dashboards and coach you on analytical judgement.
Code and dashboard reviews with written feedback
Doubt-clearing sessions for SQL and Python
Mock SQL and case interviews
Mentor line-up for each cohort is shared during your advisor conversation
Career support
Preparation, not promises — we don’t guarantee jobs; hiring decisions belong to employers.
Show impact with numbers and tools in your experience.
Publish your projects with clear READMEs and visuals.
Timed SQL rounds, case studies and behavioural mocks.
SQL and Excel question banks with an in-browser SQL editor.
Curated analyst roles on the ActuateMinds job board.
Have more questions or need more information?
Request a call backPortfolio
Portfolio-ready work, reviewed by mentors.
Use SQL to analyse a store's sessions, orders and customers, locate the biggest drop-off in the funnel and recommend where to focus.
Build monthly cohorts, chart retention curves and identify which customer segments retain best — and propose why.
Design a Power BI or Tableau dashboard for an operations team, with KPI definitions, filters and a short user guide.
Take a public dataset from question to recommendation, document the method and present it to a panel.
Toolkit
Certificate of completion
Your Name
has completed the required projects of the Data Analytics Fellowship.
Certificate
Awarded once you complete the programme's required projects. The reviewed projects themselves are what you'll show employers.
Timeline
Module order may be refined between cohorts. Week-by-week dates are shared with each cohort.
Kick-off
Dates are confirmed per cohort.
Module 1: Thinking like an analyst
Produce: Analysis plan for a business question
Module 2: Excel for analysis
Produce: Sales performance workbook
Module 3: SQL fundamentals
Produce: Query set answering ten business questions
Module 4: Advanced SQL
Produce: Cohort retention analysis
Module 5: Python for data analysis
Produce: Exploratory data analysis notebook
Module 6: Statistics for decisions
Produce: A/B test readout
Module 7: Dashboards and BI
Produce: Interactive KPI dashboard
Module 8: Storytelling and interviews
Produce: Capstone presentation and mock interview
Wrap-up
Complete the required projects to earn your certificate.
Admissions
Apply online
Share your background and the roles you are aiming for.
Advisor conversation
Get the schedule, the fee and answers to your questions.
Fit check
A short logical-reasoning and numeracy exercise.
Offer and onboarding
Confirm your seat and complete spreadsheet and SQL pre-work.
FAQs
Yes. The programme starts with Excel and builds up to SQL and Python step by step. What helps most is comfort with numbers, patience with messy data and curiosity about why things happen. Weekly hands-on practice matters more than prior coding.
The fee for each cohort is shared during your advisor conversation, including any payment options. We publish it on this page once it is confirmed. There is no charge to apply or to speak to an advisor.
You will build dashboards in one BI tool in depth and learn the concepts that transfer between them — data modelling, KPI design and chart choice. The tool used for the cohort is confirmed during onboarding.
It is a part-time programme with live sessions and weekly practice. Expected weekly hours and the session schedule are confirmed per cohort and shared before you enrol.
There is structured career support — resume reviews, mock interviews, portfolio guidance and curated roles. We do not guarantee placement; outcomes depend on your effort, background and the market.
Yes, a certificate of completion is issued once you complete the required projects. Your GitHub portfolio and SQL skills will carry more weight with recruiters, which is why the programme is project-heavy.
Refunds follow our published refund policy, which your advisor explains before you pay. Please read the refund policy page for full terms.
Request a call back for personalised guidance on fit, schedule and fee.
Request a call backTalk to an advisor
Leave your details and an advisor will walk you through the schedule, fee and fit. No obligation.
Data Analytics3 min read
ROW_NUMBER, RANK, running totals, moving averages and LAG — learned once, on a single orders table, so the pattern sticks instead of the syntax.
Data Analytics2 min read
You do not need to learn everything at once. A sequenced path — what to learn in each tool, when to move on, and which projects prove you are ready.
Data Analytics2 min read
Most analyses fail at the last step. A simple structure — answer first, evidence second, method last — that turns charts into decisions.