DATA ANALYSIS COURSE OUTLINE
|
DATA ANALYSIS
|
|
Introduction
|
|
Data analyst Vs
Data scientist
|
|
Overview of Big
data
|
|
FUNDAMENTALS OF
STATISTICS
|
|
Sample
|
|
Population
|
|
Random varibales
|
|
Mean
|
|
Median
|
|
Mode
|
|
Probability
|
|
Bayes theorem
|
|
Chi Square test
|
|
F test
|
|
T test
|
|
Z test
|
|
Normal
Distribution
|
|
Normal Variates
|
|
Bi-nominal theorem
|
|
FUNDAMENTALS OF
SQL
|
|
Basics of DBMS
|
|
Codd rules
|
|
Types of DBMS
|
|
ER Diagrams
|
|
ERD to Tables
|
|
Relational DBMS
(RDBMS)
|
|
Introduction to
SQL
|
|
In-built functions
|
|
User created
Functions
|
|
Constraints
|
|
Views
|
|
Joins
|
|
Sub Queries
|
|
Operators
|
|
Expressions
|
|
DATA ANALYSI
WITH EXCEL
|
|
Working with Excel
tables
|
|
Importing data
into excel
|
|
Data cleaning
|
|
Functions
|
|
Database functions
|
|
Pivot tables
|
|
Pivot charts
|
|
Graphs
|
|
Statistical
Functions in Excel
|
|
Applying statitcs
to data using Excel
|
|
DATA ANALYSIS
WITH PYTHON
|
|
Introducing Data
Analysis and Libraries
|
|
NumPy Arrays and
Vectorized Computation
|
|
Data Analysis with
Pandas
|
|
Data Visualization
|
|
Time Series
|
|
Interacting with
Databases
|
|
Data Analysis Application
Examples
|
No comments:
Post a Comment