Data Wrangling Using Sql and Excel

• Sql queries

• Integrating with R• Deployment and execution

• Data modelling and formatting using excel

• Excel formulas to perform analytics

• Macros for job automation

Data Analysis and Visualization Using Tableau

• Introduction to tableau and its layout
• Connecting tableau to files and databases

• Data filters in tableau
• Calculation and parameters
• Tableau graphs and maps
• Creating tableau dashboard
• Data blending

NLP (Natural Language Processing)

• Bag of Words• U - Bag of Words and P - Bag of Words• How to use NLP with Machine Learning models.• How to use NLP with Deep Learning models.• Category Predictor• U - Category Predictor and P - Category Predictor• Gender Identifier• U - Gender Identifier and P - Gender Identifier• Sentiment Analyzer• U - Sentiment Analyzer and P - Sentiment Analyzer• Topic Modeling•U - Topic Modeling and P - Topic Modeling• Introduction to Chatbots• Script based chatbots• Integrations with api.ai

Machine learning mining algorithms using Python and R

• Association analysis• Market-based analysis / rules

• Apriori algorithm

• Ensemble models - random forest model, boosting model• Segmentation analysis- types of segmentation, k-means clustering, bayesian clustering

• Feature selection/ dimension reduction, factor or component analysis.

• Axes

• Covariance