- Description
- Curriculum
- Reviews
-
1
Class One; Text (Introduction To Data Analysis)What is 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 Excel)
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.
Using Formulae
Simple mathematical operators can be used to:
Add (+) Also known as SUM
Subtract (-)
Divide (/)
Multiply (*)
Calculate Indices (powers) of a number
-
4
Class Two Video Part 1 (Introduction to Basic excel formula and functions) -
5
Class Two Video Part 2
-
6
Class Two Video Part 3
-
7
Class Two Video Part 4
-
8
Class Two Quiz
-
9
Class Three: Text (Split, Transpose, Drop down list and Vlookup functions)
SPLIT FUNCTION
The split function is used to split a string into multiple parts based on a delimiter. A delimiter is a character that separates parts of a string. For example, the split function could be used to split a first name and last name into two separate columns. If you had a column of data with full names, like "John Adebayo", the split function could be used to separate "John" and "Adebayo" into two columns.
-
10
Class Three Video Part 1
-
11
Class Three Video Part 2
-
12
Class Three Video Part 3
-
13
Class Three Video Part 4
-
14
Class Three Video Part 5
-
15
Class Three Video Part 6
-
16
Class Three Quiz
-
17
WEEK 1 ASSIGNMENT
-
18
Class Four; Text (If statement and data cleaning)
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
-
19
Class Four Video Part 1
-
20
Class Four Video Part 2
-
21
Class Four Video Part 3
-
22
Class Four Video Part 4
-
23
Class Four Video Part 5
-
24
Class Four Video Part 6
-
25
Class Four Quiz
-
26
Class Five: Text (SORT AND FILTER, CONDITIONAL FORMATTING, 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.
-
27
Class Five Video Part 1
-
28
Class Five Video Part 2 (Sort and Filter)
-
29
Class Five Video Part 3
-
30
Class Five Video Part 4
-
31
Class Five Video Part 5
-
32
Class Five Quiz
-
33
Class Six: Text (Data Cleaning using 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.
-
34
Class Six Video Part 1 (Power Query Editor)
-
35
Class Six Video Part 2
-
36
Class Six Video Part 3
-
37
Class Six Quiz
-
38
WEEK 2 ASSIGNMENT
-
39
Class Seven; Text (Advance part of 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.
-
40
Class Seven Video Part 1 (Advance part of data cleaning)
-
41
Class Seven Video Part 2
-
42
Class Seven Video Part 3
-
43
Class Seven Video Part 4
-
44
Class Seven Quiz
-
45
Class Eight; Text (Continuation on data cleaning and Chart)
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.
-
46
Class Eight Video Part 1
-
47
Class Eight Video Part 2
-
48
Class Eight Video Part 3
-
49
Class Eight Video Part 4
-
50
Class Eight Video Part 5
-
51
Class Eight Video Part 6
-
52
Class Eight Video Part 7
-
53
Class Eight Video Part 8
-
54
Class Eight Quiz
-
55
Class Nine; Text (Chart and Dashboard)
1. 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.
-
56
Class Nine Video Part 1
-
57
Class Nine Video Part 2
-
58
Class Nine Video Part 3
-
59
Class Nine Video Part 4
-
60
Class Nine Video Part 5
-
61
Class Nine Video Part 6
-
62
Class Nine Video Part 7
-
63
Class Nine Video Part 8
-
64
Class Nine Video Part 9
-
65
Class Nine Quiz
-
66
WEEK 3 ASSIGNMENT
-
67
Class Ten; Text (Formatting Dashboard, Slicers and Correlation)
SLICERS
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.
-
68
Class Ten Video Part 1
-
69
Class Ten Video Part 2
-
70
Class Ten Video Part 3
-
71
Class Ten Video Part 4
-
72
Class Ten Video Part 5
-
73
Class Ten Video Part 6
-
74
Class Ten Video Part 7
-
75
Class Ten Video Part 8
-
76
Class Ten Quiz
-
77
Class Eleven; Text (Introduction to Structured Query Language (SQL))
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
-
78
Class Eleven Video Part 1
-
79
Class Eleven Video Part 2
-
80
Class Eleven Video Part 3
-
81
Class Eleven Video Part 4
-
82
Class Eleven Video Part 5
-
83
Class Eleven Video Part 6
-
84
Class Eleven Video Part 7
-
85
Class Eleven Video Part 8
-
86
Class Eleven Quiz
-
87
Class Twelve; Text (Modifying data within database)
There are three main operations: INSERT, UPDATE, and DELETE.
INSERT Statement -
88
Class Twelve Video Part 1
-
89
Class Twelve Video Part 2
-
90
Class Twelve Video Part 3
-
91
Class Twelve Video Part 4
-
92
Class Twelve Video Part 5
-
93
Class Twelve Video Part 6
-
94
Class Twelve Video Part 7
-
95
Class Twelve Video Part 8
-
96
Class Twelve Quiz
-
97
WEEK 4 ASSIGNMENT
-
98
Class Thirteen; Text (Operators in SQL)
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)
-
99
Class Thirteen Video Part 1 (Operators in SQL)
-
100
Class Thirteen Video Part 2
-
101
Class Thirteen Video Part 3
-
102
Class Thirteen Video Part 4
-
103
Class Thirteen Video Part 5
-
104
Class Thirteen Quiz
-
105
Class Fourteen; Text (Logical Operators and Join )
Logical operators or operational operators
(And, Or, Between, In, Like, Not like, Is)
And operators, (condition 1 and condition 2 must be settle)
True result –both statements must be settled
False result—condition not satisfied
True + False = False
False + True = False
False + False = False
-
106
Class Fourteen Video Part 1
-
107
Class Fourteen Video Part 2
-
108
Class Fourteen Video Part 3
-
109
Class Fourteen Video Part 4
-
110
Class Fourteen Video Part 5
-
111
Class Fourteen Video Part 6
-
112
Class Fourteen Video Part 7
-
113
Class Fourteen Video Part 8
-
114
Class Fourteen Video Part 9
-
115
Class Fourteen Quiz
-
116
Class Fifteen: Text(Group by statement, Having statement and subquery)
GROUP BY" is only used with aggregate functions like "SUM", "MIN", "MAX", "AVG", and "COUNT". You can't use "GROUP BY" with a regular function that returns a single value, like "ID" or "NAME". Only functions that return a set of values can be used with "GROUP BY"
-
117
Class Fifteen Video Part 1
-
118
Class Fifteen Video Part 2
-
119
Class Fifteen Video Par 3
-
120
Class Fifteen Quiz
-
121
WEEK 5 Assignment
-
122
Class Sixteen: Text(CASE STATEMENT )
The CASE statement is SQL's way of handling if/then logic. The CASE statement is followed by at least one pair of WHEN and THEN statements—SQL's equivalent of IF/THEN in Excel. Because of this pairing, you might be tempted to call this SQL CASE WHEN , but CASE is the accepted term.
-
123
Class Sixteen Video Part 1
-
124
Class Sixteen Video Part 2
-
125
Class Sixteen Video Part 3
-
126
Class Sixteen Video Part 4
-
127
Class Sixteen Video Part 5
-
128
Class Sixteen Video Part 6
-
129
Class Sixteen Video Part 7
-
130
Class Sixteen Video Part 8
-
131
Class Sixteen Quiz
-
132
Class Seventeen: Text(TABLE DESIGNER METHOD IN SQL)
"Table Designer" feature in SQL Server Management Studio! That's a very useful feature, especially if you're new to SQL. It allows you to visually create a table, instead of writing the "CREATE TABLE" command. It's a quick and easy way to create tables, but it's not as powerful as writing the command yourself.
-
133
Class Seventeen Video Part 1
-
134
Class Seventeen Video Part 2
-
135
Class Seventeen Video Part 3
-
136
Class Seventeen Video Part 4
-
137
Class Seventeen Video Part 5
-
138
Class Seventeen Video Part 6
-
139
Class Seventeen Video Part 7
-
140
Class Seventeen Video Part 8
-
141
Class Seventeen Quiz
-
142
Class Eighteen: Text(Revisions on SQL class)
General SQL REVISIONS
-
143
Class Eighteen Video Part 1
-
144
Class Eighteen Video Part 2
-
145
Class Eighteen Video Part 3
-
146
Class Eighteen Video Part 4
-
147
Class Eighteen Video Part 5
-
148
Class Eighteen Video Part 6
-
149
WEEK 6 ASSIGNMENT
-
150
Class Nineteen; 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.
-
151
Class Nineteen Video Part 1
-
152
Class Nineteen Video Part 2
-
153
Class Nineteen Video Part 3
-
154
Class Nineteen Video Part 4
-
155
Class Nineteen Video Part 5
-
156
Class Nineteen Video Part 6
-
157
Class Nineteen Quiz
-
158
Class Twenty: Text (The query editor, shaping data, unpivot, append and merge data)
The query ribbons
The ribbon in Power Query Editor consists of four tabs: Home, Transform, Add Column, View, Tools, and Help.
The Home tab contains the common query tasks.
The Transform tab provides access to common data transformation tasks, such as:
· Adding or removing columns
· Changing data types
· Splitting columns
· Other data-driven tasks
-
159
Class Twenty video Part 1
-
160
Class Twenty video Part 2
-
161
Class Twenty video Part 3
-
162
Class Twenty video Part 4
-
163
Class Twenty video Part 5
-
164
Class Twenty video Part 6
-
165
Class Twenty Quiz
-
166
Class Twenty-one; Text (Data modelling and creating chart)
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.
-
167
Class Twenty-one Video Part 1
-
168
Class Twenty-one Video Part 2
-
169
Class Twenty-one Video Part 3
-
170
Class Twenty-one Video Part 4
-
171
Class Twenty-one Video Part 5
-
172
Class Twenty-one Video Part 6
-
173
Class Twenty-one Quiz
-
174
WEEK 7 ASSIGNMENT
-
175
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.
-
176
Class Twenty-Two Video Part 1
-
177
Class Twenty-Two Video Part 3
-
178
Class Twenty-Two Video Part 2
-
179
Class Twenty-Two Video Part 4
-
180
Class Twenty-Two Video Part 5
-
181
Class Twenty-Two Video Part 6
-
182
Class Twenty-Two Quiz
-
183
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
-
184
Class Twenty-Three Video Part 1
-
185
Class Twenty-Three Video Part 2
-
186
Class Twenty-Three Video Part 3
-
187
Class Twenty-Three Video Part 4
-
188
Class Twenty-Three Video Part 5
-
189
Class Twenty-Three Quiz
-
190
Class Twenty-Four; Text (Correlation and Regression 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.
Correlation analysis in research is a statistical method used to measure the strength of the linear relationship between two variables and compute their association. Simply put - correlation analysis calculates the level of change in one variable due to the change in the other.
-
191
Class Twenty-Four Video Part 1
-
192
Class Twenty-Four Video Part 2
-
193
Class Twenty-Four Video Part 3
-
194
Class Twenty-Four Video Part 4
-
195
Class Twenty-Four Video Part 5
-
196
Class Twenty-Four Video Part 6
-
197
Class Twenty-Four Quiz
-
198
WEEK 8 ASSIGNMENT
-
199
Class Twenty-five; Text (Introduction to python)
Download Anaconda and install Jupyter notebook.
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.
-
200
Class Twenty-five Video part 1
-
201
Class Twenty-five Video part 2
-
202
Class Twenty-five Video part 3
-
203
Class Twenty-five Video part 4
-
204
Class Twenty-five Video part 5
-
205
Class Twenty-five Video part Part 6
-
206
Class Twenty-Five Quiz
-
207
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:
-
208
Class Twenty-six video part 1
-
209
Class Twenty-six video part 2
-
210
Class Twenty-six video part 3
-
211
Class Twenty-six video part 4
-
212
Class Twenty-six video part 5
-
213
Class Twenty-six video part 6
-
214
Class Twenty-Six Quiz
-
215
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
-
216
Class Twenty-seven video part 1
-
217
Class Twenty-seven video part 2
-
218
Class Twenty-seven video part 3
-
219
Class Twenty-seven video part 4
-
220
Class Twenty-seven video part 5
-
221
Class Twenty-Seven Quiz
-
222
WEEK 9 ASSIGNMENT
-
223
Class Twenty-Eight: Text (Data structure)
List method
Remove
Student_name.remove (‘omo’)
Print (student_name)
-
224
Class Twenty-Eight Video part 1
-
225
Class Twenty-Eight Video part 2
-
226
Class Twenty-Eight Video part 3
-
227
Class Twenty-Eight Video part 4
-
228
Class Twenty-Eight Video part 5
-
229
Class Twenty- Eight Quiz
-
230
Class Twenty-Nine: Text (Continuation on Dictionary, Functions and Modules)
Add new info to dictionary
Person[‘address’] = ’20 sakpoba road’
Print(person)
Keys in dictionary
Print (person.keys())
Values to dictionary
Print(person.values())
Keys and values of the dictionary using items
Print (person.items())
-
231
Class Twenty-Nine Video part 1
-
232
Class Twenty-Nine Video part 2
-
233
Class Twenty-Nine Video part 3
-
234
Class Twenty-Nine Video part 4
-
235
Class Twenty-Nine Video part 5
-
236
Class Twenty-Nine Video part 6
-
237
Class Twenty-Nine Quiz
-
238
Class Thirty: Text (Numpy and Pandas Libraries)
NUMPY
NumPy means numerical python.
Is a powerful library in python that is widely used for numerical and scientific computing. It provides support for large, multidimensional arrays and matrices, along with a collection of mathematical functions to operate on the data structure.
1. Python object: High level number objects; integers, floating point
2. Containers: list (costless insertion and append) dictionaries (fast lookup)
-
239
Class Thirty Video Part 1
-
240
Class Thirty Video Part 2
-
241
Class Thirty Quiz
-
242
WEEK 10 ASSIGNMENT
-
243
Class Thirty-One: Text( Data manipulation and visualization in python)#import libraryimport pandas as pdimport numpy as npimport matplotlib.pyplot as pltimport seaborn as sns
-
244
Class Thirty-One Video Part 1
-
245
Class Thirty-One Video Part 2
-
246
Class Thirty-One Video Part 3
-
247
Class Thirty-One Video Part 4
-
248
Class Thirty-One Video Part 5
-
249
Class Thirty-One Video Part 6
-
250
Class Thirty-One Video Part 7
-
251
Class Thirty-Two: Text(Continuation of data visualization and how to handle errors)
How to calculate the correlation in python.
#correlation of sales and order quantitycorrelation = df1['SALES'].corr(df1['QUANTITYORDERED'])print(correlation) -
252
Class Thirty-Two Video Part 1
-
253
Class Thirty-Two Video Part 2
-
254
Class Thirty-Two Video Part 3
-
255
Class Thirty-Two Video Part 4
-
Data Analysis 2025 (Batch A)
₦200,000
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.
