Data Analytics Training in London – Excel, SQL, Power BI, Tableau & Python

SoftPro9 runs Data Analytics with Excel, SQL, Power BI, Tableau & Python training as live online batches in UK time, for learners in the City, Canary Wharf, Shoreditch and across London.

  • Covers: Microsoft Excel, Power Query, Power Pivot, SQL, MySQL, PostgreSQL, SQL Server, Power BI and more
  • Mode: Live online in UK time
  • New batches: Every Monday and Thursday; UK time slots 8 AM / 3:30 PM / 6 PM
  • Duration: 14–16 weeks at 8–10 hours a week; 8-week fast track for working analysts
  • Fee: The current fee is listed on the Data Analytics with Excel, SQL, Power BI, Tableau & Python course page: /course/data-analytics-course. Any Microsoft PL-300 or Tableau exam is optional and paid directly to the exam provider.
  • Batch size: Up to 15 learners
  • Practice: Power BI, Tableau Public, a cloud SQL database and practice datasets, available 24/7

Last updated: 28 October 2026

Data Analytics course in London: basic to advanced

Finance, retail and consulting firms in London hire SQL, Power BI and Tableau analysts. The course is split into three levels. You can join at the level that matches your experience after a short assessment at counselling.

Basic

Excel and analytical thinking

  • Excel essentials: formulas, cell references, formatting, data validation
  • Lookup functions: XLOOKUP, INDEX-MATCH; logical and text functions
  • Pivot tables, slicers and pivot charts
  • Power Query for cleaning and combining data
  • Statistics for analysts: averages, spread, correlation, sampling
  • Framing business questions and choosing KPIs

London practice: UK GDPR and consent practice in web and data exercises.

Intermediate

SQL and Power BI

  • SQL on MySQL, PostgreSQL and SQL Server: SELECT, WHERE, GROUP BY, joins
  • Subqueries, CTEs and window functions (RANK, LAG, running totals)
  • Power BI Desktop: Power Query, data modelling with a star schema
  • DAX: measures, CALCULATE, time intelligence, variables
  • Report design, drill-through, bookmarks and tooltips
  • Power BI Service: publishing, scheduled refresh, row-level security, sharing

London practice: Accessibility to WCAG 2.2 AA, as UK public-sector sites require.

Advanced

Tableau, Python and storytelling

  • Tableau: calculated fields, LOD expressions, parameters and dashboards
  • Python for analysts: pandas, Matplotlib/Seaborn, automating Excel reports
  • Business analysis: funnel, cohort, RFM and A/B test analysis
  • Excel Power Pivot, what-if analysis and forecasting
  • Google Looker Studio and Google Analytics 4 basics
  • Intro to modern data stacks: ETL, dbt and Microsoft Fabric
  • Data storytelling: presenting insights to managers, and using AI copilots in Excel and Power BI with care

London practice: UK date formats, postcodes and the April–April tax year.

Who joins from London

  • Finance and insurance staff in the City and Canary Wharf
  • Career changers building a portfolio for tech roles
  • Developers adding data or modern front-end skills

Roles it typically leads to in London

  • Data analyst
  • Business / BI analyst
  • Power BI developer
  • MIS analyst
  • Reporting analyst / operations analyst

Freshers usually start in junior or support versions of these roles.

Data Analytics with Excel, SQL, Power BI, Tableau & Python – full course details and fee →

Tools you will use

Every tool below is used hands-on in class or in a project, not just mentioned on a slide.

  • Microsoft Excel
  • Power Query
  • Power Pivot
  • SQL
  • MySQL
  • PostgreSQL
  • SQL Server
  • Power BI
  • DAX
  • Tableau
  • Python
  • pandas
  • Matplotlib
  • Seaborn
  • Jupyter
  • Looker Studio
  • Google Analytics 4
  • Microsoft Fabric (intro)
  • dbt (intro)

Projects you will build

  1. A sales performance dashboard in Power BI with DAX measures and row-level security

  2. A Tableau story analysing customer cohorts and retention

  3. A SQL case study answering ten real business questions, written up for a manager

  4. A Python script that turns a monthly Excel dump into a formatted report automatically

  5. London project: A retail sales dashboard comparing UK regions and seasons, using data and conventions from London.

Upcoming London Data Analytics batches

