Chat with Us
About Curriculum Fees Team Locations Enroll Now →
Now Enrolling · Data Analytics Cohort

Become a Data Analyst
the Industry Respects

A 10-week, project-driven Data Analytics course by TechSwap Academy. No theory-only fluff — real tools, real datasets, real portfolio projects that get you hired.

10
Weeks
2
Live Projects
5+
Industry Tools
100%
Portfolio Ready
📊
Excel & Google Sheets
Weeks 1–2 · Data Foundation
🗄️
SQL & BigQuery
Weeks 3–4 · Database Querying
📈
Tableau / Power BI
Weeks 5–6 · Visualization
🐍
Python for Data
Weeks 7–8 · Analysis & Automation
🗂️
Capstone Projects
Weeks 9–10 · Portfolio Build
Who We Are

Empowering the Next Generation
of Tech Talents

TechSwap Academy was founded to do one thing exceptionally well: empower individuals with refined, industry-grade tech skills that make them truly tech-savvy — not just certificate holders, but builders, analysts, and innovators ready for tomorrow's tech landscape.

🏗️

Project-Based Learning

We don't teach theory in isolation. Every concept is anchored to real-world application. You'll build actual projects, solve real data problems, and graduate with a portfolio that speaks louder than any certificate.

🎯

Industry-Connected Tutors

We bridge the gap between learners and the tech industry by bringing experienced professionals into the classroom — people who work with these tools daily and know exactly what employers look for.

💼

Portfolio That Gets You Hired

By graduation, you won't just have skills — you'll have two complete, real-world data projects that are ready to showcase to any employer or client, giving you a concrete edge in the job market.

🌐

Flexible Learning Modes

Choose to learn physically at our Lagos campuses for an immersive, in-person experience, or join online from anywhere in the world — the same curriculum, same tutors, same quality.

Our Mission
"Empowering individuals with refined tech skills to become the next generation of tech talents."
  • Project-first, portfolio-driven curriculum
  • Industry professionals as mentors & tutors
  • Bridging learners directly to the tech industry
  • Hands-on with tools used in real companies
  • Physical and online learning available
  • Small cohorts for maximum attention
  • Career support & networking opportunities
What You'll Learn

10-Week Data Analytics Curriculum

A structured, tool-by-tool journey from spreadsheet basics to Python-powered analysis — with two real-world projects woven throughout.

10 Weeks · Comprehensive
Week 1 Introduction to Data Analytics & Excel Foundations Excel

Kick off your data journey by understanding what data analytics actually means in industry, and building a rock-solid foundation in Excel — the tool that almost every analyst uses daily.

What is Data Analytics? Types & roles in industry
The data analysis lifecycle (collect → clean → analyze → visualize → communicate)
Excel interface, ribbons, shortcuts & navigation mastery
Data types, formatting, and structuring raw data correctly
Core formulas: SUM, AVERAGE, COUNT, COUNTA, IF, IFS
Text functions: CONCATENATE, LEFT, RIGHT, MID, TRIM, LEN
Lookup functions: VLOOKUP, HLOOKUP, INDEX/MATCH
Logical operators: AND, OR, NOT with nested IFs
Conditional formatting for data highlighting
Introduction to data tables and named ranges
Week 2 Advanced Excel & Google Sheets — Dashboards & Automation Excel · Google Sheets

Go beyond formulas — learn how to clean messy data, build pivot tables, create interactive dashboards, and leverage Google Sheets for collaborative cloud-based analysis.

Data cleaning: removing duplicates, handling blanks, text-to-columns
PivotTables: creating, filtering, grouping & slicing data
PivotCharts and chart types (bar, line, scatter, pie)
Building interactive Excel dashboards with slicers & timelines
XLOOKUP, FILTER, SORT, UNIQUE (modern Excel functions)
Google Sheets: IMPORTRANGE, QUERY, ARRAYFORMULA
Google Sheets: collaborative features, sharing & protecting ranges
Data validation, drop-down lists & form controls
Introduction to Macros for task automation
Mini-project: Sales performance dashboard in Excel
Week 3 SQL Fundamentals — Querying Relational Databases SQL

Enter the world of databases. Learn how companies store and manage data, and master SQL — the universal language every data analyst must speak fluently.

