PEA Professional Excellence
Academy Africa
In-Person Office Training

Data Analytics & Business Intelligence (In-Person)

Turn raw data into executive decisions with hands-on training in SQL, Python, Power BI, and Tableau.

Duration 4 Months
Next Cohort Next Cohort Starts: November 15, 2026
Class Schedule Weekday & Weekend Cohorts Available
Training Format 100% In-Person Physical Hub
Enrol in This Cohort
Tuition from ₦128,333/mo (or ₦700,000 full fee)
₦700,000
Or 6 installments of ₦128,333/month
  • Physical PC workstation provided
  • 24/7 Power & dedicated fiber internet
  • 1-on-1 direct mentor coaching
  • Real enterprise lab simulations
  • CPD-accredited certificate
  • Hiring partner referral support
Enrol Now

Course Overview

Organizations today live and die by their ability to understand data. This physical training program equips you with the end-to-end analytical stack: Advanced Excel, Relational Databases with SQL, Exploratory Data Analysis with Python (Pandas/NumPy), and interactive Executive Dashboards in Power BI and Tableau. You will work on live commercial business cases alongside experienced data leads.

  • Physical classroom setting with dual-monitor data workstations
  • Real commercial datasets from African and international fintechs
  • Advanced SQL: Window functions, CTEs, subqueries, and stored procedures
  • Python data engineering and automated report pipelines
  • Business Intelligence: Dynamic interactive KPI dashboards in Power BI
  • Executive Stakeholder Presentation & Data Storytelling mastery

What You Will Learn

A rigorous, practical curriculum built from real enterprise workflows and defensive/offensive architectures.

1 Month 1: Advanced Excel & Business Data Foundations
Weeks 1 - 4
  • Data hygiene, structure, and validation rules
  • Advanced formulas: XLOOKUP, INDEX/MATCH, dynamic arrays
  • PivotTables, PivotCharts & Power Query automation
  • Financial modeling, scenario analysis & KPI scorecards
  • Capstone Case: Automating Monthly Performance Reporting for a Retail Chain
2 Month 2: Enterprise SQL & Relational Databases
Weeks 5 - 8
  • Relational Schema Design, Normalization & Primary/Foreign Keys
  • Complex Queries: Multi-table JOINs, GROUP BY, HAVING
  • Advanced Analytical SQL: Window Functions (RANK, DENSE_RANK, LEAD, LAG)
  • Common Table Expressions (CTEs), Subqueries & Query Optimization
  • Capstone Case: Cohort Retention & Churn Analysis for a Subscription Business
3 Month 3: Python for Exploratory Data Analysis & Visualization
Weeks 9 - 12
  • Python Programming Fundamentals & Jupyter Notebooks
  • Data Wrangling with Pandas & Numerical Computing with NumPy
  • Statistical Data Visualizations with Matplotlib and Seaborn
  • Exploratory Data Analysis (EDA) on messy real-world datasets
  • Capstone Case: Consumer Spending & Fraud Indicator Analysis
4 Month 4: Power BI, Tableau & Executive Storytelling
Weeks 13 - 16
  • Power BI Architecture, Data Modeling & Star Schema
  • DAX Fundamentals: Measures, Calculated Columns & Time Intelligence
  • Interactive Dashboard UX/UI Design & Custom Tooltips
  • Executive Presentation: Translating Data Insights into Commercial Strategy
  • Live Portfolio Showcase to Partner Hiring Managers

Tools & Technologies Covered

Microsoft Excel
PostgreSQL
MySQL
Python
Pandas
NumPy
Power BI
Tableau
Jupyter Lab
Git/GitHub

Career Pathways & Salary Outlook

Demand for verified physical academy graduates remains at an all-time high across African fintechs, banks, and international remote teams.

Role Nigeria (Annual) Remote / Global
Data Analyst ₦5M - ₦9M / yr $60,000 - $90,000 / yr
Business Intelligence Analyst ₦6M - ₦11M / yr $70,000 - $105,000 / yr
Marketing & Growth Analyst ₦5.5M - ₦9.5M / yr $65,000 - $95,000 / yr
Operations Data Lead ₦7M - ₦13M / yr $75,000 - $115,000 / yr

Who Is This Program For?

  • Graduates seeking high-demand analytical careers in finance, tech, and healthcare.
  • Accountants, marketers, and administrators wanting to elevate into strategic analytics.
  • Professionals wanting structured in-person guidance with real business cases.

Flexible and Affordable Payment

Choose the payment structure that fits your financial goals. All plans include full physical workstation access and certifications.

Pay in 6 Installments
₦128,333
Per month for 6 months
  • Smallest monthly commitment
  • Full in-person workstation access
  • All labs & project reviews
  • Certificate upon completion
Enrol Now
Full Fees Upfront
₦700,000
One-time payment (Best value)
  • Guaranteed seat reservation
  • Zero recurring monthly stress
  • Complete lab sandbox access
  • Direct hiring partner introduction
Enrol Now