- Description
- Curriculum
- Reviews
-
1
Class One; Text (Introduction To Data Analysis)Data analysis is the process of identifying, cleaning, transforming, and modeling data to discover meaningful and useful information. The data is then crafted into a story through reports for analysis to support the critical decision-making process.
-
2
Class One Quiz -
3
Class Two; Text (Introduction to Basic excel formula and functions)
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.
-
4
Class Two Video Part 1 -
5
Class Two Video Part 2
-
6
Class Two Video Part 3
-
7
Class Two Video Part 4
-
8
Class Two Video Part 5
-
9
Class Two Video Part 6
-
10
Class Two Quiz
-
11
Class Three; Text (If statement, Nested If, proper, Value and Trim functions, remove extra rows)
IF Function
An IF function is made up of 3 parts:
A condition
What to do if the condition is met
What to do if the condition is not met.
-
12
Class Three Video Part 1
-
13
Class Three Video Part 2
-
14
Class Three Video Part 3
-
15
Class Three Video Part 4
-
16
Class Three Video Part 5
-
17
Class Three Video Part 6
-
18
Class Three Quiz
-
19
Week 1 Assignment
-
20
Class Four; Text (Sort and Filter, Pivot table and Chart)
What is the difference between filter and sort by?
Filters set a hard boundary on the search results and exclude anything not falling within the categories selected, while sort sets a soft boundary and only changes the sequence of appearance. Sorting helps to organize data by particular attribute or parameter, such as alphabetically or by date or by descending and ascending order.
-
21
Class Four Video Part 1
-
22
Class Four Video Part 2
-
23
Class Four Video Part 3
-
24
Class Four Video Part 4
-
25
Class Four Video Part 5
-
26
Class Four Quiz
-
27
Class Five; Text ( Data Cleaning in Excel using Power Query Editor)
DATA CLEANING
What is data cleaning?
Data cleaning, also known as data cleansing, is the process of detecting and correcting errors or inconsistencies in a dataset. This can include tasks like removing duplicate records, correcting spelling mistakes, standardizing date formats, and so on. Data cleaning is important because it ensures that your analysis is based on accurate and consistent data.
-
28
Class Five Video Part 1
-
29
Class Five Video Part 2
-
30
Class Five Video Part 3
-
31
Class Five Video Part 4
-
32
Class Five Video Part 5
-
33
Class Five Video Part 6
-
34
Class Five Quiz
-
35
Class Six; Text ( Data Cleaning in Power Query Editor )
Data cleaning, also known as data cleansing, is the process of detecting and correcting errors or inconsistencies in a dataset. This can include tasks like removing duplicate records, correcting spelling mistakes, standardizing date formats, and so on
-
36
Class Six Video Part 1
-
37
Class Six Video Part 2
-
38
Class Six Video Part 3
-
39
Class Six Video Part 4
-
40
Class Six Video Part 5
-
41
Class Six Quiz
-
42
Week 2 Assignment
-
43
Class Seven; Text (Conditional column in Power Query Editor)
In Power Query Editor, a Conditional Column is a feature that allows you to create a new column based on specific conditions or rules applied to existing columns.
-
44
Class Seven Video Part 1
-
45
Class Seven Video Part 2
-
46
Class Seven Video Part 3
-
47
Class Seven Video Part 4
-
48
Class Seven Video Part 5
-
49
Class Seven Video Part 6
-
50
Class Seven Quiz
-
51
Class Eight: Text(Data Visualization in Excel)
The process of creating data with visuals. Data visualization is used to interpret and gain insight into large amount of data. This is achieved through visual representations often interactive of raw data.
-
52
Class Eight Video Part 1
-
53
Class Eight Video Part 2
-
54
Class Eight Video Part 3
-
55
Class Eight Video Part 4
-
56
Class Eight Video Part 5
-
57
Class Eight Video Part 6
-
58
Class Eight Quiz
-
59
Class Nine: Text (Excel Dashboard)
A dashboard is a visual representation of key performance indicators (KPIs) and metrics that provide insights into an organization's or business's performance. It's a centralized platform that displays data in a clear and concise manner, allowing users to quickly understand complex data and make informed decisions.
-
60
Class Nine Video Part 1
-
61
Class Nine Video Part 2
-
62
Class Nine Video Part 3
-
63
Class Nine Video Part 4
-
64
Class Nine Video Part 5
-
65
Class Nine Video Part 6
-
66
Class Nine Quiz
-
67
WEEK 3 Assignment
-
68
Class Ten: Text (Dashboard, Metrics and Slicer)
Slicers are a powerful feature in Excel that allows users to filter data in a pivot table or chart. Here's an overview of slicers and their functions in an Excel dashboard:
-
69
Class Ten Video Part 1
-
70
Class Ten Video Part 2
-
71
Class Ten Video Part 3
-
72
Class Ten Video Part 4
-
73
Class Ten Video Part 5
-
74
Class Ten Quiz
-
75
Class Eleven: Text(Statistical Analysis)
MOVING AVERAGE
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.
-
76
Class Eleven Video Part 1
-
77
Class Eleven Video Part 2
-
78
Class Eleven Video Part 3
-
79
Class Eleven Video Part 4
-
80
Class Eleven Video Part 5
-
81
Class Eleven Video Part 6
-
82
Class Eleven Quiz
-
83
Class Twelve; Text(Correlation and Regression Analysis)
CORRELATION AND REGRESSIONAL ANALYSIS
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. Similarly, if two variables have a strong negative correlation, it means that when one variable increases, the other variable tends to decrease. Understanding these relationships can help you make better decisions and understand how different factors influence each other.
-
84
Class Twelve Video Part 1
-
85
Class Twelve Video Part 2
-
86
Class Twelve Video Part 3
-
87
Class Twelve Video Part 4
-
88
Class Twelve Video Part 5
-
89
Class Twelve Video Part 6
-
90
Class Twelve Quiz
-
91
Week 4 Assignment
-
92
Class Thirteen; Text (Introduction Structured Query Language)
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
-
93
Class Thirteen Video Part 1
-
94
Class Thirteen Video Part 2
-
95
Class Thirteen Video Part 3
-
96
Class Thirteen Video Part 4
-
97
Class Thirteen Video Part 5
-
98
Class Thirteen Quiz
-
99
Class Fourteen: Text (MODIFYING DATA WITHIN DATABASE)
There are three main operations in modifying database:
INSERT, UPDATE, and DELETE.
INSERT Statement -
100
Class Fourteen Video Part 1
-
101
Class Fourteen Video Part 2
-
102
Class Fourteen Video Part 3
-
103
Class Fourteen Video Part 4
-
104
Class Fourteen Video Part 5
-
105
Class Fourteen Video Part 6
-
106
Class Fourteen Quiz
-
107
Class Fifteen: Text(OPERATORS IN SQL)
Comparison operators (Greater than”>”, Less than “<”, Equal to “=”, Not equal to “!=” “<>”)
Arithmetic operators (Additions, subtractions, division and multiplications)
Logical operators or operational operators (And, Or, Between, In, Like, Not like, Is)
-
108
Class Fifteen Video Part 1
-
109
Class Fifteen Video Part 2
-
110
Class Fifteen Video Part 3
-
111
Class Fifteen Video Part 4
-
112
Class Fifteen Video Part 5
-
113
Class Fifteen Video Part 6
-
114
Class Fifteen Quiz
-
115
Week 5 Assignment
-
116
Class Sixteen Text (Join)
In SQL, a JOIN is used to combine rows from two or more tables based on a related column between them.
-
117
Class Sixteen Video Part 1
-
118
Class Sixteen Video Part 2
-
119
Class Sixteen Video Part 3
-
120
Class Sixteen Video Part 4
-
121
Class Sixteen Video Part 5
-
122
Class Sixteen Video Part 6
-
123
Class Sixteen Quiz
-
124
Class Seventeen Text(Group by, Having, Case statement and Subquery)
In SQL, GROUP BY is a clause used to group rows of a result set by one or more columns. It allows you to aggregate data and perform calculations on groups of rows that share common values.
-
125
Class Seventeen Video Part 1
-
126
Class Seventeen Video Part 2
-
127
Class Seventeen Video Part 3
-
128
Class Seventeen Video Part 4
-
129
Class Seventeen Video Part 5
-
130
Class Seventeen Video Part 6
-
131
Class Seventeen Quiz
-
132
Class Eighteen Tex:(Table Designer Method in SQL)
The Table Designer is a graphical tool in SQL Server Management Studio (SSMS) that allows you to create and modify database tables.
-
133
Class Eighteen Video Part 1
-
134
Class Eighteen Video Part 2
-
135
Class Eighteen Video Part 3
-
136
Class Eighteen Video Part 4
-
137
Class Eighteen Video Part 5
-
138
Class Eighteen Quiz
-
139
WEEK 6 ASSIGNMENT
-
140
Class Nineteen; Text(Introduction to Power BI)
Power BI is a business analytics service by Microsoft that allows users to create interactive visualizations and business intelligence reports.
-
141
Class Nineteen Video Part 1
-
142
Class Nineteen Video Part 2
-
143
Class Nineteen Video Part 3
-
144
Class Nineteen Video Part 4
-
145
Class Nineteen Video Part 5
-
146
Class Nineteen Video Part 6
-
147
Class Nineteen Quiz
-
148
Class Twenty; Text(Transpose, Pivot and unpivot column)
Transpose
Transpose is an operation that swaps the rows and columns of a table.
It converts rows into columns and columns into rows.
Change table from horizontal to vertical or from vertical to horizontal
-
149
Class Twenty Video Part 1
-
150
Class Twenty video Part 2
-
151
Class Twenty video Part 3
-
152
Class Twenty video Part 4
-
153
Class Twenty video Part 5
-
154
Class Twenty video Part 6
-
155
Class Twenty video Part 7
-
156
Class Twenty Quiz
-
157
Class Twenty-one; Text (Appending, Merging and Data Modelling)
In Power BI, Append and Merge are two distinct operations used to combine data from multiple tables or queries.
-
158
Class Twenty-one Video Part 1
-
159
Class Twenty-one Video Part 2
-
160
Class Twenty-one Video Part 3
-
161
Class Twenty-one Video Part 4
-
162
Class Twenty-one Video Part 5
-
163
Class Twenty-one Video Part 6
-
164
Class Twenty-one Quiz
-
165
WEEK 7 ASSIGNMENT
-
166
Class Twenty-Two: 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.
-
167
Class Twenty-Two Video Part 1
-
168
Class Twenty-Two Video Part 2
-
169
Class Twenty-Two Video Part 3
-
170
Class Twenty-Two Video Part 5
-
171
Class Twenty-Two Video Part 4
-
172
Class Twenty-Two Video Part 6
-
173
Class Twenty-Two Video Part 7
-
174
Class Twenty-Two Quiz
-
175
Class Twenty-Three: Text (DATE AND TIME FUNCTIONS)
Basic date and time functions as well as advance time intelligence operators; common example; DateDiff, YearFranc, Year/Month/Day, Hour/Minute/Second, Today/Now, Weekday/Weekend.
-
176
Class Twenty-Three Video Part 1
-
177
Class Twenty-Three Video part 2
-
178
Class Twenty-Three Video part 3
-
179
Class Twenty-Three Video part 4
-
180
Class Twenty-Three Video part 6
-
181
Class Twenty-Three Video part 5
-
182
Class Twenty-Three Quiz
-
183
Class Twenty-four: Text (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.
-
184
Class Twenty-four Video part 1
-
185
Class Twenty-four Video part 2
-
186
Class Twenty-four Video part 3
-
187
Class Twenty-four Video part 4
-
188
Class Twenty-four Video part 5
-
189
Class Twenty-Four Quiz
-
190
WEEK 8 ASSIGNMENT
-
191
Class Twenty-Five: Text(Introduction to Python)
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]
-
192
Class Twenty-five Video part 1
-
193
Class Twenty-five Video part 2
-
194
Class Twenty-five Video part 3
-
195
Class Twenty-five Video part 4
-
196
Class Twenty-Five Quiz
-
197
Class Twenty-Six: Text(Operators in Python)
In Python, operators are special symbols or keywords that are used to perform operations on variables and values. Here are the main categories of operators in Python:
Types of operators
1. Arithmetic Operators
- + (addition), - (subtraction), * (multiplication), / (division), ** (exponentiation), % (modulus)
- // (floor division)
-
198
Class Twenty-Six Video part 1
-
199
Class Twenty-Six Video part 2
-
200
Class Twenty-Six Video part 3
-
201
Class Twenty-Six Video part 4
-
202
Class Twenty-Six Video part 6
-
203
Class Twenty-Six Video part 5
-
204
Class Twenty-Six Quiz
-
205
Class Twenty-Seven: Text (CONTROL FLOW)
Control flow in python refers to the order in which individual statements, instructions or functions are executed or evaluated in a program. It determines how a program move through its code, allowing for decision making and repetition
-
206
Class Twenty-Seven Video part 1
-
207
Class Twenty-Seven Video part 2
-
208
Class Twenty-Seven Video part 3
-
209
Class Twenty-Seven Video part 4
-
210
Class Twenty-Seven Video part 5
-
211
Class Twenty-Seven Video part 6
-
212
Class Twenty-Seven Quiz
-
213
WEEK 9 ASSIGNMENT
-
214
Class Twenty-Eight: Text DATA STRUCTURE (LIST)
TYPES
1. LIST
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.
-
215
Class Twenty-Eight Video part 1
-
216
Class Twenty-Eight Video part 2
-
217
Class Twenty-Eight Video part 3
-
218
Class Twenty-Eight Video part 4
-
219
Class Twenty-Eight Video part 5
-
220
Class Twenty-Eight Quiz
-
221
Class Twenty-Nine: Text; DATA STRUCTURE (TUPLE, SET )
TUPLE
Inserting values into tuple by separating each value with a comma.
Mytup = (2)
Print(mytup)
A= (2,3,4,6,9)
Print(type(A)
B= 2, 4, 6,9
Type(B)
-
222
Class Twenty-Nine Video part 1
-
223
Class Twenty-Nine Video part 2
-
224
Class Twenty-Nine Video part 3
-
225
Class Twenty-Nine Video part 4
-
226
Class Twenty-Nine Quiz
-
227
Class Thirty: Text (Dictionary, Functions)
In Python, a dictionary is a mutable data type that stores mappings of unique keys to values.
-
228
Class Thirty Video part 1
-
229
Class Thirty Video part 2
-
230
Class Thirty Video part 3
-
231
Class Thirty Video part 4
-
232
Class Thirty Quiz
-
233
WEEK 10 ASSIGNMENT
-
234
Class Thirty-One; Text(Modules in python)
A module is a file containing python definitions and statements. A module can define functions, classes and variables that can be reused across different programs.
Importing modules
You can use the import keyword to bring a module into your program using system inbuild module.
-
235
Class Thirty-One Video Part 1
-
236
Class Thirty-One Video Part 2
-
237
Class Thirty-One Video Part 3
-
238
Class Thirty-One Video Part 4
-
239
Class Thirty-One Video Part 5
-
240
Class Thirty-One Video Part 6
-
241
Class Thirty-One Quiz
-
242
Class Thirty-Two: Text (PANDAS)
Pandas is a powerful and widely used open-source data analysis and manipulation library for python. It provides flexible data structures that make it easy to work with structure data.
Key features of pandas
-
243
Class Thirty-Two Video Part 1
-
244
Class Thirty-Two Video Part 2
-
245
Class Thirty-Two Video Part 3
-
246
Class Thirty-Two Video Part 4
-
247
Class Thirty-Two Video Part 5
-
248
Class Thirty-Two Video Part 6
-
249
Class Thirty-Two Video Part 7
-
250
Class Thirty-Three; Text (Data Visualization with Python)
Data visualization with Python is the process of creating graphical representations of data to better understand and communicate insights
-
251
Class Thirty-Three Video Part 1
-
252
Class Thirty-Two Video Part 2
-
253
Class Thirty-Two Video Part 3
-
254
Class Thirty-Three Video Part 4
-
255
Class Thirty-Three Video Part 5
-
256
Class Thirty-Three Video Part 6
-
257
Class Thirty-Four; Text (THE 12 KEY POINTS TO CONSIDER WHEN PRESENTING TO BUSINESS EXCUTIVES)
Always remember that the goal is to enable executive to make informed decisions quickly and confidently. Keep the focus on the business impact of the data and how it aligns with organizational objectives.
-
258
Class Thirty-Four Video Part 1
-
259
Class Thirty Four Video part 2
-
260
Class Thirty Four Video part Part 3
-
261
Class Thirty Four Video part 4
-
262
Class Thirty-Five (General Revision)
HYPOTHESIS TEST FOR A SAMPLE MEAN
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.
-
263
Class Thirty-Six (Project Presentation)
Students presenting their individual projects.
-
Data Analysis Batch B 2025
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.
