Certification Course
Advanced track with Excel, Power BI, SQL, and Python. Sharpen analytical and coding skills while building a career-ready project portfolio.
BETA-DATA PROGRAM
₦80k
FEATURES:
Advanced Excel
Advanced PowerBI
SQL
Python
Project Portfolio
Unlimited Interview Preparation Sessions
CV & LinkedIn Revamp
An advanced program crafted for aspiring data professionals aiming to sharpen both analytical and programming skills. With a curriculum spanning Advanced Excel, Advanced Power BI, SQL, and Python, learners will also develop a project portfolio that showcases their expertise for career-ready opportunities in data analytics.
Learning Schema
Week 1: Excel Basics & Referencing (Case Study-Based)
Session 1
- Introduction to Excel: Interface, workbook vs. worksheet
- Understanding rows, columns, cells, and ranges
- Formatting basics: numbers, text, dates, and conditional formatting
Session 2
- Cell referencing: Relative, Absolute, and Mixed
- Basic functions: SUM, AVERAGE, MIN, MAX, IF
- Case Study Exercise: Simple budget tracker or attendance sheet
Week 2: Intermediate Excel – Tables to Dashboards
Session 1
- Excel Tables & Structured Referencing
- Lookup functions: VLOOKUP, XLOOKUP (optional), INDEX MATCH
- Data cleaning basics: Remove duplicates, trim, split text, etc
Session 2
- Pivot Tables & Pivot Charts
- Building Excel Dashboards
- Case Study Exercise: Sales dashboard or employee performance report
Week 3: Power BI Essentials
Session 1
- Introduction to Power BI Interface
- Connecting to data sources (Excel, CSV)
- Data cleaning using Power Query Editor
Week 4: Modelling & Dashboarding
Session 1
- Creating calculated columns and measures (DAX intro)
- Filtering and slicers
- Card and KPI visuals
Week 5: SQL Fundamentals
Session 1
- Introduction to SQL & DBMS
- Data types, tables, and schemas
- Writing basic queries: SELECT, WHERE, ORDER BY
Session 2
- Filtering with AND, OR, IN, BETWEEN, LIKE
- Sorting & limiting results
- Case Study Exercise: Querying a sales database
Week 6: Joins, Aggregates & Subqueries
Session 2
- Joins: INNER, LEFT, RIGHT, FULL
- Subqueries and nested queries
- Case Study: Customer order analysis
Week 7: Python Basics
Session 1
- Introduction to Python & Jupyter Notebooks
- Data types, variables, and operations
- Control flow: if-else, loops
Session 2
- Functions, lists, dictionaries
- Basic file handling (CSV reading)
- Hands-on: Student performance dataset (basic stats)
Week 8: Data Manipulation with Pandas
Session 1
- Introduction to Pandas: Series and DataFrames
- Reading CSVs and inspecting datasets
- Filtering, sorting, and cleaning data
Session 2
- Grouping, merging, and reshaping data
- Handling missing values
- Case Study: Sales analysis with Pandas
Week 9: Visualisation & Project
Session 1
- Data visualisation with matplotlib and seaborn
- Plot types: bar, line, scatter, histogram
- Styling plots
