ICTTrainingsin Nigeria
All courses

Data Analytics

Data Analysis

Turn raw numbers into decisions businesses can act on.

12 weeks Beginner friendly Online or in-person
Data Analysis class

About this course

Learn the full analyst toolkit — from spreadsheets to databases to programming. You will clean messy data, query it with SQL, build dashboards in Power BI and Tableau, and use Python and R to uncover insights worth presenting to any boardroom.

What you'll learn

  • Clean, analyse and model data in Excel like a pro
  • Query databases confidently with SQL
  • Design interactive dashboards in Power BI and Tableau
  • Automate analysis with Python and R

Curriculum

  1. Module 01

    Excel mastery

    Formulas & lookups · Pivot tables · Data cleaning

  2. Module 02

    SQL for analysts

    SELECT, JOIN & GROUP BY · Working with real databases

  3. Module 03

    Visualisation

    Power BI dashboards · Tableau storytelling

  4. Module 04

    Python & R

    pandas for analysis · Statistics in R · Charts & reports

  5. Module 05

    Capstone

    End-to-end analysis of a Nigerian business dataset

Tools you'll master

Microsoft ExcelPower BITableauSQLPythonR

Career paths

Data Analyst Business Intelligence Analyst Reporting Analyst