- Description
- Curriculum
- Reviews
-
1
Class One Text: Introduction to Data AnalysisData: 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
-
2
Class One Quiz -
3
Class Two Text: Introduction To Excel
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.
-
4
Class Two Video -
5
Class Two Quiz
-
6
Class Three Text(Nested IF, Value and clean functions)
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.
-
7
Class Three Video
-
8
Class Three Quiz
-
9
WEEK 1 ASSIGNMENT
-
10
Class Four Text: Conditional formatting, Sort and Filter
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.
-
11
Class Four Video
-
12
Class Four Quiz
-
13
Class Five Text: Data Cleaning in Power Query
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.
-
14
Class Five Video
-
15
Class Five Quiz
-
16
Class Six Text: Pivot Table
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.
-
17
Class Six Video
-
18
Class Six Quiz
-
19
WEEK 2 ASSIGNMENT
-
20
Class Seven Text: DATA MANIPULATION IN EXCEL
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.
-
21
Class Seven Video
-
22
Class Seven Quiz
-
23
Class Eight 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.
-
24
Class Eight Video
-
25
Class Eight Quiz
-
26
Class Night 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.
-
27
Class Nine Video
-
28
Class Nine Quiz
-
29
WEEK 3 Assignment
-
30
Class Ten Text (Pivot Tables for Business Insights)
Pivot Tables are powerful Excel tools that help you summarize, analyze, and explore large data sets quickly to answer key business questions.
-
31
Class Ten Video
-
32
Class 10 Quiz
-
33
Class Eleven Text (Continuation on 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.
-
34
Class Eleven Video
-
35
Class Eleven Quiz
-
36
Class Twelve Text (Q & A)
Questions and Answer session
-
37
Class Twelve Video
-
38
WEEK 4 ASSIGNMENT
-
39
Class Thirteen Text (Introduction to 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. The basic structure of an SQL query involves:
Querying Data
-
40
Class Thirteen Video
-
41
Class Thirteen Quiz
-
42
Class Fourteen Text (MODIFYING DATA WITHIN DATABASE)
There are three main operations: INSERT, UPDATE, and DELETE.
INSERT Statement -
43
Class Fourteen Video
-
44
Class Fourteen Quiz
-
45
Class Fifteen Text (Table designer method and Operators in SQL)
"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
-
46
Class Fifteen Video
-
47
Class Fifteen Quiz
-
48
WEEK 5 ASSIGNMENT
-
49
Class Sixteen 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
-
50
Class Sixteen Video
-
51
Class Sixteen Quiz
-
52
Class Seventeen Text (Left, Right and full Join, Group by and Having Statement)
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.
-
53
Class Seventeen Video
-
54
Class Seventeen Quiz
-
55
Class Eighteen Text: (Subqueries, Case Statement and Partition By)
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:
-
56
Class Eighteen Video
-
57
Class Eighteen Quiz
-
58
WEEK 6 ASSIGNMENT
-
59
Class Nineteen Text (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.
-
60
Class Nineteen Video
-
61
Class Nineteen Quiz
-
62
Class Twenty Text (Pivot, Unpivot, Merge and Append Queries)
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.
-
63
Class Twenty Video
-
64
Class Twenty Quiz
-
65
Class Twenty-one Text (Data Modelling)
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.
-
66
Class Twenty-One Video
-
67
Class Twenty One Quiz
-
68
Class Twenty-Two Text (Optimizes queries in Power BI)
- 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
-
69
Class Twenty- Two Video
-
70
Class Twenty-Two Quiz
-
71
Class Twenty-Three Text (Data Analysis Expression )
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.
