Certification Program in Data Analytics

BY
EduBridge

Mode

Online

Duration

550 Hours

Fees

₹ 65000 72000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays

Course and certificate fees

Fees information
₹ 65,000  ₹72,000
certificate availability

Yes

certificate providing authority

EduBridge

The syllabus

Fundamentals of probability and statistics

  • Course Introduction
  • What I will be learning after this course
  • Activity
  • Project assignment Statistics
  • Introduction to Statistics
  • Methods/Types of Statistics
  • Other Basic concepts
  • Importance of statistics
  • Probability for data analytics

Introduction to Data Analytics

  • Module Introduction
  • Stars of the Project
  • What is Data?
  • Data Analytics overview
  • Types of Data Analytics
  • Data Analysis Overview
  • Process of Data Analysis
  • Role of a Data Analyst
  • Activity: Migrant & Seasonal Head Start Technical Assistance Centre-Hand Book Data Analysis
  • Quiz Activity

Project Presentation and Guidance

  • Predictive analytics-Overview
  • Simple Liners regression
  • Multiple linear regression
  • Logistic regression
  • Decision Trees and Unstructured data analysis
  • Forecasting and Time series Analysis
  • K means cluster analysis for Indian liver
  • Sales prediction using partitioning tree method
  • Classification model for thoracic surgery data
  • Fertility data analysis with R
  • Breast tissue analysis using KNN
  • Forecasting infant mortality rate in India with time series
  • Predictive model for Diabetic Retinopathy Debrecen data

Fundamentals of Python programming for Analytics

  • Introduction to Python
  • Activity- Python features
  • Python features
  • Lab Activity - Environment Setup & setting path
  • Python Environmental Variables
  • Running Python
  • Lab Activity - First Python program
  • Python Identifiers
  • Reserved Words
  • Python Variables
  • Lab Activity
  • Standard Data Types
  • Lab Activity Time
  • Sets
  • Frozen set
  • Lab Activity
  • Data Type Conversion
  • Python Basic Operators
  • Lab Activity
  • Decision Making
  • Lab Activity
  • Loops
  • Lab Activity
  • Python Functions
  • Lab Activity
  • Modules
  • Lab Activity
  • Files- I/O
  • Lab Activity
  • Directory and File Management
  • Lab Activity
  • Python Errors & Exception Handling
  • Lab Activity
  • Python OOPS
  • Lab Activity
  • Constructors
  • Inheritance
  • Lab Activity
  • Polymorphism, Encapsulation and Data Abstraction
  • Lab Activity
  • Multi-threaded Programming
  • Lab Activity
  • Assignment 2: Project: Churn E-Mail Inbox with Python
  • Capstone Project Discussion 2

Advanced Python

  • Python Libraries Introduction
  • Pandas
  • NumPy
  • Data operations
  • Lab Activity
  • Data Cleansing
  • Lab Activity
  • Data Processing
  • Lab Activity
  • Data Wrangling
  • Lab Activity
  • Data Visualization
  • Lab Activity
  • Statistical Analysis of Data using Python
  • Lab Activity
  • Activity – Solo Learn
  • Assignment 3: Project assignment: Advanced Python: Building Spam Classifier using Python
  • Capstone project Discussion 3

R programming

  • R – Overview
  • Lab Activity - Installation of R
  • Data Types
  • Lab Activity - Data Types- Vector
  • Data Types- List
  • Data Types- Matrices
  • Lab Activity - Data types List and Matrices
  • Data Types Arrays
  • Data Types - Data Frames
  • Lab Activity - Data Types- Arrays & Frames
  • Variables
  • Lab Activity - Variables
  • Operators
  • Lab Activity - Operators
  • Decision Making
  • Lab Activity - Decision Making
  • Loops
  • Lab Activity Time- Loops
  • Apply, Lapply, Sapply, Tapply in R
  • Lab Activity - Apply,Lapply, Sapply, Tapply in R
  • Functions
  • Lab Activity - Functions
  • Packages
  • Data Reshaping
  • Lab Activity - Packages & Data Reshaping
  • Data Interfaces
  • Lab Activity - Data Interfaces
  • Data Visualization
  • Statistical Analysis Using R- Mean, Median & Mode
  • T- Test in R: One Sample & Paired
  • Lab Activity
  • Capstone Project Discussion:4

