• 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

Data Science and Advanced Tableau 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 -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.

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.