Description

DETAILED COURSE SYLLABUS

INTRODUCTION TO PYTHON
PRINT, COMMENTS, VARIABLES
TYPE CASTING AND STRINGS
INDEXING, SLICING
OPERATORS AND CONDITIONAL
STATEMENTS
MATH FUNCTIONS
LOOPS IN PYTHON
NESTED IF-ELSE
NESTED LOOPS
FUNCTIONS(INBUILT & USER DEFINED)
DATA STRUCTURES
FUNDAMENTALS OF CLASSES
FILE HANDLING

EXCEPTION HANDLING
RECURSION
REGEX
NUMPY
PANDAS
MATPLOTLIB & SEABORN
EXPLORATORY DATA ANALYSIS
HACKERRANK PROBLEMS
9 ASSIGNMENTS

BLACK FRIDAY CASE STUDY
HANGMAN PROJECT
HABERMAN CANCER SURVIVAL
DATA ANALYSIS
CASE STUDIES

INTRODUCTION TO DATABASE
CONSTRAINTS IN SQL
NORMALISATION
CRUD OPERATIONS
DATA DEFINITION LANGUAGE
DATA MANIPULATION LANGUAGE
KEYWORD EXECUTION
GROUP FUNCTION
INNER, OUTER, LEFT, RIGHT, CROSS,
SELF JOIN
SUB QUERIES & OTHER FUNCTIONS
ADVANCED QUERIES ON
UNIVERSITY SCHEMA
VIEWS IN SQL

TRANSACTIONS
WINDOWS FUNCTION
CTE
STRING TRANSFORMATION AND
REGEX
DATE TIME MANIPULATION
DATA MODELING
SQL PRACTICE SET ON SPORTS
CLUB SCHEMA
SQL PRACTICE SET ON HACKERANK
PROBLEMS
SQL PRACTICE SET ON COMPANY
SCHEMA
STORED PROCEDURES

DATAMART CASE STUDY
TEXTURE TALES CASE STUDY
DATA BANK CASE STUDY
CASE STUDIES

AUTO FILL
FIND& SEARCH
INSERT & DELETE
HIDE & UNHIDE
CELL REFERENCING, CELL ERROR
FUNCTIONS
CONDITIONAL FORMATTING
PASTE SPECIAL
DATE TIME FUNCTION
LEFT ,RIGHT, MID,LEN,CONCATENATE
REPLACE AND SUBSTITUTE
TEXT AND VALUE
SUM, PRODUCT, MOD, SQRT, FACT
ROUND, ROUNDUP, ROUNDDOWN, SUMIFS
CHART TYPES, EXCEL TEMPLATES
PIVOT TABLE, POWER PIVOT

VLOOKUP AND HLOOKUP
IF, NESTED IF, SUMIF, IFERROR
MATCH, INDEX
AND, OR, NOT, ISERROR, ISNUMBER, ISBLANK,ISTEST
COUNT, COUNTA, COUNTBLANK,COUNTIFS
MEAN, MEDIAN, MODE, STD,RANK,QUARTILES,CORR
SORT, FILTER
FORMULA AUDIT, WORKSHEET PROTECTION
SOLVER FUNCTION, SCENARIO MANAGER
MACRO RECORDING, WAYS OF RUNNING MACRO
VBA, VBA PROCEDURE, VBA VARIABLES, LOOPS
INDIRECT, OFFSET, DASHBOARD
UBER CASE STUDY

Tableau

PowerBI
Introduction to Tableau
Tableau installation
Tableau User Interface
Dimensions and Measures

Working with Data
Default Properties of Fields
Dimension Filter
Measure Filter

Sets
Parameters
Groups
Calculated Fields
Date Functions
Text Functions

Visual Filter
Interactive Filter
Data Source Filter
Context Filter

Bins and Histogram
Sort Function
Reference lines and Trend lines
Quick Table Calculations
Pareto Chart and Waterfall
Chart
TABLEAU INTRODUCTION

DIFFERENT TYPES OF PLOTS, CHART,
LINE CHART, AXIS CHART, AREA
CHART, TYPES OF PLOT
DATA TYPES AND FILTERS IN TABLEAU

APPLYING ANALYTICS TO TABLEAU

Introduction to Dashboards
Object in Dashboards
Filters in Dashboard

Actions
Dashboard for Mobile
Story

A ti

DASHBOARD

Union
Joins
Data Blending - Part 1
Data Blending - Part 2
WORKING WITH MULTIPLE DATA SOURCES

Fixed LOD
Include LOD
Exclude LOD
LEVEL OF DETAIL

COVID 19 Analysis
Loan Application Study
IPL Data Analysis
Super Store Sales Analysis
CASE STUDIES

DETAILED COURSE SYLLABUS

