Statistics Full Course

Notes

Contact - 78801-13112
[Link]
 Statistic
s • Evaluating median in a dataset
• What is Statistics • Mode
• Types of statistics • Scipy Library
• Descriptive statistics • Mode using statistics module
• Inferential Statistics • Uisng Scipy library
• Measure of central tendency • Handling multimodal datasets
• Mean, mode, median • Measure of Dispersion
• Population mean, Sample mean • Range
• Finding mean – manual calculation • Variance
• Mean using numpy • Population & sample variance
• Mean using stats • Why sample variance formula is different than
• Average of the data set population
• Median • Variance using Numpy
• Why Median is different from mean • Variance using Pandas
• Median using numpy • Variance using Scipy
• Median using Statistics • Standard Deviation
• Median using Pandas • Standard Deviation using numpy
Website – [Link] Contact : 7880-113-112 theiscale [Link]
 Statistic
• Standard Deviation using s • Inferential statistics
pandas • Estimate
• Deviation using Scipy • Point estimate
• Data Distribution • Interval estimate
• Normal/Gaussian Disribution • Confidence interval
• Gaussian distribution - code • Significance value
• Skewness • Hypothesis testing
• Right skewed curve • Mechanism for hypothesis testing
• Positive skew curve - code • P-test
• Left skewed curve • P- test use case via code
• Negative skew curve - code • T –test
• Uniform Distribution • T-test use case via code
• Code for uniform distribution • Z – test
• Bi-modal distribution • Z- table
• Code for Bi-modal curve • Z- test use case via code
• Multimodal distribution • Two test trail
• Code for Histogram multimodal • Practice questions
Website – [Link] Contact : 7880-113-112 theiscale [Link]
 Statistic
s
For which Job Roles can this statistics course be helpful?

• Data Scientist
• Data Analyst
• Business Analyst
• Machine Learning Engineers
• AI Engineers
• BI Developers

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Statistic
s Why are we studying statistics for data science?

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Statistic
s
Data Science & Analytics
Why are we studying statistics for data science?

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Statistic
s statistics for data science?
Why are we studying

Descriptive Statistics

Regression Analysis

k-means clustering

time series analysis

A/B testing

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Types of Statistics

Descriptive Statistics Inferential Statistics

Descriptive statistics ka kaam hai kisi bhi Inferential statistics ka use karke hum ek chhoti si
dataset ke main features ko summarize, sample data se puri population ke baare mein
analyze, visualize aur describe karna. predictions ya inferences bana sakte hain.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Descriptive Statistics
Descriptive statistics ka kaam hai kisi bhi
dataset ke main features ko summarize,
analyze, visualize aur describe karna.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Descriptive Statistics
Descriptive statistics ka kaam hai kisi bhi dataset ke main features ko summarize, analyze, visualize aur
describe karna. Iska main purpose yeh hota hai ki hum data ke andar chhipe hue patterns ko samajh sakein
aur unhe simple terms mein explain kar sakein.
Common Techniques

Measures of Central Tendency - Mean (average), Median, aur Mode

Measures of Variability - Range, Variance, Standard Deviation

Data Representation - Charts, graphs, tables, frequency

distributions

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
Inferential Statistics (Inferential Statistics) ka purpose hota hai kisi sample data ka use karke
population ke baare mein conclusions aur predictions banana. Yeh statistics ke ek branch
hai jo data analysis ke baad generalized statements aur hypotheses test karne mein madad
karta hai.
Common Techniques

Hypothesis Testing
Confidence Intervals
Regression Analysis
Correlation

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question 1

What is Descriptive Statistics?

A. A method to predict future trends

B. A method to summarize and organize data
C. A method to test hypotheses
D. A method to establish a relationship between two variables

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question 2

Which of the following techniques is used in Inferential Statistics?

A. Mean
B. Hypothesis Testing
C. Frequency Distribution
D. Median

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question 3

What is the main difference between Descriptive and Inferential Statistics?

A. Descriptive statistics summarize data, while inferential statistics make predictions

or inferences about a population
B. Descriptive statistics are based on probability, while inferential statistics are not
C. Inferential statistics focus on organizing data, while descriptive statistics focus on
making predictions
D. Both deal with making predictions about data

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Measure of Central Tendency
Measures of Central ka matlab hota hai data set ke center ko samajhna. Inka use karke hum jaan sakte
hain ki data ke values kis jagah ke aas-paas clustered hain. Yeh three main types ke hote hain: Mean,
Median, aur Mode.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Mean

Mean ek statistical measure hai jo central tendency ko represent karta hai. Yeh ek dataset ke sabhi
values ka average hota hai. Hum mean ko do tarikon se calculate karte hain: Population Mean aur
Sample Mean.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Population Mean
Population Mean tab calculate kiya jata hai jab aapke paas poore population ka data available ho. Population mean ko
µ se denote kiya jata hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Sample Mean
Sample Mean tab calculate kiya jata hai jab aap population se ek chhota sample lete hain. Sample mean
ko x̄ se denote kiya jata hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Median
The median is a measure of central tendency that represents the middle value of a dataset when it is
arranged in ascending or descending order. Unlike the mean, the median is not affected by outliers or
skewed data, making it a more robust measure for datasets with extreme values.

Steps to Calculate the Median

1. Sort the dataset in ascending or descending order.

2. Determine the number of observations n.
3. Apply the appropriate formula depending on whether n is odd or even.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Mode
In statistics, the mode is a measure of central tendency that represents the value that appears most
frequently in a dataset. Unlike the mean (average) and median (middle value), the mode focuses solely
on the frequency of values.

Consider the following dataset of exam scores:

[85, 90, 90, 95, 85, 80, 85, 90, 80]

List Frequencies:

85 appears 3 times
90 appears 4 times
95 appears 1 time
80 appears 2 times
Determine Mode:

The value 90
appears most
frequently (4
times), so 90 is the
mode of this
dataset.
Website – [Link] Contact : 7880-113-112 theiscale [Link]
 Scipy Library
The scipy library is a powerful open-source Python library used for scientific and technical
computing. It builds on the numpy library and provides a wide range of functionalities for
different types of scientific and engineering tasks.

The scipy library is widely used in various fields, including:

• Engineering: For optimizing designs and control systems.

• Finance: To optimize investment portfolios and forecast economic trends.
• Medical Imaging: Enhances and analyzes diagnostic images.
• Data Science: Fills missing data and optimizes machine learning models.
• Signal Processing: Analyzes audio and vibration signals for better quality and maintenance.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question 1

If the mode of a data set is 10, what does this imply?

a) 10 is the most frequently occurring value in the data set

b) 10 is the average of the data set
c) 10 is the middle value when the data is sorted
d) 10 is the sum of all values divided by the number of values

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question 2

If a data set is perfectly symmetrical, which of the following statements is

true?

a) The mean is less than the median

b) The mean is greater than the median
c) The mean and median are equal
d) The mode and median are always equal

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question 3

In which situation is the mean not a good measure of central tendency?

a) When the data set has extreme outliers

b) When the data set is normally distributed
c) When the data set has a small number of values
d) When the data set is uniformly distributed

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Measure of Dispersion
Measure of dispersion , statistics mein data ke spread ya spread out hone ki extent ko measure karta hai. Ye
bataata hai ki data points ek mean value se kitne door hain. Inka use data ke distribution ko samajhne aur
compare karne ke liye hota hai.

