- Description
- Curriculum
- Reviews
-
1
Class One; Text ( Introduction to Data Analysis)INTRODUCTION TO DATA ANALYSIS
Data analysis refer to the process of inspecting, cleaning and modelling data with the goal of extracting useful information and making informed decisions.
It involves applying statistical and mathematical techniques to uncover patterns, trends, and insight within data set.
-
2
Class One; Quiz -
3
Class Two; Text (Introduction to Basic Excel formula and functions)
Excel sheet consist of cells in which you can enter and calculate data. The cells are organized into columns and rows.
Excel is used for the followings; Data entry, data management, accounting, financial and data analysis, charting and graphing, time management etc
COLUMNS--------Are alphabet line (A—XFD) There are 16,384 columns in a single cell
ROWS---------Are numeric line (1---more than 1 million).
-
4
Class Two Video Part 1 -
5
Class Two Video Part 2
-
6
Class Two Video Part 3
-
7
Class Two Quiz
-
8
Class Three; Text (Splitting, Transpose, Sort and Filter)
SPLIT FUNCTION
The split function is used to split a string into multiple parts based on a delimiter. A delimiter is a character that separates parts of a string. For example, the split function could be used to split a first name and last name into two separate columns. If you had a column of data with full names, like "Monday Osazuwa", the split function could be used to separate "Monday" and "Osazuwa" into two columns.
-
9
Class Three Video Part 1
-
10
Class Three Video Part 2
-
11
Class Three Video Part 3
-
12
Class Three Quiz
-
13
WEEK 1 ASSIGNMENT
-
14
Class Four; Text (Drop-down list, Ifstatement, Join and Remove Extra rows)
DROP DOWN LIST
A drop-down list is a feature in Excel that allows you to select a value from a pre-defined list of options. Drop-down lists are useful for controlling data entry, ensuring consistency, and preventing errors. They can also make it easier for users to enter data, as they don't have to type values manually.
-
15
Class Four Video Part 1
-
16
Class Four Video Part 2
-
17
Class Four Video Part 3
-
18
Class Four Video Part 4
-
19
Class Four Video Part 5
-
20
Class Four Video Part 6
-
21
Class Four Quiz
-
22
Class Five; Text (VLOOKUP , Proper function, Clean Function, Value Function, Trim Function and Conditional Formatting)
Using Lookups
The term ‘Look up’ as used in the examinations, means to look up (search) from a list.
There are two main LOOKUP functions that can be used within Excel. These are:
-
23
Class Five Video Part 1
-
24
Class Five Video Part 2
-
25
Class Five Video Part 3
-
26
Class Five Video Part 4
-
27
Class Five Video Part 5
-
28
Class Five Video Part 6
-
29
Class Five Quiz
-
30
Class Six; Text (Pivot Table and Chart)
.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.
-
31
Class Six Video Part 1
-
32
Class Six Video Part 2
-
33
Class Six Video Part 3
-
34
Class Six Video Part 4
-
35
Class Six Video Part 5
-
36
Class Six Quiz
-
37
WEEK 2 ASSIGNMENT
-
38
Class Seven ; 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 dataset. 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.
-
39
Class Seven Video Part 1
-
40
Class Seven Video Part 2
-
41
Class Seven Video Part 3
-
42
Class Seven Video Part 4
-
43
Class Seven Quiz
-
44
Class Eight; Text (Power Query Editor)
POWER QUERY EDITOR
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.
Power Query Editor has several functions for data analysis, including:
Importing Data from Multiple Sources: Power Query Editor supports importing data from various sources such as databases, files, web pages, and even other Microsoft applications.
Transforming and Cleaning Data: The "Transform" feature in Power Query Editor enables users to filter, sort, and group data.
-
45
Class Eight Video Part 1
-
46
Class Eight Video Part 2
-
47
Class Eight Video Part 3
-
48
Class Eight Video Part 4
-
49
Class Eight Video Part 5
-
50
Class Eight Quiz
-
51
Class Nine: Text (Data Cleaning with power Query Editor continuation)
Trim:
- Select the column you want to trim.
- Go to "Transform" tab, click to highlight the "Text Column" then click "Trim".
- Alternatively, right-click on the column the click "Transform" and select "Trim".
Replace value:
- Select the column you want to replace values in. right click and go to replace values and then enter the value to find and also the value that will replace it and click Ok.
-
52
Class Nine Video Part 1
-
53
Class Nine Video Part 2
-
54
Class Nine Video Part 3
-
55
Class Nine Quiz
-
56
WEEK 3 ASSIGNMENT
-
57
Class Ten ; 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.
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.
-
58
Class Ten Video Part 1
-
59
Class Ten Video Part 2
-
60
Class Ten Video Part 3
-
61
Class Ten Video Part 4
-
62
Class Ten Video Part 5
-
63
Class Ten Quiz
-
64
Class Eleven; Text ( Building Dashboard with a Slicer )
SLICERS
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.
-
65
Class Eleven Video Part 1
-
66
Class Eleven Video Part 2
-
67
Class Eleven Video Part 3
-
68
Class Eleven Quiz
-
69
Class Twelve; Text (Correlation in excel)
Correlation analysis measures the strength and direction of the linear relationship between two variables. It gives you a correlation coefficient (usually "r") that ranges from -1 to 1. The closer the value is to 1, the stronger the positive correlation is between the variables; the closer the value is to -1, the stronger the negative correlation is. However, correlation analysis doesn't tell you why two variables are related.
-
70
Class Twelve Video Part 1
-
71
Class Twelve Quiz
-
72
WEEK 4 ASSIGNMENT
-
Data Analysis 2024 (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.
