Schedule: Saturdays, and Sundays
Duration: 5 Weeks (Learning + Final Project + Presentation)
Tools Covered: Excel, Power Query, Power BI, SQL, Python
Learning Approach Final Project Objective:
Overview of foundational data analysis tool Clean, analyse, and visualise a real-world dataset
Practical exercises and assignment Create an interactive Power BI dashboard
Mini project and capstone dashboar Use SQL to extract insights
Career insights and portfolio development
Apply basic Python data exploration (optional)
Certification: Embold Lab Data Analysis Foundations Certificate
Program Payment Benefits
Final Deliverables for Certificatio
Before the close of the bootcamp you will be required to pay the sum of N5,000 to access the following program benefits Submission of all Mini-Projects and Assignment
Certificate issued Successful completion and presentation of Capstone Projec
Portfolio Projec
Access to the A-Z freelancing masters class and how to get your first paying client
Payment of certificat
Access to our Alumni community Tech Challeng
Access to the 21-day Tech challenge Instructor/mentors final feedback and review
Access to continuous mentorship
Eligible for master class and accelerator, price slashed
Week 1: Excel for Data Management & Basic Statistics
Day Topics Sub-Topics
What is Data Analysi
Overview of Excel interface and tool
Saturday Excel Basics and Data Management
Data entry, formatting, and basic calculation
Data management techniques: sorting, filtering, and validation
Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATC
Logical functions: IF, AND, O
Sunday Advanced Excel Functions
Introduction to PivotTables (practical
Practical Assignments: Data cleaning and transformation in Excel; practice PivotTables.
Week 2: Visualization & Power Tools in Excel/Power BI
Day Topics Sub-Topics
Creating and customizing charts (bar, line, pie
Saturday Data Visualization in Excel & Statistics Descriptive statistics: mean, median, mode, variance, standard deviatio
Introduction to probability and data distribution
Overview of Power Query interfac
Importing data from multiple source
Sunday Power Query Basics
Data cleaning techniques (practical)
Mini Project: Use Excel + Power Query to clean and visualize a dataset.
Week 3: Power BI, SQL, and Python Introduction
Day Topics Sub-Topics
Overview of Power BI interface and tool
Connecting to data sources and creating visualization
Saturday Power BI & Dashboard Design
Data modeling and DAX (calculated columns, measures
Interactive dashboards: slicers, bookmarks, drill-through
Introduction to SQL & relational database
Writing SQL queries: SELECT, WHERE, ORDER BY, GROUP BY, JOINS, subqueries, aggregatio
Overview of Python and its role in data analysi
Sunday SQL Basics & Python Overview
Practical Assignment: SQL query practice + install Python and explore data analysis libraries (pandas, matplotlib).
Final Project Release
Week 4: Capstone Project Development
Day Topics Sub-Topics
Activity: Students work collaboratively in small teams to complete
Saturday
their Capstone Project.
Resume & Portfolio Building for Data Analytics Role
Advanced Data Analytics tool
Advanced Crash Course: Scaling from beginner to pro - How to Build
Sunday Students receive mentorship check-ins during this week.
a Data Analytics Career Roadmap
Students receive mentorship check-ins and review sessions during the week.
Week 5: Teams Project Demo Day
Day
Sunday Final Project Demo Day
