Excel & Data Foundations
₦100,000Basic computer literacy; see course entry requirements.
Choose your stage below ↓PRACTICAL LEARNING / ITC COMPUTERS
Data Analysis
Turn raw information into useful reports and clearer business decisions.
₦250,000 · group full-payment tuitionSix months · 24 teaching weeks
Choose a package & enquire →Who can join?
Basic computer literacy. Learners without this should complete computer fundamentals first.
How you learn
Online and Offline (in-person) training available. Instructor-led lessons, demonstrations and practical exercises. Schedule and intake are confirmed before enrolment. ITC confirms practical labs, equipment and attendance arrangements for your chosen mode.
Assessment
Practical exercises, assignments and a final project or skills assessment.
One stage or the full pathway.
Join a stage that matches your skills. Later-stage entry requires previous-stage completion or an assessment.
SQL & Power BI Foundations
₦100,000Successful completion of the preceding stage, or an entry assessment demonstrating equivalent skills.
Choose your stage below ↓Dashboards, Python & Applied Analysis
₦100,000Successful completion of the preceding stage, or an entry assessment demonstrating equivalent skills.
Choose your stage below ↓What you’ll learn and practise
Six months comprises 24 teaching weeks; holiday dates are confirmed with each intake. A typical six-month timetable is three two-hour sessions weekly plus independent practice; confirm your cohort’s teaching hours.
WEEKS 1–2 Understanding Data
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Business questions, types, sources and responsible handling
Practical: Define an analysis problem.
WEEKS 3–4 Excel Foundations
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Tables, formulas, references and organization
Practical: Build a business-record workbook.
WEEKS 5–6 Data Cleaning
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Missing values, duplicates, formats and validation
Practical: Clean a messy dataset.
WEEKS 7–8 Excel Analysis
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Lookups, PivotTables, summaries and charts
Practical: Analyse sales or expenses.
WEEKS 9–10 Statistics for Analysis
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Averages, variation, distributions and sampling
Practical: Interpret findings and limitations.
WEEKS 11–12 SQL Foundations
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Filtering, sorting, grouping and aggregation
Practical: Answer questions from a training database.
WEEKS 13–14 Relational Data
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Keys, joins and combining tables
Practical: Connect customer, product and sales records.
WEEKS 15–16 Power BI & Data Modelling
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Importing, Power Query and relationships
Practical: Build a clean report model.
WEEKS 17–18 Dashboards & Measures
Available online or offline (in-person), with practical arrangements confirmed by ITC.
DAX foundations, indicators, filters and visual design
Practical: Create an interactive dashboard.
WEEKS 19–20 Python for Analysis
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Python, pandas and plotting foundations
Practical: Reproduce a small analysis in a notebook.
WEEKS 21–22 Reporting, Power BI Service & Security
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Publishing, refresh, access, row-level security and storytelling
Practical: Publish a training report and explain access controls.
WEEKS 23–24 Capstone & Assessment
Available online or offline (in-person), with practical arrangements confirmed by ITC.
Analysis, dashboards and PL-300 gap review
Practical: Present a dashboard and written findings.
What you gain
- Turn raw information into useful reports and clearer business decisions.
- Demonstrate practical work, document decisions and explain limitations.
- Complete a final project or skills assessment and build evidence of learning.
International certification pathway
Certification preparation is integrated at the relevant stages. A checkpoint means reviewing the awarding body’s full objectives, completing supplementary preparation and passing a readiness assessment; attendance alone does not establish exam readiness.
Microsoft Power BI Data Analyst Associate (PL-300)
Paid external examination
Complete exam-specific modelling, Power Query, DAX, service management and security practice.
Official qualification information ↗Certificates and examination fees
Successful completion of ITC training and assessment earns an ITC Computers Certificate of Completion. This is separate from any external qualification. International examination, registration and certification charges are not included in tuition and are paid by the learner. ITC helps identify suitable free opportunities and promotions where available; availability is verified before booking. Free completion certificates and badges are distinguished from professional certifications. No external pass or employment is guaranteed.
Tools, materials and support
Optional software subscriptions, internet/data and external examination fees are separate from tuition.
Ask a person on WhatsApp ↗