Certification Course
The Alpha-Data Program
The Alpha-Data Program
The Alpha-Data Program
Beginner to intermediate track covering Advanced Excel, Power BI, and SQL. Build strong foundations through hands-on projects and real-world insights.
ALPHA-DATA PROGRAM
₦50k
FEATURES:
Advanced Excel
Advanced PowerBI
SQL
Project Portfolio
5 Interview Preparation Sessions
ALPHA-DATA PROGRAM
₦50k
FEATURES:
Advanced Excel
Advanced PowerBI
SQL
Project Portfolio
5 Interview Preparation Sessions
ALPHA-DATA PROGRAM
₦50k
FEATURES:
Advanced Excel
Advanced PowerBI
SQL
Project Portfolio
5 Interview Preparation Sessions
Course Description
Course Description
Course Description
A beginner-to-intermediate program designed to build strong technical foundations in data analysis. Covering Advanced Excel, Advanced Power BI, and SQL, this track emphasizes practical learning through a personal project portfolio, helping participants translate theory into real-world insights.
A beginner-to-intermediate program designed to build strong technical foundations in data analysis. Covering Advanced Excel, Advanced Power BI, and SQL, this track emphasizes practical learning through a personal project portfolio, helping participants translate theory into real-world insights.
A beginner-to-intermediate program designed to build strong technical foundations in data analysis. Covering Advanced Excel, Advanced Power BI, and SQL, this track emphasizes practical learning through a personal project portfolio, helping participants translate theory into real-world insights.
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
© 2025. AnalystXcelerate, NG. All rights reserved.
© 2025. AnalystXcelerate, NG. All rights reserved.
© 2024. AnalystXcelerate, NG.
All rights reserved.