Data Analytics

About Course

About the Course

The Data Analytics program is designed to provide practical skills in collecting, analyzing, and interpreting data to drive business decisions. Participants will learn modern tools such as Excel, SQL, Power BI, Python, and other industry-standard applications for transforming raw data into actionable insights.

Course Objectives

Understand the fundamentals of data analytics and visualization.

Learn how to use analytics tools to process and analyze large datasets.

Develop practical skills in business intelligence and reporting.

Apply statistical methods and predictive models for decision-making.

Gain the expertise to support organizational growth with data-driven strategies.

Admission Requirements

Minimum of OND, HND, BSc, or equivalent qualification.

Professionals in business, statistics, IT, finance, or related fields.

Basic knowledge of Microsoft Excel is an advantage.

Duration

3 – 6 Months (Flexible online & blended learning options available).

Certification

Participants will receive a Professional Certificate in Data Analytics from ICBMD, with international recognition.

Cost

₦250,000

Course Content

Module 1: Introduction To Data Analytics
Data Analytics courses will give you insights into how to apply data and analytics principles in your business. Learning analytics, data visualization, and data science methodologies through this course will make you capable of driving better business decisions and ROI.

Course Introduction
Data Analytics Overview
Dealing with different types of Data
Data Visualization for Decision Making
Data Science, Data Analytics and Machine Learning
Data Science Methodology
Data Analytics in Different Sectors
Analytics Framework and latest trends

Module 2: Boost your Data Analytics Career with MS Excel
Boost your Data Analytics Career with Microsoft Excel skills

Introduction to MS Excel
Efficient Tools in MS Excel
MS Excel Best Practices
Data Cleaning and Preparation
Professional Formatting
Cells and references
Excel functions – if and nested
Functions, Array functions
H lookup, V lookup, Index and Matching
Advanced MS Excel functions
Analyzing Data with pivot tables
Data Analysis using MS Excel
MS Excel Charts and Visualization
Using Macros for Analytics

Module 3: PowerBI
This training program helps you master PowerBI, a world-wide utilized data visualization, reporting, and business intelligence tool.

Module 4: Data Extraction using SQL
In this part of Data Analytics syllabus, you will learn how to extract data using Structured Query Language (SQL) from a relational database.

Understanding the fundamentals of SQL
Introduction to Databases (Types, Tools)
Data Models: Thinking about your Data
The evolution of Data Models
Relational vs Transactional Models
Installing SQL
Introduction to SQL GUI
Creating Tables
Restoring Data sets
Writing SQL Statements
SQL Commands and retrieving Data
SQL Aggregations
Advanced Filtering with SQL
Sorting with SQL
Using wildcards SQL Joins
SQL Subqueries
Grouping Data with SQL

Module 5: Data Analyst Projects and Portfolio Building
Data Analyst caps projects will give you an opportunity to implement the skills you learned in this Data Analyst certification course.

Module 6: Python for Data Analysis
Learn how to perform Data Analytics with Python

Programming Basics and Data Analytics with Python
Introduction to Programming
Programming Environment Setup
OOPs Concept with Python
Programming Fundamentals of Python
File handling, Exception handling, and Package handling in Data Analytics
Statistical Computing
Mathematical Computing using NumPy
Data Manipulation using Pandas
Data Visualization with Python
Introduction to Model building
Python for Data Science – Python Basics
Python Data Structure
Python Programming Fundamentals
Working with Data in Python
Working with NumPy Arrays
Introduction to Visualization Tools
Basic Visualization Tools
Specialized Visualization Tools
Advanced Visualization Tools
Creating Maps and Visualizing Geospatial Data

Module 7: Career Blueprint

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Course Introduction

Data Analytics Overview

Dealing with different types of Data

Data Visualization for Decision Making

Data Science, Data Analytics and Machine Learning

Data Science Methodology

Data Analytics in Different Sectors

Analytics Framework and latest trends

Module 2: Boost your Data Analytics Career with MS Excel Boost your Data Analytics Career with Microsoft Excel skills

Introduction to MS Excel

Efficient Tools in MS Excel

MS Excel Best Practices

Data Cleaning and Preparation

Professional Formatting

Cells and references

Excel functions – if and nested

Functions, Array functions

H lookup, V lookup, Index and Matching

Advanced MS Excel functions

Analyzing Data with pivot tables

Data Analysis using MS Excel

MS Excel Charts and Visualization

Using Macros for Analytics

Module 3: PowerBI This training program helps you master PowerBI, a world-wide utilized data visualization, reporting, and business intelligence tool.

Introduction to MS PowerBI

Navigating PowerBI Interface

PowerBi Query Editor

Data Visualization in PowerBI

Creating interactive dashboards

Data Modelling

DAX Measures

PowerBI Projects

Module 4: Data Extraction using SQL In this part of Data Analytics syllabus, you will learn how to extract data using Structured Query Language (SQL) from a relational database.

Understanding the fundamentals of SQL

Introduction to Databases (Types, Tools)

Data Models: Thinking about your Data

The evolution of Data Models

Relational vs Transactional Models

Installing SQL

Introduction to SQL GUI

Creating Tables

Restoring Data sets

Writing SQL Statements

SQL Commands and retrieving Data

SQL Aggregations

Advanced Filtering with SQL

Sorting with SQL

Using wildcards SQL Joins

SQL Subqueries

Grouping Data with SQL

Module 5: Data Analyst Projects and Portfolio Building Data Analyst caps projects will give you an opportunity to implement the skills you learned in this Data Analyst certification course.

Module 6: Python for Data Analysis Learn how to perform Data Analytics with Python

Programming Basics and Data Analytics with Python

Introduction to Programming

Programming Environment Setup

OOPs Concept with Python

Programming Fundamentals of Python

File handling, Exception handling, and Package handling in Data Analytics

Statistical Computing

Mathematical Computing using NumPy

Data Manipulation using Pandas

Data Visualization with Python

Introduction to Model building

Python for Data Science – Python Basics

Python Data Structure

Python Programming Fundamentals

Working with Data in Python

Working with NumPy Arrays

Introduction to Visualization Tools

Basic Visualization Tools

Specialized Visualization Tools

Advanced Visualization Tools

Creating Maps and Visualizing Geospatial Data

Module 7: Career Blueprint

How to develop a plan for a successful and amazing career in Data Analytics

How to get Freelancing Gigs as a Data Analyst

Global opportunities to relocate to and work in the US, UK, Canada and Europe

Module 2: Boost your Data Analytics Career with MS Excel
Boost your Data Analytics Career with Microsoft Excel skills

Module 3: PowerBI
This training program helps you master PowerBI, a world-wide utilized data visualization, reporting, and business intelligence tool.

Module 4: Data Extraction using SQL
In this part of Data Analytics syllabus, you will learn how to extract data using Structured Query Language (SQL) from a relational database.

Module 5: Data Analyst Projects and Portfolio Building
Data Analyst caps projects will give you an opportunity to implement the skills you learned in this Data Analyst certification course.

Module 6: Python for Data Analysis
Learn how to perform Data Analytics with Python