New batches start every Monday and Thursday, with no more than 15 learners in each. Weekday class slots in UK time: 8 AM / 3:30 PM / 6 PM. Weekend slots: 10 AM / 5 PM. Times shown are for winter; they move one hour when clocks change.

The early-morning and evening UK-time slots fit around a standard working day.

Start dateCourseModeBatch size
Thu, 29 Oct 2026Data Analytics (all levels)Live onlineUp to 15
Mon, 2 Nov 2026Data Analytics (all levels)Live onlineUp to 15
Thu, 5 Nov 2026Data Analytics (all levels)Live onlineUp to 15
Mon, 9 Nov 2026Data Analytics (all levels)Live onlineUp to 15

Message us with the start date and slot you want, and we will confirm your seat.

Reserve on WhatsApp

Data analytics in brief

Data analytics turns raw business data into answers people can act on: which products are slowing, where costs are leaking, how a campaign performed. Analysts pull data with SQL, clean and model it, build dashboards in Power BI or Tableau, and explain the findings to managers.

Almost every company has data and too few people who can read it, which is why analyst roles exist in every industry, not just tech. You do not need a coding background: the course starts with Excel and builds up to SQL, Power BI with DAX, Tableau and Python for automation.

Data science vs data analytics vs business analytics

The three fields share tools and are often confused in job titles. The simplest way to tell them apart is by the question each one answers.

AspectData AnalyticsBusiness AnalyticsData Science
Main questionWhat happened, and why?What should the business do?What will happen, and can we automate the decision?
FocusCleaning data, reporting, dashboardsTurning analysis into business decisions and plansPredictive models, machine learning and AI
Core toolsExcel, SQL, Power BI, TableauExcel, SQL, Power BI, forecasting, BRDs and process mapsPython, statistics, scikit-learn, PyTorch, MLOps
Maths neededBasic statisticsBusiness statistics and forecastingStatistics, linear algebra and probability
CodingLow (SQL, some Python)Low (SQL, light Python)High (Python every day)
Typical outputDashboards and reportsRecommendations, business cases, requirement documentsModels, predictions and AI features
Typical first rolesData analyst, MIS analyst, Power BI developerBusiness analyst, BI analyst, strategy analystJunior data scientist, ML engineer
Best starting point forAnyone new to data, any degreeMBA, BBA and commerce graduates, managersEngineering, maths and statistics graduates, developers
Course length here14–16 weeks14–16 weeks24–28 weeks

Which should you choose? If you are new to data, start with Data Analytics: it is the foundation the other two build on. Choose Business Analytics if you enjoy the business side and want to influence decisions. Choose Data Science if you like programming and maths and want to build predictive models.

Why data analytics skills matter in London

London is Europe's largest financial centre and one of its biggest technology hubs: banks and insurers in the City and Canary Wharf, fintech and startups around Shoreditch and King's Cross, and public-sector digital teams. Employers value clean, tested code, accessibility and a clear explanation of your work.

Who hires in London

  • Banking, insurance and fintech

    The City and Canary Wharf host global banks, insurers and many fintechs.
  • Technology and startups

    Shoreditch, King's Cross and the wider tech scene, including AI companies.
  • Public sector digital

    Government digital services and the NHS, which follow strict accessibility and design standards.
  • Retail, media and consulting

    Retailers, broadcasters and consultancies with large data and web teams.

UK context you will work with

Generic courses use generic datasets, and interviewers notice. Our exercises include:

  • GBP pricing and 20% VAT in invoice data
  • UK GDPR and consent practice in web and data exercises
  • Accessibility to WCAG 2.2 AA, as UK public-sector sites require
  • UK date formats, postcodes and the April–April tax year
  • Clock changes (GMT/BST) in time-series data

How to choose the right Data Analytics track

Your backgroundStart withWhy
Commerce / BBA / MBA graduateFull courseBusiness sense plus SQL and Power BI is the analyst profile
MIS / Excel-heavy roleSQL, Power BI, then PythonMove from manual reports to automated dashboards
Engineering graduateFull course, Python earlyYour logic transfers; add business framing
Career returnerExcel and Power BI firstQuickest route to a portfolio you can show
Planning to move into MLData Analytics, then Data ScienceSQL and statistics are the base ML builds on

Common pairings: Data Analytics + Python (for automation-heavy analyst roles), Data Analytics + Data Science (to move into prediction), and Data Analytics + SAP FICO or MM (for ERP reporting roles). Learn one course well before adding a second.

