Data Analysis
- Description
- Curriculum
- Reviews
Unlock the Power of Data with Our Data Analysis Course! Dive into the world of data analysis and gain valuable skills to interpret and visualize data effectively. Whether you’re a beginner or looking to enhance your analytical abilities, our course offers a comprehensive curriculum covering Excel, statistical analysis, data visualization, and more. Join us and take the first step towards becoming a data-driven decision-maker!
-
1
Introduction to Data analyticsAs a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database. For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site
-
2
Introduction to Excel (Basic Excel Formula)
INTRODUCTION TO EXCEL
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
(i) COLUMNS--------Are alphabet line (A—XFD) There are 16,384 columns in a single cell
(II) ROWS---------Are numeric line (1---more than 1 million).
-
3
Excel Functions
Functions is built set of instructions. (In functions excel gives a set of instructions to arrive at the answer).
The set of instruction given by excel to arrived at the answer is called function syntax.
-
4
Data Cleaning in Excel
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, removing etral rows, removing unprintable characters, correcting spelling mistakes, standardizing date formats, and so on.
-
5
Conditional Formatting
CONDITIONAL FORMATTING
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.
-
6
Table and Chart
TABLE AND CHART
TABLE
Tables are used to organize data that is too detailed or complicated to be described adequately in the text, allowing the reader to quickly see the results. They can be used to highlight trends or patterns in the data and to make a manuscript more readable by removing numeric data from the text.
-
7
PIVOT TABLE AND PIVOT 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.
-
8
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.
-
9
Summary of Day 1 to day 8
Introduction
As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database. For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site
-
10
Introduction to SQL (Structured Query Language)
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
-
11
How to bring data base files into data base in SQL and How to delete a column in SQL
Bringing a file with the ".bak" extension into SQL Server;
First, you'll need to log into SQL Server Management Studio (SSMS) and connect to the database server. Next, right-click on the database you want to import the ".bak" file into and a dialogue box will appear, choose device and click 3 dots at the right side of device to add file and browse to the location of the file. Then select the file name and click Ok.
NOTE; It is advisable you save the ".bak file" on a local disk(c) insed users folder.
-
12
OPERATORS IN SQL
An operator is a reserved word or a character that is used to query our database in a SQL expression. To query a database using operators, we use a WHERE clause. Operators are necessary to define a condition in SQL, as they act as a connector between two or more conditions.
-
13
LIKE OPERATORS AND JOIN IN SQL
LIKE OPERATORS (WILD CARD % %) A wild card is used to substitute one or more characters in a string. They are used with Like operator. The Like operator is used in a WHERE clause to search for a specific pattern in a column.
-
14
GROUP BY STATEMENT, HAVING STATEMENT, SUBQUERIES AND CASE STATEMENT
"GROUP BY" is another built-in function in SQL that allows you to group your data based on a specific field. For example, you could use "GROUP BY" to group your data by the "department" field in your "inventory" table
-
15
Temporary Table (TempTable), Partition By, Common Table Expression (CTE) and Views
Temporary Table (TempTable)
A temporary table is a base table that is not stored in the database but instead exists only while the database session in which it was created is active. At first glance, this may sound like a view, but views and temporary tables are rather different: ▪ A view exists only for a single query.
-
16
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.
-
17
DATA VISUALIZATION IN TABLEAU
Data visualization is the graphical representation of information and data. By using visual elements like charts, graphs, and maps, data visualization tools provide an accessible way to see and understand trends, outliers, and patterns in data.
-
18
Creating Calculated Field and Visualization
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.
-
19
CREATING A BINS IN TABLEAU AND VISUALIZATION
Tableau Bins are equal-sized containers that store data values that correspond to or fit within the Bin Size. Tableau Bins divide a set of data into groups of equal intervals or sizes, resulting in a systematic distribution of data.
-
20
TABLE DESIGNER METHOD IN SQL AND REVISION ON JOIN
"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.
-
21
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.
-
22
SHAPING DATA WITH 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.
-
23
Append and Merge Query
To append data, under home tab click append query and select append query as new and a dialog box will appear with options; (a) Append with two tables (b) Append with three or more tables. Select base on the number of tables you want to append. After selecting three or more tables then two boxes will appear, the one at the left with all the names of your table and the second at the right with one table name, highlight all the table at the left box and click add in between the table to move them to the right-side box then click Ok to append your table.
-
24
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.
Modeling data is about establishing and maintaining relationships so that you can effectively visualize the data in the form that your business requires.
The tables in a data model are called “Fact” tables and “Dimension” table.
A fact table contains quantitative information like sales transactions or customer purchase While a dimension table contains descriptives information like customer demographics or product categories.
-
Data Analysis
₦150,000
-
What is Prerequisite coursesA prerequisite is a specific course that you must complete before you can take another course at the next grade level.
