Data Analytics Bootcamp: What You'll Learn in 16 Weeks

By Tech Faculty · Mar 1, 2026

Data Analytics is one of the most in-demand skills globally, and Nigeria is no exception. Here's exactly what you'll learn in Tech Faculty's 16-week Data Analytics Bootcamp.

Weeks 1-4: Foundations

Excel Mastery

• Advanced formulas (VLOOKUP, INDEX-MATCH, SUMIFS)
• Pivot tables and charts
• Data cleaning and validation
• Dashboard creation

Statistics Fundamentals

• Descriptive statistics
• Probability distributions
• Hypothesis testing
• Correlation and regression basics

Weeks 5-8: SQL & Databases

• Writing SQL queries (SELECT, JOIN, GROUP BY)
• Database design fundamentals
• Working with PostgreSQL
• Real-world data extraction projects

Weeks 9-12: Python for Data Analysis

• Python basics and data types
• Pandas for data manipulation
• NumPy for numerical computing
• Matplotlib and Seaborn for visualization
• Working with APIs and web scraping

Weeks 13-16: Business Intelligence & Capstone

Power BI / Tableau

• Building interactive dashboards
• Data modeling and DAX formulas
• Connecting to multiple data sources
• Publishing and sharing reports

Capstone Project

• Analyze a real Nigerian business dataset
• Present findings to a panel of industry professionals
• Build a portfolio-ready case study

Career Outcomes

Our Data Analytics graduates have gone on to:

• Junior Data Analyst roles at banks and fintechs
• Business Intelligence positions at FMCG companies
• Freelance data consulting
• Starting their own analytics firms

Ready to become a data analyst? Enroll in Tech Faculty's next cohort today.