Brochure
Enquire
- 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
- Home
- Edvancer Eduventures
- Courses
- Certified Data Analytics Specialist
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
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
Analytics Manager
Flipkart Pvt. Ltd.
B.E /B.Tech, Other Masters
Mr Lalit Sachan
Co Founder
Edvancer Eduventures
B.E /B.Tech, Other Masters
Mr Renold Devaraj
Data Scientist
Dell
B.E /B.Tech, MBA
Mr Abhishek Nagarjuna
Data Scientist
Freelancer
Articles
Popular Articles
prev
next
Latest Articles
Data Science vs Data Analytics - Difference between Data Science and Data Analytics
Updated On 06 Nov, 2024
Power of Data Analytics in Shaping Product Strategy and Gaining a Competitive Edge
Updated On 06 Jun, 2024
prev
next
