Back
Data Analysis
Learn Excel, SQL, Python, and Power BI to clean data, analyze patterns, build dashboards, and communicate insights.
8 Weeks
4 Lessons
Certification on completion
3 Mentors
1 Project
Course overview
About this skill path.
This 8-week track takes you from spreadsheet thinking to professional analytics. You’ll clean and analyze data in Excel/Sheets, write SQL queries for real insights, use Python (Pandas) for wrangling and visualization, build dashboards in Power BI, and complete a capstone project for your portfolio.
What you'll learn.
Each track is carefully structured to take you from basics to real-world application.
- Spreadsheet cleaning and analysis (Excel/Google Sheets)
- Lookups, PivotTables, dashboards, KPIs
- SQL querying, aggregation, joins, and basic window functions
- Python basics + Pandas for cleaning and prep
- EDA, correlation, outliers, and ethics/bias awareness
- Visualization best practices
- Power BI dashboarding and storytelling
- Capstone project workflow and portfolio readiness
Curriculum
Course syllabus
2 units
·2 Assignment
What's included:
- What data is; analysis lifecycle (collection → insight)
- Data types (categorical, numerical, datetime)
- Cleaning functions (TRIM, CLEAN, LEN, IF, ISBLANK, etc.)
- Basic analysis (COUNTIF, SUMIF, conditional formatting)
- Mini project: clean and summarize a performance dataset
2 units
·2 Assignment
What's included:
- Lookups (VLOOKUP, INDEX/MATCH) and IFERROR
- PivotTables/PivotCharts; slicers; reusable templates
- Dashboard design principles; KPIs vs metrics
- Problem framing: stakeholder needs → analysis questions
- Mini project: retail sales dashboard
2 units
·2 Assignment
What's included:
- SQL databases, tables, schemas
- SELECT, WHERE, ORDER BY, LIMIT
- Aggregations: COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING; CASE WHEN intro
- Mini project: analyze behavior with SQL queries
2 units
·2 Assignment
What's included:
- JOINs (INNER/LEFT/RIGHT) and cleaning join results
- Subqueries and CTEs (WITH)
- Window functions: RANK/ROW_NUMBER/LAG/LEAD basics
- Insight-ready SQL summaries for decision-making
- Mini project: churn patterns and purchase trends
2 units
·2 Assignment
What's included:
- Jupyter basics; light Python foundations (lists, dicts, loops, functions)
- Pandas: read_csv, inspection, basic transforms
- Missing values, duplicates, string ops, date parsing
- Calculated columns and prep workflows
- Mini project: clean a messy dataset in Pandas
2 units
·2 Assignment
What's included:
- EDA workflow: describe, value_counts, groupby
- Charts: bar, line, histogram, scatter, heatmaps
- Correlation and relationships; outliers (IQR/Z-score)
- Data bias: what it is and why it matters
- Mini project: 3 charts + written insights
2 units
·2 Assignment
What's included:
- Power BI setup, data loading, modeling relationships
- Visuals: slicers, maps, and layout structuring
- Storytelling with dashboards for executives
- Writing insight reports (docs/slides/Notion)
- Mini project: regional retail dashboard + insight script
2 units
·1 Assignment
What's included:
- Scoping and structuring workflow (plan → clean → analyze → visualize → explain)
- Capstone: dataset of choice with Excel/SQL/Python/Power BI
- Final report + presentation
- Portfolio and LinkedIn/resume preparation + mock interview focus
We believe learning practical tech skills should be affordable.
We've stripped away the fluff and focused on what matters. This is the best value-for-money tech education you'll find.
Special Offer
One-time payment
₦10,000/track
- 8 weeks intensive training
- Live classes & Recordings
- Weekly mentorship sessions
- Real-world portfolio projects
- Certificate of Completion
- Community Access