Data Analysis 2026 (Batch A)
- Description
- Curriculum
- Reviews
-
1Class One Text: Introduction to Data Analysis3 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
-
2Class One Quiz5 questions
-
3Class Two Text: Introduction To Excel3 Hours
Data Manipulation Techniques:
1. Text to Column: Splitting text into multiple columns using delimiters.
2. Concatenate: Combining text from multiple columns into one column.
3. Transpose: Rotating data from horizontal to vertical or vice versa.
-
4Class Two VideoPreview 3 Hours
-
5Class Two Quiz5 questions
-
6Class Three Text(Nested IF, Value and clean functions)3 Hours
Nested functions contain a function within another function. They can handle MORE
than two outcomes (A limitation of the normal IF Function)
Sometimes nested functions can contain several functions nested within each other.
-
7Class Three VideoPreview 3 Hours
-
8Class Three Quiz5 questions
-
9WEEK 1 ASSIGNMENTAssignment
-
10Class Four Text: Conditional formatting, Sort and Filter3 Hours
Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.
-
11Class Four VideoPreview 3 Hours
-
12Class Four Quiz5 questions
-
13Class Five Text: Data Cleaning in Power Query3 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.
-
14Class Five VideoPreview 3 Hours
-
15Class Five Quiz5 questions
-
16Class Six Text: Pivot Table3 Hours
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.
-
17Class Six VideoPreview 3 Hours
-
18Class Six Quiz5 questions
-
19WEEK 2 ASSIGNMENTAssignment
-
20Class Seven Text: DATA MANIPULATION IN EXCEL3 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.
-
21Class Seven VideoPreview 3 Hours
-
22Class Seven Quiz5 questions
-
23Class Eight Text (DATA VISUALIZATION)3 Hours
• 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.
-
24Class Eight Video3 Hours
-
25Class Eight Quiz5 questions
-
26Class Night Text (BUILDING OF DASHBOARD AND SLICERS3 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.
-
27Class Nine Video3 Hours
-
28Class Nine Quiz5 questions
-
29WEEK 3 AssignmentAssignment
-
30Class Ten Text (Pivot Tables for Business Insights)3 Hours
Pivot Tables are powerful Excel tools that help you summarize, analyze, and explore large data sets quickly to answer key business questions.
-
31Class Ten Video3 Hours
-
32Class 10 Quiz5 questions
-
33Class Eleven Text (Continuation on Dashboard)3 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.
-
34Class Eleven Video3 Hours
-
35Class Eleven Quiz5 questions
-
36Class Twelve Text (Q & A)3 Hours
Questions and Answer session
-
37Class Twelve Video3 Hours
-
38WEEK 4 ASSIGNMENTAssignment
-
39Class Thirteen Text (Introduction to SQL)3 Hours
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
-
40Class Thirteen Video3 Hours
-
41Class Thirteen Quiz5 questions
-
42Class Fourteen Text (MODIFYING DATA WITHIN DATABASE)3 Hours
There are three main operations: INSERT, UPDATE, and DELETE.
INSERT Statement -
43Class Fourteen VideoVideo lesson
-
44Class Fourteen Quiz5 questions
-
45Class Fifteen Text (Table designer method and Operators in SQL)3 Hours
"Table Designer" feature in SQL Server Management Studio! That's a very useful feature, especially if you're new to SQL. It allows you to visually create a table, instead of writing the "CREATE TABLE" command
-
46Class Fifteen Video3 Hours
-
47Class Fifteen Quiz5 questions
-
48WEEK 5 ASSIGNMENTAssignment
-
49Class Sixteen Text (Logical operators or operational operators)3 Hours
(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
-
50Class Sixteen Video3 Hours
-
51Class Sixteen Quiz5 questions
-
52Class Seventeen Text (Left, Right and full Join, Group by and Having Statement)3 Hours
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.
-
53Class Seventeen Video3 Hours
-
54Class Seventeen Quiz5 questions
-
55Class Eighteen Text: (Subqueries, Case Statement and Partition By)3 Hours
SUBQUERIES
Subqueries, also known as nested queries, allow you to use the result of one query within another query. There are different types of subqueries:
-
56Class Eighteen Video3 Hours
-
57Class Eighteen Quiz5 questions
-
58WEEK 6 ASSIGNMENTAssignment
-
59Class Nineteen Text (INTRODUCTION TO POWERBI)3 Hours
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.
-
60Class Nineteen Video3 Hours
-
61Class Nineteen Quiz5 questions
-
62Class Twenty Text (Pivot, Unpivot, Merge and Append Queries)3 Hours
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.
-
63Class Twenty Video3 Hours
-
64Class Twenty Quiz5 questions
-
65Class Twenty-one Text (Data Modelling)3 Hours
Data modelling
A Data model is a collection of tables and relationships that can be used to create a report.
Is techniques use in creating relationship between two or more tables.
-
66Class Twenty-One Video3 Hours
-
67Class Twenty One Quiz5 questions
-
68Class Twenty-Two Text (Optimizes queries in Power BI)Text lesson
- Faster reports & less complexity
2. Fact Table- What: Transactional data (numbers, metrics)
- Examples: Sales, Orders, Website clicks
- Contains:
- Measures (e.g., sales amount, units)
- Foreign keys to dimensions
-
69Class Twenty- Two Video3 Hours
-
70Class Twenty-Two Quiz5 questions
-
71Class Twenty-Three Text (Data Analysis Expression )3 Hours
Data Analysis Expression commonly known as DAX is the formula languages that derives PowerBI.
-
Data Analysis 2026 (Batch A)
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.