Data Analysis Training Course – SuperbSolve Technologies Skills Learning Platform

About Course

Welcome

Welcome to this comprehensive course on Data Analysis. This course covers a wide range of topics, from fundamental concepts to advanced techniques, ensuring a thorough understanding of data management, analysis, and visualization. With this course, you would be equipped with the essential skills and knowledge required to excel in the field of data analysis.

Learning Outcomes

By the end of this course, you will:

Gain a solid understanding of data fundamentals and collection methods.
Be proficient in using Microsoft Excel for data analysis and visualization.
Acquire the skills to perform complex data analysis with SPSS.
Develop the ability to write SQL queries for efficient data retrieval and manipulation.
Create dynamic and interactive visualizations using Power BI.
Bonus: Understand and apply Python programming for advanced data analysis.

Duration

10 weeks (Average duration for self-paced learners)
8 weeks (Duration for our scholarship beneficiaries)

Course Features

Self-paced (you can study the lessons independently at your own pace)
Online live classes (you can request for up to 10 free online live classes of 60 minutes per class)
9 Topics (each topic is composed of lessons)
Quizzes (at least one quiz is available in each topic)
Exercises
Assignments
Final Examination

Why take the course?

Expert Instructors: Learn from the lessons created by our experienced professionals with real-world expertise.
Hands-on Practice: Engage in practical exercises and projects to reinforce learning.
Comprehensive Curriculum: Cover all essential aspects of data analysis in one training course.
Certification: Receive a certificate upon successful completion of the training course.

Enroll now to embark on your journey to becoming a proficient data analyst.

Happy learning!

1. Fundamentals of Data
2. Data Collection
3. Introduction to Data Analysis
4. Data Analysis and Visualization with Microsoft Excel
5. Inferential Data Analysis and Interpretation
6. Data Analysis with SPSS
7. SQL for Data Analysis
8. Power BI for Data Analysis and Visualization
Bonus Topic: Fundamentals of Python Programming for Data Analysis

Course Content

Topic 1: Fundamentals of Data

What is Data?
Importance of Data
Main Types of Data- Qualitative and Quantitative Data
Data Classification Based on Source
Data Classification Based on Level of Measurement
Common Data Types in Programming
Quiz 1: Fundamentals of Data

Topic 2: Data Collection

What is Data Collection?
The Data Collection Process
Methods of Data Collection
Tools for Digital Data Collection
Questionnaire for Data Collection
Types of Questionnaire
Useful Tips for Questionnaire Design
Reliability and Validity of A Questionnaire
Quiz 2: Data Collection
Practical Session 1: Questionnaire Design for Data Collection
Practical Session 2: Working with Google Form for Data Collection
**Assignment- Questionnaire Design in Google Form

Topic 3: Introduction to Data Analysis

What is Data Analysis?
Benefits of Data Analysis
Data Analysis Processes
Types of Data Analysis
Descriptive Data Analysis
Parametric Tests in Inferential Data Analysis
Non-Parametric Tests in Inferential Data Analysis
Software Packages for Data Analysis
Programming Languages for Data Analysis
Quiz 3: Introduction to Data Analysis

Topic 4: Data Analysis and Visualization with Microsoft Excel

Introduction to Microsoft Excel
Introduction to Google Sheets
Some Key Terms Related to the Use of Microsoft Excel
Practical Session 1: Descriptive Analysis with Excel
Practical Session 2: Addition of More Data and Generation of Frequency Table
Introduction to Menu Bar in Excel
The Home Tab in Excel Menu Bar
Formula Bar and Name Box
Worksheet Tabs Bar
Status Bar in Excel
Auto Fill Using the Fill Handle in Excel
Some Keyboard Shortcuts in Excel
Entering Formula in Excel
Using Excel Basic Functions
The RANK and RANK.EQ Functions
Quiz 4a: Data Analysis with Microsoft Excel
Other Important Excel Functions- Part A
Other Important Excel Functions- Part B
Other Important Excel Functions- Part C
Insert Function and Its Dialog Box
CONCATENATE Or CONCAT Function
**Assignment on Excel Functions
Getting Started with Charts in Excel
Practical Session 3: Charts Creation
Practical Session 4: Creation of Pie Chart
Practical Session 5: Bar Chart Creation
Introduction to Pivot Table
Creating PivotChart
“Slicer” Feature in Excel
Class Exercise
Solution to Class Exercise

Topic 5: Inferential Data Analysis and Interpretation

Revision and Exercise Week
In this revision and exercise week, you are expected to revisit and revise every lesson that you have learned in this training so far, and as well work on the exercises that are made available to you accordingly. Happy learning.

Topic 6: Data Analysis with SPSS

Introduction to SPSS
Data View, Variable View and Output Viewer
Coding or Defining Variables in the Variable View
Data Entry in SPSS
Error Detection and Correction in Dataset
Saving Your SPSS File
Opening An existing SPSS File
Descriptive Statistics and Frequency Table Generation
Recoding A Variable into Different Variable
Compute Variable
Chi-Square Analysis In SPSS
T-Test Analysis in SPSS
Analysis of Variance (ANOVA) in SPSS
Correlation Analysis in SPSS
Linear Regression Analysis in SPSS
Quiz 6: Data Analysis with SPSS

Topic 7: SQL for Data Analysis

