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 -Data Science and Advanced Tableau Certification Course
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 Essentials
- Supervised learning : Decision Tree
- Supervised Learning : Ensemble Learning
- Text Mining and Analytics
Course Duration – Data Science and Advanced Tableau Certification Course
Total – 210 hours
Course Fee
INR 45, 998 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.