Certification Course

The Beta-Data Program

The Beta-Data Program

Advanced track with Excel, Power BI, SQL, and Python. Sharpen analytical and coding skills while building a career-ready project portfolio.

Enroll Now

Enroll Now

Enroll Now

BETA-DATA PROGRAM

₦80k

Enroll

Get started

FEATURES:

  • Advanced Excel

  • Advanced PowerBI

  • SQL

  • Python

  • Project Portfolio

  • Unlimited Interview Preparation Sessions

  • CV & LinkedIn Revamp

BETA-DATA PROGRAM

₦80k

Enroll

Get started

FEATURES:

  • Advanced Excel

  • Advanced PowerBI

  • SQL

  • Python

  • Project Portfolio

  • Unlimited Interview Preparation Sessions

  • CV & LinkedIn Revamp

BETA-DATA PROGRAM

₦80k

Enroll

Get started

FEATURES:

  • Advanced Excel

  • Advanced PowerBI

  • SQL

  • Python

  • Project Portfolio

  • Unlimited Interview Preparation Sessions

  • CV & LinkedIn Revamp

Course Description

Course Description

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)
Week 1: Excel Basics & Referencing (Case Study-Based)
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 1

- Introduction to Excel: Interface, workbook vs. worksheet

- Understanding rows, columns, cells, and ranges

- Formatting basics: numbers, text, dates, and conditional formatting

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

Session 2

- Cell referencing: Relative, Absolute, and Mixed

- Basic functions: SUM, AVERAGE, MIN, MAX, IF

- Case Study Exercise: Simple budget tracker or attendance sheet

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
Week 2: Intermediate Excel – Tables to Dashboards
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 1

- Excel Tables & Structured Referencing

- Lookup functions: VLOOKUP, XLOOKUP (optional), INDEX MATCH

- Data cleaning basics: Remove duplicates, trim, split text, etc

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

Session 2

- Pivot Tables & Pivot Charts

- Building Excel Dashboards

- Case Study Exercise: Sales dashboard or employee performance report

Session 2

- Pivot Tables & Pivot Charts

- Building Excel Dashboards

- Case Study Exercise: Sales dashboard or employee performance report

Week 3: Power BI Essentials
Week 3: Power BI Essentials
Week 3: Power BI Essentials
Session 1

- Introduction to Power BI Interface

- Connecting to data sources (Excel, CSV)

- Data cleaning using Power Query Editor

Session 1

- Introduction to Power BI Interface

- Connecting to data sources (Excel, CSV)

- Data cleaning using Power Query Editor

Session 1

- Introduction to Power BI Interface

- Connecting to data sources (Excel, CSV)

- Data cleaning using Power Query Editor

Session 2

- Dimensions vs. Measures

- Understanding relationships: Primary & Foreign Keys

- Simple visuals (bar, pie, line charts)

Session 2

- Dimensions vs. Measures

- Understanding relationships: Primary & Foreign Keys

- Simple visuals (bar, pie, line charts)

Session 2

- Dimensions vs. Measures

- Understanding relationships: Primary & Foreign Keys

- Simple visuals (bar, pie, line charts)

Week 4: Modelling & Dashboarding
Week 4: Modelling & Dashboarding
Week 4: Modelling & Dashboarding
Session 1

- Creating calculated columns and measures (DAX intro)

- Filtering and slicers

- Card and KPI visuals

Session 1

- Creating calculated columns and measures (DAX intro)

- Filtering and slicers

- Card and KPI visuals

Session 1

- Creating calculated columns and measures (DAX intro)

- Filtering and slicers

- Card and KPI visuals

Session 2

- Designing dashboards

- Case Study Exercise: Sales or product dashboard with drill-through

- Publishing & sharing reports

Session 2

- Designing dashboards

- Case Study Exercise: Sales or product dashboard with drill-through

- Publishing & sharing reports

Session 2

- Designing dashboards

- Case Study Exercise: Sales or product dashboard with drill-through

- Publishing & sharing reports

Week 5: SQL Fundamentals
Week 5: SQL Fundamentals
Week 5: SQL Fundamentals
Session 1

- Introduction to SQL & DBMS

- Data types, tables, and schemas

- Writing basic queries: SELECT, WHERE, ORDER BY