Project Presentation 2

  • Python-Advanced Python -Project Presentation
  • Announcement of Star Performers

Introduction to machine learning and its algorithm

  • Overview of Machine Learning
  • Types of Machine Learning Algorithms
  • Introduction to Machine Learning with Python
  • Supervised Learning Algorithms
  • Unsupervised Learning Algorithms
  • The math of Intelligence
  • Artificial Intelligence vs Machine Learning
  • Natural Language Processing

Hands-on Machine Learning

  • Implement and demonstrate the FIND-S algorithm
  • Candidate-Elimination algorithm
  • ID3 algorithm
  • Backpropagation algorithm
  • naïve Bayesian classifier
  • Bayesian Network
  • k means algorithm
  • k-Nearest Neighbour algorithm
  • Locally Weighted Regression algorithm

Project Presentation 3

  • Machine learning Project Presentation
  • Announcement of Star Performers

Data Analytics with Excel

  • Sorting Data
  • Filtering Data
  • Split Window and Freeze Panes
  • Charts in MS Excel
  • Activity
  • Lab Activity - Pivot Tables
  • Lab Activity - VLOOKUP
  • Lab Activity - SPARKLINE in Excel
  • Lab Activity - SUMIF function in Excel
  • Lab Activity - Excel ISBLANK function in Excel
  • CSV vs Excel (.xls) - What's the Difference?
  • Assignement5: Dashboard making with Excel
  • Capstone Project Discussion 5

VBA in Excel

  • Creating a macro
  • Workbook and Worksheet object
  • Range Object
  • variable
  • If then statement
  • Loop
  • Macro Errors
  • String manipulation
  • Date and Time
  • Events
  • Array
  • Function and Sub
  • Application object
  • ActiveX controls
  • User form
  • Capstone project Discussion 6

SAS - For Beginners

  • SAS- Overview
  • SAS Environment Installation
  • SAS Studio
  • Lab Activity Time- SAS Environmental Installation
  • SAS- Program Structure
  • SAS: Data Sets
  • Lab Activity - Statistical Structure & Data Sets
  • SAS: Variables
  • Lab Activity Time- SAS Variables
  • SAS: Strings
  • SAS: Arrays
  • Lab Activity - SAS Strings & Arrays
  • SAS: Numeric Formats
  • Lab Activity - SAS Numeric Formats
  • SAS: Operators
  • Lab Activity Time- SAS Operators
  • SAS: Loops
  • SAS: Decision Making
  • Lab Activity Time- SAS Loops & Decision Making
  • SAS: Functions
  • SAS: Input Methods
  • Lab Activity Time- SAS Functions & Input Methods
  • SAS Macros
  • Lab Activity Time- SAS Macros
  • SAS: Date & Time
  • Lab Activity Time- SAS Date & Time
  • SAS: Reading Raw Data
  • SAS: Merge Data sets
  • SAS: Subsetting Data sets
  • SAS: Sorting Data sets
  • SAS: Format Data sets
  • Lab Activity Time-SAS Merge, Concatenate, Sub- setting, Sorting, Format Data Sets
  • SAS: SQL
  • SAS: Output Delivery System
  • SAS: Simulations
  • Lab Activity Time-SAS SQL, ODS & Simulations
  • SAS: Data Visualization
  • Lab Activity Time-SAS Data Visualization
  • SAS: Enterprise Guide
  • Visual Analytics
  • JMP
  • Lab Activity
  • Capstone project Discussion 7

Project Presentation 4

  • Dashboard making with Excel
  • Announcement of Star Performers

Data Visualisation with Tableau

  • Introduction to Visualization and Tableau
  • Tableau essentials
  • Creating visualisations in Tableau
  • Filter groups and sets
  • Formulas in Tableau
  • Level of detailed expressions
  • Optimizing tableau performance
  • Advanced visualisation in Tableau
  • Connecting to different data sources
  • Tableau Prep

Capstone Project

  • Capstone Project Presentation and report submission-8 (6 hrs)

