• HOME
  • GET HIRED THEN YOU PAY
  • OUR COURSES
    • Data Science Certifications
      • Deep Dive in Data Science, Artificial Intelligence and Machine Learning
      • Business Analytics Certification Course
      • Data Science and Advanced Tableau Certification Course
      • Data Science & Machine Learning, Artificial Intelligence and Deep Learning Certification Course
      • Data Science and Big Data Analytics Certification Course
      • Data Visualization And Reporting
      • Predictive Analytics with R Certification
      • Data Science, Machine Learning and AI Pro+ Certification
      • Machine Learning with Python Certification
      • Pick Your Module
      • Advanced Analytics
      • Diploma in Data Science ML AI Big Data
    • Actuarial Science
      • Actuarial Common Entrance Test (ACET) Coaching
      • Core Technical (CT) Papers Coaching
  • CORPORATES
  • Webinar
  • BLOG
  • CONTACT US

Call us today! 7676882222

Find us
info@ivyproschool.com
Logo
  • HOME
  • GET HIRED THEN YOU PAY
  • OUR COURSES
    • Data Science Certifications
      • Deep Dive in Data Science, Artificial Intelligence and Machine Learning
      • Business Analytics Certification Course
      • Data Science and Advanced Tableau Certification Course
      • Data Science & Machine Learning, Artificial Intelligence and Deep Learning Certification Course
      • Data Science and Big Data Analytics Certification Course
      • Data Visualization And Reporting
      • Predictive Analytics with R Certification
      • Data Science, Machine Learning and AI Pro+ Certification
      • Machine Learning with Python Certification
      • Pick Your Module
      • Advanced Analytics
      • Diploma in Data Science ML AI Big Data
    • Actuarial Science
      • Actuarial Common Entrance Test (ACET) Coaching
      • Core Technical (CT) Papers Coaching
  • CORPORATES
  • Webinar
  • BLOG
  • CONTACT US

Business Analytics Certification Course

Why IvyCourse OutlineCourses DurationCourse FeeEligibility

 

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 of Business Analytics 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

Tableau Essentials

  • 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

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 Business Analytics Certification Course

Total – 195 hours

Course Fee for Business Analytics Certification Course

INR 38, 747  plus taxes

      We also facilitate loans to students

Detailed course brochure.

Download

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

Contact us

Launch Your Global Analytics Career with IVY

Enrol Now

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.

More on Analytics

    • Analytics at IVY
    • Business Analytics Certification
    • Big Data Certification
    • Predictive Analytics with R Certification
    • Pick Your Module
    • Advanced Analytics
  • Data Visualization
Register / Sign-Up for Premium Content

Contact Us

We're currently offline. Send us an email and we'll get back to you, asap.








    Enquire Download Student Success Stories
    12,500+

    Professionals and students trained

    75+

    Analytics companies as partners

    300+

    Trainers on our panel

    5,000+

    Blog subscribers

    For Information, Career Advices & Job Alerts on Analytics, Actuarial Science:
    Subscribe to our blog

    COMPANY

    • About IVY Pro School
    • Management Team
    • Faculty
    • Careers at IVY
    • IVY Blog
    • Certificate E-verification
    • Contact Us
    • Learning Management System
    • Privacy Policy

    ANALYTICS COURSES

    • Data Science and Advanced Tableau Certification Course
    • Data Science and Big Data Analytics Certification Course
    • Predictive Analytics with R Certification
    • Data Visualization And Reporting
    • Pick Your Module
    • Advanced Analytics

    ACTUARIAL COACHING

    • Actuarial Common Entrance Test (ACET) Coaching
    • Core Technical (CT) Papers Coaching

    NEED HELP?

    • Ivy Knowledge Services (P) Ltd.
    • +91 7676882222
    • info@ivyproschool.com
    Kolkata campus

    5th Floor 14B, Camac Street. Kolkata - 700017
    +917676882222 (Central Helpline)

    Bangalore campus

    7th Floor HM Vibha Towers, Hosur Road, Near Forum Mall Chikku Lakshmaiah Layout, Adugodi, Kormangala,
    Bangalore – 560029 +91 7676882222 (Bangalore)

    New Delhi campus

    A-4, 3rd floor Adhchini Road, Block A, Sarvodaya Enclave, Nearest metro station Hauz khas
    New Delhi 1100024 / +91 7676882222 (Delhi)

    Pune campus

    Ivy Professional School
    F.C. ROAD Worklab, 318/19, Dhyaneshwar Paduka Chowk,
    Opp. Deccan Education Society Shivajinagar,
    FC Road, Pune - 411016
    +917676882222 (Pune)

    Mumbai Campus

    Ivy Knowledge Services (P) Ltd.
    16th Floor, Lodha Supremus Opposite MTNL Off JVLR, Saki Vihar Road, Powai
    Mumbai-400072.
    7676882222 (Mumbai)


    •   
    •   

    © 2016 · Ivy Knowledge Services Pvt Ltd.