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