Enrol on 6-Week Programme for the
6-Week Data Analytics Programme
We are happy to get you started
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.
Program ID
undefined--1102
Price
₦110,000
Duration
6 Weeks
Program Outline
- 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
View Program Modules
Program 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