AI & Data ScienceNational Certificate Level IV100% Scholarship Eligible
Data Analytics & Business Intelligence
Advanced SQL, Power BI, Python, ETL Engineering & Predictive Forecasting
Turn raw organizational data into decisive executive intelligence. Learn ETL pipeline design, star-schema data modeling, interactive Power BI / Tableau dashboarding, statistical regression, and algorithmic customer segmentation.
Duration
6 months
Proficiency
Beginner
Start Date
November 2026
Credit Units
60 Units
Accredited TVETCertification:National Certificate in Data Analytics & BI
Tuition Fee:₦350,000 (100% Scholarship Eligible)
Study Mode:Hybrid (Lab + Online)
Accreditation:National Skills Qualification Framework (NSQF)
Terrain-Optimized Learning
Syllabus & Real Engineering Modules
Designed for Nigerian connectivity and power constraints. Study online or export complete lesson guides for offline learning.
Key Topics & Theoretical Concepts
Complex Joins, Aggregations & Grouping Sets
Window Functions: ROW_NUMBER, RANK, LEAD, LAG & Running Totals
CTEs, Recursive Queries & Temporary Tables
Dimensional Modeling: Fact Tables, Dimension Tables & Surrogate Keys
Hands-On Lab: Build a Retail & Supply Chain Business Analytics DatabaseBeginner
Write complex analytical SQL queries calculating monthly customer retention, churn cohorts, and product velocity.
Toolchain & Stack:
PostgreSQLDBeaverSQL
Recommended Module Literature
SQL for Data Analysis
Source: Cathy Tanimura (O'Reilly) • Advanced techniques for transformational data querying.
Graduation Competencies
✓
Extract and transform large-scale organizational data using advanced SQL queries✓
Clean, wrangle, and analyze complex datasets using Python and Pandas✓
Architect interactive executive dashboards using Microsoft Power BI and DAX formulas✓
Forecast business metrics using statistical and predictive modeling techniquesTechnologies Mastered
Advanced SQL (Window Functions, CTEs)Microsoft Power BIPython (Pandas, Seaborn)TableauETL PipelinesData Modeling (Star Schema)DAX Formulas
Prerequisites
- •Basic arithmetic & interest in business metrics
- •Familiarity with spreadsheet tools (Excel / Google Sheets)
Target Industry Roles
Business Intelligence AnalystData AnalystFinancial Data SpecialistOperations Analyst