Data Analysis 2026 (Batch C)
- Curriculum
- Reviews
-
1
Class One Text (Introduction to Data Analysis)DATA: A representation of information or material recorded and assumed as facts. used as a basis of reasoning, discussion, or calculation, especially in the form of numbers
d assumed as facts — used as a basis of reasoning, discussion, or calculation, especially in the form of numbers
-
2
Excel Class One -
3
Class One Quiz -
4
Class Two Text (Introduction to Excel )
Excel as an offline spreadsheet application used for data entry, calculations, organization, and basic analysis — the foundation every data analyst starts with.
-
5
Excel Class Two
-
6
Class Two Quiz
-
7
Class Three Text ( Using Lookups)
What is a "Lookup"?
A lookup function searches for a value in one place and returns related information from another place — the same way you'd scan a printed table to find someone's phone number from their name.
-
8
Excel Class Three A
-
9
Excel Class Three B
-
10
Class Three Quiz
-
11
WEEK 1 ASSIGNMENT
-
12
Class Four Text (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 data.
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.
-
13
Excel Class Four A
-
14
Excel Class Four B
-
15
Excel Class Four C
-
16
Class Four Quiz
-
17
Class Five 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.
-
18
Excel Class Five
-
19
Class Five Quiz
-
20
Class Six 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 sis achieved through visual representations often interactive of raw data.
-
21
Class Six Quiz
-
22
WEEK 2 ASSIGNMENT
-
23
Excel Class Six A
-
24
Excel Class Six B
-
25
Class Seven Text (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.
-
26
Excel Class Seven
-
27
Class Seven Quiz
-
28
Class Eight Text (KPIs, Metric and Slicers in Dashboard)
Metric: a measurement. It is a number that describes something that happened, such as total revenue, number of orders or average discount. A metric answers “how much?” or “how many?”
KPI (Key Performance Indicator): a metric chosen because it tracks progress toward a specific business goal. A KPI has a target and a time frame, and it triggers action when it is off track. A KPI answers “are we succeeding at what matters most?”
-
29
Excel Class Eight A
-
30
Excel Class Eight B
-
31
Excel Class Eight C
-
32
Class Eight Quiz
-
33
WEEK 3 ASSIGNMENT
-
34
Class Nine 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.
-
35
Class Nine Quiz
-
36
Excel Class Nine A
-
37
Excel Class Nine B
-
38
Class Ten Text (CORRELATION AND REGRESSIONAL ANALYSIS)
1. What is correlation?
Correlation measures how strongly two numeric variables move together in a straight-line pattern. The Pearson correlation coefficient, written r, runs from -1 to +1.
The SIGN of r tells you the direction: positive (+) means both rise together; negative (-) means one rises while the other falls. The SIZE of r (ignoring the sign) tells you the strength: the closer to 1, the tighter the points hug a straight line.
-
39
Correlation Analysis
-
40
Class Ten Quiz
-
41
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.
-
42
Introduction to SQL
-
43
Class Eleven Quiz
-
44
WEEK 4 ASSIGNMENT
-
45
Class Twelve Text(MODIFYING DATA WITHIN DATABASE)
There are three main operations: INSERT, UPDATE, and DELETE.
INSERT Statement -
46
Class Twelve Quiz
-
47
SQL Class 2
-
48
Class Thirteen Text (OPERATORS IN SQL)
Definition: Operators are symbols or keywords used in SQL (mostly in the WHERE clause and in SELECT expressions) to compare values, perform calculations, and combine conditions.
-
49
Class Thirteen Quiz
-
50
SQL Class Three
-
51
SQL Class Three B
-
52
Class Fourteen Text (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
-
53
SQL Class Four A
-
54
SQL Class Four B
-
55
Class Fourteen Quiz
-
56
WEEK 5 ASSIGNMENT
-
57
Class Fifteen Text ( SQL JOIN )
JOIN
A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table.
A join stitches two tables and puts on the same row records with matching fields: It is a way of joining two or more tables together to fetch related data.
-
58
Class Fifteen Quiz
-
59
SQL Class Five
-
60
Class Sixteen Text ( Types of SQLM Joins)
Left Outer join returns all rows from the left table with corresponding rows from the right table. If there is no matching row, NULLS are returned as value from the second table.
-
61
Class Sixteen Quiz
-
62
SQL Class Six A
-
63
SQL Class Sixx B
-
64
WEEK 6 ASSIGNMENT
-
65
Class Seventeen 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.
-
66
Class Seventeen Quiz
-
67
Class Eighteen Text (SUBQUERIES AND WINDOW FUNCTION)
Subqueries, also known as nested queries, allow you to use the result of one query within another query. There are different types of subqueries:
-
68
Class Eighteen Quiz
-
69
SQL Class Seven A
-
70
SQL Class Seven B
-
71
WEEK 7 ASSIGNMENT
-
Data Analysis 2026 (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.
