Data Analysis 2024 (BATCH C)
- 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
-
73
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
-
74
Class Thirteen Video Part 1
-
75
Class Thirteen Video Part 2
-
76
Class Thirteen Video Part 3
-
77
Class Thirteen Quiz
-
78
Class Fourteen; Text(Modify data in database)
Modifying data in database
There are three main operations:
INSERT, UPDATE, and DELETE.
-
79
Class Fourteen Video Part 1
-
80
Class Fourteen Video Part 2
-
81
Class Fourteen Video Part 3
-
82
Class Fourteen Quiz
-
83
Class Fifteen; Text(TABLE DESIGNER METHOD 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. It's a quick and easy way to create tables, but it's not as powerful as writing the command yourself.
-
84
Class Fifteen Video Part 1
-
85
Class Fifteen Video Part 2
-
86
Class Fifteen Video Part 3
-
87
Class Fifteen Video Part 4
-
88
Class Fifteen Video Part 5
-
89
Class Fifteen Quiz
-
90
WEEK 5 ASSIGNMENT
-
91
Class Sixteen Text; (OPERATORS IN SQL)
Comparison operators (Greater than”>”, Less than “<”, Equal to “=”, Not equal to “!=” “<>”)
Arithmetic operators (Additions, subtractions, division and multiplications)
Logical operators or operational operatorss (And, Or, Between, In, Like, Not like,
-
92
Class Sixteen Video Part 1
-
93
Class Sixteen Video Part 2
-
94
Class Sixteen Video Part 3
-
95
Class Sixteen Video Part 4
-
96
Class Sixteen Quiz
-
97
Class Seventeen Text; (LOGICAL OPERATORS OR OPERATIONAL OPERATORS)
Logical operators or operational operators comprises;
(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
False result—condition not satisfied
True + False = False
False + True = False
False + False = False
-
98
Class Seventeen Video Part 1
-
99
Class Seventeen Video Part 2
-
100
Class Seventeen Video Part 3
-
101
Class Seventeen Video Part 4
-
102
Class Seventeen Quiz
-
103
Class Eighteen Text; ( JOIN IN SQL)
JOIN
A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table.
A join stitches two tables and puts on the same row records with matching fields: It is a way of joining two or more tables together to fetch related data.
-
104
Class Eighteen Video Part 1
-
105
Class Eighteen Video Part 2
-
106
Class Eighteen Video Part 3
-
107
Class Eighten Video Part 4
-
108
Class Eighteen Video Part 5
-
109
Class Eighteen Quiz
-
110
WEEK 6 Assignment
-
111
Class Nineteen Text; Continuation of Types of Join
2). 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.
-
112
Class Nineteen Video Part 1
-
113
Class Nineteen Video Part 2
-
114
Class Nineteen Video Part 3
-
115
Class Nineteen Video Part 4
-
116
Class Nineteen Video Part 5
-
117
Class Nineteen Quiz
-
118
Class Twenty Text: (SUBQUERIES AND TEMPORARY TABLE)
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:
Subqueries are a powerful tool that allow you to use the results of one query as part of another query. Subqueries are sometimes called "nested queries" because they're nested within another query. In the example we just looked at, the subquery is nested within the main query.
-
119
Class Twenty Video Part 1
-
120
Class Twenty Video Part 2
-
121
Class Twenty Video Part 3
-
122
Class Twenty Video Part 4
-
123
Class Twenty Video Part 5
-
124
Class Twenty Quiz
-
125
Class Twenty-One; Text(PARTITION BY AND CTE)
The 'PARTITION BY' clause in SQL is a subclause of the 'OVER' clause. It's used to split a large table into smaller, more manageable partitions. Each partition is then processed for the function present in the 'OVER()' clause.
-
126
Class Twenty-One Video Part 1
-
127
Class Twenty- One Video Part 2
-
128
Class Twenty-One Video Part 3
-
129
Class Twenty- One Quiz
-
130
WEEK 7 Assignment
-
131
Class Twenty-Two: 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.
-
132
Class Twenty - Two Video Part 1
-
133
Class Twenty- Two Video Part 2
-
134
Class Twenty -Two Video Part 3
-
135
Class Twenty - Two Video Part 4
-
136
Class Twenty- Two Quiz
-
137
Class Twenty-Three: Text (Power Query Editor)
Power BI Desktop also includes the Power Query Editor, which opens in a separate window. In Power Query Editor, you can build queries and transform data, then load the refined data model into Power BI Desktop to create reports. Use Power Query Editor to connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.
-
138
Class Twenty- Three Video Part 1
-
139
Class Twenty- Three Video Part 2
-
140
Class Twenty- Three Video Part 3
-
141
Class Twenty- Three Video Part 4
-
142
Class Twenty- Three Video Part 5
-
143
Class Twenty-Three Quiz
-
144
Class Twenty- Four: Text(Transpose, Pivot and Unpivot data)
Unpivoting data, also known as "melting" or "normalizing," transforms data from a wide format to a long format, making it more suitable for analysis.
This can be use when data is gotten from any data source but it is most often use when data was imported from Excel sheet.
-
145
Class Twenty- Four Video Part 1
-
146
Class Twenty- Four Video Part 2
-
147
Class Twenty- Four Video Part 3
-
148
Class Twenty- Four Video Part 4
-
149
Class Twenty- Four Quiz
-
150
WEEK 8 ASSIGNMENT
-
151
Class Twenty-Five: Text (Append Query, Merge Query and Data Modelling)
Appending is to join table vertically
-
152
Class Twenty- Five Video Part 1
-
153
Class Twenty-Five Video Part 2
-
154
Class Twenty-Five Video Part 3
-
155
Class Twenty-Five Video Part 4
-
156
Class Twenty-Five Video Part 5
-
157
Class Twenty-Five Quiz
-
158
Class Twenty- Six; Text (Data Analysis Expression )
Data Analysis Expression commonly known as DAX is the formula languages that derives PowerBI.
-
159
Class Twenty-Six Video Part 1
-
160
Class Twenty-Six Video Part 2
-
161
Class Twenty-Six Video Part 3
-
162
Class Twenty- Six Quiz
-
163
Class Twenty-Seven; 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.
-
164
Class Twenty-seven Video Part 1
-
165
Class Twenty-seven Video Part 2
-
166
Class Twenty-seven Video Part 3
-
167
Class Twenty-Seven Quiz
-
168
WEEK 9 ASSIGNMENT
-
169
Class Twenty-eighth; Text(Assignment Correction and 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, maps, and graphs.
-
170
Class Twenty-eight Video Part 1
-
171
Class Twenty-eight Video Part 2
-
172
Class Twenty-eight Video Part 3
-
173
Class Twenty-Nine; Text (Continuation of PowerBI dashboard)
A Power BI dashboard is a centralized platform that displays key performance indicators (KPIs), metrics, and data visualizations to provide insights and support data-driven decision-making.
-
174
Class Twenty-Nine Video Part 1
-
175
Class Twenty-Nine Video Part 2
-
176
Class Twenty-Nine Video Part 3
-
177
Class Twenty-Nine Video Part 4
-
178
Class Twenty-Nine Video Part 5
-
179
Class Twenty-Nine Quiz
-
180
Class Thirty; Text (Introduction to Tableau)
WHAT IS TABLEAU
Tableau is a data analytical platform.
Tableau is a software company that offers collaborative data visualization software for organizations working with business information analytics. Organizations use Tableau to visualize data and reveal patterns for analysis in business intelligence, making the data more understandable.
-
181
Class Thirty Video Part 1
-
182
Class Thirty Video Part 2
-
183
Class Thirty Video Part 3
-
184
Class Thirty Video Part 4
-
185
Class Thirty Video Part 5
-
186
Class Thirty Quiz
-
187
Class Thirty - One; Text (Calculated Field)
A calculated field in Tableau is a custom field that you create by using a combination of the values in your data source and a formula that you define. You can use a calculated field to perform calculations, such as aggregations, logical operations, or string manipulations. Calculated fields are very flexible and can be used in a variety of ways, such as creating new measures, grouping data, or filtering data.
-
188
Class Thirty - One Video Part 1
-
189
Class Thirty - One Video Part 2
-
190
Class Thirty - One Video Part 3
-
191
Class Thirty - One Quiz
-
192
Class Thirty - Two; Text (Creating story in Tableau and key points to be consider for presentation)
The "Story" feature in Tableau is a great way to create a narrative with your data. You can use the Story feature to combine multiple dashboards into a single story, and you can add text to explain the story.
-
193
Class Thirty - two Video Part 1
-
194
Class Thirty - two Video Part 2
-
195
Class Thirty - two Video Part 3
-
196
Class Thirty - two Video Part 4
-
197
Class Thirty - Two Quiz
-
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.
