get app

    Certified Data Analytics Specialist

    BY
    Edvancer Eduventures

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 14995 42900

    Quick Facts

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

    Course and certificate fees

    Fees information
    ₹ 14,995  ₹42,900
    certificate availability

    Yes

    certificate providing authority

    Edvancer Eduventures

    The syllabus

    Module 1: Predictive Analytics in R

    Introduction to business analytics
    • What is analytics & why is it so important?
    • Applications of analytics
    • Different kinds of analytics
    • Various analytics tools
    • Analytics project methodology
    • Real world case study
    Fundamentals of R
    • Installation of R & R Studio
    • Getting started with R
    • Basic & advanced data types in R
    • Variable operators in R
    • Working with R data frames
    • Reading and writing data files to R
    • R functions and loops
    • Special utility functions
    • Merging and sorting data
    • Case study on data management using R
    • Practice assignment
    Data visualization in R
    • Need for data visualization
    • Components of data visualization
    • Utility and limitations
    • Introduction to grammar of graphics
    • Using the ggplot2 package in R to create visualizations
    Data preparation and cleaning using R
    • Needs & methods of data preparation
    • Handling missing values
    • Outlier treatment
    • Transforming variables
    • Derived variables
    • Binning data
    • Modifying data with Base R
    • Data processing with dplyr package
    • Using SQL in R
    • Practice assignment
    Understanding the data using univariate statistics in R
    • Summarizing data, measures of central tendency
    • Measures of variability, distributions
    • Using R to summarize data
    • Case study on univariate statistics using R
    • Practice assignment
    Hypothesis testing and ANOVA in R to guide decision making
    • Introducing statistical inference
    • Estimators and confidence intervals
    • Central Limit theorem
    • Parametric and non-parametric statistical tests
    • Analysis of variance (ANOVA)
    • Conducting statistical tests
    • Practice assignment
    Correlation and Linear regression
    • Correlation
    • Simple linear regression
    • Multiple linear regression
    • Model diagnostics and validation
    • Case study
    Logistic regression
    • Moving from linear to logistic
    • Model assumptions and Odds ratio
    • Model assessment and gains table
    • ROC curve and KS statistic
    • Case Study
    Techniques of customer segmentation
    • Need for segmentation
    • Criterion of segmentation
    • Types of distances
    • Hierarchical clustering
    • K-means clustering
    • Deciding number of clusters
    • Case study
    Time series forecasting techniques
    • Need for forecasting
    • What are time series?
    • Smoothing techniques
    • Time series models
    • ARIMA
    Decision trees & Random Forests
    • What are decision trees
    • Entropy and Gini impurity index
    • Decision tree algorithms
    • CART
    • Random Forest
    • Case Study
    Boosting Machines
    • Concept of weak learners
    • Introduction to boosting algorithms
    • Adaptive Boosting
    • Extreme Gradient Boosting (XGBoost)
    • Case study
    Cross Validation & Parameter Tuning
    • Model performance measure with cross validation
    • Parameter tuning with grid & randomised grid search

    Module 2: Data Visualization in Tableau (Videos Only)

    Introduction to Business Intelligence & Visualization
    • What is Business Intelligence?
    • What is data visualization?
    • Need for Visualization
    • Uses of visualization
    Introduction to Tableau
    • What is Tableau
    • Tableau vs. Excel
    • Installing Tableau Desktop
    • Overview of Tableau Desktop
    • Various Applications of Tableau
    • Components of Tableau Desktop
    • Benefits of Tableau and Opportunities
    • Tableau Products & Certifications
    • Tableau Architecture
    • Saving and publishing your work in Tableau
    Dive into Tableau
    • Explore Tableau Interface
    • Understand various Tableau terminologies
    • Create Different Views to Analyze Data
    • Case Study
    Fueling More Data - Connecting Data Sources
    • Connection Options
    • Data Types
    • Data Roles
    • Joins & Over Joins
    • Unions
    • Custom SQL Query
    • Data Blending
    • Editing Connections
    • Case Study 1
    • Case Study 2
    Tableau generated Fields
    • Use of Measure Names and Measure Values
    • Compare Multiple Measures
    • Fetch Number of Records In Database
    • Latitude & Longitude Fields
    • Case Study
    Data Manipulation in Tableau
    • Creating Groups
    • Creating Combined Fields
    • Sorting
    • Filtering Data
    • Sets
    • Binning Data
    • Hierarchies
    • Case Study 1
    • Case Study 2
    • Case Study 3
    Working with Dates in Tableau
    • Changing Date Levels
    • Different Date Parts
    • Custom Dates
    • Create Fiscal Dates
    • Case Study
    Data Customization with Calculations
    • Calculated Fields
    • Arithmetic Calculations
    • Date Calculation
    • String Calculation
    • Logical Calculation
    • Type Conversion Calculation
    • Table Calculation
    • Level of Detail Calculations
    • String Calculation
    • Case Study 1
    • Case Study 2
    Adding Dynamism to a View with Parameters
    • Introduction to Parameters
    • Create a Parameter
    • Explore Parameters
    • Use Parameters in Calculations
    • Parameters in Reference Lines
    • Parameters in Filters
    • Make Estimates using Parameters
    • Case Study
    Geographical Analysis & Maps
    • Where is a Geographical or Map View Useful?
    • Creating a Map view
    • Custom Geocoding
    • WMS Maps
    • Modify Locations
    • Case Study
    Creating Visualizations
    • Bar in Bar Chart
    • Scatter Plots
    • Histogram
    • Heat Maps
    • Highlighting in Tables
    • Motion Charts
    • Pie Chart
    • Bullet Chart
    • Box & Whisker Plot
    • KPI Chart
    • Market Basket Analysis Chart
    • Pareto Chart
    • Waterfall Chart
    • Best Practice for Selecting Chart Type
    • Case Study 1
    • Case Study 2
    Adding Statistics to Data
    • Reference Lines
    • Reference Bands
    • Distribution Bands
    • Trend Lines
    • Forecasting
    • Clustering
    • Summary Card
    • Case Study 1
    • Case Study 2
    Formatting & Annotation
    • Add Titles, Captions & Annotations
    • Formatting Options - Fonts, Shading, Borders etc.
    • Formatting Axes, Mark Labels and Legends
    Dashboards & Stories
    • What are Dashboards?
    • Why and How are Dashboards Useful?
    • Creating an Interactive Dashboard
    • Adding Actions to a Dashboard
    • Best Practices for Dashboard Design
    • What is a Story?
    • Creating a Story
    • Adding a Background Image to a Story
    • Case Study
    Projects & Quiz
    • Work on 3 real projects. Pass the final quiz to get our industry recognised certificate.

    Module 3: Data Analysis in SQL (Videos Only)

    Introduction To SQL
    • What is SQL?
    • Why SQL?
    • What are relational databases?
    • SQL command group
    • MS SQL Server installation
    SQL Data Types & Operators
    • SQL Data Types
    • Filtering Data
    • Arithmetic Operators
    • Comparison operators
    • Logical Operators
    • Exercises
    Useful Operations in SQL
    • Distinct Operation
    • Top N Operation
    • Sorting results
    • Combine results using Union
    • Null comparison
    • Alias
    Aggregating Data in SQL
    • Aggregate functions
    • Group By clause
    • Having clause
    • Over clause
    • Exercises
    Writing Sub-Queries in SQL
    • What are sub-queries?
    • Sub-query rules
    • Writing sub-queries
    • Exercises
    Common function in SQL
    • Ranking functions
    • Date & time functions
    • Logical functions
    • String functions
    • Conversion functions
    • Mathematical functions
    • Exercises
    Analytic Functions in SQL
    • What are analytic functions?
    • Various analytic functions
    • SQL syntax for analytic functions
    • Exercises
    Writing DML Statements
    • What are DML Statements? 
    • Insert statement 
    • Update statement 
    • Delete statement 
    • Exercises
    Writing DDL Statements
    • What are DDL Statements? 
    • Create statement 
    • Alter statement 
    • Drop statement 
    • Exercises
    Using Constraints in SQL
    • What are constraints? 
    • Not Null Constraint 
    • Unique constraint 
    • Primary key constraint 
    • Foreign key constraint 
    • Check constraint 
    • Default Constraint 
    • Exercises
    SQL Joins
    • What are joins? 
    • Cartesian Join 
    • Inner Join 
    • Left & Right Join 
    • Full Join 
    • Self Join
    Views in SQL
    • What are views? 
    • Create View 
    • Drop view 
    • Update view

    Instructors

    Mr Utsab Chakraborty

    Mr Utsab Chakraborty
    Analytics Manager
    Flipkart Pvt. Ltd.

    B.E /B.Tech, Other Masters

    Mr Lalit Sachan

    Mr Lalit Sachan
    Co Founder
    Edvancer Eduventures

    B.E /B.Tech, Other Masters

    Mr Renold Devaraj

    Mr Renold Devaraj
    Data Scientist
    Dell

    B.E /B.Tech, MBA

    Mr Abhishek Nagarjuna

    Mr Abhishek Nagarjuna
    Data Scientist
    Freelancer

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Programming Courses Cyber Security Courses Data Science Courses Law Courses Digital Marketing Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses NPTEL Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    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