- 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.
-
72
Class Twenty-Three Video
-
73
Class Twenty-Three Quiz
-
74
Class Twenty-Four Text (CREATING CHART FOR DASHBOARD )
In Power BI, charts are a powerful tool for visualizing and manipulating data in the Report View. Here's a step-by-step guide on how to use charts and drag columns to the x and y axes:
-
75
Class Twenty-Four Video
-
76
Class Twenty-Four Quiz
-
77
Class Twenty- Five Text (DASHBARD)
The primary goal of a dashboard is to monitor and interpret key facts as quickly as possible. User interactions are limited by insights that are highly curated toward the audience. Report visuals are focused, self-explanatory, and clearly labeled.
-
78
Class Twenty-Five Video
-
79
Class Twenty-Five Quiz
-
80
Class Twenty-Six Text (CORRELATION ANALYSIS)
Correlation analysis also known as bivariate, is primarily concerned with finding out whether a relationship exist between variables and then determining the magnitude and action of that relationship.
-
81
Class Twenty-Six Video
-
82
Class Twenty-Six Quiz
-
83
Class Twenty-Seven Text (Introduction to Python)
PYTHON FOR DATA ANALYSIS
Download Anaconda and install Jupyter notebook.
Python Basics:
Variable: A Variable is like a container that is used to store data or values.
· A variable is assigned names which is used to refer its values
· A variable is mutable. Ie its values can change anytime.
For example:
my_list = [1, 2, 3]
my_list[0] = 10 # modify the first element
print(my_list) # [10, 2, 3]
-
84
Class Twenty-Seven Video
-
85
Class Twenty -Seven Quiz
-
86
Class Twenty-Eight Text(INPUT FORMAT and OPERATORS IN PYTHON)
In Python, the input format refers to the way data is received from the user or an external source. Here are some common input formats:
Firstname = input (‘what is your firstname?’)
Lastname = input (‘what is your lastname?’)
Print (f ‘your firstname is {firstname} and your lastname is {lastname} ‘)
-
87
Class Twenty-Eight Video
-
88
Class Twenty-Eight Quiz
-
89
Class Twenty-Nine Text (IF STATEMENT)
The use of if, elif and nested if statements in python is critical for data analysis, as they allow you to implement decision making logic in your code. These constructs are powerful tools for filtering and processing data, making them valuable for any data analyst working with python.
If, elif, and nested if is a conditional logic data cleaning and processing.
-
90
Class Twenty-Nine Video
-
91
Class Twenty Nine Quiz
-
92
Class Thirty Text: (DATA STRUCTURE)
TYPES
1. LIST 2. TUPLE 3. DICTIONARY 4. SET
A list is a collection of values that can be of the same data type or not. It is mutable, it item can be modified or change.
-
93
Class Thirty Video
-
94
Class Thirty Quiz
-
95
Class Thirty- One Text: (Dictionary)
DICTIONARY
In Python, a dictionary is a mutable data type that stores mappings of unique keys to values.
Dictionaries are also known as associative arrays, hash tables, or maps in other programming languages.
A dictionary consists of key-value pairs, where each key is unique and maps to a specific value.
-
96
Class Thirty-One Video
-
97
Class Thirty One Quiz
-
98
Class Thirty-two Text:(Data Manipulation and visualization )
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
-
99
Class Thirty two video
-
100
Class Thirty Two Quiz
-
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.
