Data Analysis Batch 2025 (Batch C)
- 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 Video Part 1 -
3
Class One Video Part 2
-
4
Class One Video Part 3
-
5
Class One Video Part 4
-
6
Class One Video Part 5
-
7
Class One Quiz -
8
Class Two; Text(Introduction 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.
-
9
Class Two Video Part 1
-
10
Class Two Video Part 2
-
11
Class Two Video Part 3
-
12
Class Two Video Part 4
-
13
Class Two Quiz
-
14
Class Three; Text (Create dropdown list, VLOOKUP, If statement)
DROP DOWN LIST
A drop-down list is a feature in Excel that allows you to select a value from a pre-defined list of options. Drop-down lists are useful for controlling data entry, ensuring consistency, and preventing errors. They can also make it easier for users to enter data, as they don't have to type values manually
-
15
Class Three Video Part 1
-
16
Class Three Video Part 2
-
17
Class Three Video Part 3
-
18
Class Three Video Part 4
-
19
Class Three Video Part 5
-
20
Class Three Video Part 6
-
21
Class Three Video Part 7
-
22
Class Three Quiz
-
23
WEEK 1 ASSIGNMENT
-
24
Class Four: Text (Removing extra rows, Sorts and Filter, Pivot table and Chart)
REMOVING EXTRA ROWS
This function is used to remove rows of data that are blank or have no data in certain columns. For example, let's say you have a spreadsheet with 10 rows of data, but 3 of the rows are blank. You could use the remove extra rows function to remove those 3 blank rows. The function would leave you with 7 rows of data.
-
25
Class Four Video Part 1
-
26
Class Four Video Part 2
-
27
Class Four Video Part 3
-
28
Class Four Video Part 4
-
29
Class Four Video Part 5
-
30
Class Four Video Part 6
-
31
Class Four Video Part 7
-
32
Class Four Quiz
-
33
Class Five: Text (Excel Cell Reference and Data Cleaning in Power Query Editor)
1. Relative References: Understanding how cell references change when formulas are copied to other cells.
2. Absolute References: Learning how to lock cell references using $ signs to prevent changes when formulas are copied.
-
34
Class Five Video Part 1
-
35
Class Five Video Part 2
-
36
Class Five Video Part 3
-
37
Class Five Video Part 4
-
38
Class Five Video Part 5
-
39
Class Five Video Part 6
-
40
Class Five Video Part 7
-
41
Class Five Quiz
-
42
Class Six Text: (Data Cleaning in Power Query)
Data Cleaning in Power Query
Data cleaning in Power Query involves transforming and refining data to make it more accurate, consistent, and reliable for analysis
-
43
Class Six Video Class Part 1
-
44
Class Six Video Part 2
-
45
Class Six Video Part 3
-
46
Class Six Video Part 4
-
47
Class Six Video Part 5
-
48
Class Six Video Part 6
-
49
Class Six Quiz
-
50
WEEK 2 ASSIGNMENT
-
51
Class Seven Text (Data Visualization)
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 Seven Video Part 1
-
53
Class Seven Video Part 2
-
54
Class Seven Video Part 3
-
55
Class Seven Quiz
-
56
Class Eight Text (Pivot Table and Chart)
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.
-
57
Class Eight Video Part 1
-
58
Class Eight Videos Part 2
-
59
Class Eight Video Part 3
-
60
Class Eight Video Part 4
-
61
Class Eight Video Part 5
-
62
Class Eight Video Part 6
-
63
Class Eight Video Part 7
-
64
Class Eight Quiz
-
65
Class Nine Text (Data Manipulation in excel )
Data manipulation in Excel involves transforming and analyzing data to extract insights and answer business questions
-
66
Class Nine Quiz
-
67
Class Nine Video Part 1
-
68
Class Nine Video Part 2
-
69
Class Nine Video Part 3
-
70
Class Nine Video Part 4
-
71
Class Nine Video Part 5
-
72
Class Nine Video Part 6
-
73
WEEK 3 ASSIGNMENT
-
74
Class Ten Text (Building of Excel 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.
-
75
Class Ten Video Part 1
-
76
Class Ten Video Part 2
-
77
Class Ten Video Part 3
-
78
Class Ten Video Part 4
-
79
Class Ten Video Part 5
-
80
Class Ten Quiz
-
81
Class Eleven Text (Metric and KPIs in Dashboard and Slicer)
Metric
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.
-
82
Class Eleven Video Part 1
-
83
Class Eleven Video Part 2
-
84
Class Eleven Video Part 3
-
85
Class Eleven Video Part 4
-
86
Class Eleven Video Part 5
-
87
Class Eleven Video Part 6
-
88
Class Eleven Video Part 7
-
89
Class Eleven Video Part 8
-
90
Class Eleven Quiz
-
91
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. 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.
-
92
Class Twelve Video Part 1
-
93
Class Twelve Video Part 2
-
94
Class Twelve Video Part 3
-
95
Class Twelve Quiz
-
96
WEEK 4 ASSIGNMENT
-
97
Class Thirteen 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.
-
98
Class Thirteen Video Part 1
-
99
Class Thirteen Video Part 2
-
100
Class Thirteen Video Part 3
-
101
Class Thirteen Quiz
-
102
Class Fourteen Text (Introduction to 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
-
103
Class Fourteen Video Part 1
-
104
Class Fourteen Video Part 2
-
105
Class Fourteen Video Part 3
-
106
Class Fourteen Video Part 4
-
107
Class Fourteen Video Part 5
-
108
Class Fourteen Video Part 6
-
109
Class Fourteen Quiz
-
110
Class Fifteen Text (MODIFYING DATA WITHIN DATABASE)
There are three main operations: INSERT, UPDATE, and DELETE.
INSERT Statement -
111
Class Fifteen Video Part 1
-
112
Class Fifteen Video Part 2
-
113
Class Fifteen Video Part 3
-
114
Class Fifteen Video Part 4
-
115
Class Fifteen Video Part 5
-
116
Class Fifteen Video Part 6
-
117
Class Fifteen Quiz
-
118
ASSIGNMENT WEEK 5
-
119
Class Sixteen 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)
-
120
Class Sixteen Video Part 1
-
121
Class Sixteen Video Part 2
-
122
Class Sixteen Video Part 3
-
123
Class Sixteen Video Part 4
-
124
Class Sixteen Video Part 5
-
125
Class Sixteen Video Part 6
-
126
Class Sixteen Quiz
-
127
Class Seventeen Text ( Like Operators and Table Designer Methods)
LIKE OPERATORS (WILD CARD % %) A wild card is used to substitute one or more characters in a string. They are used with Like operator. The Like operator is used in a WHERE clause to search for a specific pattern in a column.
-
128
Class Seventeen Video Part 1
-
129
Class Seventeen Video Part 2
-
130
Class Seventeen Video Part 3
-
131
Class Seventeen Video Part 4
-
132
Class Seventeen Quiz
-
133
Class Eighteen Text (Joins)
A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table.
-
134
Class Eighteen Video Part 1
-
135
Class Eighteen Video Part 2
-
136
Class Eighteen Quiz
-
137
WEEK 6 ASSIGNMENT
-
138
Class Nineteen Text (GROUP BY, HAVING AND CASE 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 "Region" field in your "Sales" table. This would allow you to see the total price for each Region in your table. The syntax for a "GROUP BY" statement is "GROUP BY column name". So, to group your data by region.
-
139
Class Nineteen Video Part 1
-
140
Class Nineteen Video Part 2
-
141
Class Nineteen Video Part 3
-
142
Class Nineteen Video Part 4
-
143
Class Nineteen Video Part 5
-
144
Class Nineteen Video Part 6
-
145
Class Nineteen Quiz
-
146
Class Twenty Text (Partition by and nested query)
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.
-
147
Class Twenty Video Part 1
-
148
Class Twenty Video Part 2
-
149
Class Twenty Video Part 3
-
150
Class Twenty Video Part 4
-
151
Class Twenty Quiz
-
152
Class Twenty-One Text (Introduction to Power BI)
INTRODUCTION TO POWERBI
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
-
153
Class Twenty-One Video Part 1
-
154
Class Twenty-One Video Part 2
-
155
Class Twenty-One Video Part 3
-
156
Class Twenty-One Video Part 4
-
157
Class Twenty-One Video Part 5
-
158
Class Twenty-One Video Part 6
-
159
Class Twenty-One Video Part 7
-
160
Class Twenty-One Quiz
-
161
WEEL 7 ASSIGNMENT
-
162
Class Twenty-two Text (Pivot, Unpivot, Append and Merge Query)
PIVOT
Pivot: Pivot in Power BI is a feature that allows you to rotate data from rows to columns. It's useful for summarizing and analyzing data, making it easier to visualize and report. For example, if you have a table with sales data by year and region, you can pivot the region column to create separate columns for each region, making it easier to compare sales across regions.
-
163
Class Twenty-Two Video Part 1
-
164
Class Twenty-Two Video Part 2
-
165
Class Twenty-Two Video Part 3
-
166
Class Twenty-Two Video Part 4
-
167
Class Twenty-Two Video Part 5
-
168
Class Twenty-Two video Part 6
-
169
Class Twenty-two Quiz
-
170
Class Twenty-Three Text (Data Modelling)
Data modelling
A Data model is a collection of tables and relationships that can be used to create a report
-
171
Class Twenty-Three Video Part 1
-
172
Class Twenty-Three Video Part 2
-
173
Class Twenty-Three Video Part 3
-
174
Class Twenty-Three Video Part 4
-
175
Class Twenty-Three Video Part 5
-
176
Class Twenty-Three Video Part 6
-
177
Class Twenty-Three Video Part 7
-
178
Class Twenty-Three Quiz
-
179
Class Twenty-Four 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.
-
180
Class Twenty-Four Video Part 1
-
181
Class Twenty-Four Video Part 2
-
182
Class Twenty-Four Video Part 3
-
183
Class Twenty-Four Video Part 4
-
184
Class Twenty-Four Video Part 5
-
185
Class Twenty-Four Video Part 6
-
186
Class Twenty -Four Quiz
-
187
WEEK 8 ASSIGNMENT
-
188
Class Twenty-Five Text (DAX : MEASURE)
In Power BI, a measure is a calculation that uses DAX (Data Analysis Expressions) to compute a value. Measures are used to create calculations that can be used in reports, such as sums, averages, and percentages.
-
189
Class Twenty-Five Video part 1
-
190
Class Twenty-Five Video part 2
-
191
Class Twenty-Five Video part 3
-
192
Class Twenty-Five Quiz
-
193
Class Twenty-Six Text (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:
-
194
Class Twenty-Six Video Part 1
-
195
Class Twenty-Six Video Part 2
-
196
Class Twenty-Six Video Part 3
-
197
Class Twenty-Six Video Part 4
-
198
Class Twenty-Six Video Part 5
-
199
Class Twenty-Six Video Part 6
-
200
Class Twenty-Six Video Part 7
-
201
Class Twenty-Six Quiz
-
202
Class Twenty-Seven Text (Power BI Dashboard)
A Power BI dashboard is a visual representation of key performance indicators (KPIs) and metrics that provide insights into an organization's performance. It's a customizable, interactive, and shareable report that helps users make data-driven decisions.
-
203
Class Twenty-Seven Video Part 1
-
204
Class Twenty-Seven Video Part 2
-
205
Class Twenty-Seven Video Part 3
-
206
Class Twenty-Seven Video Part 4
-
207
Class Twenty-Seven Video Part 5
-
208
Class Twenty-Seven Video Part 6
-
209
Class Twenty-Seven Video Part 7
-
210
Class Twenty-Seven Video Part 8
-
211
Class Twenty-Seven Quiz
-
212
WEEK 9 ASSIGNMENT
-
213
Class Twenty-Eight Text (Forecasting in powerBI and Correlation Analysis)
FORECASTING IN POWERBI
When you use forecasting in Power BI, it generates a forecast line that predicts future values based on historical data. Along with the forecast line, Power BI also provides upper and lower bounds, which represent the confidence interval of the forecast.
-
214
Class Twenty-Eight Video Part 1
-
215
Class Twenty-Eight Video Part 2
-
216
Class Twenty-Eight Video Part 3
-
217
Class Twenty-Eight Video Part 4
-
218
Class Twenty-Eight Video Part 5
-
219
Class Twenty-Eight Video Part 6
-
220
Class Twenty-Eight Video Part 7
-
221
Class Twenty-Eight Video Part 8
-
222
Class Twenty-Eight Quiz
-
223
Class Twenty-Nine 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.
-
224
Class Twenty-Nine Video Part 1
-
225
Class Twenty-Nine Video Part 2
-
226
Class Twenty-Nine Video Part 3
-
227
Class Twenty-Nine Video Part 4
-
228
Class Twenty-Nine Video Part 5
-
229
Class Twenty-Nine Video Part 6
-
230
Class Twenty-Nine Video Part 7
-
231
Class Twenty-Nine Video Part 8
-
232
Class Twenty-Nine Quiz
-
233
Class Thirty Text (Input format and Operators in Python)
In Python, the input format refers to the way data is received from the user or an external source. Here are some common input formats:
-
234
Class Thirty Video Part 1
-
235
Class Thirty Video Part 2
-
236
Class Thirty Video Part 3
-
237
Class Thirty Video Part 4
-
238
Class Thirty Video Part 5
-
239
Class Thirty Video Part 6
-
240
Class Thirty Video Part 7
-
241
Class Thirty Quiz
-
242
WEEK 10 ASSIGNMENT
-
243
Class Thirty-One Text (Comparison Operators and IF STATEMENT)
== (equal to), != (not equal to), > (greater than), < (less than), >= (greater than or equal to)
-
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-One Video Part 8
-
252
Class Thirty-One Quiz
-
253
Class Thirty-Two Text (DATA STRUCTURE)
TYPES
1. LIST
2. TUPLE
3. DICTIONARY
4. SET
-
254
Class Thirty-Two Video Part 1
-
255
Class Thirty-Two Video Part 2
-
256
Class Thirty-Two Video Part 3
-
257
Class Thirty-Two Video Part 4
-
258
Class Thirty-Two Video Part 5
-
259
Class Thirty-Two Video Part 6
-
260
Class Thirty-Two Quiz
-
261
Class Thirty-Three Text (Tuple, set and dictionary)
TUPLE
Inserting values into tuple by separating each value with a comma.
-
262
Class Thirty-Three Video Part 1
-
263
Class Thirty-Three Video Part 2
-
264
Class Thirty-Three Video Part 3
-
265
Class Thirty-Three Video Part 4
-
266
Class Thirty-Three Video Part 5
-
267
Class Thirty-Three Video Part 6
-
268
Class Thirty-Three Quiz
-
269
Class Thirty-Four Text (NUMPY and PANDAS
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.
-
270
Class Thirty-Four Quiz
-
271
Class Thirty-Four Video Part 1
-
272
Class Thirty-Four Video Part 2
-
273
Class Thirty-Four Video Part 3
-
274
Class Thirty-Four Video Part 4
-
275
Class Thirty-Four Video Part 5
-
276
Captone Project
-
Data Analysis Batch 2025 (Batch C)
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.
