Empowering learners with industry-ready skills through interactive teaching and hands-on guidance.


ExcelR Edtech Pvt. Ltd.

Learn Python, Pandas, Numpy, and visualization tools. Machine Learning algorithms and model building. Projects on real-world data sets. Includes hypothesis testing and feature engineering. Covers end-to-end DS lifecycle.

Data Science /Machine Learning Short  Term Internship

Python Basics

Numpy and Pandas

Visualization

Statistics Descriptive

Statistics (Hypothesis Testing)

Statistics (Hypothesis Testing 2) 

EDA,Feature Engineering

Linear_Regression, Stats Models , Error Metrics

Lasso,Ridge,Elasticnet, Logistic Regression, Performance Metrics, PPS

KNN, PCA, Support Vector Machines

DECISION TREE,RFE, Naive Bayes

Ensemble Learning ( Bagging, Boosting)

Unsupervised Machine Learning(clustering-KMeans,Hierarchial,,DBSCAN)

Isolation Forest, Model Deployment, Time Series Forecasting--Exponential Smoothing

Time Series Forecasting(ARIMA,ACF,PCF,AR,NMA), Recommendation Engine

Recommendation Engine(Content Based), Association Rules, Apriori( Market Basket Analysis)

NLP(Text Mining, NER, WordEmbedding,WordCloud, WordFrequency)

NLP(Emotion Mining), Deep Learning

NN, Hyperparameter Tuning

CNN, R-Programming

R-Programming, Project

INTRODUCTION TO PYTHON | SOFTWARE INSTALLATION | VARIABLE | DATATYPE'S

Operator -Arthmatic ,Comparison , Assignment ,Logical , Bitwise opeartor conditional Statemet

Decision making If, While loop, for loop and nested loop

Mathametical functions , Random function , Trigonometric function Number type conversion - int(), long(). Float ()"

"Strings- Escape char, String special Operator , String formatting Operator Build in string methods - center(), count()decode(), encode()"

Python List and Tuple- Accessing values, Delete elements,updating , Indexing slicing & Matrices Built in Function - cmp(), len(), min(), max()

SET creation,adding and deleting elements,frozenset,Dictionary-Accessing values from dictionary, Deleting and updating elements in Dict.Properties of Dist.,Built in Dist functions & Methods.

Function - Define function , Calling function pass by refernece as value , Function arguments , Anonymous functions , return statements

Import statemnts , Locating modules - current directory Dir() function , global and location functions and reload () functions .

Files in Python- Reading keyboard input ,closing files modes Files object attribute- open , close . Reading and writing files , file Position. Renaming and deleting files"

mkdir methid, chdir () method , getcwd method , rm dir Exception handling - List of exceptions - Try and exception Try- finally clause and user defined exceptions

OOPS concepts , class , objects , Inheritance Overriding methods like _init_, Overloading operators , Data hiding

match function , search function , matching vs searching Regular exp modifiers and patterns

Day 35

Day 36

Introduction to Tableau, Software Installation, UI

UI, Marks shelves, basic formatting, basic charts

Basic charts (continue)

Tables, table calculations, dual and combined axis

custom charts (continue), filters

Filters (continue), live v/s extract, parameters, calculated fields

Groups, sets, bins, hierarchies, histogram

Reference lines, band, LOD's, Data modelling techniques

Data modelling (continue), Dashboard objects

Dashboarding and dashboard actions, Doubt solving

Day 1 Introductions of SQL and Installation. Created DATABASE

Day 2 Created Database and Tables, Insert values in Tables, Data type(Numeric, String/text)

Day 3 Data Types(ENUM, Floating, Date), SQL Constraints(Domain(Unique, Not Null, Default, Check), Key(Primary + Auto_Increment)

Day 4 Referential Integrity(Foreign Key)), DDL commands(Create, Alter(Add, Drop, Modify, Change column), Rename, Truncate and Drop Table)

Day 5 Operators with Where Clause, DML(Insert, Update, Delete), IS keyword, On delete Cascade and On Update Cascade

Day 7 Group By with having clause Examples and Joins(Inner Join, Left Join, Right Join, Left Join), Imported table from CSV file in SQL, ACID Properties

Day 8 Joins(Inner, Right, Left, Full Outer Join, Self Join, Cross Join)

Day 9 View With Joins, Index Types(BTREE, HASH ), Explain BTREE with Examples, Unique Index , CASE WHEN. EEE diagram

Day 10 Subquery, Subquery(Multirow subquery, Correlated Subquery) , Window Functions Over clause with (Partioned By) and (Order By)

Day 11 Window Functions(Value window functions(Lag,Lead)), Ranking window functions (rank() , row_number(), dense_rank())

Day 12 IFNULL(), Coalesce(), Temporary Table. Union & Union All, Stored Procedure(Variable, IN Parameters)

Day 13 Stored Procedure(IN, OUT parameter, IF-Else, Loop, Error Handling with Continue and Exit Handler, Out Parameter, Cursor)

Day 14 User Defined Functions, String, Number and Date functions , Types of Trigger(Before(Insert)

ChatGPT_01

ChatGPT_02

ChatGPT concepts

ChatGPT data analysis concepts

Optimization, Gradient Descent, Into to NN

ANN and its applications

Artificial Intelligence_01

Artificial Intelligence_02

Artificial Intelligence_03

Artificial Intelligence_04

Artificial Intelligence_05

Data Science & Machine Learning_File-01-A

Agenda_Data Science & Machine Learning

Data Science & Machine Learning_File-01-B

Data Science & Machine Learning_File-02-A

Data Science & Machine Learning_File-03-A

Data Science & Machine Learning_File-03-B

Data Science & Machine Learning_File-04-A

Data Science & Machine Learning_File-05-A

Data Science & Machine Learning_File-07-A

Data Science & Machine Learning_File-08-A

Data Science & Machine Learning_File-10-A

Data Science & Machine Learning_File-11-A

Data Science & Machine Learning_File-12-A

Data Science & Machine Learning_File-13-A

Data Science & Machine Learning_File-14-A

Data Science & Machine Learning_File-15-A

Data Science & Machine Learning_File-16-A

Data Science & Machine Learning_File-18-A

Data Science & Machine Learning_File-18-B

Data Science & Machine Learning_File-20-A

Data Science & Machine Learning_File-21-A

Data Science & Machine Learning_File-22-A

Data Science & Machine Learning_File-23-A

Data Science & Machine Learning_File-24-A

Data Science & Machine Learning_File-26-A

Data Science & Machine Learning_File-27-A

Data Science & Machine Learning_File-28-A

Data Science & Machine Learning_File-29-A

Data Science & Machine Learning_File-31-A

Data Science & Machine Learning_File-33-A

ExcelR

Data Science /Machine Learning Short Term Internship

What you'll get out of this course

Course content

Session Recordings - Data Science

Session Recordings - Core Python

Session Recordings - Tableau

Session Recordings - MySQL

Session Recordings - ChatGPT

Session Recordings - Artificial Intelligence

Material

Your Instructor

ExcelR Edtech Pvt. Ltd.