Data Analytics Group Class

Three-Month Data Analytics Program

Learn Excel, SQL and Power BI from the fundamentals, complete three full analysis projects, and finish with a professional portfolio you can show employers and clients.

Enroll Now: ₦120,000 View Curriculum FAQs

Starts: Tuesday, 3 November 2026
Duration: 3 months of instruction + project and career weeks
Delivery: Fully online
Fee: ₦120,000

Course overview

Not just tools: the way an analyst thinks

The goal is not simply to teach you software. It is to make you an analyst who can take a raw dataset, ask the right question, clean and analyse the data, and present recommendations a business can act on.

Designed for beginners and aspiring data analysts. You will build practical skills in Excel, SQL and Power BI through hands-on projects, and develop the analytical thinking and portfolio that show you can do the work.

How the programme is structured

Three months of core instruction, with one month dedicated to each tool: Excel, then SQL, then Power BI.
Two classes per week during instruction weeks, giving eight classes per month.
Additional weeks for projects, presentation and career preparation. These fall outside the three months of instruction and are included at no extra cost.
Every module ends with full data analysis classes that work through a complete project from start to finish, followed by a project you complete on your own.

Schedule

Two live classes a week during instruction weeks. Proposed: Tuesdays and Thursdays, 7:00 PM to 9:00 PM WAT (UTC+1). To be confirmed.

Tools you will use

Microsoft Excel
Spreadsheet analysis, reporting and dashboards.
Microsoft SQL Server
Querying databases, with SQL Server Management Studio.
Microsoft Power BI Desktop
Data modeling, visualisation and business intelligence.

Curriculum

What you will learn, week by week

Four stages, from your first spreadsheet to a published portfolio. Open the full curriculum to see every class, exactly as in the official programme document.

01Month OneMicrosoft Excel8 classes · independent project · presentation
02Month TwoMicrosoft SQL8 classes · independent project
03Month ThreeMicrosoft Power BI8 classes · independent project
04Final WeekAI and Portfolio2 classes

Download PDF

Welcome to the Program

Welcome to the Data Immersed Data Analytics Program. Over the coming months you will move from complete fundamentals to building and presenting full analytics projects, using the same three tools that employers ask for most often: Microsoft Excel, Microsoft SQL Server, and Microsoft Power BI.

This is your official curriculum. It shows exactly what will be taught, in what order, and what is expected of you at each stage. Please read it fully before the first class and keep it for reference throughout the program.

Our goal is not simply to teach you tools. It is to make you an analyst who can take a raw dataset, ask the right question, clean and analyse the data, and present recommendations that a business can act on.

How the Program Works

Structure

Three months of core instruction, with one month dedicated to each tool: Excel, then SQL, then Power BI.
Two classes per week during instruction weeks, giving eight classes per month.
Additional weeks for projects, presentation and career preparation. These fall outside the three months of instruction and are included at no extra cost.
Every module ends with full data analysis classes that work through a complete project from start to finish, followed by a project you complete on your own.

The Data Analysis Framework

In every module, the final classes follow the same six stage framework. By the end of the program you will have applied it three times, once in each tool.

1Ask: Understand the business problem and define the question you are answering.
2Prepare: Identify, collect and assess the data you need.
3Process: Clean the data and make it reliable enough to analyse.
4Analyze: Explore the data, find patterns, and answer the question.
5Share: Visualise the findings and communicate them clearly.
6Act: Deliver conclusions and practical recommendations to stakeholders.

Tools You Will Use

Microsoft Excel: Spreadsheet analysis, reporting and dashboards.
Microsoft SQL Server: Querying databases, with SQL Server Management Studio.
Microsoft Power BI Desktop: Data modeling, visualisation and business intelligence.

What Is Expected of You

Attend both classes each week and complete the practice work given after each class.
Submit each module project on time. The projects are what build your portfolio.
Have a working laptop with a stable internet connection. Installation is guided in class where required.
Ask questions. Support is available between classes, and no question is too basic.

Month One: Microsoft Excel

Building your analytical foundation. You will learn how to work confidently in Excel, clean and summarise data, and complete your first end to end analysis project.