From course to first role: a realistic path

  1. Master the excel and analytical thinking before moving on.

  2. Build and publish your projects, including the London capstone.

  3. Apply for entry roles such as data analyst or business / bi analyst with employers like the banking, insurance and fintech above.

Honest note: freshers usually start in junior or trainee roles, and salaries in London vary too widely for a headline figure. Ask us which openings we are seeing.

Data Analytics certification: what we cover and what we issue

The most recognised analyst exams are Microsoft PL-300 (Power BI Data Analyst Associate) and Tableau Certified Data Analyst. Both are optional and paid directly to Microsoft or Tableau, not part of our fee; our Power BI and Tableau modules cover their skills outlines and include practice questions. SoftPro9 issues a course completion certificate.

What to check before choosing a Data Analytics institute in London

  • A 2026 syllabus: look for Seaborn, Jupyter, Looker Studio, Google Analytics 4, not only the basics.

  • Projects on your own accounts, a trainer you can meet first, and a published fee with nothing hidden.

  • No "global certification" or "100% placement" claims: vendors run their own exams, and nobody can promise a job.

How our Data Analytics classes work

  • Taught from Bangalore

    Classes are taught live by the same trainers who teach our Bangalore classroom, streamed to London in UK time.
  • Live, with recordings and reviews

    Live sessions in UK time, recordings for revision, and project reviews from the trainer. Power BI, Tableau Public, a cloud SQL database and practice datasets, available 24/7.
  • Interview preparation

    Mock interviews, resume reviews and referrals to London and remote openings we hear about. We do not guarantee a job.

Data Analytics training across London: which option suits your area

AreaWhereMost learners choose
The City, Canary WharfCentral / eastLive online, evening slots
Shoreditch, King's Cross, CamdenCentral / northLive online
Croydon, Wimbledon, RichmondSouth / westLive online, weekend batches
Stratford, Ilford, Harrow, WembleyOuter LondonLive online

London batches are live online in UK time (times shift with GMT/BST); there is no classroom in London.

Where your classes come from

London batches are live online. They are run from our Bangalore centre, which you are welcome to visit if you are ever in the city.

SoftPro9 IT Services – Bangalore
22/1, Opp Infosys, BHBCS Layout, BTM Layout 2nd Stage, BTM Layout, Bengaluru, Karnataka – 560076

Phone: +91 95354 51414

Getting here

We are in BTM Layout 2nd Stage, opposite the Infosys office. The nearest metro is Jayadeva Hospital station, about a 10-minute walk away, and BMTC buses on the Outer Ring Road and Bannerghatta Road stop nearby.

Opening hours

Monday–Friday 9:30 AM–7:30 PM · Saturday 9:30 AM–3:30 PM · Sunday closed

Get directions

Data Analytics training in London: frequently asked questions

How much does Data Analytics training cost in London?

The current training fee is listed on the Data Analytics with Excel, SQL, Power BI, Tableau & Python course page: /course/data-analytics-course. It covers live classes, the practice environment, projects and interview preparation. Any Microsoft PL-300 or Tableau exam is optional, not included, and paid directly to the exam provider.

Do I need coding for data analytics?

No. You start with Excel, then learn SQL, which reads close to English. Python comes last and is used for automation, not complex programming.

Power BI or Tableau: which should I learn?

We teach both. Power BI is more common in companies that run on Microsoft 365; Tableau appears in many consulting and product teams. Knowing both widens your options.

Is the PL-300 exam fee included?

No. The Microsoft PL-300 exam is optional and paid directly to Microsoft. Our course prepares you for it.

What kind of jobs can I apply for?

Data analyst, BI analyst, Power BI developer, MIS analyst and reporting roles. Freshers usually start in reporting or operations analytics and move up with experience.

Is there a classroom in London?

No. London learners join live online batches in UK time, with recordings and a 15-learner cap.

Is the course regulated or eligible for UK student finance?

No. It is a private professional course and not eligible for UK student finance.

When does the next batch start?

New Data Analytics batches start every Monday and Thursday. See the batch table on this page for the next dates and UK time class slots.

Do you guarantee placement?

No. We provide interview preparation, resume help and referrals to openings we hear about in London, but no institute can honestly guarantee a job.

Talk to us about your Data Analytics course

Tell us your degree, your current job (if any) and where in London you are. We will suggest a track and a batch that fits.