Data Analysis 2026 (Batch B)
- Description
- Curriculum
- Reviews
-
1Class One Text (INTRODUCTION TO DATA ANALYSIS)3 Hours
Data: a representation of information or material recorded and known or assumed as facts and used as a basis of reasoning, discussion or calculation represented especially in the form of numbers
-
2Excel Class OneVideo lesson
-
3Class Two Text (Formulae and Functions)2 Hours
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.
We clarified the difference between formulas and functions, highlighting how they're often used interchangeably in everyday usage.
-
4Excel Class TwoVideo lesson
-
5Class Two Quiz5 questions
-
6Class Three Text (Using Lookups)2 Hours
The term ‘Look up’ as used in the context, means to look up (search) from a list.
There are two main LOOKUP functions that can be used within Excel. These are:
HLOOKUP
VLOOKUP
XLOOKUP
-
7Excel Class ThreeVideo lesson
-
8Class Three Quiz5 questions
-
9WEEK 1 ASSIGNMENTAssignment
-
10Class Four Text (If Statement, Nested If and Functions for Data Cleaning)2 Hours
An IF statement in Excel is a logical function that tests a condition and returns one value if true and another value if false.
-
11Excel Class FourVideo lesson
-
12Class Four Quiz5 questions
-
13Class Five Text (Sort and Filters, Removing extra rows, Conditional formatting, removing duplicate)2 Hours
Sorts: Arrange data in a specific order (ascending, descending, alphabetical, etc.) to organize and analyze it.
Filters: Show only specific data that meets certain conditions, hiding the rest. This helps focus on relevant information
-
14Excel Class FiveVideo lesson
-
15Class Five Quiz5 questions
-
16Class Six Text: (Data Cleaning in Power Query Editor)2 Hours
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.
-
17Excel Class SixVideo lesson
-
18Class Six Quiz5 questions
-
19WEEK 2 ASSIGNMENTAssignment
-
20Class Seven Text: (-DATA MANIPULATION IN EXCEL)2 Hours
Pivot tables are a powerful tool for data manipulation.
Data Manipulation with Pivot Tables:
1. Summarize large datasets: Pivot tables help you summarize large datasets by grouping and aggregating data.
2. Analyze data from different angles: Pivot tables enable you to rotate and pivot your data to analyze it from different perspectives.
3. Create custom calculations: Pivot tables allow you to create custom calculations, such as calculated fields and measures.
-
21Excel Class SevenVideo lesson
-
22Class Seven Quiz5 questions
-
23Class Eight Text (Building Dashboard in Excel)2 Hours
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.
It's a great way to get a quick overview of your data and identify areas that need attention. Dashboards are often used in business intelligence and data analytics applications.
-
24Excel Class EightVideo lesson
-
25Class Eight Quiz5 questions
-
26Class Night Text (More on Data manipulation and Dashboard)2 Hours
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.
-
27Excel Class NineVideo lesson
-
28Class Nine Quiz5 questions
-
29WEEK 3 ASSIGNMENTAssignment
-
30Class Ten Text (More on Data Manipulation and Dashboard)2 Hours
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.
-
31Excel Class TenVideo lesson
-
32Class Ten Quiz5 questions
-
33Class Eleven Text (Dashboard, Metric and Slicers)2 Hours
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
-
34Excel Class ElevenVideo lesson
-
35Class Twelve Text(Correlation and Regression)2 Hours
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
-
36Class Thirty Text(Statistical Analysis)2 Hours
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.
-
37Class Forty Text(HYPOTHESIS TEST)2 Hours
A hypothesis test for a sample mean is a statistical procedure used to determine whether a sample mean is significantly different from a known or hypothesized population mean.
-
Data Analysis 2026 (Batch B)
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.