INTRO TO POWER BI
BASIC CHARTS - barchart, piechart, donutchart etc
MAPS , TABLES, CONDITIONAL FORMATTING
TABULAR DATA IN POWER BI
CARDS IN POWER BI
FILTERS, SLICERS
ADVANCE CHART , SCROLLER, INFOGRAPHIC
INSERTING OBJECT
BOOKMARK ACTION
CREATING REPORT
PUBLISHING REPORT ON POWER BI SERVICE
DASHBOARD
REFRESHING DATA IN POWER BI AND SCHEDULING
USING TEXT FUNCTIONS, DATE FUNCTIONS, NUMBER
FUNCTIONS IN POWER QUERY
NORMALISATION 1NF, 2NF, 3NF
OLTP VS OLAP

APPENDING AND MERGING SHEET
COLUMNS FROM EXAMPLE IN POWER QUERY,
CONDITIONAL COLUMSN
DATA MODELLING IN POWER BI
CONNECTING TO MYSQL
M LANGUAGE-LIST & CUSTOM TOOLS, DAX
FUNCTION, CREATING OWN QUERY
CONNECTING TO WEB, PYTHON, R, IMPORTING
DATA FROM MULTIPLE SOURCES, DAX
DAX-DATE FUNCTION, TEXT FUNCTION,
LOGICAL FUNCTION, QUICK & CALCULATED
MEASURE
PYTHON SCRIPT, R SCRIPT

School Performance Report
Customer Churn Analysis
Covid-19 Insights Analysis
Airport Authority Data Analysis

Maths & Statistics
VECTORS
MATRICES
LINEAR EQUATION
VECTOR NORMS
CALCULUS
CENTRAL TENDENCY
SAMPLE VS POPULATION
PROBABILITY
TYPES OF DISTRIBUTION
CENTRAL LIMIT THEOREM

HYPOTHESIS TESTING
TYPES OF TEST
ANOVA TEST
SKEWNESS & KURTOSIS

HOUSING ANALYSIS
MOBILE PHONE
ANALYSIS
DRUG TESTING
PAYROLL ANALYSIS
#CASE STUDY

Fundamentals of AI
INTRO TO ARTIFICIAL INTELLIGENCE
INTRO TO MACHINE LEARNING
WHAT IS DATA?
BRIEF INTRO TO ML ALGORITHMS
LIFE CYCLE OF DATA SCIENCE & ML
PROJECT
WHAT IS DEEP LEARNING?
REAL WORLD IMPLEMENTATION OF AI
DIFFERENT ROLES IN DATA SCIENCE

Machine Learning
INTRODUCTION TO MACHINE LEARNING
TYPES OF ML ALGORITHMS
FEATURE SECTION
MISSING VALUE TREATMENT
VARIANCE THRESHOLD REMOVAL
TYPES OF FEATURE SELECTION
FIT TRANSFORM VS FIT PREDICT TRANSFORM
RECURSIVE FEATURE ELIMINATION
FEATURE ENGINEERING
HANDLING CATEGORICAL DATA
OUTLIER DETECTION
ZSCORE
BINNING
TRANSFORMING DATA
DATE-TIME MODULE
LINEAR REGRESSION
ASSUMPTION IN SIMPLE LINEAR REGRESSION
REGRESSION METRICS
RESIDUAL ERRORS
MULTIPLE LINEAR REGRESSION
MAP FUNCTION
GET DUMMIES
STANDARD VS NORMAL
MULTICOLLINEARITY
ADVANCED LINEAR REGRESSION
CROSS VALIDATION
REGULARISATION
PIPELINE
LOGISTIC REGRESSION
STATSMODEL
CORRELATION
VIF
CLASSIFICATION METRICS
ROC-AUC
PCA(PRINCIPAL COMPONENT ANALYSIS)
PCA FUNDAMENTALS
PCA VISUALIZATION
DIMENSION REDUCTION USING PCA
KNN
KNN INTUITION
KNN IMPLEMENTATION
DECISION TREE
WORKING OF DECISION TREE
VISUALIZING DECISION TREE
GRID SEARCH CV
PRUNING

NAIVE BAYES
BERNAULLLI
GAUSSIAN
MULTINOMIAL
TEXT ANALYSIS
SENSITIVITY SPECIFICITY
BAGGING
BAGGING INTUITION
PIPELINE
ENSEMBLE LEARNING
RANDOM FOREST
EXTRA TREE
HYPERPARAMETER TUNING
BOOSTING
ADAPTIVE
GRADIENT
XGBOOST
CAT BOOST
CLUSTERING
UNSUPERVISED LEARNING
HOPKIN STATISTICS
KMEAN CLUSTERING
ELBOW METHOD
DBSCAN CLUSTERING
MEAN SHIFT CLUSTERING
OPTICS
SUPPORT VECTOR MACHINE
SVM INTUITION
HYPERPARAMETER TUNING (SVM)
HYPOTHESIS TESTING
NULL ALTERNATE HYPOTHESIS
DIFFERENT TYPES OF TEST
T TEST
Z TEST
PAIRED TEST
CHI SQUARE ETC
ANOVA & ITS TYPE
GRADIENT DESCENT
GRADIENT DESCENT INTUITION
GD ON LINEAR REGRESSION
16 ASSIGNMENTS ON MACHINE LEARNING
WITH EXPLANATION VIDEOS

And Many More.......