LCFA Logo
LCFALondon Center for Analytics
ProgramsTestimonialsAbout
DashboardLoginDashboard
Beginner-Friendly · Live Online

8-Week Data Analytics Bootcamp

From zero to portfolio-ready using Excel, SQL, Power BI & Python, built around a real Sales, Retail, Product & Market Analytics business case.

Length
8 weeks
Commitment
10–15 hrs a week
Format
Live online, recorded
What you leave with

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

Who This Is For

True Beginners
No prior coding required. We start with Excel and build up gradually.
Career Switchers
Retail, admin, operations, finance, customer service - turn experience into analytics strength.
Excel Power Users
Already use spreadsheets? Level up to SQL, Power BI and beginner-friendly Python.

What You'll Learn (8 weeks)

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

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

Total Revenue (pre/post discount)
Sales Growth (YoY/MoM)
Store/Branch Performance
Revenue by Region/Segment/Channel
Top/Low-Selling SKUs
Profit Margins by Product
Seasonality Trends
New Product Adoption
Order-to-Ship Lead Time
Customer Segments & CLV
On-Time Delivery Rate
Market Share
Stockout & Overstock Rates
Repeat Purchase & Retention

Analyses You'll Perform

Sales forecasting (overall, region, product)
Inventory optimization vs demand
Customer segment performance & CLV uplift
Discount impact on revenue & margins
Peak period identification
New product demand prediction
Profit margin forecasting & mix optimization

Deliverables

Excel operational reports & dashboard
Power BI executive dashboard
SQL queries (ETL + analytical views)
Python forecasting notebook & report
Management summary recommendations
This business case is executed across Excel, SQL, Power BI, and Python for multi-tool skill building and portfolio depth.

Outcomes & Next Steps

Outcomes
By Graduation

Technical Mastery

Mastery of Excel, SQL, Power BI, Python fundamentals

Portfolio Projects

1–2 portfolio projects tied to business KPIs

Presentation Skills

Confidence presenting insights & defending decisions

Where You Go Next

Career Accelerator

Move into the Accelerator (12 months) to build visibility, interview mastery, and earn internship opportunities

L.I.F.T.™ Program

Join the L.I.F.T.™ Program (12 months) for the full transformation

Support, Schedule & Tools

End-to-End System

Not just tools — you get skills, proof, visibility, and real-world experience in one program.

Mentors & Accountability

Weekly coaching, feedback, and metrics keep you on track.

Beginner-Friendly Setup

Excel: Microsoft 365 or 2019+

Power BI Desktop: Free download

SQL: PostgreSQL/MySQL/SQLite (guided install)

Python + Jupyter: Anaconda (guided install)

Two Guarantees That Prove We're Serious

14-Day Satisfaction Guarantee

Don't love it? Get 100% refunded, no questions asked.

12 Months Job Outcome Guarantee

Complete the program + meet requirements. No job offer in 12 months? Get tuition refunded.

Your Call.....

❌

Every day you wait:

  • •More people enter the market
  • •Requirements get higher
  • •Opportunities disappear
  • •Your current skills become more outdated
✅

Every day you act:

  • •Building skills that can't be automated
  • •Positioning yourself for the future economy
  • •Taking control of your career destiny
  • •You're closer to financial freedom

What it costs

Pay in full

Saves £250

Payment plan

Total

£1,000

Saves £250

£1,250

Today

£1,000

£500

The smallest deposit. You can put down more.

Then

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.

Enrol now

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.

Check your readiness

FAQ

Still Have Questions?
Get in touch with our team for personalized guidance
Email:
learn@lcfa.ai

LCFA

LONDON CENTER FOR ANALYTICS

Professional data analytics training and career accelerator. Transform your career with our L.I.F.T.™ Method — from learning to landing in 6 months.

Email

learn@lcfa.ai

Programs

  • 8-Week Bootcamp
  • Career Accelerator
  • L.I.F.T.™ Method

Quick Links

  • About Us
  • Success Stories
  • Free Job Guide
Privacy PolicyTerms & ConditionsRefund Policy© 2025 London Center for Analytics. All rights reserved.