Mock Interview - Advanced IT

Curriculum for Aptitude Skills

Quantitative - Number System
  • Course Introduction
  • Module Introduction
  • Number System-Basic Calculations
  • Number System-Divisibility Rule
  • Number System-Power Cycle
  • Number System-Remainder Cycle
  • App-Based Problem Solving
  • Number System - No. Of Zeros
  • Number System-Hcf & Lcm
  • Number System – Simplification
  • Number System - Surds & Indices
  • App-Based Problem Solving
  • Quiz- Student Portal

Quantitative - Percentage

  • Percentage – Basics
  • Percentage – Formula
  • Percentage - Problem Solving
  • App-Based Problem Solving
  • Quiz- Student Portal

Quantitative - Simple Interest & Compound Interest

  • Simple And Compound Interest- Basic
  • Simple And Compound Interest- Problem Solving
  • App-Based Problem Solving
  • Quiz- Student Portal

Quantitative - Profit & Loss

  • Profit & Loss - Basic
  • Profit & Loss - Formula
  • Profit & Loss - Problem Solving
  • Ratio Proportions
  • App-Based Problem Solving
  • Partnership
  • Ages
  • Mixture Allegations
  • Averages
  • App-Based Problem Solving
  • Quiz- Student Portal

Quantitative - Time Speed & Distance

  • Time Speed Distance- Basic & Formula
  • Time Speed Distance- Problem Solving
  • Problems On Trains- Basic & Formula
  • Problems On Trains- Problem Solving
  • App-Based Problem Solving
  • Boats & Streams - Basic & Formula
  • Boats & Streams - Problem Solving
  • Clocks- Basics & Formula
  • Clocks- Problem Solving
  • App-Based Problem Solving
  • Quiz- Student Portal
  • Time Speed Distance- Basic & Formula
  • Time Speed Distance- Problem Solving
  • Problems On Trains- Basic & Formula
  • Problems On Trains- Problem Solving
  • App-Based Problem Solving
  • Boats & Streams - Basic & Formula
  • Boats & Streams - Problem Solving
  • Clocks- Basics & Formula
  • Clocks- Problem Solving
  • App-Based Problem Solving
  • Quiz- Student Portal

Quantitative - Time & Work

  • Time & Work - Basic & Formula
  • Time & Work - Problem Solving
  • Pipes & Cistern - Formula & Problems
  • App-Based Problem Solving
  • Quiz- Student Portal

Quantitative - Permutation Combination & Probability

  • Permutation & Combination -Basic
  • Permutation & Combination -Formula & Types
  • Permutation & Combination- Problem Solving
  • Probability- Basic & Formula
  • Probability- Problem Solving
  • App-Based Problem Solving
  • Quiz- Student Portal

Logical Reasoning - Coding & Decoding

  • Coding-Decoding - Concept & Types
  • Coding-Decoding - Problems On Each Types
  • Number Series
  • Letter Series
  • Alpha Numeric Series
  • App-Based Problem Solving
  • Calendars
  • Direction Sense
  • Blood Relations
  • Analogy
  • App-Based Problem Solving
  • Quiz- Student Portal

Logical Reasoning - Data Arrangements

  • Seating Arrangements - Basic & Types
  • Seating Arrangements - Problems
  • Puzzle- Basics & Types
  • Puzzle - Problem Solving
  • App-Based Problem Solving
  • Quiz- Student Portal

Logical Reasoning - Data Interpretation

  • Pie Charts
  • Bar Graphs
  • Line Graphs
  • Caselets
  • Mixed Graphs
  • Tables

Analytical Reasoning - Syllogisms, Inductive & Deductive Reasoning

  • Syllogisms
  • Statements & Arguments
  • Statements & Course Of Action
  • Statements & Assumptions
  • Statements & Conclusions
  • App-Based Problem Solving
  • Quiz- Student Portal

Analytical Reasoning - Visual Reasoning

  • Dice & Cubes, Figure Counting
  • Mirror Images & Water Images
  • Series, Analogy, Classification
  • Quiz- Student Portal
  • Final Quiz- Student Portal

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books