Agar hum sirf mean (average) dekhte hain, to humein yeh nahi pata chalta ki data points mean se kitna
door hain.
Isliye dispersion ki measures help karti hain humein yeh samajhne mein ki data kitna spread out hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Measure of Dispersion

Range Variance Standard Deviation

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Range

In descriptive statistics, range is a simple measure of variability or spread in a data set. It

indicates how far the data points are spread out by showing the difference between the
maximum and minimum values in the dataset.

Key Points:
1. Range gives a quick sense of dispersion: If the range is small, it indicates that the data
points are close to each other. A larger range suggests that the data points are more spread
out.
2. Range is sensitive to outliers: Since the range only looks at the two extreme values
(maximum and minimum), any outlier can significantly increase the range, even if the rest of
the data is closely packed.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Variance

Variance ek statistical measure hai jo data set ki values ke beech ki variability ya

dispersion ko quantify karta hai. Yani, yeh batata hai ki data ke individual values
mean (average) se kitna door hain, aur yeh data set ka spread kitna hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Population Variance and Sample Variance are measures of dispersion that
quantify how much data points differ from the mean.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Standard Deviation
Standard Deviation ek important measure of dispersion hai statistics mein. Yeh batata hai ki aapke data points average
ke aas-paas kitna spread (faila) hue hain. Simple terms mein, standard deviation se aapko pata chalta hai ki aapke data
values mean (average) se kitni door ya paas hain.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question- 1

Which measure of dispersion is affected the least by

outliers?

a) Range
b) Variance
c) Standard Deviation
d) Median

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question- 2

Which of the following statements is true about the standard deviation?

a) It can never be zero

b) It is always larger than the range
c) It is the square root of the variance
d) It is less informative than the variance

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question- 3

If a data set has a range of 30 and a standard deviation of 6, what can you infer about
the data?

a) The standard deviation is greater than the range

b) The range is likely to be larger than the standard deviation
c) The data set is normally distributed
d) The variance is 36

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Data Distribution
Normal Distribution (Gaussian Distribution)
Ye distribution bell-shaped hoti hai, jahan data ka majority center ke aas-paas concentrated hota hai aur
gradually decrease hota hai dono taraf. Iska mean, median, aur mode sab ek hi point par hota hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Data Distribution
Skewed Distribution
Skewness ek statistical measure hai jo data distribution ki symmetry ko describe karta hai. Iska use distribution ke shape
ko samajhne ke liye kiya jata hai. Skewness ko positive, negative, ya zero ke roop me categorize kiya jata hai.

Positive Skewness Negative Skewness

(Right-Skewed) (Left-Skewed)
Website – [Link] Contact : 7880-113-112 theiscale [Link]
 Data Distribution

Uniform Distribution
Isme sabhi values ki probability equal hoti hai. Graph ek straight horizontal line hoti hai jo indicate karti
hai ki kisi bhi value ki occurrence equal chance ke saath hoti hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Data Distribution

Bimodal Distribution
Bimodal Distribution ek statistical distribution hai jisme data ke do
distinct peaks ya modes hote hain. Iska matlab hai ki data do alag-
alag clusters ya groups me divided hota hai, aur in clusters ki
frequencies alag-alag peaks ki form me show hoti hain.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Data Distribution

Multimodal Distribution ek statistical distribution hai

jisme data ke do se zyada distinct peaks ya modes hote
hain. Ye distribution complex data sets ko represent
karta hai jahan data multiple distinct groups ya clusters
me divided hota hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
Estimate

Inferential Statistics me "estimate" ka matlab hota hai kisi population parameter

(jaise population ka mean ya proportion) ko ek sample data ke basis pe approximate
karna. Jab bhi hum kisi bade group (population) ke baare me kuch conclude karte
hain sample data ke use se, to usse "estimation" kehte hain.

Types of Estimates in Inferential Statistics:

Point Estimate
Interval Estimate

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
Estimate
Types of Estimates
Point Estimate:
Definition: Point estimate ek single value hoti hai jo sample data se kisi population
parameter ka best guess hoti hai.
Example: Agar aapke sample ka mean 50 hai, toh aapka point estimate population
mean ke liye 50 hoga.

Interval Estimate:
Definition: Interval estimate ek range provide karta hai jismein population parameter
hone ki probability hoti hai. Yeh zyada reliable hota hai kyunki yeh ek range provide
karta hai, na ki ek single value.
Example: Agar aapke sample data se aapka interval estimate 45 se 55 hai, toh aap keh
sakte hain ki population mean 45 se 55 ke beech ho sakta hai with a certain level of
confidence.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics

Confidence Interval (CI) ek range hota hai jo estimate karta hai ki

kisi population parameter ki value kis range ke andar fall kar sakti
hai, aur yeh ek confidence level ke sath hota hai. Confidence
level yeh batata hai ki agar aap multiple samples lenge aur unke
confidence intervals calculate karenge, toh usme se kitne
intervals population parameter ko cover karenge.

For Example:

Agar aapke sample mean ke liye 95% confidence interval 45 se 55

hai, iska matlab hai ki aapke population mean ka 95% chance hai
ki yeh range (45 se 55) ke andar hoga.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
Hypothesis Testing
inferential statistics mein ek fundamental method hai jo help karta hai data ke basis pe
decisions lene aur conclusions draw karne mein. Yeh process decide karta hai ki sample
data ke basis pe population ke baare mein koi specific claim ya hypothesis true hai ya
nahi.

Hypothesis Testing Kya Hai?

Hypothesis Testing ek systematic method hai jisme hum ek hypothesis (assumption) ko
test karte hain aur decide karte hain ki sample data us hypothesis ko support karta hai
ya nahi. Yeh statistical inference ka ek part hai jo ki probability theory pe based hota hai.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
Hypothesis Testing Mechanism
1) Null Hypothesis (H0)
The assumptions you are beginning with

2)Alternative Hypothesis
(H1) Opposite of Null
Hypothesis

3) Experiments
Use Statistical methods (such as t-tests, z-tests, ANOVA, chi-square tests,etc) to analyze the
data.

4) Accept the null hypothesis or reject the null hypothesis

It helps researchers and analysts assess the validity of claims, evaluate the effectiveness of
interventions and draw meaningful conclusions about population
Website – [Link] Contact : 7880-113-112 theiscale [Link]
 Inferential Statistics
p-Value Test
p-Value Test inferential statistics mein ek key concept hai jo hypothesis testing ke process ka essential
part hota hai. Yeh ek measure hai jo batata hai ki sample data ko null hypothesis ke saath kitna
consistent hai. Specifically, p-value se yeh assess kiya jata hai ki null hypothesis ko reject karne ke liye
aapke sample data ke basis pe kitni evidence hai.

p-Value Kya Hai?

p-Value ek probability hai jo aapke sample data ya usse extreme results aane ki probability ko represent
karta hai, assuming ki null hypothesis sach hai. Yeh batata hai ki aapke observed results (ya aur extreme
results) ko observe karna kitna unlikely hai agar null hypothesis sach hoti.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
p-Value Test

In statistics, a t-test is a hypothesis test used to determine if there

is a significant difference between the means of two groups. It's
especially useful when dealing with small sample sizes or when
the population standard deviation is unknown. Here’s a
breakdown of what a t-test involves:
Website – [Link] Contact : 7880-113-112 theiscale [Link]
 Inferential Statistics
