8-Week Data Analytics Bootcamp
Build the Foundation.Then Prove You Can Use It.
An 8-week live Data Analytics Bootcamp that takes you from learning the core tools to applying them to real business problems — so you don't just know Excel, SQL, Power BI and Python. You can show what you can do with them.
- Length
- 8 weeks
- Commitment
- 10–15 hrs a week
- Format
- Live online, recorded
Four tools you can use to a deadline, and work that shows it.
- Excel, SQL, Power BI and Python fundamentals
- One to two portfolio projects tied to business KPIs
- A capstone you present and defend in week 8
- Replays of every live session
Learning the Tools Is Only the Beginning
You can watch hours of tutorials and complete multiple certificates and still struggle when someone asks:
What business problem have you actually solved with these skills?
The LCFA Bootcamp is designed to close that first gap.
You learn the core analytics tools, but you learn them through business problems, decisions and practical application rather than isolated exercises.
Build practical capability across the core analytics tools employers repeatedly ask for.
Use those tools to investigate realistic business problems rather than simply completing exercises.
Finish with work you can explain, present and begin using as credible evidence of your capability.
This Is For You If...
- You're starting your journey into Data Analytics.
- You've learned bits of Excel, SQL, Power BI or Python but don't yet feel confident connecting them.
- You need structure and accountability rather than another self-paced course.
- You want to understand how analysts use tools to solve business problems.
- You want to build the foundation required for the Accelerator or wider professional transition.
The Tools You'll Learn — Through Business Application
We don't teach tools as isolated subjects. Throughout the Bootcamp, you'll learn how they connect across an analytics workflow — from raw data to insight, recommendation and communication.
Weeks 1–2: Excel for Business Analytics
Interface, formatting, data types, tables
Sorting, filtering, lookups (VLOOKUP, XLOOKUP, Index/Match)
Pivot tables/charts, KPI analysis, conditional formatting
Power Query (clean, merge, unpivot)
Interactive dashboards (slicers, timelines)
Weeks 3–4: SQL for Analysis
Set up DB & import Excel/CSV
SELECT, WHERE, ORDER BY; date filtering
Joins, GROUP BY & aggregates; CASE WHEN
CTEs, handling NULLs; window functions
Create views, time-series rollups; export to BI
Weeks 5–6: Power BI for Insights
Data import; star schema (fact & dimensions)
DAX basics (SUM, CALCULATE, FILTER, ALL)
Time intelligence (DATEADD, TOTALYTD, SAMEPERIODLASTYEAR)
KPI cards, slicers/filters; advanced DAX & RLS
Forecasting & executive dashboard design; publish & share
Weeks 7–8: Python for Analytics & Forecasting
Jupyter setup; pandas load/clean/transform
EDA describe(), correlations, visuals (matplotlib/seaborn)
Feature engineering; train/test split
Regression models (Linear, Ridge, RandomForest)
Forecast pipeline; evaluate MAE/RMSE; plot actual vs predicted
What You Should Be Able to Do by the End
- Clean and structure business data.
- Query and investigate data using SQL.
- Build dashboards that answer business questions.
- Use Python for analysis and deeper investigation.
- Translate findings into recommendations.
- Explain why you made particular analytical decisions.
- Present a complete analytics case rather than simply displaying tools.
The goal isn't to finish knowing more tools.
The goal is to begin thinking and communicating like an analyst.
Real Business Case: Sales, Retail, Product & Market Analytics
Objective
Run an end-to-end analysis using historical data to understand performance drivers, optimize inventory & pricing, and build forecasts across sales, retail ops, product and market.
Key KPIs
Analyses You'll Perform
Deliverables
Support, Schedule & Tools
Not just tools — you get skills, proof, visibility, and real-world experience in one program.
Weekly coaching, feedback, and metrics keep you on track.
Excel: Microsoft 365 or 2019+
Power BI Desktop: Free download
SQL: PostgreSQL/MySQL/SQLite (guided install)
Python + Jupyter: Anaconda (guided install)
A Guarantee That Proves We're Serious
14-Day Satisfaction Guarantee
Don't love it? Get 100% refunded, no questions asked.
What Happens After the Foundation?
The Bootcamp solves the foundation problem.
For some professionals, that's exactly what's missing.
For others, the next challenge is turning those skills into professional evidence, positioning themselves for the UK market and building confidence through real implementation and professional testing.
That's where the LCFA Accelerator begins.
What it costs
Choose the commitment structure that works for you. A larger initial payment means a smaller remaining balance.
Pay in full
Saves £250Payment plan
£1,000
Saves £250
£1,250
£1,000
£500
The smallest deposit. You can put down more.
Nothing left to pay
2 × £375
Monthly, until the £1,250 is paid.
You pick the deposit and the number of months at checkout. A bigger deposit means smaller monthly payments.
Still deciding? and ask us anything first.
Not sure where you stand?
The career readiness check takes a few minutes. It scores you on skills, proof of work and job search, and shows you the gap to close first.