Blog

SQL Interview Questions and answers – 2021

1. What is DBMS? A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be termed as File Manager that manages data in a database rather than saving it in file systems. A Database Management System (DBMS) is a software application that interacts with the user, applications, and the

Questions and answers for dimensionality reductions

1. What is dimensionality reduction? When we have a dataset with multiple input features, we know the model will overfit. To reduce input feature space, we can either drop or extract features, this is basically a dimension reduction. Now let’s discuss more about both techniques. Drop irrelevant, redundant features as they do not contribute to

Statistics interview questions and answers for data scientist

Statistics interview questions and answers for data scientist

How do you assess the statistical significance of an insight? We need to perform hypothesis testing to determine statistical significance. Will take following steps. First will define null hypothesis and alternate hypothesis We will calculate p- value Last, we would set the level of the significance (alpha) and if the p-value is less than the

Exploratory data analysis

Exploratory data analysis

Eda is a first and important work in Data Analysis. Here I have created a short notes for exploratory Data analysis in python. Please click on the title or image and go through the attached jupyter notebook.