Apply Now

Data & AI

Data Analytics

  • Duration: 4 months
  • Level: Beginner

Turn data into decisions. Learn to clean, analyse and visualise data with Excel, SQL, Python and Power BI, and build dashboards that answer real business questions.

  • 100% remote
  • Live online classes
  • Beginner friendly
  • Dashboard portfolio

About This Program

Data Analytics is a four-month, live online programme that teaches you to collect, clean, analyse and present data so that organisations can make better decisions.

You work with the tools analysts use every day — Excel, SQL, Python and Power BI — on realistic datasets from areas such as retail, finance and health, and you finish with a portfolio of analyses and dashboards.

What You’ll Learn

  • Clean and analyse data in Excel and Google Sheets
  • Query databases with SQL
  • Analyse data with Python, pandas and Jupyter
  • Apply core statistics to business questions
  • Build interactive dashboards in Power BI
  • Present findings clearly to non-technical audiences

Curriculum

  1. Module 1 Module 1: Spreadsheets for analysis (weeks 1–3) 3 topics
    • Data types, cleaning and validation
    • Formulas, lookups and pivot tables
    • Charts and basic dashboards
  2. Module 2 Module 2: SQL (weeks 4–6) 3 topics
    • Relational databases
    • SELECT, filtering, joins and aggregation
    • Subqueries, CTEs and window functions
  3. Module 3 Module 3: Python for data (weeks 7–10) 4 topics
    • Python basics in Jupyter notebooks
    • pandas for cleaning and transformation
    • Visualisation with Matplotlib and Seaborn
    • Descriptive statistics and hypothesis testing
  4. Module 4 Module 4: Business intelligence (weeks 11–13) 3 topics
    • Power BI data modelling
    • DAX basics
    • Interactive dashboards and reports
  5. Module 5 Module 5: Capstone and career (weeks 14–16) 3 topics
    • End-to-end analytics project
    • Data storytelling and presentation
    • Portfolio, CV and interview preparation

What You’ll Build

  • A sales performance dashboard in Excel
  • SQL analysis of an e-commerce database
  • A Python exploratory analysis of a public dataset
  • An interactive Power BI dashboard for a business case

Career Outcomes

  • Data Analyst
  • Business Intelligence Analyst
  • Reporting Analyst
  • Operations or Marketing Analyst

Who This Program Is For

This programme is for beginners, graduates and professionals in any field who want to work with data, including people already using spreadsheets at work who want to go further.

Requirements

  • No prior coding experience needed
  • Comfort with basic numbers and percentages
  • A laptop or desktop computer (Windows is recommended for Power BI Desktop)
  • A reliable internet connection
  • About 10–15 hours a week, including live classes

Frequently Asked Questions

Do I need to be good at maths?

You need to be comfortable with everyday numbers such as averages and percentages. We teach the statistics you need as we go.

I use a Mac. Can I take this programme?

Yes. Power BI Desktop runs only on Windows, so on a Mac you can use the Power BI web service or a Windows virtual machine. We help you set this up in week one.

Looking for a program you can join now?

See every Virexa program and its admissions status.

View All Programs