Enrolled: 8 students
Duration: 72 hours
Lectures: 118
Level: Beginner

Working hours

Monday 10:00 am - 7:00 pm
Tuesday 10:00 am - 7:00 pm
Wednesday 10:00 am - 7:00 pm
Thursday 10:00 am - 7:00 pm
Friday 10:00 am - 7:00 pm
Saturday 10:00 am - 7:00 pm
Sunday 10:00 am - 7:00 pm

Introduction

1
Analytics and Analysis
2
Data Analytics and Business Analytics
3
Descriptive, Predictive & Prescriptive Analytics
4
Quantitative and Qualitative Data
5
Data and Visualization

Descriptive Statistics

1
Measures of central tendency and Dispersion
2
Skewness and Kurtosis
3
Percentile, Decile & Quartile
4
Histogram, Boxplot and Scatterplot

Probability and Distribution

1
Random Variable
2
Discrete and Continuous
3
Binomial and Poisson Distribution
4
Normal Distribution
5
Central Limit Theorem

Sampling and Distribution

1
Concept of population and sample
2
Simple Random Sampling
3
Stratified Random Sampling
4
Systematic Sampling
5
Theory of Estimation
6
Point and Interval Estimation
7
T distribution
8
Chi Square distribution
9
F distribution

Hypothesis Testing

1
Null & Alternative Hypothesis
2
Confidence Interval and level of significance
3
Type I and Type II error
4
P Value
5
Power of a test

Introduction to Excel

1
Text to column
2
Concatenating and splitting data
3
Simple & nested IF function
4
RIGHT and LEFT function
5
MID function
6
Customize format
7
Formatting dates
8
MATCH and INDEX function
9
VLOOKUP and HLOOKUP function
10
Conditional Formatting
11
What if analysis
12
Absolute and Relative cell reference
13
Scenarios, Goal seek and Data Table
14
Pivot Table and Visualization
15
Excel Data Analysis Tool tab
16
Histogram and Normality plot
17
One sample t test
18
Two Independent sample ttest
19
Paired ttest
20
Test of correlation
21
One way ANOVA
22
Two way ANOVA
23
Simple Linear Regression
24
Moving Average

Introduction to Mysql

1
Installing Mysql server and Mysql workbench on windows
2
Creating a database
3
Create table
4
Insert value into the table
5
DROP table
6
SQL SELECT statement
7
WHERE clause
8
HAVING clause
9
LIKE operator
10
Logical and , or
11
wild card characters
12
in , not in
13
Aggregate function
14
GROUP BY & ORDER BY clause
15
Connecting MySQL with Excel
16
Export MySQL table as CSV file
17
SQL JOIN
18
Left join, right join , cross join
19
My SQL functions
20
Character function, Numeric Function
21
Date and Time Function
22
Sub queries
23
My SQL stored routines

Tableau

1
Tableau Interface
2
Importing Excel File
3
Importing CSV file
4
Tableau connection manager
5
Physical and logical layers
6
Measures and Dimensions
7
Discrete and continuous data
8
Tableau Work space
9
Granulerity in tableau
10
Different chart types
11
Bar chart
12
Pie chart
13
Tree Map
14
Bullet chart
15
Waterfall chart
16
Pareto Chart
17
Gantt chart
18
Legend color scale
19
Gradient color scale
20
Joining data in Tableau
21
Blending data
22
Joining and blending together
23
Create relationship in tableau
24
Map
25
Group and set
26
Action filter and Quick filter
27
Scatter plot and cross tab
28
Create hierarchy
29
Calculated field
30
Create parameter
31
Tableau dashboard
32
Story telling in Tableau
33
Automation in tableau

Python Basics

1
Python data types
2
Print statement
3
IF ELIF ELSE statement
4
FOR and WHILE loop
5
User defined function
6
List and properties
7
Dictionary
8
Tuple
9
Sets
10
Introduction to Object Oriented Programming

Be the first to add a review.

Please, login to leave a review