Session 1

- Introduction to SQL & DBMS

- Data types, tables, and schemas

- Writing basic queries: SELECT, WHERE, ORDER BY

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

Session 2

- Filtering with AND, OR, IN, BETWEEN, LIKE

- Sorting & limiting results

- Case Study Exercise: Querying a sales database

Session 2

- Filtering with AND, OR, IN, BETWEEN, LIKE

- Sorting & limiting results

- Case Study Exercise: Querying a sales database

Week 6: Joins, Aggregates & Subqueries
Week 6: Joins, Aggregates & Subqueries
Week 6: Joins, Aggregates & Subqueries
Session 1

- Aggregate functions: COUNT, SUM, AVG, MAX, MIN

- Grouping with GROUP BY and filtering with HAVING

Session 1

- Aggregate functions: COUNT, SUM, AVG, MAX, MIN

- Grouping with GROUP BY and filtering with HAVING

Session 1

- Aggregate functions: COUNT, SUM, AVG, MAX, MIN

- Grouping with GROUP BY and filtering with HAVING

Session 2

- Joins: INNER, LEFT, RIGHT, FULL

- Subqueries and nested queries

- Case Study: Customer order analysis

Session 2

- Joins: INNER, LEFT, RIGHT, FULL

- Subqueries and nested queries

- Case Study: Customer order analysis

Session 2

- Joins: INNER, LEFT, RIGHT, FULL

- Subqueries and nested queries

- Case Study: Customer order analysis

Week 7: Python Basics
Week 7: Python Basics
Week 7: Python Basics
Session 1

- Introduction to Python & Jupyter Notebooks

- Data types, variables, and operations

- Control flow: if-else, loops

Session 1

- Introduction to Python & Jupyter Notebooks

- Data types, variables, and operations

- Control flow: if-else, loops

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)

Session 2

- Functions, lists, dictionaries

- Basic file handling (CSV reading)

- Hands-on: Student performance dataset (basic stats)

Session 2

- Functions, lists, dictionaries

- Basic file handling (CSV reading)

- Hands-on: Student performance dataset (basic stats)

Week 8: Data Manipulation with Pandas
Week 8: Data Manipulation with Pandas
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 1

- Introduction to Pandas: Series and DataFrames

- Reading CSVs and inspecting datasets

- Filtering, sorting, and cleaning data

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

Session 2

- Grouping, merging, and reshaping data

- Handling missing values

- Case Study: Sales analysis with Pandas

Session 2

- Grouping, merging, and reshaping data

- Handling missing values

- Case Study: Sales analysis with Pandas

Week 9: Visualisation & Project
Week 9: Visualisation & Project
Week 9: Visualisation & Project
Session 1

- Data visualisation with matplotlib and seaborn

- Plot types: bar, line, scatter, histogram

- Styling plots

Session 1

- Data visualisation with matplotlib and seaborn

- Plot types: bar, line, scatter, histogram

- Styling plots

Session 1

- Data visualisation with matplotlib and seaborn

- Plot types: bar, line, scatter, histogram

- Styling plots

Session 2

- Mini Project: EDA on provided dataset (students or sales)

- Summary report and presentation prep

Session 2

- Mini Project: EDA on provided dataset (students or sales)

- Summary report and presentation prep

Session 2

- Mini Project: EDA on provided dataset (students or sales)

- Summary report and presentation prep

Your pathway to a successful data analysis career starts here.

EMAIL

mailto:admin@analystxcelerate.com

MOBILE

+234 703 077 7275

Alpha-Data Program

Beta-Data Program

AI-Data Program

© 2025. AnalystXcelerate, NG. All rights reserved.

Your pathway to a successful data analysis career starts here.

EMAIL

mailto:admin@analystxcelerate.com

MOBILE

+234 703 077 7275

Alpha-Data Program

Beta-Data Program

AI-Data Program

© 2025. AnalystXcelerate, NG. All rights reserved.

Your pathway to a successful data analysis career starts here.

EMAIL

mailto:admin@analystxcelerate.com

MOBILE

+234 703 077 7275

Alpha-Data Program

Beta-Data Program

AI-Data Program

© 2024. AnalystXcelerate, NG.

All rights reserved.