Advanced data analysis in excel: Data Analysis tools (toolpak add-in) for statistics / solver for linear optimization
Master: Association rules (MBA) & it's usage, Linear Discriminant Analysis (LDA) for classification & variable selection
Learn SAS programming through data workout. See sorting, merging, appending, graphs, tabulate, statistical procedure etc
Recording Macro, Creating Excel VBA form, Fetching data from MS Access, Working with multiple sheets and workbook
Unsupervised Machine Learning : Hierarchical & non hierarchical clustering (k-means), theory & SAS / R program
Analytics / Machine Learning / Dimensionality Reduction : PCA & Factor Analysis using SAS and R program
Statistics Simplified - Statistics Made Easy by Excel Simulations. Master fundamentals of statistics & Probability.
Learn the syntax of SAS macro and see workout examples. understand use case, debugging, error handling, looping etc.
Dummy Variable regression (ANOVA / ANCOVA / structural shift), Conjoint analysis for product design Survey analysis
Machine learning algorithm (ANN) - simplified. See the use cases with R to understand the application
Basics of Risk, Marketing, Collections, Operations & Fraud Analytics. Know the objective, techniques & Success stories
Analytics/ Supervised Machine Learning/ Data Science (applied statistics): CHAID / CART / GINI/ ID3/ Random Forest etc.
Predictive Analytics - Learn R syntax for step by step logistic regression model development and validations
Analytics / Data Science: Learn to Import, Sort, Merge, Subset, Append, Freq, Univariate, Regression, Derive variable
Introduction and side by side comparison of Basel I / Basel II/ Basel III, Different Risk Measures & capital associated