T Test
In statistics, a t-test is a hypothesis test used to determine if there
is a significant difference between the means of two groups. It's
especially useful when dealing with small sample sizes or when
the population standard deviation is unknown.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
Z - Test
Z-Value Test (Z-Test) inferential statistics ka ek method hota hai, jo tab use hota hai jab
aapko test karna ho ki sample ka mean population mean ke barabar hai ya nahi. Z-test ko
tab use kiya jata hai jab sample size bada ho (usually n>30n > 30n>30) ya jab population
ka standard deviation σ\sigmaσ pata ho.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Inferential Statistics
Z - Test
The average height of all the residents in a city is 168 cm, with a standard deviation = 3.9. A
doctor believes the mean to be different. He measured the height of 36 individuals and found
the average height to be 169.5 cm.
1) State null and alternate hypothesis
2) At a 95% confidence level, is there enough evidence to reject the null hypothesis

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question – 1

What is the purpose of a confidence interval in statistics?

A. To determine the exact value of a population parameter.

[Link] provide a range of values within which the population parameter is expected
to lie with a certain level of confidence.
C. To calculate the probability of a Type II error.
D. To test the null hypothesis.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question – 2

Which of the following is true about a z-test?

A. It is used when the population standard deviation is unknown.

[Link] is used for hypothesis testing when the sample size is small and the
population variance is known.
[Link] is appropriate when the sample size is large and the population standard
deviation is known.
D. It is used to test the relationship between two categorical variables.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 Practice Question – 3

If the sample mean is significantly different from the population mean based
on a z-test, what can be inferred?

A. The sample is not representative of the population.

B. The null hypothesis can be rejected, suggesting a significant difference.
C. The sample size is too small for the z-test.
D. The population variance is not known.

Website – [Link] Contact : 7880-113-112 theiscale [Link]

 How to connect with us?

Instagram Handle

theiscale [Link]
The iScale Organization Handle
Siblings - Nishant Dhote & Swati Dhote

Website – [Link] Contact : 7880-113-112 theiscale [Link]

12/09/2024, statistics youtube 3 september - Jupyter
14:07 Notebook

localhost:8888/notebooks/Documents/new/statistics youtube 3 sept/statistics youtube 3 [Link] 9/1

3
 Check out the
Premium Courses of
Data Science & Data Analyst

Contact -> 78801-13112

rc Industries
@ iSCALE

Top Companies for

Data Scientist & Analyst
Jobs
Learn alongside goal-oriented individuals & build a strong
network in top firms. This is your chance to grow with
professionals who work at revered organizaùons. Take a look
at some of the top companies:

Deloitte, Microsok Go gle EY ••***•*<

’”" y
NETFLIX
H SBC

r‹1 Adobe amazon Èi'ü!°› ••• PaG TïO-

A W A LY T ł C CISCO
ûR
1

>
accentur
Uber e
Myntra

Cognizont O PHILIPS y
lenskort
A
CONSULTANCY
SERVICES
G ol
sa ‹ 4
AMER
ICAN
Ädım an Honeywell ‹io »> Mïndtree
\tt y;D R şRMi1>ræ=e
EXPR ßYJU's
s
ESS

ïSCALE Data Science & Analytics -

05
e e Industries
@ iSCALE

Program Highlights
Immerse yourself in a curriculum that seamlessly integrates
theoretical knowledge with hands-on projects, ensuring a
comprehensive skill set in data analysis and data science.
p

12 Month Course Duration

LMS software access

Industry-Oriented Curriculum
By Industry Professionals

L
I
V
E

&

S
c
h
e
d
u
l
e
d

C
l
a
s iSCALE Data Science & Analytics -
07
 @
iSCALE
Dedicated Career
Support

Mock Interviews

professional success.

Linkedin Profile Building - Strong Linkedln profile

can contribute to career development. We help
you in making a professional Linkedin Profile.

Data Science & Analytics

 @ iSCALE
e e Industries
e
pi’ng
Hands

Program Outcomes
- According to features list
•Acquire proficiency in industry-standard tools such as
Python, SQL, and data visualization libraries to manipulate and
analyze diverse datasets effectively.
• Apply theoretical knowledge to practical scenarios
through hands-on projects, building a robust portfolio that
demonstrates your ability to tackle diverse challenges
encountered in the field.
• Master the art of conveying insights through compelling data
visualizations, using tools like Matplotlib, Seaborn, PowerBl and
Tableau to communicate complex findings in a clear and impactful
manner.
• Complete the program with a portfolio showcasing practical
projects, a comprehensive grasp of data science methodologies,
and the expertise needed to launch a successful career journey as
a Data Scientist or Data Analyst.

iSCALE Data Science & Analytics -

e e Industries
iSCALE

CERTI CATE

.tries !SCALE
lpirig
riands

CANDIDATENAME

Get the Certificate of Course Completion

Upon completion of this Course, you will receive a
verified, industry - recognized ce%ficate from our
training platform.

iSCALE Data Science & Analytics - 10

 Tools Frameworks
Learners build real-world portfolio projects that help
them master industry-standard tools, frameworks &
libraries that are used daily in thousands of companies
around the world.
-
. ,, , .
|,4ą matpæiib¡¡ț¿x upp,
sc•ex
p”qthon.|,
,
. Excel

PostgreL ! |y '¢ż PyTotch)

Pow
*
Queryt

Ke ra s t""Beautifouu
: e seabo r n . '
p"" i

jupyter
!• AH. ACO..

H .D.Â....'

ISCALE Data Sclence ß Analytics - 11

 iSCALE

The Learning
Path
Module 2

Statistics

Module
6

Module 7
Machine Learning - Il
Unsupervised

Data Science & Analytics - 12

 iSCAL
E

Module 9

Module
SQ
11
Ł

Power Bł

Module 13
Advanced Excel

Tableau

odule 15

Data Science & Analytics -

13
 iSCALE

Hands
Industry
on Oriented
Projects
01 PROJECT 02 PROJECT 03 PROJECT

Google Image IMDB Web Scrapping Movie Recommendation

Scrapping with Flask with Flask Project

04 PROJECT 05 PROJECT 06 PROJECT

suH
Œgčł
3
6
18
21

Covid 19 Analysis Whatsapp Chat Weather

Using Dash Library Analysis Prediction

0
07 PROJECT 08/PROJECT
9

Diabetes Medical Diamond Price

Prediction Prediction Prediction
Data Science & Analytics - 14
 iSCALE

Hands
Industry
on Oriented
Projects
10 PROJECT 11 PROJECT 12 PROJECT

Credit Card Object Image

Fault Detection Racking Classification

PROJECT 14 PROJECT 15 PR

Image to Indian Premier Shipping

Text League E-Commerce

16 PROJECT 17 PROJECT 18 PROJECT

flETFLI
X
Virat Kohli ODI T20 Netflix Stock Moon Mission
Performance Index Prediction Analysis Project
Data Science & Analytics - 15
Nishant Swat
Dhote i

Vibhor Bhaves
Sahu h

Bija Sweta Agrawal

y
 iSCALE
e s
Industrics
»8

Connected CE0s &

CHROs
Prasad Menon Uday Narang Harjeet Khanduja
CHRO CEO Vice President

Rahil Gupta Jaibir Siwach Jainendera Anand

CTO

iSCALE Data Science & Analytics - 17

 iSCALE
e s Industrics
»8