What is a relational database? Tables, rows, columns & relationships
SQL syntax: SELECT, FROM, WHERE, ORDER BY, LIMIT
Filtering: comparison operators, IN, BETWEEN, LIKE, IS NULL
Aggregate functions: COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING clauses
DISTINCT, aliases (AS) and calculated columns
JOINS: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
Subqueries and nested SELECT statements
String & date functions in SQL
Hands-on practice with real datasets using SQL sandbox tools
Week 4 Advanced SQL & Google BigQuery — Cloud-Scale Data SQL · BigQuery

Take SQL to the cloud. BigQuery is Google's enterprise data warehouse used by global companies. Learn to query millions of rows in seconds and tackle advanced SQL patterns.

Introduction to Google BigQuery — workspace setup & UI tour
BigQuery vs standard SQL: syntax differences & best practices
Window functions: ROW_NUMBER, RANK, DENSE_RANK
OVER(), PARTITION BY & ORDER BY in window functions
CTEs (Common Table Expressions) with WITH clause
CASE WHEN statements for conditional logic
Querying public datasets in BigQuery
Optimizing queries: partitioning, clustering & cost management
Exporting BigQuery results to Sheets & visualization tools
SQL-based mini-project: Analyzing e-commerce transaction data
Week 5 Data Visualization with Tableau Public — Telling Stories with Data Tableau Public

Learn the art and science of data visualization using Tableau Public. Transform raw numbers into compelling visual stories that decision-makers instantly understand.

Tableau Public interface: sheets, dashboards & stories
Connecting data sources: Excel, CSV, Google Sheets
Dimensions vs measures; continuous vs discrete fields
Chart types: bar, line, area, scatter, map, treemap, heatmap
Filters, quick filters, context filters & filter order
Calculated fields and level-of-detail (LOD) expressions
Parameters & sets for dynamic dashboards
Designing interactive dashboards with actions & tooltips
Geographic maps: plotting data by region, city, country
Publishing dashboards to Tableau Public for portfolio
Week 6 Power BI — Business Intelligence & Enterprise Dashboards Power BI

Power BI is the leading BI tool in corporate environments. Learn to build enterprise-grade dashboards, write DAX formulas, and create reports that drive business decisions.

Power BI Desktop vs Power BI Service — setup & workspace
Power Query: importing, transforming & cleaning data (ETL)
Data modeling: star schema, relationships & cardinality
DAX fundamentals: CALCULATE, FILTER, ALL, RELATED
DAX time intelligence: TOTALYTD, SAMEPERIODLASTYEAR
Building KPI cards, slicers & cross-filtering visuals
Row-level security (RLS) for data access control
Designing mobile-responsive Power BI reports
Comparing Tableau vs Power BI — when to use which
Mini-project: HR analytics dashboard in Power BI
Week 7 Python for Data Analysis — Foundations & Pandas Python

Python is the most powerful tool in a data analyst's toolkit. Start from the ground up — learn the language, then master Pandas, the library that makes data wrangling effortless.

Python basics: variables, data types, lists, dicts, loops & functions
Setting up Jupyter Notebook / Google Colab environment
Introduction to NumPy: arrays, indexing & vectorized operations
Pandas: Series & DataFrame fundamentals
Reading data: pd.read_csv(), read_excel(), read_json()
Exploring data: .head(), .info(), .describe(), .value_counts()
Selecting, filtering & slicing with .loc[] and .iloc[]
Handling missing values: dropna(), fillna(), isnull()
Groupby, aggregation & pivot_table in Pandas
Merging & joining DataFrames: merge(), concat(), join()
Week 8 Python Data Visualization & Exploratory Data Analysis (EDA) Python · Matplotlib · Seaborn

Data without visualization is incomplete. Learn to create publication-quality charts in Python and conduct full exploratory data analysis — a core skill in every data analyst job description.

Matplotlib: figures, axes, subplots & chart customization
Seaborn: statistical charts — boxplot, violin, heatmap, pairplot
Plotly: building interactive charts in Python
Full EDA workflow: understanding distributions, outliers & correlations
Univariate, bivariate & multivariate analysis techniques
Correlation matrices and heatmaps for feature relationships
Handling datetime data: parsing dates, resampling & time series plots
Automating repetitive data tasks with Python scripts
Documenting analysis in Jupyter Notebook with Markdown
Exporting Python outputs to Excel, CSV & PDF reports
Week 9 Capstone Project 1 — End-to-End Real-World Data Analysis All Tools · Project Week

