LearnData Analytics

Data Analytics

Analyse data, build dashboards, and tell stories with data using Excel, SQL, and Power BI.

7 modules35 hours28 lessonsBeginner

What you will learn

What data analytics is and why it matters

Types of data, data sources, and data collection methods

Cleaning and transforming data for analysis

Exploratory data analysis and statistical thinking

Data visualisation with charts, graphs, and dashboards

Working with spreadsheets and SQL for data querying

Using Python and pandas for data manipulation

Communicating insights to non-technical stakeholders

Introduction to Data Analytics

Understand what data analytics is, the types of data that exist, and how analysts think.

Excel for Data Analysis

Master Excel as an analyst tool: formulas, pivot tables, data cleaning, and building dashboards.

SQL for Data Analysis

Query databases with confidence using SQL. Covers SELECT, filtering, aggregations, joins, and CTEs.

Python for Data Analysis

Use Python and pandas to clean, explore, and analyse data at scale.

Data Visualisation and Dashboards

Master data visualisation principles, chart selection, Power BI, Tableau, and executive dashboards.

Statistics for Data Analysis

Build statistical foundations: descriptive stats, distributions, hypothesis testing, regression, and statistical thinking.

Real-World Data Projects

Apply your skills to complete projects: end-to-end analysis, presenting insights, data storytelling, and portfolio building.

Getting Hired as a Data Analyst

Everything you need to land your first data analyst role: job market, CV writing, interview prep, and career planning.

Join CareerEx for 12 weeks of guided training, live classes, real tutor feedback, and an industry-recognised certificate.