IVY is ranked in the top 10 institutes for Big data and Analytics schools in the country (Analytics India magazine, 2014 ranking). We are the official training partners of companies like Cap Gemini, Genpact, HSBC, Cognizant, eBay/Paypal etc and more than 60 Analytics companies recruit from us. Our prized faculty are associated with esteemed organizations like ISI, IIM’s IIT and US universities.
Course Outline
- Introduction to MS Excel, Basic Functions and Usage
- Sorting, Filtering, Advance Filtering, Subtotal
- Pivot Tables
- What-if-Analysis (Data Tables, Scenario Manager & Goal Seek) and Solver
- Different Charts Graphs – Which one to use and when
- Lookup Functions – Vlookup, Hlookup, Match, Index
- Formatting – Style & Number Formatting, Conditional Formatting
- Linking of Sheets – Worksheet & Workbook Reference
- Logical Operators & Functions – AND, OR, IFERROR, IF and Nested IF etc.
- Data Validation
- Text Functions
- VBA Programming
- Relational Database Fundamentals
- Steps to Design Efficient Relational Database Models
- Case Studies on Designing Database Models
- Case Study Implementation on Handling Data in MS-Access 2007
- Importing / Exporting Large Amount of Data into/from MS-Access
- Intro to SQL Statements
- Writing Transactional SQL Queries, Merging, joining, sorting, indexing, etc.
- Hands-on Exercises on Manipulating Data Using SQL Queries
- Creating Database Models Using SQL Statements
- Individual Projects on Handling SQL Statements
- Analytical Problem Solving Skills, Creative Thinking, Root Cause Analysis, Decision Tree Analysis, Fish Bone Analysis, Mind Mapping, Minto Pyramid’s Principle, etc.
- Techniques to Handle Case Based Interviews
- Group / Individual Exercises / Case Studies
- Importance of Data for Management Decisions
- Time Series Analysis
- Probability Concepts and Applications
- Basics of Sampling and Sampling Distributions
- Theory of Estimation and Testing of Hypothesis
- Correlation and Regression Models
- Forecasting
- Theory of Attributes
- Statistical Decision Analysis
- Analysis of Variance
- Multivariate Analysis
- Base and Advanced SAS 9 Concepts
- Advanced Analytics Modeling Techniques
- Regression
- Clustering
- Logistics
- Time Series/ARIMA etc.
- Data Handling, Visualization and Statistical Programming in R
- Introduction and Overview of R Package
- Data Cleaning and Management in R
- Logic Building in R
- Data Visualization in R
- Statistical Research in R
- Object Oriented Programming in R
- Introduction to Hadoop
- Hadoop Stack
- Hadoop Hands-on
- MapReduce Introduction
- MapReduce Exercises
- HDFS Introduction
- Hive
- Hive Hands-on
- Pig
- Pig Hands-on
- Introduction to Sqoop
- Hadoop Multi Node Cluster Setup
Course Duration
Module I – 48 hours
Module II – 15 hours
Module III – 9 hours
Module IV – 21 hours
Module V – 62 hours
Module VI – 25 hours
Module VII – 24 hours
Eligibility
Under-grad or Post-grad in Maths/ Stats/ Economics/ Commerce/ Finance
MBA Students (All Streams)
3rd and Final Year B.E./ B.Tech
Banking/ Finance/ IT/ KPO Working Professional
B.Sc and M.Sc