Data Analytics Course

Turn Raw Data
Into Powerful
Decisions.

Learn Excel, SQL, Python, and Power BI from industry practitioners. Go from zero to confidently analysing real datasets with hands-on projects, live sessions, and a certificate upon completion.

100%

Hands-On Projects

5+

Industry Tools

0

Experience Required

What You'll Learn

A complete roadmap from data beginner to confident analyst — no prior coding or statistics experience needed.

Data Foundations

Understand what data analytics is, how data flows in organisations, and the key concepts behind data-driven decision-making.

Week 1

Excel & Spreadsheets

Master formulas, pivot tables, VLOOKUP, conditional formatting, and charts. The most essential tool in every analyst's toolkit.

Week 2–3

SQL & Databases

Write queries to extract, filter, join, and aggregate data from relational databases. Query real datasets from day one.

Week 4–5

Python for Data

Use Pandas and NumPy to clean, transform, and analyse datasets. Automate repetitive tasks that would take hours in Excel.

Week 6–8

Data Visualisation

Build compelling charts with Matplotlib, Seaborn, and Power BI. Tell clear data stories that non-technical stakeholders understand.

Week 9–10

Capstone Project

Analyse a real-world dataset end-to-end — clean, explore, visualise, and present your findings in a professional dashboard.

Week 11–12

What's Inside the Course

Every module is built to take you from understanding concepts to working with real data.

01

Introduction to Data Analytics

What data is, why it matters, and how analysts work

What is data analytics?
Types of data: structured vs unstructured
The data analytics process (collect → clean → analyse → visualise)
Tools overview: Excel, SQL, Python, Power BI
Setting up your analytics environment
02

Excel Essentials

The analyst's most-used tool, mastered

Workbooks, sheets & cell references
Essential formulas: SUM, IF, COUNTIF, AVERAGE
Sorting, filtering & data validation
Conditional formatting
Project: Clean & summarise a sales dataset
03

Advanced Excel & Pivot Tables

Extract insights from large datasets fast

VLOOKUP, HLOOKUP & XLOOKUP
Pivot tables & pivot charts
Named ranges & dynamic arrays
Charts: bar, line, scatter, combo
Project: Monthly performance report
04

Data Cleaning Principles

Bad data gives bad answers — fix it

Identifying missing values & outliers
Removing duplicates & standardising formats
Text functions: TRIM, PROPER, CONCATENATE
Data quality checklist
Project: Clean a messy real-world dataset
05

SQL Fundamentals

Query any database like a pro

Databases, tables & relational models
SELECT, WHERE, ORDER BY, LIMIT
Aggregate functions: COUNT, SUM, AVG, MAX
GROUP BY & HAVING
Project: Analyse an e-commerce database
06

SQL Joins & Subqueries

Combine and nest data from multiple tables

INNER, LEFT, RIGHT & FULL JOINs
Subqueries & CTEs
Window functions (RANK, ROW_NUMBER)
Project: Customer retention analysis
07

Python for Data Analysis

Automate and scale your analysis

Python basics: variables, loops, functions
Jupyter Notebooks workflow
Pandas: DataFrames, series & indexing
Reading CSV, Excel & JSON files
Project: Analyse Nigeria market data
08

Pandas & Data Wrangling

Transform messy data into analysis-ready tables

Filtering, sorting & grouping with Pandas
Merging & reshaping DataFrames
Handling missing values & duplicates
Apply, map & lambda functions
Project: Clean & explore a public dataset
09

Data Visualisation with Python

Make your data speak visually

Matplotlib: line, bar, pie, scatter plots
Seaborn: heatmaps, distributions & boxplots
Choosing the right chart for your data
Styling for presentations
Project: Visual sales insights report
10

Power BI Dashboards

Build interactive reports that impress

Power BI interface & data import
DAX basics: calculated columns & measures
Building interactive dashboards
Publishing & sharing reports
Project: Business KPI dashboard
11

Capstone Project

A full end-to-end analytics case study

Pick a real-world dataset (business, health, sports)
Clean & explore the data (Python + Excel)
Write SQL queries to answer business questions
Build a Power BI dashboard
Present findings to the class & mentors
12

Graduation & Certification

You made it. Now prove it.

Final project review with mentor
Portfolio walkthrough presentation
Certificate of completion
Career guidance & next-steps session

Training Details

Training Time

7PM - 9PM

Training Days

Mon, Wed & Fri

Training Fee

Level 1: ₦70,000

Level 2: ₦70,000

Level 3: ₦180,000

Training Venue

Google Meet for Online / Message us for Pyhsical Venue

Training Duration

6 Weeks Per Level

Start Date

22nd June, 2026.

Learning That Actually Works

We don't just teach theory. We build careers.

Project-Based Learning

Analyse real datasets every week. Graduate with a portfolio of dashboards and reports that employers will actually look at.

Expert Mentors

Learn from data professionals with real industry experience. Not just tutors but practitioners who've done the work.

Career Support

CV reviews, interview prep, and direct employer connections. We stay with you until you land your first data role.

Learn Anywhere

Live sessions with recordings available. Study on your phone, tablet, or laptop, whichever works for you.

Tight-Knit Community

Join a growing community of graduates, learners, and mentors across Nigeria. Collaborate, share datasets, and grow together.

Your Future Starts with Great Teachers — Meet Them at TechStaz

Learn from the minds who make online education meaningful.

Get In Touch