Data Analytics

Unlock the power of data. Learn how to collect, clean, analyze, and visualize information to make smarter business decisions. This course equips you with practical skills in Excel, Power BI, and SQL to turn raw data into actionable insights.

By the end of the programme, you'll be able to build dashboards, run exploratory analysis, and present findings with confidence — the exact workflow data teams use to guide real decisions.

4 Month Internship

Instructor led courses

6 Month duration

Modules

Course Duration

6 Months of Instructor-led classes with 4 months Internship

Projects

10 Projects

Course Description

You'll work through real datasets each week, moving from spreadsheet fundamentals to dashboarding and query writing, so every concept is tied to a project you can show in your portfolio.

By the final module, you'll have built a full analytics case study end to end — from raw data to a presentation-ready report — with feedback from an instructor at every stage.

Jump to the full week-by-week breakdown below.

View Curriculum

Meet your instructor further down this page in the "Connect With Your Instructor" section.

No reviews yet — be the first learner to complete this course and leave feedback.

Course Curriculum

WEEK 0

Introduction to Data Analytics

The Introduction to Data Analytics

Module 1 : Data Analytics

Module 2 : Course Introduction

Module 3 : Course Introduction

Module 4 : Course Introduction

WEEK 1

Excel Fundamentals

Spreadsheets, formulas, and data cleaning basics

Module 1 : Data Cleaning in Excel

WEEK 2

Data Cleaning & Preparation

Getting raw data ready for analysis

Module 1 : Handling Missing Data

Module 2 : Data Types & Validation

WEEK 3

Exploratory Data Analysis

Finding patterns and trends in a dataset

Module 1 : Descriptive Statistics

Module 2 : Pivot Tables

Module 3 : Charting Basics

WEEK 4

Introduction to SQL

Querying data from relational databases

Module 1 : SELECT, WHERE & JOIN

Module 2 : Aggregations & GROUP BY

Module 3 : Writing Subqueries

WEEK 5

Data Visualization with Power BI

Turning tables into readable visuals

Module 1 : Building Your First Dashboard

Module 2 : Chart Types & When to Use Them

Module 3 : Interactive Filters

WEEK 6

Dashboard Design Principles

Making dashboards clear and decision-ready

Module 1 : Layout & Hierarchy

Module 2 : Choosing the Right Metric

Module 3 : Storytelling with Data

WEEK 7

Statistics for Analysts

Core statistical concepts for business analysis

Module 1 : Correlation vs Causation

Module 2 : Hypothesis Testing Basics

Module 3 : Working with Confidence Intervals

WEEK 8

Capstone Project — Part 1

Scoping and data collection for your final project

Module 1 : Defining the Business Question

Module 2 : Sourcing & Cleaning the Dataset

Module 3 : Initial Exploratory Analysis

WEEK 9

Capstone Project — Part 2

Building the analysis and dashboard

Module 1 : Building the Dashboard

Module 2 : Peer Review & Feedback

Module 3 : Refining the Insights

WEEK 10

Final Presentation & Internship Handoff

Presenting your capstone and transitioning into internship

Module 1 : Presenting Your Findings

Module 2 : Instructor & Peer Q&A

Module 3 : Internship Placement Briefing