Ashwani Pushkaraj Dheeraj

Jaiswal Salunke Shetty
Vice President cTO CHRO

Ultra
lette

Srikanth Reddy Javed Khatri Hyder Khan

CEO CEO CEO

iSCALE Data Science & Analytics - 18

 @
iSCALE
Students
Testimonials

Manas Shubha
Bohr
Jyoti m
a

Riya ‹fia Su
rg yakant

Anwar Abhinanda
n
Khan

Bhoopendr
a

Data Science & Analytics -

 Hands'
@ iSCALE

Talk
With
We have conducted the Interview Experience Talk of the Achievers.
Focused, hard work is the real key to success. Keep your eyes on
the goal, and just keep taking the next step towards compleùng it.

TiOûR Cognizont cATERPILLAR accentur

A N A LY T f S
Siya e

Î
0
Deloitt / accenture5trat
0

e. 7yp¿g egy Ashish

MAERBK

Vishal

iSCALE Data Science B Analytics

Industries
iSCALE

CI
HSBC«›
SC0
Anand Jashan !! Ayushi Roshan

Tzeola MicrosoR
ITlasloln -I- #\OtStO Walmart
F
Anindya Vaibhav I! Ankush ! Nishant

amazo amaz.
n
on

There are approximately 400,000 bytes of data for

every grain of sand on earth. For managing this huge
data, Data Scientist & Analysts' demands are growing
globally.

iSCALE Data Science & Analytics - 21

@
iSCALE
0 * Industries
Hl @ iSCALE

UNIT 1: The Basics of Python Programming

• Understanding Problem Solving
• Why Python
• What is an IDE (Integrated Development Environment)
• Installation of Python — Anaconda & Launching of Jupiter
Notebook
• Write your first Python Program

UNIT 2: Variables and Operators in Python

• Python Arithmetic Operators
• Python Assignment Operators
• Python Boolean & Logical Operators
• Python Comparison Operators
• Python Bitwise Operator

UNIT 3: Built-in Functions of Python

• Round Functîon & Divmod Functîon
• Isinstance Funct1on & Pow Funct1on,
• Input Funct1on , int funct1on, Float Funct1on
• Len, Min and Max functîon
• Sorted Funct1on and help funct1on

iSCALE Data Science & Analytics Curr.- 02

 @ iSCALE

UNIT 4: Control Flow Statements

• If Condition
• If else Condition
• If-EIif-else Condit1on
• Nested if

UNIT 5: Concepts of Loops

• While Loop
• Break & Continue Statements
• For Loop & Range Function
• Nested Loops in Python

UNIT 6: User-Defined Functions in Python

• Introduction & Doc String
• Functions Input Arguments
• Functions Order of input Arguments
• Functions Return Statement
• Function Variable Number of Input Arguments
• *args and **kwargs in Function
• Lambda function

UNIT 7: Python Strings

• Introduction to String
• Indexing & Slicing
• Methods — strip, lower, upper
• Methods — replace, split, capitalize
• Methods — title, swapcase, find, index
iSCALE Data Science & Analytics Curr.- 03
 Industries
iSCALE

• Methods — isalnum, isalpha, isdigit

• Methods — isupper, islower, istitle, startswith, endswith
• Multiline String & checking of substring in String
• Converting String into another Data Type
• Loops in string

UNIT 8: Python List

• Introduction to List
• Slicing on List
• Indexing on List
• Methods - Append, Extend & Insert in List
• Methods - Remove, Pop, Clear
• Methods — Count, Max,Min
• Reverse, Index Count, Copy
• Using Loops in List
• Using conditional statement in List

UNIT 9: Python Tuples

• Introduction, Concatenation & Nesting
• length, count, index method, indexing & slicing
• The tuple() Constructor
• Duplicates in tuples
• max, min, unpacking of tuples
• conditional statement and loops in tuple

UNIT 10: Python Sets

• Introduction to Set
iSCALE Data Science & Analytics Curr.- 04
 Industries
iSCALE

• Methods - add, update, remove, discard, pop, clear, del, union

• Methods - intersection_update, intersection, diPerence_
update, difierence
• Methods - symmetric diPerence update,
symmetric diPerence
• Methods - isdisjoint, issuperset, issubset
• Methods - set(), max, min, copy, loops in sets

UNIT 11: Python Dictionary

• Introduction to Dictionary
• Methods-, len, dict constructor fromkeys, setdefault
• Methods - get, keys, values, items, update
• Methods - pop, popitem, del, clear, copy
• Methods - Nested Dictionaries, loops in dictionary

UNIT 12: Object Oriented Programming

• OOPS Basic concept & creating classes
• polymorphism and encapsulation
• Types of Inheritance - single, multilevel, multiple, hierarchical
• abstraction & decorator
• Types of methods - Class method, static method
• Special-magic/dunder method
• property decorators — getters, setters and deletes

UNIT 13: Files Handling

• Working with Files
iSCALE Data Science & Analytics Curr.- 05
 Industries
iSCALE

• Reading & writing files

• Buffered Read and Write
• Other File Methods
• Logging & Debugger

UNIT 14: Exception Handling

• Introduction
• Exception handling with try, except, else, and finally block of code.
• Custom Exception Handling
• List of general use exceptions
• Best Practice Exception Handling

iSCALE Data Science & Analytics Curr.- 06

P 0
Industries @
Handng
iSCALE

UNIT 1: NumPy

• Introduction to Numpy
• Numpy - Nd Array Object.
• Numpy - Data Types.
• Numpy - Array Attributes.
• Numpy - Array Creation Routines.
• Numpy - Array From Existing.
• Data Array From Numerical Ranges.
• Numpy - Indexing & Slicing.
• Numpy — Advanced Indexing.
• Numpy — Broadcasting.
• Numpy - Iterat!ng Over Array.
• Numpy - Array Manipulation.
• Numpy - Binary Operators.
• Numpy - String Functions.
• Numpy - Mathematical Functions.
• Numpy - Arithmetic Operations.
• Numpy - Statistical Functions.
• Sort, Search & Counting Functions.
• Numpy - Byte Swapping.
• Numpy - Copies &Views.
• Numpy - Matrix Library.
• Numpy - Linear Algebra.

UNIT 2: Pandas
iSCALE Data Science & Analytics Curr.- 07
 Industries
iSCALE
• Introduction to Pandas
• Reading Data From Different File Systems
• Python Pandas — Data Frame
• Python Pandas - operations
• Python Pandas - Basic Functionality
• Reading Data From Different File Systems
• Python Pandas — Re-Indexing Python
• Pandas — Iteration
• Python Pandas — Sorting.
• Working With Text Data Options & Customizat1on
• Indexing & Selecting
• Data Stat1st1caI Functions
• Python Pandas - Window Functions
• Python Pandas - Date Funct1onality
• Python Pandas —Time Delta
• Python Pandas - Categorical Data
• Python Pandas — Visualization
• Python Pandas — Tools

UNIT 3: Matplotlib
• Introduction to Matplotlib
• Bar chart
• Scatter Plot
• Bar Graph
• Histogram
• Pie Chart
• Stem Plots
• Box Vs Whisker Plot
• Area Vs Stack Plot
• Step Plot
• Fill Between Plotots
iSCALE Data Science & Analytics Curr.- 08
P 0 IJtdustries
Hends'
@ iSCALE
• subplot
• Savefig
• Axis matplotlib plots
• Text in matplotlib plots

