Data Analytics Training — Nigeria

2Programmes

6 WeeksShortest programme

CPDCertified

Course Overview

Our Nigeria Data Analytics Training programmes are designed specifically for Nigerian professionals and career changers who want to build strong, employer-ready data skills. Delivered live online, our programmes are taught in English by experienced instructors and are flexible enough to fit around work or study commitments.

Choose the 6-Week Programme for a focused introduction covering Excel and Power BI — ideal if you are new to data or want to add a valuable certification quickly. Choose the Full Programme for the complete pathway, adding SQL, Python, and machine learning fundamentals to your skill set.

All programmes are CPD-certified and include live sessions, recordings, real data projects, and a professional completion certificate.

Learning Pathway

Who is this for?

Choose Your Programme

All programmes include CPD certification, live project experience, CV support and interview preparation.

6-Week Data Analytics Programme

A focused, practical introduction to data analytics. In six weeks you will gain hands-on skills in Microsoft Excel and Power BI — the two most in-demand data tools in Nigerian and international organisations. By the end you will be able to clean, analyse, and visualise data, and you will leave with a CPD-certified certificate.

Flexible payment: spread the cost — contact us for details.

✓Microsoft Excel fundamentals and advanced functions (VLOOKUP, IF, COUNTIF, INDEX/MATCH)
✓Data cleaning and preparation — removing errors, handling duplicates, structuring data
✓PivotTables, PivotCharts and Excel dashboards
✓Introduction to Power BI — connecting data sources and building reports
✓Power Query for data transformation and automation
✓Building interactive Power BI dashboards
✓Data storytelling — presenting insights clearly to non-technical audiences
✓Real-world datasets used throughout — practice on data you will see in the workplace
✓Live instructor-led sessions via Microsoft Teams (recordings included)
✓CPD-certified completion certificate

6 Weeks

₦110,000

Enrol on 6-Week Programme

View Programme Modules

1. Week 1 — Introduction to Data Analytics & Excel Fundamentals

What data analytics is and why it matters
Navigating Excel: workbooks, worksheets, and the ribbon
Data types, formatting, and basic formulas (SUM, AVERAGE, COUNT)
Sorting and filtering data
Introduction to tables in Excel

2. Week 2 — Advanced Excel for Data Analysis

Logical functions: IF, AND, OR, nested IF statements
Lookup functions: VLOOKUP, HLOOKUP, INDEX and MATCH
Statistical and text functions
Named ranges and data validation
Conditional formatting to highlight key data

3. Week 3 — Data Cleaning & Data Quality

Identifying and handling missing values and duplicates
Standardising inconsistent data (dates, names, formats)
Using Flash Fill and Text to Columns
Introduction to Power Query for automated data cleaning
Building a repeatable data cleaning workflow

4. Week 4 — PivotTables, Charts & Excel Dashboards

Creating and customising PivotTables
PivotCharts — bar, line, pie and combo charts
Slicers and timeline filters for interactive reports
Building a one-page Excel dashboard
Best practices for presenting data visually

5. Week 5 — Introduction to Power BI

Installing and navigating Power BI Desktop
Connecting to Excel, CSV and online data sources
Power Query in Power BI — transforming and shaping data
Building your first report: cards, bar charts, tables
Publishing to Power BI Service and sharing reports

6. Week 6 — Power BI Dashboards & Capstone Project

Advanced visuals: maps, KPI cards, slicers and drill-through
Introduction to DAX: basic calculated columns and measures
Building an interactive multi-page Power BI dashboard
Capstone project: analyse a real dataset end-to-end
CPD assessment and certificate submission

Full Data Analytics Programme

The complete data analytics pathway — everything in the 6-Week Programme plus SQL for querying databases, Python for advanced analysis and automation, and an introduction to machine learning. By the end you will have a portfolio of real projects and the skills to apply for junior data analyst, BI analyst, and data science roles.

Payment plans available — split into 3 or 6 monthly instalments. Contact us for details.

✓Everything in the 6-Week Programme (Excel, Power BI, data cleaning, dashboards)
✓SQL — writing queries to extract and analyse data from relational databases
✓Python for data analysis — pandas, NumPy, matplotlib and seaborn
✓Data wrangling with Python — merging, reshaping, aggregating datasets
✓Statistical analysis and hypothesis testing
✓Machine learning fundamentals — supervised and unsupervised learning
✓Building predictive models with scikit-learn
✓End-to-end data projects added to your professional portfolio
✓Advanced DAX formulas and Power BI enterprise features
✓Live instructor-led sessions, session recordings, and dedicated tutor support
✓CPD-certified completion certificate

24 Weeks

₦380,000

Enrol on Full Programme

View Programme Modules

1. Weeks 1–6 — Excel, Power BI & Data Cleaning

Full 6-Week Programme content (see above)
Excel: formulas, functions, PivotTables, dashboards
Power BI: reports, dashboards, Power Query and DAX basics
Data cleaning and quality management

2. Weeks 7–10 — SQL for Data Analysis

Relational databases: tables, keys, relationships
SELECT, WHERE, GROUP BY, ORDER BY, HAVING
Joins: INNER, LEFT, RIGHT, FULL OUTER
Subqueries, CTEs and window functions
Analysing real business datasets using SQL

3. Weeks 11–16 — Python for Data Analysis

Python fundamentals: variables, control flow, functions
pandas: reading, exploring and transforming DataFrames
NumPy for numerical computation
Data visualisation: matplotlib and seaborn charts
Automating reports and data pipelines

4. Weeks 17–20 — Machine Learning Fundamentals

What is machine learning and where it is applied
Supervised learning: regression and classification
Unsupervised learning: clustering and dimensionality reduction
Building and evaluating models with scikit-learn
Interpreting model results and communicating findings

5. Weeks 21–24 — Advanced Analytics & Capstone

Advanced Power BI: enterprise features, Row-Level Security, dataflows
Combining SQL, Python and Power BI in a single workflow
Portfolio capstone project: full end-to-end analytics case study
Peer review and tutor feedback session
CPD assessment, certificate submission and career guidance

Why Choose Coseng for Data Analytics Training in Nigeria?

✓

Taught by Experienced Professionals

✓

Flexible and Online

✓

Affordable and Recognised

✓

Practical Learning

Ready to start your learning journey?

Our advisors will help you choose the right programme and discuss funding options — no obligation.

Apply Now Contact Us