Data Analysis 2024 (BATCH C)
- Description
- Curriculum
- Reviews
-
1Class One; Text ( Introduction to Data Analysis)3 Hours
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.
-
2Class One; Quiz5 questions
-
3Class Two; Text (Introduction to Basic Excel formula and functions)3 hours
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).
-
4Class Two Video Part 1Preview Video lesson
-
5Class Two Video Part 2Video lesson
-
6Class Two Video Part 3Video lesson
-
7Class Two Quiz5 questions
-
8Class Three; Text (Splitting, Transpose, Sort and Filter)3 hours
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.
-
9Class Three Video Part 1Video lesson
-
10Class Three Video Part 2Video lesson
-
11Class Three Video Part 3Preview Video lesson
-
12Class Three Quiz5 questions
-
13WEEK 1 ASSIGNMENTAssignment
-
14Class Four; Text (Drop-down list, Ifstatement, Join and Remove Extra rows)3 hours
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.
-
15Class Four Video Part 1Video lesson
-
16Class Four Video Part 2Video lesson
-
17Class Four Video Part 3Video lesson
-
18Class Four Video Part 4Video lesson
-
19Class Four Video Part 5Video lesson
-
20Class Four Video Part 6Preview Video lesson
-
21Class Four Quiz5 questions
-
22Class Five; Text (VLOOKUP , Proper function, Clean Function, Value Function, Trim Function and Conditional Formatting)Preview 3 hours
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:
-
23Class Five Video Part 1Video lesson
-
24Class Five Video Part 2Video lesson
-
25Class Five Video Part 3Video lesson
-
26Class Five Video Part 4Video lesson
-
27Class Five Video Part 5Video lesson
-
28Class Five Video Part 6Preview Video lesson
-
29Class Five Quiz5 questions
-
30Class Six; Text (Pivot Table and Chart)3 hours
.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.
-
31Class Six Video Part 1Video lesson
-
32Class Six Video Part 2Video lesson
-
33Class Six Video Part 3Video lesson
-
34Class Six Video Part 4Video lesson
-
35Class Six Video Part 5Preview Video lesson
-
36Class Six Quiz5 questions
-
37WEEK 2 ASSIGNMENTAssignment
-
38Class Seven ; Text(DATA CLEANING)3 hours
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.
-
39Class Seven Video Part 1Video lesson
-
40Class Seven Video Part 2Video lesson
-
41Class Seven Video Part 3Video lesson
-
42Class Seven Video Part 4Preview Video lesson
-
43Class Seven Quiz5 questions
-
44Class Eight; Text (Power Query Editor)3 hours
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.
-
45Class Eight Video Part 1Video lesson
-
46Class Eight Video Part 2Video lesson
-
47Class Eight Video Part 3Video lesson
-
48Class Eight Video Part 4Video lesson
-
49Class Eight Video Part 5Preview Video lesson
-
50Class Eight Quiz5 questions
-
51Class Nine: Text (Data Cleaning with power Query Editor continuation)3 hours
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.
-
52Class Nine Video Part 1Video lesson
-
53Class Nine Video Part 2Video lesson
-
54Class Nine Video Part 3Preview Video lesson
-
55Class Nine Quiz5 questions
-
56WEEK 3 ASSIGNMENTAssignment
-
57Class Ten ; Text (BUILDING OF DASHBOARD AND SLICERS)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.
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.
-
58Class Ten Video Part 1Video lesson
-
59Class Ten Video Part 2Video lesson
-
60Class Ten Video Part 3Video lesson
-
61Class Ten Video Part 4Video lesson
-
62Class Ten Video Part 5Video lesson
-
63Class Ten Quiz5 questions
-
64Class Eleven; Text ( Building Dashboard with a Slicer )Preview 3 hours
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.
-
65Class Eleven Video Part 1Video lesson
-
66Class Eleven Video Part 2Video lesson
-
67Class Eleven Video Part 3Video lesson
-
68Class Eleven Quiz5 questions
-
69Class Twelve; Text (Correlation in excel)3 hours
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.
-
70Class Twelve Video Part 1Video lesson
-
71Class Twelve QuizQuiz
-
72WEEK 4 ASSIGNMENTAssignment
-
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.