Week 1 · Day 1
Introduction to Data Analytics and Introduction to Excel
What data analytics is, the role of a data analyst, career paths in the field, and a full tour of the Excel workspace: workbooks, worksheets, cells, ranges, and data entry.
Week 1 · Day 2
Basic Excel Functions
Core functions including SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, and ROUND.
Week 2 · Day 1
Logical Functions and Conditional Formatting
IF, nested IF, AND, OR, IFERROR plus conditional formatting to highlight patterns, duplicates, and outliers.
Week 2 · Day 2
Text Functions and Data Cleaning
Cleaning and reshaping text with LEFT, RIGHT, MID, LEN, TRIM, CONCAT, TEXT and Text to Columns, then joining datasets.
Week 3 · Day 1
Pivot Tables and Pivot Charts
Building pivot tables, grouping and filtering, slicers, calculated fields, and turning summaries into pivot charts and simple dashboards.
Week 3 · Day 2
Full Data Analysis Project Class 1
Ask and Prepare. Defining the business question, understanding stakeholders, identifying the data required, and assessing data quality and structure.
Week 4 · Day 1
Full Data Analysis Project Class 2
Process and Analyze. Cleaning the dataset, handling blanks, duplicates and inconsistencies, then analysing to answer the business question.
Week 4 · Day 2
Full Data Analysis Project Class 3
Share and Act. Visualising results, building the dashboard, writing insights, and presenting clear recommendations to a stakeholder.
Week 5 · Project
Excel Project WeekIndependent project
No new lessons this week. You will receive an Excel project brief and dataset and work independently, with support available throughout the week.
Week 6 · Review
Project Presentation WeekPresentation
Each student presents their Excel project, walks through their analysis and recommendations, and receives feedback from the instructor and peers.

Month Two: Microsoft SQL

Working with databases. You will learn to write queries that pull, combine and summarise data directly from a relational database, which is where most business data actually lives.

Week 1 · Day 1
Introduction to SQL and Installation
Why analysts use SQL, how relational databases are organised, and full installation and setup of Microsoft SQL Server and SQL Server Management Studio.
Week 1 · Day 2
Data Types, DDL and DML
SQL data types, then Data Definition Language (CREATE, ALTER, DROP) and Data Manipulation Language (INSERT, UPDATE, DELETE) for building and maintaining tables.
Week 2 · Day 1
Basic SQL Syntax
Writing queries with SELECT, WHERE, ORDER BY, DISTINCT, TOP, LIKE, IN, BETWEEN, and logical operators to filter and sort data accurately.
Week 2 · Day 2
Aggregate Functions and CASE Statements
SUM, COUNT, AVG, MIN and MAX with GROUP BY and HAVING, plus CASE statements for conditional logic and categorisation inside queries.
Week 3 · Day 1
Joins
Combining data across multiple tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and self joins, and knowing which join answers which question.
Week 3 · Day 2
Subqueries
Writing subqueries in SELECT, FROM and WHERE clauses, nested queries, and an introduction to common table expressions for cleaner, more readable SQL.
Week 4 · Day 1
Full Data Analysis Project Class 1
Ask, Prepare and Process using SQL. Framing the business question, exploring the database, and cleaning and preparing the data with queries.
Week 4 · Day 2
Full Data Analysis Project Class 2
Analyze and Share using SQL. Writing the analysis queries, interpreting the output, documenting findings, and presenting recommendations.
Week 5 · Project
SQL Project WeekIndependent project
No new lessons and no presentation this month. You will receive a SQL project brief and database and submit your queries and written findings at the end of the week.

Month Three: Microsoft Power BI

Business intelligence and storytelling. You will learn to model data, write DAX measures, and build interactive dashboards that stakeholders can use to make decisions.

Week 1 · Day 1
Introduction to Power BI, Connecting and Loading Data
The Power BI ecosystem and interface, installing Power BI Desktop, and connecting to and loading data from Excel, CSV files, and SQL Server.
Week 1 · Day 2
Data Cleaning and Transformation
Using Power Query Editor to remove duplicates, handle nulls, split and merge columns, change data types, unpivot data, and append and merge queries.
Week 2 · Day 1
Data Modeling and Relationships
Building a clean data model: fact and dimension tables, star schema, cardinality, filter direction, and creating and managing table relationships.
Week 2 · Day 2
Basic Visualization
Choosing the right chart for the question, building bar, column, line, pie and card visuals, and using slicers, filters, and drill down.
Week 3 · Day 1
Measures and DAX
Calculated columns versus measures, DAX syntax, and key functions including SUM, CALCULATE, FILTER, DIVIDE, time intelligence, and quick measures.
Week 3 · Day 2
Advanced Visualization Techniques
Dashboard design principles, bookmarks, tooltips, conditional formatting, custom visuals, page navigation, and applying a consistent theme and layout.
Week 4 · Day 1
Full Data Analysis Project Class 1
Ask, Prepare and Process in Power BI. Defining the question, loading and cleaning the dataset, and building the model that supports the analysis.
Week 4 · Day 2
Full Data Analysis Project Class 2
Analyze and Share in Power BI. Building the report, writing the measures, designing the final dashboard, and delivering insights and recommendations.
Week 5 · Project
Power BI Project WeekIndependent project
No new lessons this week. You will receive a Power BI project brief and dataset and build a complete, presentation ready dashboard.

Final Week: AI and Portfolio

This week sits outside the three months of instruction. It is where everything you have built becomes something you can show to an employer or client.