UNIT 4: Seaborn
• Introduction to Seaborn
• Heatmap plot method
• Count plot method
• Violin Plot method
• Pair plot method
• Strip Plot method
• Box plot method
• Factor plot method
• Cat Plot method
• Styling plot method
• Facet Grid Method
• Line Plot method
• Histogram plot method
• Bar plot method
• Scatter plot method

UNIT 5: Plotly
• Introduction to Plotly
• Bubble Charts
• Bar charts
• Pie Charts
• Creating maps
• Time Series
iSCALE Data Science & Analytics Curr.- 09
P 0
Industries @ iSCALE
Handng

Project 1: Google Image Scrapping - Scraping Google Images,

involves extracting data from website the project involved sending
requests to the Google Images website, parsing the HTML content,
and extracting relevant image URLs using BeautifulSoup. This
project showcases technical skills in Python programming and data
analytics.

Project 2: Covid-19 Impacts Analysis - Covid-19 impacted the global

economy. This project is to analyze the spread of Covid-19 cases and
all the impacts of covid-19 on the economy.

Project 3: Movie-Recommendation System Project -

Recommendation systems are among the most popular applicat1ons
of data science. This project is about the recommendat1on of movies.

Project 4: WhatsApp Chats Analysis - WhatsApp is one of

the most used messenger applications today so we can use
WhatsApp chats for analyzing our chat with a friend,
customer, or a group of people.

Project 5: Image Scrapping with Flask - Image Scraping with Flask is

a Python data science project that utilizes the Flask framework. It in-
volves extracting and collecting images from various sources,
demonstrating the integration of web scraping capabilities within a
Flask web application for elective data retrieval and analysis.

iSCALE Data Science & Analytics Curr.- 10

0 * Industries
Hl @ iSCALE

UNIT 1:
• Introduction to Statistics
• Types of Statistics
• Types of Data
• Levels of Measurement

UNIT 2:
• Measures of Central Tendency
• Measures of Central Tendency in Python
• Measures of Dispersion
• Measures of Dispersion in Python
• Random Variables
• Sets
• Histogram Skewness
• Covariance Correlation
• Covariance Correlation in Python

UNIT 3:
• Probability Density Distribution Funct1on
• PDF, PMF CDF
• Types of Probability Distribution
• Bernoulli Distribution
iSCALE Data Science B Analytics Curr.- 11
 @ iSCALE
• Binomial Distribuüon
• Poisson DistribuÙon
• Normal or Gaussian Distribution

UNIT 4:
• Uniform Distribution
• Z Stats Z Table
• Central Limit Theorem

UNIT 5:
• Estimate
• Hypothesis Testing Mechanism
• P value
• Z Test with Examples
• Student T Distribution
• T Stats T Test
• When to use T test vs Z test

UNIT 6:
• Type 1 Type 2 Error
• Confidence Interval Margin of Error
• Bayes Theorem

UNIT 7:
• What is Chi Square Test
• Chi Square for Goodness of Fit
• Chi Square Test with Python

iSCALE Data Science & Analytics Curr.- 12

 @ iSCALE

UNIT 8:
• F Distribution
• Variance Rat1o Test ( F test )
• F test with Python

UNIT 9:
• Anova
• Assumptions in Anova
• Types of Anova
• Part1t1on of variance in Anova

iSCALE Data Science & Analytics Curr.- 13

0 * Industries
Hl @ iSCALE

UNIT 1:
• AI vs ML vs DL vs DS
• Supervised, Unsupervised Reinforcement Learning
• Train, Test Validation
• Variance, Bias, Overfitting Underfitting

UNIT 2:
• Handling Missing Values
• Handling Imbalanced Dataset
• SMOTE
• Data Interpolation
• Handling Outliers

UNIT 3:
• Feature Extraction
• Feature Scaling Normalization
• Normalization Min Max Scaling
• Unit Vectors Feature Scaling
• PCA

iSCALE Data Science B Analytics Curr.- 14

 @ iSCALE

UNIT 4:
• Data Encoding
• Nominal or One Hot Encoding

UNIT 5:
• Label Ordinal Encoder
• Target Guided Ordinal Encoding

iSCALE Data Science & Analytics Curr.- 15

 @ iSCALE

UNIT 1:
• EDA With Red Wine Data
Exploratory Data Analysis (EDA) With Red Wine Data" is focusing
on the analysis of a dataset related to red wine. Through statist1-
cal and visual techniques, this aims to uncover patterns, trends,
and insights within the data.

• EDA Student Performance Indicator

EDA Student Performance Indicator involves conducting Explor-
atory Data Analysis (EDA) on a dataset related to student perfor-
mance.

• EDA Forest Fires

EDA Forest Fires refers to an Exploratory Data Analysis project fo-
cusing on the examination of a dataset related to forest fires.

UNIT 2:
• EDA Flight Price
EDA Flight Price focuses on Exploratory Data Analysis for a dataset
related to flight prices.

• EDA Forest Fires

EDA Google Playstore" involves conducting Exploratory Data Anal-
ysis on a dataset related to the Google Play Store.
iSCALE Data Science & Analytics Curr.- 16
 @ iSCALE

Part 1 -
Regression
UNIT 1:
• Simple Linear Regression
• Multiple Linear Regression
• Polynomial Linear Regression

UNIT 2:
• R squared Adjusted R squared
• MSE,MAE RMSE
• Simple Linear Regression With Python
• Multiple Linear Regression

UNIT 3:
• Ridge Regression
• Lasso Regression

UNIT 4:
• Elastic Net Regression
• EDA with Algerian Forest Fire
• Model Training for Ridge, Lasso Elastic Net

iSCALE Data Science & Analytics Curr.- 17

* * Industries
*-fH1s:g iSCALE

Project 1: End to End ML Project :

Weather Prediction - Scraping Google Images, involves extracting

data from website the project involved sending requests to the
Google Images website, parsing the HTML content, and extracting
relevant image URLs using BeautifulSoup. This project showcases

PART 2: Logistics Regression

• Logistic Regression Indepth Intuition
• Logistic Regression with Regularization
• Performance Metrics Confusion Matrix, Accuracy,
Precision Recall
• Cross Validation Types
• Hyperparameter Tuning
• Logistic Regression Implementation
• Logistic Regression Multiclass Classification

Project 2: End to End ML Project :

Diabetes Prediction - Diabetes Prediction is a machine learning

project for data science designed to forecast the likelihood of
diabetes based on relevant health data. Using predictive modeling,
the project aims to assist in early detection and proactive
management of diabetes risk [Link] skills in Python
programming and data analytics.

• Decision Tree Classifier

Intuition
• Decision Tree For Numerical iSCALE Data Science & Analytics Curr.- 18
 @ iSCALE
• Post Pruning And Prepruning Decision Trees
• Decision Tree Classifier Implementation
• Decision Tree Post Pruning
• Decision Tree Regressor In depth Intuition
• Decision Tree Regressor Implementation

PART 4: Support Vector Machines

• Support Vector Classifier lndepth Intuition
• Support Vector Machines Classifier
• Support Vector Regressor Indepth Intuition
• Support Vector Regressor Implementation
• SVM Kernels Intuition
• SVM Kernels Implementation

PART 5: Naive Bayes

• Naive Bayes Indepth Intuition
• Variants Of Naive Bayes Algorithms
• Naive Bayes Practical Implementation

