- 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
-
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.
