Data Analysis 2026 (Batch B)
- Curriculum
- Reviews
-
1
Class One Text (INTRODUCTION TO DATA ANALYSIS)Data: a representation of information or material recorded and known or assumed as facts and used as a basis of reasoning, discussion or calculation represented especially in the form of numbers
-
2
Excel Class One -
3
Class Two Text (Formulae and Functions)
Formula are users made (it is defined by a user’s without excel instructions) When a user uses any kind of logic to get an answer is called formula.
We clarified the difference between formulas and functions, highlighting how they're often used interchangeably in everyday usage.
-
4
Excel Class Two
-
5
Class Two Quiz -
6
Class Three Text (Using Lookups)
The term ‘Look up’ as used in the context, means to look up (search) from a list.
There are two main LOOKUP functions that can be used within Excel. These are:
HLOOKUP
VLOOKUP
XLOOKUP
-
7
Excel Class Three
-
8
Class Three Quiz
-
9
WEEK 1 ASSIGNMENT -
10
Excel Class One
-
11
Excel Class Two
-
12
Excel Class Three
-
13
Class Four Text (If Statement, Nested If and Functions for Data Cleaning)
An IF statement in Excel is a logical function that tests a condition and returns one value if true and another value if false.
-
14
Excel Class Four
-
15
Class Four Quiz
-
16
Class Five Text (Sort and Filters, Removing extra rows, Conditional formatting, removing duplicate)
Sorts: Arrange data in a specific order (ascending, descending, alphabetical, etc.) to organize and analyze it.
Filters: Show only specific data that meets certain conditions, hiding the rest. This helps focus on relevant information
-
17
Excel Class Five
-
18
Class Five Quiz
-
19
Class Six Text: (Data Cleaning in Power Query Editor)
Power Query Editor, also known as "Get & Transform" in some versions of Microsoft Excel, is a data analysis tool that allows users to efficiently import, transform, and combine data from various sources.
-
20
Excel Class Six
-
21
Class Six Quiz
-
22
WEEK 2 ASSIGNMENT
-
23
Excel Class Four_a
-
24
Excel Class Four_b
-
25
Excel Class Five_a
-
26
Excel Class Five_b
-
27
Excel Class Six_a
-
28
Excel Class Six_b
-
29
Class Seven Text: (-DATA MANIPULATION IN EXCEL)
Pivot tables are a powerful tool for data manipulation.
Data Manipulation with Pivot Tables:
1. Summarize large datasets: Pivot tables help you summarize large datasets by grouping and aggregating data.
2. Analyze data from different angles: Pivot tables enable you to rotate and pivot your data to analyze it from different perspectives.
3. Create custom calculations: Pivot tables allow you to create custom calculations, such as calculated fields and measures.
-
30
Excel Class Seven
-
31
Class Seven Quiz
-
32
Class Eight Text (Building Dashboard in Excel)
BUILDING OF DASHBOARD AND SLICERS
A dashboard is a visual representation of data that's designed to provide an at-a-glance overview of key metrics. A dashboard can include a variety of visualizations, like charts, tables, and graphs.
It's a great way to get a quick overview of your data and identify areas that need attention. Dashboards are often used in business intelligence and data analytics applications.
-
33
Excel Class Eight
-
34
Class Eight Quiz
-
35
Class Night Text (More on Data manipulation and Dashboard)
Metrics in a dashboard refer to the quantifiable measures used to track and analyze performance, progress, or trends. These metrics are often displayed in a visual format, such as charts, graphs, or tables, to provide insights and facilitate decision-making.
-
36
Excel Class Nine
-
37
Class Nine Quiz
-
38
WEEK 3 ASSIGNMENT
-
39
Excel Class Seven
-
40
Excel Class Eght
-
41
Excel Class Nine_a
-
42
Excel Class Nine_B
-
43
Class Ten Text (More on Data Manipulation and Dashboard)
A dashboard is a visual representation of data that's designed to provide an at-a-glance overview of key metrics. A dashboard can include a variety of visualizations, like charts, tables, and graphs.
-
44
Excel Class Ten
-
45
Class Ten Quiz
-
46
Class Eleven Text (Dashboard, Metric and Slicers)
Metrics in a dashboard refer to the quantifiable measures used to track and analyze performance, progress, or trends. These metrics are often displayed in a visual format, such as charts, graphs, or tables, to provide insights and facilitate decision-making
-
47
Excel Class Eleven
-
48
Class Eleven Quiz
-
49
Class Twelve Text(Correlation and Regression)
Calculating the correlation between two variables can tell you a lot about the relationship between those variables. If two variables have a strong positive correlation, it means that when one variable increases, the other variable tends to increase as well
-
50
Excel Class Twelve
-
51
Class Twelve Quiz
-
52
WEEK 4 ASSIGNMENT
-
53
Excel Class 10A
-
54
Excel Class 10B
-
55
Excel Class 10C
-
56
Class ThirteenText(Statistical Analysis)
A moving average (MA) is a statistical technique used to smooth out short-term fluctuations in a time series data, highlighting longer-term trends and patterns.
-
57
Excel Class Thirteen
-
58
Class Thirteen Quiz
-
59
Class Fourteen Text (HYPOTHESIS TEST)
A hypothesis test for a sample mean is a statistical procedure used to determine whether a sample mean is significantly different from a known or hypothesized population mean.
-
60
Class Fourteen Quiz
-
61
Class Fifteen Text (Introduction to SQL (STRUCTURED QUERY LANGUAGE)
SQL (Structured Query Language) is a programming language designed for managing and querying relational databases. It provides a standardized way to interact with databases. The basic structure of an SQL query involves:
Querying Data
-
62
SQL Class One
-
63
Class Fifteen Quiz
-
64
WEEK 5 ASSIGNMENT
-
65
Class Sixteen Text(MODIFYING DATA WITHIN DATABASE)
There are three main operations: INSERT, UPDATE, and DELETE.
INSERT Statement -
66
SQL Class Two
-
67
Class Sixteen Quiz
-
68
Class Seventeen Text (TABLE DESIGNER METHOD IN SQL and OPERATORS)
Table Designer" feature in SQL Server Management Studio! That's a very useful feature, especially if you're new to SQL.
-
69
Class Seventeen Quiz
-
70
SQL Class Three
-
71
WEEK 6 ASSIGN MENT
-
72
Class Eighteen Text (ARITHMETIC OPERATORS zArithmetic and Logical Operators and JOINS)
ARITHMETIC OPERATORS
Comprises Addition, subtraction, multiplication and Division
-
73
SQL Class Four
-
74
Class Eighteen Quiz
-
75
Class Nineteen Text(Types of Joins in SQL)
TYPES OF JOINS
INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER.
-
76
Class Nineteen Quiz
-
77
SQL Class Five
-
78
Class Twenty Text( Group By Statement, Having Statement, Case Statement and Subquery)
"GROUP BY" is another built-in function in SQL that allows you to group your data based on a specific field. For example, you could use "GROUP BY" to group your data by the "Region" field in your "Sales" table. This would allow you to see the total price for each Region in your table.
-
79
Class Twenty Quiz
-
80
SQL Class Six
-
81
WEEK 7 ASSIGNMENT
-
82
Class Twenty-One Text (Window functions and Temporary Table)
Window functions
• Ranking functions → assign order (ROW_NUMBER, RANK, DENSE_RANK, NTILE).
• Aggregate functions with OVER → calculate totals/averages per partition while keeping row detail.
• Value functions → peek at other rows (LEAD, LAG, FIRST_VALUE, LAST_VALUE)
Why Use NTILE
• Quartile analysis: Identify top/bottom performers, salary bands, or customer segments.
• Percentile grouping: Split data into deciles (NTILE(10)), quintiles (NTILE(5)), etc.
• Balanced distribution: Unlike RANK or DENSE_RANK, NTILE ensures groups are evenly spread across the dataset.
-
83
Class Twenty-One Quiz
-
84
SQL Class Seven
-
85
Class Twenty-Two Text(Introduction to POWER BI)
What is Power BI?
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.
-
86
Class Twenty-Two Quiz
-
87
Introduction to Power BI: Power BI Class One
-
88
Class Twenty-Three Text (Pivot, Unpivot table, Merge and Append Queries)
Pivot Columns
transforms rows into columns.
Example: If you have sales data with "Month" and "Product" as rows, pivoting can make each product a column with sales values under each month.
-
89
Power BI Class Two
-
90
Class Twenty-Three Quiz
-
91
WEEK 8 ASSIGNMENT
-
92
Class Twenty- Four Text (Data modelling)
A Data model is a collection of tables and relationships that can be used to create a report.
Is techniques use in creating relationship between two or more tables.
Modeling data is about establishing and maintaining relationships so that you can effectively visualize the data in the form that your business requires.
-
93
Class Twenty-Four Quiz
-
94
Power BI Class Three
-
95
Class Twenty-five Text (Data Analysis Expression )
Data Analysis Expression commonly known as DAX is the formula languages that derives PowerBI.
With DAX you can (a) Add calculated columns and Measures to your model using intuitive syntax. (b) Go beyond the capabilities of traditional “grid style” formulas, with powerful and flexible functions built specifically to work with relative data models.
-
96
Power BI Class Four
-
97
Class Twenty Five Quiz
-
98
Class Twenty-Six Text(CREATING DASHBARD IN POWERBI)
CREATING CHART FOR DASHBOARD
In Power BI, charts are a powerful tool for visualizing and manipulating data in the Report View. Here's a step-by-step guide on how to use charts and drag columns to the x and y axes:
-
99
Power BI Class Five
-
100
Class Twenty Six Quiz
-
101
WEEK 9 ASSIGNMENT
-
102
Class Twenty-Seven Text (Correlation and forecasting in Power BI)
CORRELATION ANALYSIS
Correlation analysis also known as bivariate, is primarily concerned with finding out whether a relationship exist between variables and then determining the magnitude and action of that relationship.
-
103
Class Twenty-Seven Quiz
-
104
Power BI Class Six
-
105
Class Twenty- Eight Text (Introduction to Python)
PYTHON FOR DATA ANALYSIS
-
106
Class Nine Text (Python Basics)
Variable: A Variable is like a container that is used to store data or values.
· A variable is assigned names which is used to refer its values
· A variable is mutable. Ie its values can change anytime.
For example:
my_list = [1, 2, 3]
my_list[0] = 10 # modify the first element
print(my_list) # [10, 2, 3]
-
107
Class Twenty-Nine Quiz
-
108
Python Class One
-
109
Class Thirty Text (Print format and Arithmetic in Python)
When printing, you must use small letters.
Firstname = ‘Peter’
Lastname = ‘Okafor’
Print (f ‘your firstname is’, Firstname, ‘and your lastname is’, Lastname)
-
110
Python Class Two
-
111
Class Thirty Quiz
-
112
Class Thirty-One Text (If, Elif and nested if statements)
IF STATEMENT
The use of if, elif and nested if statements in python is critical for data analysis, as they allow you to implement decision making logic in your code. These constructs are powerful tools for filtering and processing data, making them valuable for any data analyst working with python.
If, elif, and nested if is a conditional logic data cleaning and processing.
-
113
Python Class Three
-
114
Class Thirty-One Quiz
-
115
Class Thirty-Two Text(DATA STRUCTURE)
DATA STRUCTURE
TYPES
1. LIST 2. TUPLE 3. DICTIONARY 4. SET
A list is a collection of values that can be of the same data type or not. It is mutable, it item can be modified or change.
List declaration
Empty =[ ]
Type (Empty)
Each value in a list is separated by a comma.
· Student_age = [5,10,7,9,6,8,6]
Print (student_age)
· Student_name = [‘john’, ‘peter’, ‘omo’, ‘ruth’, ‘osas’, ‘nosa’]
Print(student_name)
List with different data type
My_var = [= [‘john’, 100, ‘peter’, ‘omo’, 30, ‘ruth’, ‘osas’, 6, ‘nosa ‘]
Print(my_var)
-
116
Python Class Four
-
117
Class Thirty-Two Quiz
-
118
Class Thirty-Three Text( Set and Dictionary)
SET {}: A set is an inorder collection of unique elements' sets are used to stored multiple items in a single variable. Characteristics of set
- unordered: set do not maintain the order of their elements
- Unique elements: they only store unique elements, duplicate are auto remove.
- Mutable: sets can be modified after creation. {} curly bracket
-
119
Python Class Five
-
120
Class Twenty -Four Text (Data Manipulation (pandas)
DataFrames: pd.DataFrame()
- create, manipulate tabular
DataRead/Write: pd.read_csv(), df.to_csv() - handle CSV
FilesSelect/Filter: df[], df.loc[], df.query() - subset data
Group/Aggregate: df.groupby(), df.agg() - summarize data
Merge/Join: pd.merge(), df.join() - combine datasets
-
121
Python Class Six
-
122
CAPSTONE PROJECT
-
Data Analysis 2026 (Batch B)
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.
