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.
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 and Power BI
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
Power BI :
- Connecting with various data sources
- Power Query
- Data Transformation
- Data Modeling
- Create Report and Dashboard
- Advance Visualization techniques
- Analytics
- AI visuals
- Publishing Report
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
Data Manipulation and Predictive modelling in 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 Manipulation and Predictive modelling in 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
Course Duration
184 hrs (Live Training) + 100 hrs
(Assignments, Case Study and Project
Course Fee
INR 51,500 + GST
No Cost EMI Avaliable
We also facilitate loans to students
Eligibility
- Graduate or Postgraduate in any stream
- Final Year Students of any field
- Working Professional from any industry
- Not mandatory to have maths or computer programming background
Internships and Portfolio Projects
1-month internships on each tool
- Excel
- MySQL
- R
- Python
- Tableau or Power BI
Project Portfolio
- 1:1 Mentoring
- Evaluation
Industry Projects
- Telecom: Analyse Customer attrition and customer dissatisfaction feedback
- 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?
In today’s rapidly evolving business landscape, organizations and SMEs are more data-driven than ever before. The need to extract valuable insights from vast amounts of data has become paramount. In this fiercely competitive era, analytics plays a pivotal role in guiding decision-making, enabling companies to harness insights for crafting innovative strategies and ensuring a robust return on investment (ROI). The job opportunities in the field of data analytics are also set to grow significantly in the next two years, with an expected increase of over 20% in data-related job openings, making it a promising career choice for many.