Data Analysis – Ongoing Batch (New lessons daily)

About Course

Data is the new oil, and the ability to analyze it effectively is one of the most valuable skills today. This course, Data Analysis Using Excel & SQL, is designed to equip learners with the practical knowledge and hands-on skills required to turn raw data into meaningful insights.

Course Content

Basics of Data & Analysis
In this module, learners will build a strong foundation by understanding what data really is and why it matters in today’s world. We’ll explore the difference between data and information, types of data (structured, unstructured, qualitative, quantitative), and how data flows through the analysis process. Students will also learn the key steps of data analysis — collecting, cleaning, organizing, analyzing, and presenting insights.

What is Data?

15:45
Types of Data

14:32
Methods of Data Collection

16:17
Data Organization

15:14
Introduction to Data Analysis

13:33
Types of Data Analysis

12:21
Process of Data Analysis

00:00
Basics of Data & Analysis Test
Introduction to Statistics

00:00

Descriptive Statistics

Introduction to Descriptive Statistics

08:48
Data Collection & Organization
Measure of Central Tendency – Mean
Measure of Central Tendency – Median
Measure of Central Tendency – Mode
Relationship Between Mean, Median, and Mode
Measure of Position
Measures of Dispersion
Correlation
Descriptive Statistics Test
Assignment-1

Excel for Data Analysis
Microsoft Excel is one of the most powerful and widely used spreadsheet applications. It allows users to store, organize, analyze, and visualize data in a structured way using rows and columns.

Introduction to Excel
Interface of Excel
Basic Concept of Excel
Excel Quick Tips
Basic Excel Tools
Cell Reference
Operators
Formulas and Functions in Excel
Statistical Functions
Mathematical Functions
Practical Test-1
Logical Functions
Lookup & Reference Function
Logical and Lookup Function Test-1
Text Functions
Text Analysis – Duplicate Customer Names
Text Analysis – Invoice Number Checking
Data Analysis Assignment-1
Data Analysis Assignment-1 Quiz

Database Management System(DBMS)
This course covers the core concepts of Database Management Systems (DBMS), including data models, relational databases, ER modeling, normalization, indexing, transactions, concurrency control, and database security. Students will learn how to design, implement, and manage efficient databases, ensuring data integrity, consistency, and performance for real-world applications.

Introduction to Data
Introduction to Database
Types of Database
Database Users
DBMS Components
Database Architecture
Data Modeling
ER Modeling
Relational Model
Basics of DBMS Test

Normalization
Normalization in DBMS is a systematic approach to organizing data in a database to reduce redundancy and improve data integrity. This course explains how data anomalies occur and how normalization techniques such as 1NF, 2NF, 3NF, BCNF, and higher forms can eliminate them. You’ll learn how to identify functional dependencies, decompose relations, and design efficient, consistent, and scalable databases.

Student Ratings & Reviews

No Review Yet

About Course

Course Content

What is Data?

Types of Data

Methods of Data Collection

Data Organization

Introduction to Data Analysis

Types of Data Analysis

Process of Data Analysis

Basics of Data & Analysis Test

Introduction to Statistics

Descriptive Statistics

Introduction to Descriptive Statistics

Data Collection & Organization

Measure of Central Tendency – Mean

Measure of Central Tendency – Median

Measure of Central Tendency – Mode

Relationship Between Mean, Median, and Mode

Measure of Position

Measures of Dispersion

Correlation

Descriptive Statistics Test

Assignment-1

Excel for Data Analysis Microsoft Excel is one of the most powerful and widely used spreadsheet applications. It allows users to store, organize, analyze, and visualize data in a structured way using rows and columns.

Introduction to Excel

Interface of Excel

Basic Concept of Excel

Excel Quick Tips

Basic Excel Tools

Cell Reference

Operators

Formulas and Functions in Excel

Statistical Functions

Mathematical Functions

Practical Test-1

Logical Functions

Lookup & Reference Function

Logical and Lookup Function Test-1

Text Functions

Text Analysis – Duplicate Customer Names

Text Analysis – Invoice Number Checking

Data Analysis Assignment-1

Data Analysis Assignment-1 Quiz

Introduction to Data

Introduction to Database

Types of Database

Database Users

DBMS Components

Database Architecture

Data Modeling

ER Modeling

Relational Model

Basics of DBMS Test

Introduction to Normalization

Data Redundancy & Anomalies

Database Dependencies

Types of Functional Dependency

Keys in Relational Databases

Normal Form 1NF

Normal Form 2NF

Student Ratings & Reviews

New: Instant Back/Forward Navigation

Courses

Excel for Data Analysis
Microsoft Excel is one of the most powerful and widely used spreadsheet applications. It allows users to store, organize, analyze, and visualize data in a structured way using rows and columns.