Project 3: End to End ML Project :

Medical Prediction - • Medical Prediction employs machine

learning for data science to forecast health outcomes based on
relevant medical data. This project aims to enhance predictive
analytics in the medical field for improved diagnosis and patient
care technical skills in Python programming and data analytics.

iSCALE Data Science & Analytics Curr.- 19

e e Industries
iSCALE

PART 6: Ensemble Techniques & its types

• Ensemble Techniques And Bagging
• Random Forest Classifier And Regressor
• Out Of Bag Score Decision Trees
• Random Forest Practical Implementation

PART 7: Boosting
• Boosting Technique
• Gradient Bosting Indepth Intuition
• Xgboost Classification Algorithms
• Xgboost Regresor Algorithm

PART 8: KNN Algorithm

• KNN Classification And Regression
• Variants Of KNN
• KNN Classifier and Regr Implementation

iSCALE Data Science & Analytics Curr.- 20

 @ iSCALE

PART 1: PCA
• Curse Of Dimensionality
• Geometric Intuition Behind PCA
• MAthemathical Intuition Of PCA
• PCA Practical Implementation

PART 2: Clustering Algorithms

• K Means Indepth Intuition
• Hierarichal Clustering Intuition
• K means vs Hierarichal Clustering
• DBSCAN Clustering
• Silhouette Score Clustering
• K Means Clustering Implementation
• Hierarichal Clustering Implementation
• DBSCAN Algorithms Implementation

UNIT 3: Anomaly Detection

• Anomaly Detect1on Isolation Fores
• DBSCAN Anomaly Detection
• Local Outlier Factor Anamoly Detection

iSCALE Data Science & Analytics Curr.- 21

e e Industries
iSCALE

PART 4: Time Series

• Introduction of time series
• components of time series
• moving average
• stationary and non stationary
• acf pacf
• arima
• time sereis model building
• Time sereis EDA

Project 1: Diamond Price Prediction - Diamond Price

Prediction is a machine learning project for data science that
predicts diamond prices based on various features. Using
algorithms, it aims to provide accurate and data-driven insights for
pricing within the diamond industry.

iSCALE Data Science & Analytics Curr.- 22

 @ iSCALE

PART 1: Neural Network & Its Perception

• Intro to Deep Learning Usecases
• Neural Network, Perceptron Mathematical Explanation

PART 2: Neural Network

• Mathematical Concepts
• Activation Functions
• Forward Back Propagation
• Implementation of ANN using Keras
• Callback Functions

UNIT 3: ANN
• Regression using ANN
• Loss Function
• Batch Normalisation
• Regularization

• Regularisation in Deep Learning

• Weight Initialisation
• Optimizers
iSCALE Data Science & Analytics Curr.- 23
 @ iSCALE
• Tensorflow
• Pytorch

Project 1: Credit card Fault detection :Credit Card Fault

Detection is a deep learning project for data science focused on
identifying fraudulent transactions within credit card data.
Leveraging neural networks, the project aims to enhance the
accuracy of fraud detection algorithms for secure financial
transactions

PART 5: CNN
• Convolutional Neural Networks
• CNN Foundation 1
• CNN 2
• CNN 3 (Explainer)
• CNN 4 (LENET)
• CNN 5 (Alex Net)
• CNN 6
• CNN 7
• VGG NET
• Resnet
• Inception Net
• RCNN
• Fast RCNN
• Faster RCNN (Object Detection)
• Non Maximum Suppression

iSCALE Data Science & Analytics Curr.- 24

e e Industries
iSCALE

PART 6: YOLO
• YOLO
• YOLO V2
• YOLO V3
• YOLO V4
• YOLO V4 Part 2
• YOLO VS

PART 7: GAN
• GAN Introduction
• Training using GAN
• DC GAN
• Style GAN
• W Gan
• GAN Practical

iSCALE Data Science & Analytics Curr.- 25

0 * Industries
Hl @ iSCALE

PART 1:
• Introduction to NLP
• History of NLP
• Why NLP
• Use of NLP
• web scrapping
• Text processing
• Understanding regex

PART 2:
• String Tokenization
• Sentence Processing
• Word Embedding
• Lemmatization in text processing
• Frequency Distribution
• Annotator creation
• Word Count
• Text Normalization
• Word 2 Vec
• Co Occurance Vector

iSCALE Data Science & Analytics Curr.- 26

e e Industries
iSCALE

PART 3: NLP
• Doc 2 Vec
• Text blob
• NLTK
• Genism
• RNN
• LSTM
• Bi LSTM

Computer Vision
• Computer Vision in data science focuses on enabling machines
to interpret and make decisions based on visual data. It involves
developing algorithms and models to analyze images or videos,
extracting meaningful information for applications like image
segmentation, object detection, and scene recognition.

• Detection of Objects detection in computer vision is the

process of identifying and locating specific objects within images
or videos. Using advanced algorithms, this technology enables
machines to recognize and draw bounding boxes around objects.

iSCALE Data Science & Analytics Curr.- 27

* 8 Industries
H T
wHed:g
iSCALE

• Scene Recognition in computer vision involves teaching

machines to understand and categorize the overall context
or
setting within an image. Through sophisticated algorithms, this
technology enables systems to identify and classify scenes.

• Image Segmentation in computer vision is the process

of dividing an image into meaningful segments or regions.
This technique, facilitated by advanced algorithms, allows for
precise identification and extraction of objects within an image.

Project 1: Object racking - Object Tracking in computer vision for

data science involves developing algorithms to follow and analyze
the movement of objects. This project aims to enhance real-time
tracking capabilities for applications such as surveillance and
autonomous systems.

Project 2: Image Classification - Image Classification" in computer

vision for data science focuses on developing algorithms to
categorize and label images based on their content. This project aims
to improve automated image recognition systems for various
applications.

Project 3: image to text - Image to Text in computer vision for data

science involves converting visual content into text using machine
learning algorithms. This project aims to enhance accessibility and
information retrieval by enabling automated extraction of textual
information from images

iSCALE Data Science & Analytics Curr.- 28

0 * Industries
Hl @ iSCALE

UNIT 1: Introduction and Installation SoRware

• Roadmap to learn SQL & syllabus discussion
• Download & Install MySQL
• Download & Install XAMPP
• Download & Install PostgreSQL & Pgadmin

UNIT 2: Fundamentals of SQL

• Introduction to SQL
• Database Fundamental
• Learning Resources - (Cheat Code |Practice Dataset|
PDF Notes & Books |Learning Website | Interview
Questions)

UNIT 3: Case Study with Example

• Create Database | Drop Database | Create Table |
Insert Table | Drop Table
• Case study with XAMPP Sokware
• Case study with MySQL software
• Case study with PostgreSQL

iSCALE Data Science & Analytics Curr.- 29

 @ iSCALE
UNIT 4: Data Types and Keys
• All Data Type in SQLs)
• ER / Database Diagram Example: Amazon Ecommerce
• Database Keys
• Cardinality of Relationships

UNIT 5: DDL Commands for SQL

• DDL Commands for Databases: Create | Drop
• DDL Commands for Table: Create | Truncate | Drop
• Data Indignity

