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


ExcelR Edtech Pvt. Ltd.

Learners will build strong foundations in Python programming, data handling, and visualization. They will gain hands-on experience with statistics, machine learning, NLP, deep learning, and time series forecasting. By the end, they will be able to analyze data, build predictive models, and deploy real-world projects using Python and R.

Data Science and Machine Learning  Long 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 37

Day 38

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 6 TCL(Rollback, Savepoint, Commit), DCL(Grant , Revoke), Order BY, Alias, Distinct keyword, Limit, Like keyword

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)

Big data intro, Spark concepts

Spark dataframes

saprk sql functions, joins

intro to data transformations sparkML

spark machine learning contd, databricks

Databricks examples, Azure environment

Spark streaming, intro to hadoop architecture

Hadoop installation

Hadoop map reduce

Aure Services discussion

Azure ML,AIand database discussion

Batch Completed on 3rd June

Azure day 4

Cloud computing fundamentals

Azure Cloud fundamentals

Basic Stats its types

Descriptive Statistics

Hypothesis testing,Probability, Normal Distribution

Data Cleaning ,Test Z and T test

Operators,Function,Data types

Loops,Analysis with mean,mode,median

Joins ,Import data,Charts

Python Introduction,Data types,List ,Tuples

Data Structure-Sets, List, Dictionaries

Data Frame,Loops,Conditional Statement

Series,Dataframe,Pandas,Numpy,Charts

ChatGPT

ChatGPT concepts

Chatgpt data analysis concepts

Optimization, Gradient Descent, Into to NN

ANN and its applications

Artificial Intellingence

ExcelR - LMS Portal 

Data Science and Machine Learning Long Term Internship

What you'll get out of this course

Course content

Data Science Videos

Core Python Videos

Tableau

MySQL

Big Data Tools---Apache Spark & Hadoop

Azure

Basics of R

ChatGPT

Artificial Intellingence

Your Instructor

ExcelR Edtech Pvt. Ltd.