Introduction to SQL
MySQL Software for Database Management
How to Download and Install MySQL
Common Terms in SQL: Part 1
Common Terms in SQL: Part 2
Comments in SQL
Operators in SQL
Data Types in SQL
Overview of MySQL Workbench Interface
How to Create and Remove a Database in MySQL
How to Create, Modify and Delete a Table in MySQL
How to Insert Data or Records into a Table in MySQL
How to Update the Data or Records in a Table
How to Delete Data or Record from a Table
Querying or Retrieving Data using SELECT Statement with LIMIT and DISTINCT Keywords
Using SELECT Statement with Aggregate Functions (COUNT, MAX, MIN, AVG, SUM)
Using DISTINCT with COUNT keyword in SELECT statement
The GROUP BY clause
Sorting Records using the ORDER BY Clause
Using HAVING keyword with the GROUP BY clause
Filtering Results Using the WHERE Statement
Using Logical Operators (AND, OR) with WHERE Statement
Using BETWEEN, IN, IS NULL and IS NOT NULL Operators with WHERE Clause
Using LIKE Operator with WHERE Clause for Pattern Matching
Using JOIN Clause to Combine or Merge Tables (Part 1)
Using JOIN Clause to Combine or Merge Tables (Part 2)
Using JOIN Clause to Combine or Merge Tables (Part 3)
How to Import Dataset into MySQL
Modifying the Table Structure of Imported Dataset in MySQL
Using “UNION” and “UNION ALL” in SQL
Saving SQL Script and Exporting Result Output
Quiz 7: SQL for Data Analysis

Topic 8: Power BI for Data Analysis and Visualization

Introduction to Power BI
How to Install Power BI Desktop
Overview of the Power BI Desktop Interface
How to Import Dataset in Power BI (Part 1)
How to Import Dataset in Power BI (Part 2)
Getting Started with Data Transformation and Cleaning (Part 1)
Getting Started with Data Transformation and Cleaning (Part 2)
Data Transformation in Power Query Editor (Part 1)
Data Transformation in Power Query Editor (Part 2)
Data Transformation in Power Query Editor (Part 3)
Data Transformation in Power Query Editor (Part 4)
Data Transformation in Power Query Editor (Part 5)
Getting Started with Data Analysis Expressions (DAX) (Part 1)
Getting Started with Data Analysis Expressions (DAX) (Part 2)
Quiz 8a: Power BI for Data Analysis and Visualization
Functions in DAX: Aggregate Functions
Functions in DAX: Text Functions
Functions in DAX: Filter Functions
Functions in DAX: Logical Functions
DAX Demonstrations: Creation of Calculated Columns and Measures (Part 1)
DAX Demonstrations: Creation of Calculated Columns and Measures (Part 2)
DAX Demonstrations: Creation of Calculated Columns and Measures (Part 3)
Getting Started with Visualizations in Power BI (Part 1)
Getting Started with Visualizations in Power BI (Part 2)
Getting Started with Visualizations in Power BI (Part 3)
Quiz 8b: Power BI for Data Analysis and Visualization

About Course

What Will You Learn?

Course Content

Topic 1: Fundamentals of Data

What is Data?

Importance of Data

Main Types of Data- Qualitative and Quantitative Data

Data Classification Based on Source

Data Classification Based on Level of Measurement

Common Data Types in Programming

Quiz 1: Fundamentals of Data

Topic 2: Data Collection

What is Data Collection?

The Data Collection Process

Methods of Data Collection

Tools for Digital Data Collection

Questionnaire for Data Collection

Types of Questionnaire

Useful Tips for Questionnaire Design

Reliability and Validity of A Questionnaire

Quiz 2: Data Collection

Practical Session 1: Questionnaire Design for Data Collection

Practical Session 2: Working with Google Form for Data Collection

**Assignment- Questionnaire Design in Google Form

Topic 3: Introduction to Data Analysis

What is Data Analysis?

Benefits of Data Analysis

Data Analysis Processes

Types of Data Analysis

Descriptive Data Analysis

Parametric Tests in Inferential Data Analysis

Non-Parametric Tests in Inferential Data Analysis

Software Packages for Data Analysis

Programming Languages for Data Analysis

Quiz 3: Introduction to Data Analysis

Topic 4: Data Analysis and Visualization with Microsoft Excel

Introduction to Microsoft Excel

Introduction to Google Sheets

Some Key Terms Related to the Use of Microsoft Excel

Practical Session 1: Descriptive Analysis with Excel

Practical Session 2: Addition of More Data and Generation of Frequency Table

Introduction to Menu Bar in Excel

The Home Tab in Excel Menu Bar

Formula Bar and Name Box

Worksheet Tabs Bar

Status Bar in Excel

Auto Fill Using the Fill Handle in Excel

Some Keyboard Shortcuts in Excel

Entering Formula in Excel

Using Excel Basic Functions

The RANK and RANK.EQ Functions

Quiz 4a: Data Analysis with Microsoft Excel

Other Important Excel Functions- Part A

Other Important Excel Functions- Part B

Other Important Excel Functions- Part C

Insert Function and Its Dialog Box

CONCATENATE Or CONCAT Function

**Assignment on Excel Functions

Getting Started with Charts in Excel

Practical Session 3: Charts Creation

Practical Session 4: Creation of Pie Chart

Practical Session 5: Bar Chart Creation

Introduction to Pivot Table

Creating PivotChart

“Slicer” Feature in Excel

Class Exercise

Solution to Class Exercise

Topic 5: Inferential Data Analysis and Interpretation

Introduction

Key Aspects of Inferential Data Analysis

Sampling Techniques

Class Exercise A

Solution to Class Exercise A

Common Inferential Analyses in Excel: Part 1

Common Inferential Analyses in Excel: Part 2

Class Exercise B

Quiz 5: Inferential Data Analysis

Revision and Exercise Week In this revision and exercise week, you are expected to revisit and revise every lesson that you have learned in this training so far, and as well work on the exercises that are made available to you accordingly. Happy learning.

Exercise A: Data Cleaning

Exercise B

Revision and Exercise Week
In this revision and exercise week, you are expected to revisit and revise every lesson that you have learned in this training so far, and as well work on the exercises that are made available to you accordingly. Happy learning.