UNIT 6: Constraints
• Constraints in MySQL (NOT NULL | UNIQUE | PRIMARY KEY)
• Constraints in MySQL (AUTO INCRIMENT | CHECK | DEFAULT
FOREIGN KEY)
• Referent1al Actions (Restrict | CASCADE | SET NULL | SET
DEFAULT

UNIT 7: Alter Table

• ADD Columns in Alter Table
• DELETE Columns in Alter Table
• MODIFY Columns in Alter Table

UNIT 8: ADD, Editing and Deleting Constraints

• ADD Constraints
• DELETE Constraints
• EDIT Problems in MySQL, Drop Constrains
iSCALE Data Science & Analytics Curr.- 30
 @ iSCALE

UNIT 9: INSERT Query

• INSERT query
• INSERT query variation
• INSERT multiple values

UNIT 10: SELECT Query

• SELECT all columns
• Filter columns
• Alias | renaming columns
• Create expression using columns
• Constant value
• DISTINCT(unique) values from a column
• DISTINCT Combinations
• Filter rows WHERE claus
• BETWEEN operator
• IN and NOT IN Operator

UNIT 11: UPDATE Query

• Update Query to update row(s)
• Update Multiple Columns

UNIT 12: DELETE

• DELETE Query to delete row(s)
• Deletion based on multiple conditions

iSCALE Data Science & Analytics Curr.- 31

 @ iSCALE
UNIT 13: Aggregate Functions
• MAX() & MIN()
• AVG()
• SUM()

UNIT 14: Scalar Functions

• ABS()
• ROUND()
• CEIL() & FLOOR()

UNIT 15: SQL Joins

• What are SQL joins?
• Types of Joins
• Cross Joins --- Cartesian Products
• Inner Joins
• Right Joins
• Left Joins
• Full Outer Join
• Set Operations
• Self-Join
• Filtering Columns
• Filtering Rows

UNIT 16: Subquery

• What is Subquery?
• Scalar Subquery
• Row Subquery
• Table Subquery
• Correlated Subquery
iSCALE Data Science & Analytics Curr.- 32
 @ iSCALE

UNIT 17: Sorting

• Fundamental of SQL Sorting
• Sorting top 10 data
• Sorting Descending Orders
• Sorting functions in datasets

UNIT 18: Grouping

• Fundamental of SQL Grouping
• Grouping Average Function
• Group By on multiple columns
• Sorting Descending Orders
• Sorting functions in datasets

UNIT 19: Project & Case Study:

Project 1: Indian Premier League (IPL Dataset)

• Case Study in Indian Premier League

• Find the top 5 batsmen in IPL
• Find the 2nd highest 6 hitters in IPL
• Find Batsman (M.S Dhoni, Virat Kohli) performance against all
IPL team
• Find the top 10 batsmen with centuries in IPL using Sub-Quires
• Find the top 5 batsmen with the highest strike rate

iSCALE Data Science & Analytics Curr.- 33

 @ iSCALE

UNIT 20: Project & Case Study:

Project 2: Shipping E-Commerce (Sorting: Smart Phone

Datasets)

• Find the top 5 Samsung phones with the biggest

screen size
• Sort all the phones in descending order of the number
of total
cameras
• Sort data on the basis of ppi in decreasing order
• Find the phone with 2nd largest battery
• Find the name and rating of the worst rated apple
phone
• Sort phones alphabetically and then on the basis of rating in
desc order
• Sort phones alphabetically and then on the basis of price in
ascending order

iSCALE Data Science & Analytics Curr.- 34

0 * Industries
Hl @ iSCALE

UNIT 1: Introduction Power BI

• How to Download, Install and upgrade features in Power BI
• User Interface and Navigation Features in Power BI
• Import First Sample Data in Power BI

UNIT 2: Charts
• Introduction to Basic Charts in Power BI
• Create a Column Chart in Power BI
• Create a Stacked Column Chart in Power BI
• Create a Pie Chart in Power BI
• Create a Donut Chart in Power BI
• Create a Funnel Chart in Power BI
• Create a Ribbon Chart in Power BI
• What is included & Exclude in Power BI
• View Data and Export in CSV from Power BI Visuals
• Create a Ribbon Chart in Power BI
• What is included & Exclude in Power BI
• View Data and Export in CSV from Power BI Visuals

UNIT 3: Tables & Matrix

• Introduction Tables & Matrix in Power BI
iSCALE Data Science & Analytics Curr.- 35
 Industries
iSCALE

• Creating a Table in Power BI

• How to Format a Table in Power BI
• How to Apply Conditional Formatting in Power BI
• How to Change Aggregations in Power BI
• Create a Matrix in Power BI
• Apply Conditional Formatting in Matrix in Power BI
• Create Hierarchies in Power BI Matrix
• Add Totals & Sub Totals in Matrix in Power BI
• How to Change Number Formatting in Power BI

UNIT 4: Slicers

• Create Slicers in Power BI

• Create Text Slicers in Power BI
• How to format Text Slicers in Power BI
• Create Date Slicers in Power BI
• How to format a Date Slicer Power BI
• Create a Number of Slicers in Power BI

UNIT 5: Charts Visualizations Tools

• Introduction to Other Charts in Power BI
• Create a Waterfall Chart in Power BI
• Create a Gauge Chart in Power BI
• Create Line Chart in Power BI
• How to Drill Down in Line Chart in Power BI
• Create an Area Chart in Power BI
• Create a Stacked Area Chart in Power BI

iSCALE Data Science & Analytics Curr.- 36

 Industries
iSCALE

• Create a Line vs Stacked Column Chart in Power BI

• Create a Line vs Cluster Column Chart in Power BI
• Create ScaRer Plot in Power BI
• Create Tree Map in Power BI

UNIT 6: Map
• Introduction Map Visualization
• Create a Basic Map in Power BI
• Creating a Filled Map in Power BI
• Creating a Map with Pie Chart in Power BI
• Use Slicer with Map of India
• Learn Formatting of Map in Power BI
• Change the Background of Maps in Power BI
• Create a Map of the International Continent Vs Donut in
Power BI

UNIT 7: Cards & Filter

• What is Cards & Filters in Power BI
• Create a Number Card in Power BI
• Create a Date Card in Power BI
• Create a Relative Date filter in Power BI
• Create a Text Card in Power BI
• How to Format a Card in Power BI
• Create a MuIt1 - Row Card in Power BI
• Create a Filter on Visual in Power BI
• Create a Filter On This Page in Power BI
iSCALE Data Science & Analytics Curr.- 37
 Industries
iSCALE
• How to Use Filter on All Pages in Power BI
• How to Use Drill through in Power BI

UNIT 8: Insert & Action Functions

• Introduction Insert & Action
• How to Insert Image in Power BI
• Create Insert Text in Power BI
• How to Insert Shapes in Power BI
• Create Insert Buttons in Power BI
• Use Web URL Action in Power BI
• Work on Page Navigation Action in Power BI
• Use Bookmark Action in Power BI
• How to create Drill through Action in Power BI
• Create Power BI Account

UNIT 9: Advanced Charts

• Introduction to Advanced Charts in Power BI Desktop
• Create Scroller in Power BI
• Create a Word Cloud in Power BI
• Create Infographics in Power BI
• Create Drill-Down Donut Chart in Power BI
• Create Drill-Waterfall Chart in Power BI
• Create Play Axis Slicer in Power BI
• Create an Animated Bar Chart Race in Power BI
• Create Sunburst Chart in Power BI
• Create Sankey Chart in Power BI
• Create Calendar & Timeline Slicers
iSCALE Data Science & Analytics Curr.- 38
 @ iSCALE

UNIT 10: KPI & Other Functions

• Introduction to Advance Function
• How to use KPI Visualization Tool
• Learn Updates in MS Power BI
• Create a Key influencer in Power BI
• Create a Decomposition Tree in Power BI
• Create a Python & R Scripting in Power BI
• Third-Party Extensions 3 Icons Introduction in Power BI

UNIT 11: Create a Superstore Report

• Create reports and dashboards documentation.
• Collaborate, share and integrate across products documentation.
• Get Power BI samples.
• Use report themes.
• Add conditional table formatting.
• Ways to share your work.
• Organize work in the new workspaces.
• Publish to web.

UNIT 12: Dashboard Functions

• How to Publish Report to Power BI Service
• Export Power BI Report into PPT, PDF & PBIX format
• Create a Pin Live Dashboard in Power BI
• What is Comment, Share & Subscribe in Power BI Reports
• How to Refresh Reports Automatically in Power BI Service
• Free Data Files Source for Practice

iSCALE Data Science & Analytics Curr.- 39

P 0
Industries @
Handng
iSCALE

Project 1: Project Title: Virat Kohli ODI T2O Performance

Index:
Descripti on: Solve a problem statement with the help of Virat
Kohli ODI T20 Performance Index Power Bi Dashboard and discuss
multiple case studies.

Project 2: Project Title: Netflix Stock Prediction & runtime

by genres
Descripti on: Solve a problem statement with the help of Netflix
Stock Prediction Datasets & analysis the runtime by genres in Power
Bi Dashboard and discuss multiple case studies.

Project 3: Project Title: Moon Mission Analysis Project

Descripti on: Solve a problem statement with the help of moon
mission datasets & analyse the multiple functions in Power Bi
Dashboard and discuss multiple case studies.

iSCALE Data Science & Analytics Curr.- 40

0 * Industries
Hl @ iSCALE

UNIT 1: Fundamental of Excel: Beginner Level

• Basic Features - Introduction
• Basic Formatting
• Using Formulas
• Save File
• Filter & Sorting
• Conditional Formatting
• Insert & Delete Columns or Rows
• Find & Remove Duplicates
• Merge and Centre

UNIT 2: Intermediate Level of Excel

• Rounding of Numbers
• Autofill in Excel
• Add or Edit Comment
• Filters for Data Manipulation
• Sorting on multiple columns
• Insert Table
• Slicers

iSCALE Data Science & Analytics Curr.- 41

 @ iSCALE

UNIT 3: Moderate Level of Excel

• Creating an Excel Column Chart
• Working with Excel Pie Charts
• Chart Group (Line, Area, Waterfall)
• Insert Picture or Shapes
• Add link or hyperlink
• Excel Sparkline's
• Add Drop Down List
• Split Text
• Page Layout Tab and Ribbon
• Printing Excel Worksheet

UNIT 4: Advance Level of Excel

• Formula Tabs & Library
• Define Names
• Formula Auditing
• Calculation Options & Watch Window
• Get and Transform Data
• Queries and Connections
• Excel data validation
• Excel PivotTables
• Excel conditional functions
• Excel Text based Functions
• Excel “What if?” Tools
• Conditional IF Function IN [EXCEL]
• Result Format with Nested—IF [Excel]
• XOR Formula (Exclusive OR) EXCEL

iSCALE Data Science & Analytics Curr.- 42

 Industries
iSCALE
• Excel VLOOKUP Funct1on
• Advance VLOOKUP Formula

UNIT 5: Data Processing and Create Visualization Dashboard

Project Title: Analysis the Online Store Annual Report

Like Mantra | AJio | Amazon | Etc.

Description: Importing data from text files Create a fully functional

online store dashboard with the analysis the store annual reports
and learn data cleaning, processing, analysis and dashboard
creation in excel.

iSCALE Data Science & Analytics Curr.- 43

0 * Industries
Hl @ iSCALE

Tableau is a business intelligence tool which is widely used in the

analytics industry. It is one of the top data visualization tools used
for data analysis and getting data driven business insights. Learn
various techniques to extract meaning from large datasets,
detailed approaches to design dashboards. Learn to create
storyboards using Tableau which enables us to transform complex
data into meaningful insights.

UNIT 1: Creating Visualizations

• Text Table and Formatting Visuals
• Heatmap and Highlight table
• Lines Area Chart
• Circle, Side by Side Circle View and Shapes
• WordCloud
• Scatter Plot
• Histogram Bins
• Gantt view and Waterfall Chart
• Refrence lines and bands, Distribution band Bullet graphs
• Dual Axes Visuals Part 1
• Dual Axes Part 2

UNIT 2: Filtering, Sorting & Connecting

• Animated Charts
iSCALE Data Science & Analytics
 Industries
iSCALE

• Funnel Charts its types

• Donut Chart Multiple Donut Chart
• Dumbbell, Barbell or DNA Chart
• Butterfly Chart
• Box Whisker Plot
• Filters in tableau part 1
• Filters in tableau part 2

UNIT 3: Dashboard & Actions

• Parameters in tableau
• Sets in tableau
• Table Calculation
• Joins & Unions
• Data Blending
• Tableau dashboard
• Tableau Server
• User Security

UNIT 4: Review of Tableau Desktop

• Bar chart
• Line chart
• Scatter plot
• Geographic map
• Filled map
• Crosstab report
• Side by side bar

iSCALE Data Science & Analytics Curr.- 45

Industries
iSCALE

• Combines axis
• Stacked bar
• Dual axis
• Bar in bar
• Heat map
• Highlight table
• Pie chart
• Tree map
• Motion chart
• Histogram
• Dashboard
• Groups
• Sets
• Dates
• Calculations
• Quick table
• Parameters
• Reference lines

iSCALE Data Science & Analytics Curr.- 46

 @ iSCALE

UNIT 1:
• Crafting an impressive Resume -
A resume is a summary of your career, whether yours is just get-
ting started or has been going on for years. In this program, we will
help you in crafting an impressive resume.

• Portfolio Building -
A portfolio helps you to organize information so that you're
always ready to apply for jobs. Your portfolio creates an image of
you in an employer's mind. In this curriculum, you will learn about
building the best portfolio.

• Interview Tips -
Interview tips will help you gain valuable insights into elective
communication and key strategies to showcase your skills
confidently.
Online face-to-face mock interviews help you train & prepare for
job interviews in a no-pressure, stress-free environment simulating a
real job interview. Mock interviews will be conducted for you in
this course.

iSCALE Data Science & Analytics Curr.- 47

 @ iSCALE
Industrics
ep
Hands

Master of
Data Analytics
Program
1. Fundamental of Python
2. Advance Python
3. Basic Python Libraries
4. Advance Python Libraries

5. Statistics
6. Feature Engineering
7. Exploratory Data Analysis
g, Machine Learning -I
Supervised
9. Machine Learning -II
Unsupervised
[Link] Learning
11. Natural Language
Processing
— NLP
12. Computer Vision
(Open CV)
13. SQL
14. Power BI
15. Advanced
Excel

[Link]
17. Placement
Preparat1on iSCALE Data Science & Analytics Curr.- 48
TAKE THE FIRST STEP
TOWARDS
YOUR DREAM CAREER IN
DATA ANALYTICS
SCIENCE

Have more questions?

Reach out to us at
WhatsApp at +91-7880-
113-112