Apply everything from Weeks 1–8 on a real-world dataset. You'll work through the full analytics pipeline — from raw data to a polished, presentable dashboard — exactly as you would in a professional setting.

Project brief & dataset distribution (industry-sourced data)
Data collection, understanding & problem framing
Data cleaning & wrangling using Excel or Python
SQL querying to extract meaningful subsets of data
Exploratory data analysis with Python (EDA)
Building the final dashboard in Tableau or Power BI
Writing an insights report with business recommendations
Peer review and instructor feedback sessions
Preparing the project for portfolio (GitHub, Tableau Public)
Live presentation of findings to the cohort & tutors
Week 10 Capstone Project 2 & Career Readiness — Graduate Ready All Tools · Career Week

Your second project is a step up — a more complex, industry-specific challenge. Alongside the project, you'll spend time polishing your portfolio and preparing for the job market.

Advanced capstone project: complex multi-source dataset challenge
Cross-tool workflow: SQL → Python → Tableau/Power BI pipeline
Advanced dashboard design: storytelling & executive presentations
Building and publishing your data portfolio online
Writing a standout data analyst CV & LinkedIn profile
How to ace a data analyst technical interview
Understanding data analyst job roles & salary benchmarks in Nigeria & globally
Freelancing as a data analyst — finding clients & pricing your work
Certificate of completion & cohort graduation ceremony
Introduction to alumni network & continuous learning resources

Real-World Capstone Projects Included in Every Cohort

Not toy datasets — actual data challenges that replicate what analysts face in industry. You present, document, and publish both projects to your portfolio before graduation day.

Enroll & Start Building →
Course Investment

Flexible Learning, One Standard

Choose the format that works best for you — same world-class curriculum, same industry tutors, same certification of completion.

Learning Mode
Online Learning
150,000
Per cohort · 10 weeks

Full access to live virtual classes, recorded sessions, and all course materials — learn from anywhere in Nigeria or globally.

  • Live virtual instructor-led classes
  • Recorded session replays (lifetime access)
  • 2 real-world capstone projects
  • Industry-professional tutors
  • All course materials & resources
  • Certificate of completion
  • Portfolio review & feedback
  • Alumni network access
Enroll Online →
Most Immersive
Learning Mode
Physical (In-Class)
300,000
Per cohort · 10 weeks

Face-to-face learning at our Lagos campuses with direct tutor access, peer collaboration, and a fully immersive lab environment.

  • In-person classes at Lagos campuses
  • Direct tutor mentorship & support
  • 2 real-world capstone projects
  • Hands-on computer lab access
  • Peer networking & study groups
  • Certificate of completion
  • Portfolio review & industry referrals
  • Priority job placement support
Enroll In-Person →
Our Instructors

Data Analytics Expert Team

Our tutors are active industry professionals — not just academics. They bring real work experience, real-world tools, and insider knowledge directly into the classroom.

DA
Lead Data Analyst
Excel · SQL · BigQuery
6+ years industry experience
BI
BI & Viz Specialist
Tableau · Power BI
5+ years data visualization
DE
Cloud Data Engineer
BigQuery · SQL · ETL
7+ years cloud engineering
PY
Python Data Scientist
Python · Pandas · ML
8+ years data science
Find Us

Three Lagos Locations

Study at the campus closest to you, or join us online. Our physical campuses are equipped and ready for the next cohort.

🏢
Corporate Office

27 Banana Island Road,
Ikoyi, Lagos.

Get Directions →
🏫
Mainland Campus

Horizon Hub,
49 Chivita Avenue,
Ajao Estate, Lagos.

Get Directions →
🏛️
Ikoyi Campus

6b Mobolaji Johnson Avenue,
Ikoyi, Lagos.

Get Directions →
Ready to Start?

Your Data Career
Starts Right Here

Have questions about the course, schedule, or payment? Tap enroll to complete your registration, or chat with our team on WhatsApp — we'll guide you to the right path.