Why Ivy
IVY Pro School is a Top Ranked Data Science and Analytics schools in the country consistently since the last 5 years (Analytics India magazine, Silicon India Magazine). We are the official training partners of companies like Honeywell, Cap Gemini, Genpact, HSBC, Cognizant, eBay/Paypal etc and more than 100 Analytics companies have recruited our students. Our prized faculty are associated with esteemed organizations like ISI, IIMs IITs and prestigious US universities.
Course Outline
- Introduction to MS Excel, Cell Ref, Basic Functions and Usage
- Sorting, Filtering, Advance Filtering, Subtotal
- Pivot Tables and Slicers
- Goal Seek and Solver
- Different Charts Graphs – Which one to use and when
- Vlookup, Hlookup, Match, Index
- Conditional Formatting
- Worksheet & Workbook Reference, Error Handling
- Logical Operators & Functions – IF and Nested IF
- Data Validation
- Text Functions
- Form Controls
- Dashboard
- 6 Case Studies from App Cab Aggregators, Insurance, Sports, Sales, Marketing, Web Analytics Industry
- Relational Database Fundamentals
- Steps to Design Efficient Relational Database Models
- Case Studies on Designing Database Models
- Case Study Implementation on Handling Data
- Importing / Exporting Large Amount of Data into a database
- SQL Statements – DDL, DML, DCL, DQL
- Writing Transactional SQL Queries, Merging, joining, sorting, indexing, co-related queries, etc.
- Hands-on Exercises on Manipulating Data Using SQL Queries
- Creating Database Models Using SQL Statements
- Individual Projects on Handling SQL Statements
- 6 Case Studies from App Cab Aggregators, Ecommerce, Sports Industry
- Introduction to Data Visualization
- Introduction of Data Visualization using Tableau
- Tableau Basics
- Working with Sorting and Filters
- Creating Dual Axis and Combo Charts
- Table Calculations
- Calculated Field Overview
- 4 Case Studies on Retail, Airline, Bank datasets
- Types of data, Graphical representation
- Correlation, Data Modeling & Index Numbers
- Measures of Central Tendency & Dispersion
- Forecasting & Time Series Analysis
- Probability, Bayesian Theory
- Probability Distribution and Mathematical Expectation
- Sampling and Sampling Distribution
- Theory of Estimation and Testing of Hypothesis
- Analysis of Variance
- Regression Models
- Introduction to R
- Data Handling in R
- Overview of Analytics and Statistics
- String and character functions in R
- Overview of Analytics and Statistics
- Linear regression in R
- Logistic Regression in R
- Time Series theory discussion overview
- Clustering Concepts and Case Study
- Feature Engineering & Dimension Reduction and Case Study
- Decision Trees
- Python Essentials
- Scientific Distribution
- Accessing / Importing and Exporting Data using Python modules
- Data Manipulation
- Visualization using Python
- Introduction to Predictive Modeling
- Modeling on Linear Regression
- Modeling on Logistic Regression
- Time Series Forecasting
- Supervised learning : Decision Tree
- Supervised Learning : Ensemble Learning
- Text Mining and Analytics
- Introduction to Big Data and Hadoop
- HDFS
- Mapreduce
- YARN
- Sqoop
- Flume
- Hive and HiveQL
- Advanced Hive
- Pig and Advanced Pig
- Oozie
- NoSQL databases and HBase
- Apache Spark and Scala
- Spark SQL- Understanding Datasets and Dataframes
- Spark Streaming
- Spark Machine Learning
- Projects:
- Twitter Sentiment Analysis
- Data masking using Sqoop and Hive
- Movie lens data analysis using Pig
- Book Recommendation using Sqoop, Hive and Tableau
- Banking Data Analysis using Spark SQL
Course Duration
Total – 230 hours
Course Fee
INR 46,500 + GST
Detailed course brochure.
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
Software professionals with ETL/Programming background
B.Sc and M.Sc
Projects
Industry Executed Modeling Projects in SAS
- Projects from Retail, Healthcare, Finance, Education and Aviation Industry
Projects with R
- Dedicated Practice Sessions on Industry Scenarios in R
- Industry Executed Projects in R
Hadoop Project – Connecting Hadoop ecosystem with ETL Tool
- Moving data from local file system to HDFS
- Writing Map Reduce Code
- Moving data from HDFS to Database
- Writing Pig Query
- Writing Hive Query
Enquire / Enroll for the course