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.
Business programme
Turn business problems into clear requirements, sound models and decisions.
Who it's for
The Business Analytics Fellowship is for graduates and professionals who want to work as business analysts, bridging business teams and technology. You will learn to frame business problems, gather and document requirements, map processes, build Excel models, pull data with SQL, design dashboards and present recommendations to stakeholders. You finish with a reviewed portfolio of analysis and documentation.
Curriculum
9 modules, each ending in a piece of real work you keep for your portfolio.
Understand where business analysts sit in organisations, what they produce and how the role varies across industries.
Structure ambiguous problems so that analysis effort goes where it matters most.
You'll produce: Problem statement, issue tree and analysis plan
Gather what stakeholders need, not only what they ask for, and document it so that teams can build from it.
You'll produce: Business requirements document with prioritised user stories
Visualise how work really happens today and design a better future state.
You'll produce: As-is and to-be process maps with gap analysis
Build spreadsheet models that others can read, audit and use to compare options.
You'll produce: Decision model comparing three business options
Get the data you need yourself, instead of waiting in a reporting queue.
Choose the right measures for a team and present them in a dashboard that supports regular reviews.
You'll produce: Management dashboard with documented KPI definitions
Present findings so that decisions get made, and manage the relationships that make analysis useful.
Prepare for the case, Excel, SQL and behavioural rounds used to hire business analysts.
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 business analysts and consultants who review your documents, models and presentations and help you prepare for interviews.
Small-group workshops where mentors play stakeholders so you can practise elicitation and pushback.
Scheduled one-to-one sessions to plan your transition and target roles.
Detailed feedback on BRDs, process maps, Excel models and dashboards.
Mock case and behavioural interviews with notes on structure and clarity.
Career support
Preparation, not promises — we don’t guarantee jobs; hiring decisions belong to employers.
Reframe your domain and operations experience around the analysis and documentation skills BA roles look for.
Package your requirements documents, process maps and models into a concise portfolio with feedback.
Practise case, guesstimate, Excel, SQL and behavioural rounds and receive structured feedback.
Use the ActuateMinds SQL compiler and Excel practice exercises to stay sharp between sessions.
Prepare a focused summary and portfolio links so you can respond quickly when a referral opportunity appears.
Track business analyst openings on the ActuateMinds job board and plan applications with your mentor.
Have more questions or need more information?
Request a call backPortfolio
Portfolio-ready work, reviewed by mentors.
Map the current loan application journey for a mid-sized lender, identify where applications stall and design a future-state process. Support your proposal with a gap analysis and change plan.
Interview mock stakeholders from store operations, finance and supply chain, then produce a BRD and prioritised user stories for a new inventory tool. Resolve the conflicting requirements you uncover.
Build an Excel model evaluating whether a consumer brand should enter a new city. Use SQL to pull historical sales data, run scenarios and present a recommendation with its key risks.
Define KPIs for a business function of your choice, build a dashboard on realistic data and use it to diagnose a problem. Present your findings and recommendation to a mentor panel.
Toolkit
Certificate of completion
Your Name
has completed the required projects of the Business 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: The business analyst role
Understand where business analysts sit in organisations, what they produce and how the role varies across industries.
Module 2: Framing business problems
Produce: Problem statement, issue tree and analysis plan
Module 3: Requirements elicitation and documentation
Produce: Business requirements document with prioritised user stories
Module 4: Process mapping and improvement
Produce: As-is and to-be process maps with gap analysis
Module 5: Excel modelling for decisions
Produce: Decision model comparing three business options
Module 6: SQL for business analysts
Get the data you need yourself, instead of waiting in a reporting queue.
Module 7: KPIs and dashboards
Produce: Management dashboard with documented KPI definitions
Module 8: Stakeholder communication and influence
Present findings so that decisions get made, and manage the relationships that make analysis useful.
Module 9: Case interviews and career preparation
Prepare for the case, Excel, SQL and behavioural rounds used to hire business analysts.
Wrap-up
Complete the required projects to earn your certificate.
Admissions
Apply online
Share your education, work experience and the kind of business analysis role you are aiming for.
Advisor conversation
Discuss your goals, the schedule and fees with an admissions advisor. Fees are shared during this conversation.
Fit assessment
Work through a short business scenario so we can understand how you structure problems.
Offer and onboarding
Accept your offer, complete enrolment and start the pre-work, including an Excel refresher if you need one.
FAQs
Fees are shared during your advisor conversation, along with the inclusions and payment options for your cohort. We publish fees on this page once they are confirmed for the cohort. If you need cost information to plan or seek approval from an employer, ask for an advisor call and we will share the details early.
Data Analytics goes deeper into technical analysis with Python, statistics and larger datasets. Business Analytics focuses on the work between business teams and technology: framing problems, gathering requirements, mapping processes, modelling decisions in Excel and communicating with stakeholders. Both use SQL and dashboards. Choose Business Analytics if you enjoy conversations and documentation as much as numbers.
The programme combines live sessions with assignments such as requirements documents, process maps and models that you complete independently. Session timings and the time you should plan to set aside are confirmed per cohort. Your advisor will share them so you can check the fit with your job, studies or other commitments before enrolling.
Recording and catch-up arrangements are confirmed per cohort and explained during your advisor conversation. Many sessions in this programme are workshops and role-plays where you practise interviewing stakeholders and presenting, which cannot be replicated by watching later. We strongly recommend planning to attend live so you get the full benefit of practice and feedback.
No. Business analysts come from commerce, engineering, operations, sales and many other backgrounds. You should be comfortable with spreadsheets and basic arithmetic. SQL and dashboard tools are taught from the start. Domain experience in an industry such as banking or retail is a real advantage, and the programme helps you present it well.
We do not offer placement guarantees. Our career support is designed to make you well prepared: portfolio and resume reviews, mock case and technical interviews, referral readiness and access to our job board. Your progress will depend on your background, effort and the roles you pursue, and mentors help you set realistic targets for a first BA role.
Yes. A certificate of completion is issued after you complete the required projects. In business analyst hiring, interviewers usually want to see how you structure a problem, document requirements and explain a model, so the programme is built around producing portfolio work and practising interviews that demonstrate those abilities directly.
Our refund policy is published at /refund-policy and explains the conditions and timelines for refunds. Please read it before you enrol. If you are paying in instalments or your employer is sponsoring you, your admissions advisor can explain how the policy applies to your circumstances so you have a clear picture before committing.
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.