Business Analytics Certification Programme & Course | Ivy Pro School
Co-Created with Industry partner | 6 Months Weekend program | For Selected Few, Apply Now!
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
Dashboarding and Automation Using Advanced Excel
- 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
SQL Queries & Relational Database Management
- 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
Data Visualization using Tableau
- 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
- Logical Calculations
- Date Calculations
- Parameters
- Using Actions to Create Interactive Dashboards
- Advanced Charts
- Working with data
- Sets
- Drilling Up/Down using Hierarchies
- Grouping
- Bins/Histograms
- Analytics using Tableau
- Building dashboards
- Story Telling with Data
- Data Interpreter
- 4 Case Studies on Retail, Airline, Bank datasets
Business Statistics
- 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
Predictive Modeling with R
- 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
Data Science with Python
- 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
Machine Learning, Artificial Intelligence, and Deep Learning
- Predictive Modeling Basics
- Unsupervised Learning : Segmentation
- Supervised learning : Decision Tree
- Supervised Learning : Ensemble Learning
- Supervised Learning : Artificial Neural Networks (ANN)
- Supervised Learning : Support Vector Machines
- Supervised Learning : KNN
- Supervised Learning : Naïve Bayes
- Text Mining and Analytics
- Introduction to TensorFlow
- Convolutional Neural Networks (CNN)
- Recurrent Neural Networks (RNN)
Big Data – Hadoop, Spark, Scala
- 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 – 265 hours
Course Fee
INR 82,880 plus taxes
We also facilitate loans to students
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
Industry Projects
Real Industry Projects & Internships in SAS / R
- B2B Chemical Sales: Predict Customer Churn Score for a Chemical Manufacturing Company
- Banking & Finance: Create a Customer Ranking Scorecard for a Cross-selling Insurance Product in a Bank
- Banking & Finance: Predict Probability of Default of Customers for a Money Lending Firm
- Pharma: Predict Drug Efficacy for a Pharmaceutical Company
- Automobile Insurance: Predict Customer Total Claim Amount
- Retail: Predict Product Affinities for 100+ Products
- Rental / Real-Estate: Predict Rental Rates considering 100+ Parameters
- Aviation: Predict Airlines Revenue & Ticketing Pricing Mix
- HR: Predict Employee Attrition
- Retail Marketing: Analyse Marketing Campaign Effectiveness
Enquire / Enroll for the course
Launch Your Global Analytics Career with IVY
Why Analytics?
As organisations and SMEs become increasingly data-driven, there arises the need to make sense of all that data and convert it into meaningful insights. In a competitive environment, analytics becomes the driving force that facilitates decision making – to leverage the insight for innovative strategies as well as for an effective ROI on investment.