Final Week · Day 1
AI for Data Analysis
Using AI tools responsibly in a real analyst workflow: prompting for analysis, writing and debugging formulas and SQL, cleaning and documenting data, and interpreting results faster without losing accuracy.
Final Week · Day 2
Portfolio Creation
Turning your three class projects into a professional portfolio: structuring case studies, writing project documentation, publishing your work, and positioning your portfolio for job applications.

What You Will Have at the End

Working proficiency in Excel, SQL and Power BI, taught in the order analysts actually use them.
Three complete data analysis projects, one in each tool, done from question to recommendation.
Experience presenting your analysis and defending your findings.
A practical understanding of how to use AI tools inside a real analyst workflow.
A professional portfolio ready to share with employers, clients and your network.

Certification

Completing the classes is not the same as completing the program. A certificate of completion is issued only to students who meet both requirements below by the end of the class.

1Submit all three module projects: the Excel project, the SQL project, and the Power BI project. Each must be a complete piece of work, from the business question through to your recommendations.
2Publish a portfolio website that hosts all three projects as documented case studies.

We hold this standard deliberately. A certificate on its own carries very little weight with employers. A certificate backed by three finished projects and a live portfolio is evidence that you can do the work, and that is what gets you hired. If you fall behind on a project, tell us early so we can help you catch up rather than leaving it until the final week.

Class Schedule and Communication

Class days, times and the meeting link will be shared with you separately and pinned in the class group. Recordings, datasets, practice files and project briefs will be shared in the same place after each class.

If you will miss a class, please make sure you get the recording from the class and the practice work.

We are glad to have you here. Come ready to work, and by the end of this program you will not just know these tools, you will have proof that you can use them.

Download PDF

The data analysis framework

Six stages, applied three times

In every module, the final classes follow the same six-stage framework. By the end of the programme you will have applied it once in each tool.

1Ask
Understand the business problem and define the question you are answering.
2Prepare
Identify, collect and assess the data you need.
3Process
Clean the data and make it reliable enough to analyse.
4Analyze
Explore the data, find patterns, and answer the question.
5Share
Visualise the findings and communicate them clearly.
6Act
Deliver conclusions and practical recommendations to stakeholders.

Earning your certificate

Completing the classes is not the same as completing the programme. A certificate of completion is issued only to students who meet both requirements by the end of the class.

1Submit all three module projects: the Excel project, the SQL project, and the Power BI project. Each must be a complete piece of work, from the business question through to your recommendations.
2Publish a portfolio website that hosts all three projects as documented case studies.

A certificate backed by three finished projects and a live portfolio is evidence that you can do the work. If you fall behind on a project, tell us early so we can help you catch up.

Student feedback

In their own words

What past TDI students said about learning with us.

“I've learned how to be more systematic. Ann's step-by-step approach and thorough thinking really shaped how I now tackle problems. Her conversations and interactions are top notch, and she's a true goal getter.”

Louis Wemudoi

TDI Masterclass graduate

“The teaching process has been very satisfactory. Every detail is explained in the simplest way possible, making it the most simplified class I've had. Learning from such a thorough and understanding teacher has been a joy.”

God'swill Ajimi

TDI Masterclass graduate

“I loved that everyone is given room to participate and feel comfortable in the learning process. I've greatly improved in my analysis because no one shames you for not knowing or learning at your own pace. Participation is encouraged, which makes learning faster.”

Lydia Zamani

TDI Masterclass graduate

Daberechi Annie Nnamani, founder of The Data Immersed

Founder, The Data Immersed · Lead Tutor and Instructor

Learn with Annie

Annie founded The Data Immersed and leads its Data Analytics Program. A data analyst, consultant and AI engineer, she teaches Excel, SQL, Power BI and AI for data analysis, and guides students from their first spreadsheet to a published portfolio.

More about Annie Instagram X LinkedIn Medium Portfolio

FAQ

Frequently asked questions

About the Data Analytics Group Class.

Still unsure? Ask us directly.

Join the cohort starting Tuesday, 3 November 2026

₦120,000 for the full programme, paid securely on Nestuge.

Enroll Now: ₦120,000 Ask a question first

Three-Month Data Analytics Program

Not just tools: the way an analyst thinks

How the programme is structured

Tools you will use

What you will learn, week by week

Welcome to the Program

How the Program Works

Structure

The Data Analysis Framework

Tools You Will Use

What Is Expected of You

Month One: Microsoft Excel

Month Two: Microsoft SQL

Month Three: Microsoft Power BI

Final Week: AI and Portfolio

What You Will Have at the End

Certification

Class Schedule and Communication

Six stages, applied three times

Earning your certificate

In their own words

Learn with Annie

Frequently asked questions

Do I need any experience?

How long is the programme, exactly?

When are the classes?

What if I miss a class?

What do I need to take part?

How do I get the certificate?

How do I pay?

I'd prefer more personal attention. What are my options?

Join the cohort starting Tuesday, 3 November 2026