- Description
- Curriculum
- Reviews
-
1
Class One ; ( Introduction to Data Analysis)Data analysis refer to the process of inspecting,cleaning and modelling data with the goal of etracting useful information and making informed decisions.
Its involves applying statistical and mathematical techniques to uncover patterns, trends, and insight within data set.
-
2
Class 1 part 1 -
3
Class One Video part 2 (Introduction to data analysis)
-
4
Class One Quiz; (Introduction to Data Analysis ) -
5
Class Two; ( Introduction to Excel ;Basic formulae 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.
Function is built set of instructions. (In functions excel gives a set of instructions to arrive at the answer)
-
6
Class Two Video ;(Basic Excel formulae and function) video
-
7
lesson 2 live -
8
Class Two Quiz; (Basic Excel formulae and functions)
-
9
Class Three ; Functions in Excel (Split function, Join function function, Transpose and Drop down list)
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 Functions in Excel)
-
11
Class Three Video Part 2 (Functions in Excel)
-
12
Class Three Quiz (Functions in excel)
-
13
Week 1 ; Assignment
-
14
Class Four; Text ( VLOOKUP, IFSTATEMENT, NESTEDIF )
Lookup Values
The term ‘Look up’ as used in the examinations, means to look up (search) from a list.
There are two main LOOKUP functions that can be used within Excel. These are:
HLOOKUP
VLOOKUP
HLOOKUP (Horizontal Lookup)
HLOOKUP is a function that performs a horizontal look-up of data.
HLOOKUP should be used when the values you wish to compare your data with are stored in a single row.
-
15
Class Four Video Part 1 (VLOOKUP FUNCTION)
-
16
Class Four Video Part 2 (IFSTATEMENT AND NESTED IF)
-
17
Class Four Video Part 3 (Basic Data Cleaning Using Trim, Value, Clean and proper function)
-
18
Class Four Quiz
-
19
Class Five ; Text (Sort and Filter, Pivot Table and Chart)
SORT AND FILTER
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.
-
20
Class Five Video Part 1 (Sort and Filter)
-
21
Class Five Video Part 2 (Pivot-Table and Pivot- Chart)
-
22
Class Five Quiz
-
23
Class Six; Text (Data Cleaning in Excel)
What is data cleaninData 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.g?
-
24
Class Six Video Part 1 (Data Cleaning)
-
25
Class Six Video Part 2 (Data Cleaning)
-
26
Class Six Video Part 3 (Data Cleaning)
-
27
Class Six Video Part 4 (Data Cleaning)
-
28
Class Six Quiz
-
29
Week 2; Assignment
-
30
Class Seven ; Text (Data Cleaning using Power Query Editor)
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.
-
31
Class Seven Video Part 1 (Data cleaning using Power Query Editor)
-
32
Class Seven Video Part 2 (Power Query Editor)
-
33
Class Seven Video Part 3 (Power Query Editor)
-
34
Class Seven Quiz
-
35
Class Eight Text (Data Validation)
Data validation focuses on identifying and correcting errors, innconsistencies, and incompleteness in the data.
-
36
Class Eight Video Part 1 (Data Validation)
-
37
Class Eight Video part 2 (Data validation
-
38
Class Eight Quiz
-
39
Class Nine ; Text (Pivot Table and Pivot Chart)
A pivot table is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Pivot table work a little bit differently depending on what you are using it to run in excel.
It is used to analyzed numerical data in details, and answer unanticipated questions about your data. Pivot table is designed for Querying large amounts of data in many user-friendly ways.
-
40
Class Nine Video Part 1 (Pivot Table)
-
41
Class Nine Video Part 2 (Pivot Table and pivot chart)
-
42
Class Nine Video Part 3
-
43
Class Nine Video Part 4
-
44
Class Nine Video Part 5
-
45
Class Nine Video Part 6
-
46
Class Nine Quiz
-
47
Week 3 Assignment
-
48
Class Ten; Text (Data Visualization and Dashboard)
DATA VISUALIZATION
The process of creating data with visuals. Data visualization is used to interpret and gain insight into large amount of data. This sis achieved through visual representations often interactive of raw data.
Data visualization
(a). Enhance learning (b) Enhance understanding (c) Enhance reasoning (d) helps in decision making
Data visualizations leads to
(a) Detect patterns (b) detect trends (c) detect correlations in data (d) can prompt a user to draw interference, anticipate potential trajectories and outcomes.
-
49
Class Ten Video Part 1 (Data Visualization)
-
50
Class Ten Video Part 2
-
51
Class Ten Video Part 3
-
52
Class Ten Video Part 4
-
53
Class Ten Quiz
-
54
Class Eleven; Text (Introduction to 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
-
55
Class Eleven Video Part 1 (INTRODUCTION TO SQL )
-
56
Class Eleven Video Part 2 (Creating Database in SQL)
-
57
Class Eleven Video Part 3 (Creating a table and insert information on it)
-
58
Class Eleven Quiz
-
59
Class Twelve; Text (Modify data within a database using SQL)
There are three (3) main operations in modifying data;
INSERT,
UPDATE,
and DELETE.
-
60
Class Twelve Video Part 1 (Modifying Data in SQL)
-
61
Class Twelve Video Part 2 ( Update New Column with Information)
-
62
Class Twelve Video Part 3
-
63
Class Twelve Video Part 4
-
64
Class Twelve Video Part 5
-
65
Class Twelve Quiz
-
66
Week 4 Assignment
-
67
Class Thirteen ; Text (OPERATIONS IN SQL)
There are three 3 main operators in SQL
Comparison operations (Greater than”>”, Less than “<”, Equal to “=”, Not equal to “!=” “<>”)
Arithmetic operations (Additions, subtractions, division and multiplications)
Logical operation or operational operations (And, Or, Between, In, Like, Not like, Is)
-
68
Class Thirteen Video Part 1 (Operatations in SQL)
-
69
Class Thirteen Video Part 2
-
70
Class Thirteen Video Part 3
-
71
Class Thirteen Quiz
-
72
Class Fourteen; Text (Logical Operation or Operational operations and Join)
Logical operation or operational operations
(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
-
73
Class Fourteen Video Part 1 ( Logical Operations or Operational Operations)
-
74
Class Fourteen Video Part 2
-
75
Class Fourteen Video Part 3 (Join)
-
76
Class Fourteen Video Part 4
-
77
Class Fourteen Quiz
-
78
Class Fifteen; ,(GROUP BY STATEMENT AND HAVING STATEMENT SQL)
GROUP BY STATEMENT
"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 "department" field in your "inventory" table. This would allow you to see the total price for each department in your table. The syntax for a "GROUP BY" statement is "GROUP BY column name". So, to group your data by department, you would use a statement like this: "GROUP BY inventory. Department.
-
79
Class Fifteen Video Part 1 ( Types of Join and their differences)
-
80
Class Fifteen Video Part 2
-
81
Class Fifteen Video Part 3
-
82
Class Fifteen Video Part 4 (Having Statement)
-
83
Class Fifteen Quiz
-
84
Week 5 Assignment
-
85
Class Sixteen; Text (SUBQUERIES AND CASE STATEMENT )
Subqueries, also known as nested queries, allow you to use the result of one query within another query. There are different types of subqueries
-
86
Class Sixteen Video Part 1 (Subqueries)
-
87
Class Sixteen Video Part 2
-
88
Class Sixteen Video Part 3
-
89
Class Sixteen Quiz
-
90
Class Seventeen: Text ( Subquery and Case statement)
Subqueries, also known as nested queries, allow you to use the result of one query within another query. There are different types of subqueries:
-
91
Class Seventeen Video Part 1
-
92
Class Seventeen Video Part 2
-
93
Class Seventeen Video Part 3
-
94
Class Seventeen Video Part 4
-
95
Class Seventeen Quiz
-
96
Class Eighteen: Text (PARTITION BY AND TEMPORARY TABLE)
The 'PARTITION BY' clause in SQL is a subclause of the 'OVER' clause. It's used to split a large table into smaller, more manageable partitions. Each partition is then processed for the function present in the 'OVER()' clause.
-
97
Class Eighteen Video Part 1
-
98
Class Eighteen Video Part 2
-
99
Class Eighteen Video Part 3
-
100
Class Eighteen Video Part 4
-
101
Class Eighteen Quiz
-
102
Week 5 Assignment
-
103
Class Nineteen; Text (Introduction to Tableau)
WHAT IS TABLEAU
Tableau is a data analytical platform.
Tableau is a software company that offers collaborative data visualization software for organizations working with business information analytics. Organizations use Tableau to visualize data and reveal patterns for analysis in business intelligence, making the data more understandable.
-
104
Class Nineteen Video Part 1 (Introduction to Tableau)
-
105
Class Nineteen Video Part 2
-
106
Class Nineteen Video Part 3
-
107
Class Nineteen Video Part 4
-
108
Class Nineteen Video Part 5
-
109
Class Nineteen Quiz
-
110
Class Twenty : Text (Visualization and creating dashboard)
CREATING A DASHBOARD
You create a dashboard in much the same way you create a new worksheet.
-
111
Class Twenty Video Part 1
-
112
Class Twenty Video Part 2
-
113
Class Twenty Video Part 3
-
114
Class Twenty Video Part 4
-
115
Class Twenty Quiz
-
116
Class Twenty-One : Text (CREATING BINS IN TABLEAU)
Tableau Bins are equal-sized containers that store data values that correspond to or fit within the Bin Size. Tableau Bins divide a set of data into groups of equal intervals or sizes, resulting in a systematic distribution of data.
-
117
Class Twenty-One Video Part 1
-
118
Class Twenty-One Video Part 2
-
119
Class Twenty-One Video Part 3
-
120
Class Twenty-One Video Part 4
-
121
Class Twenty-One Video Part 5
-
122
Class Twenty-One Quiz
-
123
Week 6 Assignment
-
124
Class Twenty-Two: Text ( Chart and Visualization )
Data visualization is the graphical representation of information and data. By using visual elements like charts, graphs, and maps, data visualization tools provide an accessible way to see and understand trends, outliers, and patterns in data.
-
125
Class Twenty-Two Video Part 1
-
126
Class Twenty-Two Video Part 2
-
127
Class Twenty-Two Video Part 3
-
128
Class Twenty-Two Video Part 4
-
129
Class Twenty-Two Quiz
-
130
Class Twenty-Three; Text ( Dashboard And Story)
CREATING STORY
The "Story" feature in Tableau is a great way to create a narrative with your data. You can use the Story feature to combine multiple dashboards into a single story, and you can add text to explain the story. This can be useful for creating a presentation or report with your data
-
131
Class Twenty-Three Video Part 1
-
132
Class Twenty-three Video Part 2
-
133
Class Twenty-three Video Part 3
-
134
Class Twenty-three Video Part 4
-
135
Class Twenty-three Video Part 5
-
136
Class Twenty-three Quiz
-
137
Class Twenty- Four : 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.
-
138
Class Twenty-Four Video Part 1 (Introduction to Power BI )
-
139
Class Twenty-Four Video Part 2 (Connect to Different Data source)
-
140
Class Twenty - Four Quiz
-
141
Week 7 Assignment
-
142
Class Twenty - Five; Text ( Connect Data to Power BI through difference data source)
Let connect to data through web.
On the Power BI Desktop Home tab, select Get Data > Web to connect to a web data source.
In the From Web dialog box, paste your URL (www.bankrate.com/retirement/best-and-worst-states-for-retirement/) OR (https://www.kaggle.com/datasets/yasserh/walmart-dataset) Or https://en.wikipedia.org/wiki/List_of_U.S._state_abbreviations
-
143
Class Twenty-Five Video Part 1
-
144
Class Twenty-Five Video Part 2
-
145
Class Twenty-Five Video Part 3
-
146
Class Twenty-Five Video Part 4
-
147
Class Twenty-Five Video Part 5
-
148
Class Twenty - Five Quiz
-
149
Class Twenty - Six; Text (Shape data)
Now that you're connected to a data source, you can adjust the data to meet your needs. To shape data, you provide Power Query Editor with step-by-step instructions for adjusting the data while loading and presenting it. Shaping doesn't affect the original data source, only this particular view of the data.
-
150
Class Twenty-Six Video Part 1
-
151
Class Twenty-Six Video Part 2
-
152
Class Twenty-Six Video Part 3
-
153
Class Twenty -Six Video Part 4
-
154
Class Twenty - Six Quiz
-
155
Class Twenty - Seven: 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.
-
156
Class Twenty-Seven Video Part 1
-
157
Class Twenty-Seven Video Part 2
-
158
Class Twenty - Seven Quiz
-
159
Class Twenty- Eight; Text (Difference between Calculated Column and Measure)
Calculated columns; This allows you to add new formula-based columns to tables.
· No “A1-style” reference; calculated columns refer to entire table or columns.
· Calculated columns generate values for each row, which are visible within the table in a data view.
· Calculated columns understand row context; they are greater for defining properties based on information on each row, but generally useless for aggregations (Sum, count, average etc.)
NOTE; Used calculated columns when you want to fixed values to each row in a table (or used query editor).
-
160
Class Tweny-Eight Video Part 1
-
161
Class Twenty-Eight Video Part 2
-
162
Class Twenty - Eight Quiz
-
163
Week 8 Assignment
-
164
Class Twenty -Nine ;Text ( DAX OPERATORS)
DAX Operators
· Arithmetic operators
Addition (+), Subtraction (-), multiplication (*), division (/)
· Comparison operators
Equal to (=), less than (<), greater than (>), less than or equal to (<=), greater than or equal to (>=), not equal to (<>).
· Test and logical operators
Amper sand (&), (&&)
-
165
Class Twenty-Nine Video Part 1
-
166
Class Twent-Nine Video Part 2
-
167
Class Twenty-Nine Video Part 3
-
168
Class Twenty - Nine Quiz
-
169
Class Thirty; Text (Data Shaping and Dashboard)
Shaping can mean transforming the data, such as renaming columns or tables, removing rows or columns, or changing data types. Power Query Editor captures these steps sequentially under Applied Steps in the Query Settings pane. Each time this query connects to the data source, those steps are carried out, so the data is always shaped the way you specify. This process occurs when you use the query in Power BI Desktop, or when anyone uses your shared query, such as in the Power BI service.
-
170
Class Thirty Video Part 1
-
171
Class Thirty Video Part 2
-
172
Class Thirty Video Part 3
-
173
Class Thirty Video Part 4
-
174
Class Thirty Video Part 5
-
175
Class Thirty Quiz
-
176
Week 9 Assignment
-
177
Class Thirty -One ; Text (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.
-
178
Class Thirty - One Video Part 1
-
179
Class Thirty - -One Video Part 2
-
180
Class Thirty - One Video Part 3
-
181
Class Thirty - One Video Part 4
-
182
Class Thirty - One Video Part 5
-
183
Class Thirty - one Quiz
-
184
Class Thirty - Two ; Text ( Data Visualization and Chart)
DATA VISUALIZATION
The process of creating data with visuals. Data visualization is used to interpret and gain insight into large amount of data. This sis achieved through visual representations often interactive of raw data.
-
185
Class Thirty - Two Video Part 1
-
186
Class Thirty - Two Video Part 2
-
187
Class Thirty - Two Video Part 3
-
188
Class Thirty - Two Video Part 4
-
189
Class Thirty - Two Quiz
-
190
Class Thirty - Three ; Text (Correlation 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.
-
191
Class Thirty - Three Video Part 1
-
192
Class Thirty - -Three Video Part 2
-
193
Class Thirty - Three Video Part 3
-
194
Class Thirty - Three Quiz
-
195
CLASS THIRTY - FOUR ; TEXT (LINEAR REGRESSION IN POWERBI)
Introduction
In this article, you will see how to perform linear regression in Power BI. Linear regression is an extremely valuable measure that helps us to understand the connection among variables and the impacts they have on one another. It can be used across many industries in a variety of ways, from spurring value to acquiring client understanding in order to profit businesses.
-
196
Class Thirty - Four Video Part 1
-
197
Class Thirty - Four Video Part 2
-
198
Class Thirty - Four Video Part 3
-
199
Class Thirty - Four Quiz
-
200
CLASS THIRTY - FIVE ; TEXT (Revision on Excel formula and function, conditional formatting, data cleaning)
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.
Functions
Function is built set of instructions. (In functions excel gives a set of instructions to arrive at the answer)
-
201
Class Thirty - Five Video Part 1
-
202
Class Thirty -Five Video Part 2
-
203
Class Thirty - Five Video Part 3
-
204
Class Thirty - five Video Part 4
-
205
Class Thirty - Five Video Part 5
-
206
Class Thirty - Five Quiz
-
207
Class Thirty - Six Video Part 1
-
208
Class Thirty - Six Video Part 2
-
209
Class Thirty- Six Video Part 3
-
210
Class Thirty - Six Video Part 4
-
211
Class Thirty- Six Video Part 5
-
212
Week 10 Assignment
-
213
RÉSUMÉ CREATION 1
-
214
RÉSUMÉ CREATION 2
-
215
RÉSUMÉ CREATION 3
-
216
RÉSUMÉ CREATION 4
-
217
RÉSUMÉ CREATION 5
-
218
RÉSUMÉ CREATION 6
-
219
RÉSUMÉ CREATION 7
-
220
RÉSUMÉ CREATION 8
-
221
RÉSUMÉ CREATION 9
-
222
RÉSUMÉ CREATION 10
-
223
RÉSUMÉ CREATION 11
-
224
RÉSUMÉ CREATION 12
-
225
RÉSUMÉ CREATION 13
-
226
RÉSUMÉ CREATION
-
Data Analysis 2024 (Batch B)
₦150,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.
