Data Analytics Essentials
Master SQL, Excel, Python, and PowerBI in 12 weeks. Built around real Nigerian business datasets and the exact job descriptions posted by top employers right now.
Full payment · Secured by Paystack
What you'll learn
Write complex SQL queries against real business databases
Build Excel dashboards with pivot tables and dynamic charts
Clean and analyse data with Python and pandas
Create interactive PowerBI reports executives actually use
Communicate findings clearly to non-technical stakeholders
Pass technical screening rounds at Nigerian banks and fintechs
Graduate with a portfolio of four end-to-end analysis projects
Land a junior or mid-level data analyst role within 90 days
Course curriculum
SQL Fundamentals
- SELECT, WHERE, ORDER BY, LIMIT
- GROUP BY and aggregate functions
- INNER, LEFT, and RIGHT JOINs
- Nigerian sales and transactions dataset
Advanced SQL
- Common Table Expressions (CTEs)
- Window functions: ROW_NUMBER, RANK, LAG/LEAD
- Subqueries and correlated subqueries
- Query optimisation and execution plans
Excel & Spreadsheet Mastery
- VLOOKUP, INDEX/MATCH, and XLOOKUP
- Pivot tables and pivot charts
- Dynamic dashboards with slicers
- Data validation and conditional formatting
Python for Data
- pandas: DataFrames, filtering, merging
- Data cleaning: nulls, duplicates, type casting
- Visualisation with matplotlib and seaborn
- Automating repetitive Excel workflows
PowerBI
- Connecting PowerBI to databases and CSV files
- DAX basics: calculated columns and measures
- Designing reports for mobile and desktop
- Publishing and sharing via PowerBI Service
Storytelling with Data
- Choosing the right chart for each message
- Structuring an executive summary
- Slide design for data presentations
- Mock presentation to the cohort
Capstone Project
- End-to-end analysis of a real Nigerian business dataset
- SQL extraction → Python cleaning → PowerBI report
- Written commentary and executive summary
- Live demo and certificate issued
Your instructor
Chioma Nwosu
Data Analyst at Access Bank · 7 years in data
Chioma leads the analytics function at Access Bank's digital banking division. She built this curriculum by reverse-engineering real job descriptions at Nigerian companies and distilling them into skills that get people hired.
Frequently asked questions
Do I need to know Python or coding before I start?+
No. The first six weeks cover SQL and Excel with zero coding. Python is introduced gently in weeks 7–8 with full instructor support at every step.
Which version of PowerBI do we use?+
PowerBI Desktop, which is free to download. We also cover PowerBI Service for publishing and sharing reports with a team.
How job-ready will I be when I graduate?+
Very. The curriculum was built from job descriptions posted by Flutterwave, Access Bank, Kuda, Paystack, and MTN. You will graduate with portfolio pieces that match exactly what these companies are hiring for.
Is Excel taught from scratch or assumed?+
We teach Excel from the basics but move quickly. If you can open a spreadsheet and type in cells, you're fine. No advanced Excel knowledge is assumed.
Are sessions recorded?+
Yes. All live sessions are recorded and remain accessible for 12 months after your cohort ends.
How does payment work?+
This course is full payment upfront at ₦150,000 via Paystack. The monthly school-fee plan (minimum ₦300,000/month) is not applicable to this course. Payment confirms your seat and adds you to the cohort WhatsApp group immediately.
What Nigerian datasets do we work with?+
We use anonymised datasets from Nigerian e-commerce, banking, and FMCG sectors — the same domains where most analyst roles are concentrated. The problems feel familiar, which accelerates learning.
Ready to start Data Analytics Essentials?
First 30 students lock in early-bird pricing. After that — full price, no exceptions.
Full payment via Paystack · Set your password by email after payment