Today's Interview QnAs
Company - Idexcel
Role- Data Scientist
1. How is the first principal component axis selected in PCA?
In Principal Component Analysis (PCA) we look to summarize a large set of correlated variables (basically a high dimensional data) into a smaller number of representative variables, called the principal components, that explains most of the variability in the original set.
The first principal component axis is selected in a way such that it explains most of the variation in the data and is closest to all n observations.
2. What are Hard-Margin and Soft-Margin SVMs?
Hard-Margin SVMs have linearly separable training data. No data points are allowed in the margin areas. This type of linear classification is known as Hard margin classification.
Soft-Margin SVMs have training data that are not linearly separable. Margin violation means choosing a hyperplane, which can allow some data points to stay either in between the margin area or on the incorrect side of the hyperplane.
3. What is the empirical rule?
In statistics, the empirical rule states that every piece of data in a normal distribution lies within three standard deviations of the mean. It is also known as the 68–95–99.7 rule. According to the empirical rule, the percentage of values that lie in a normal distribution follow the 68%, 95%, and 99.7% rule. In other words, 68% of values will fall within one standard deviation of the mean, 95% will fall within two standard deviations, and 99.75 will fall within three standard deviations of the mean.
4. What is the left-skewed distribution and the right-skewed distribution?
In the left-skewed distribution, the left tail is longer than the right side.
Mean < median < mode
In the right-skewed distribution, the right tail is longer. It is also known as positive-skew distribution.
Mode < median < mean
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company - Idexcel
Role- Data Scientist
1. How is the first principal component axis selected in PCA?
In Principal Component Analysis (PCA) we look to summarize a large set of correlated variables (basically a high dimensional data) into a smaller number of representative variables, called the principal components, that explains most of the variability in the original set.
The first principal component axis is selected in a way such that it explains most of the variation in the data and is closest to all n observations.
2. What are Hard-Margin and Soft-Margin SVMs?
Hard-Margin SVMs have linearly separable training data. No data points are allowed in the margin areas. This type of linear classification is known as Hard margin classification.
Soft-Margin SVMs have training data that are not linearly separable. Margin violation means choosing a hyperplane, which can allow some data points to stay either in between the margin area or on the incorrect side of the hyperplane.
3. What is the empirical rule?
In statistics, the empirical rule states that every piece of data in a normal distribution lies within three standard deviations of the mean. It is also known as the 68–95–99.7 rule. According to the empirical rule, the percentage of values that lie in a normal distribution follow the 68%, 95%, and 99.7% rule. In other words, 68% of values will fall within one standard deviation of the mean, 95% will fall within two standard deviations, and 99.75 will fall within three standard deviations of the mean.
4. What is the left-skewed distribution and the right-skewed distribution?
In the left-skewed distribution, the left tail is longer than the right side.
Mean < median < mode
In the right-skewed distribution, the right tail is longer. It is also known as positive-skew distribution.
Mode < median < mean
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
🔴Machine Learning Quiz
Suppose you want to apply the AdaBoost algorithm on Data D which has T observations. You set half the data for training and half for testing initially. Now you want to increase the number of data points for training T1, T2 … Tn where T1 < T2…. Tn-1 < Tn.
Suppose you want to apply the AdaBoost algorithm on Data D which has T observations. You set half the data for training and half for testing initially. Now you want to increase the number of data points for training T1, T2 … Tn where T1 < T2…. Tn-1 < Tn.
Which of the following is true about training and testing error in such a case mentioned above?
Anonymous Quiz
33%
The difference between training error and test error increases as number of observations increases
46%
The difference between training error and test error decreases as number of observations increases
13%
The difference between training error and test error will not change
8%
None of These
Excel Shortcut Hand Written Notes by CloudyML.pdf
5.2 MB
Download Excel Shortcuts Hand Written Notes.
Check our latest YouTube video in which we have shared Tableau Mock Interview session. Prepare for Data Analyst role. Video link given below
➡️https://youtu.be/OAcDEz8ac28
➡️https://youtu.be/OAcDEz8ac28
Today's Interview QnAs
Company - Idexcel
Role- Data Scientist
1. How is the first principal component axis selected in PCA?
In Principal Component Analysis (PCA) we look to summarize a large set of correlated variables (basically a high dimensional data) into a smaller number of representative variables, called the principal components, that explains most of the variability in the original set.
The first principal component axis is selected in a way such that it explains most of the variation in the data and is closest to all n observations.
2. What are Hard-Margin and Soft-Margin SVMs?
Hard-Margin SVMs have linearly separable training data. No data points are allowed in the margin areas. This type of linear classification is known as Hard margin classification.
Soft-Margin SVMs have training data that are not linearly separable. Margin violation means choosing a hyperplane, which can allow some data points to stay either in between the margin area or on the incorrect side of the hyperplane.
3. What is the empirical rule?
In statistics, the empirical rule states that every piece of data in a normal distribution lies within three standard deviations of the mean. It is also known as the 68–95–99.7 rule. According to the empirical rule, the percentage of values that lie in a normal distribution follow the 68%, 95%, and 99.7% rule. In other words, 68% of values will fall within one standard deviation of the mean, 95% will fall within two standard deviations, and 99.75 will fall within three standard deviations of the mean.
4. What is the left-skewed distribution and the right-skewed distribution?
In the left-skewed distribution, the left tail is longer than the right side.
Mean < median < mode
In the right-skewed distribution, the right tail is longer. It is also known as positive-skew distribution.
Mode < median < mean
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company - Idexcel
Role- Data Scientist
1. How is the first principal component axis selected in PCA?
In Principal Component Analysis (PCA) we look to summarize a large set of correlated variables (basically a high dimensional data) into a smaller number of representative variables, called the principal components, that explains most of the variability in the original set.
The first principal component axis is selected in a way such that it explains most of the variation in the data and is closest to all n observations.
2. What are Hard-Margin and Soft-Margin SVMs?
Hard-Margin SVMs have linearly separable training data. No data points are allowed in the margin areas. This type of linear classification is known as Hard margin classification.
Soft-Margin SVMs have training data that are not linearly separable. Margin violation means choosing a hyperplane, which can allow some data points to stay either in between the margin area or on the incorrect side of the hyperplane.
3. What is the empirical rule?
In statistics, the empirical rule states that every piece of data in a normal distribution lies within three standard deviations of the mean. It is also known as the 68–95–99.7 rule. According to the empirical rule, the percentage of values that lie in a normal distribution follow the 68%, 95%, and 99.7% rule. In other words, 68% of values will fall within one standard deviation of the mean, 95% will fall within two standard deviations, and 99.75 will fall within three standard deviations of the mean.
4. What is the left-skewed distribution and the right-skewed distribution?
In the left-skewed distribution, the left tail is longer than the right side.
Mean < median < mode
In the right-skewed distribution, the right tail is longer. It is also known as positive-skew distribution.
Mode < median < mean
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
🚨Average Salary of Data Analyst in different companies.
Check our latest YouTube Video in which we have covered Salary of Data Analyst and Highest Salary Paying Companies details. Link given below
👉🏻 https://youtu.be/_MTPJmTfb-Y
Check our latest YouTube Video in which we have covered Salary of Data Analyst and Highest Salary Paying Companies details. Link given below
👉🏻 https://youtu.be/_MTPJmTfb-Y
Today's Interview QnAs
Company Name : Elica
Role: ML Engineer
1. What is a True positive rate and a false positive rate?
True positive rate or Recall: It gives us the percentage of the true positives captured by the model out of all the Actual Positive class.
TPR = TP/ (TP+FN)
False Positive rate: It gives us the percentage of all the false positives by my model prediction from the all Actual Negative class.
FPR = FP/(FP+TN)
2. Which classification metric works on actual probability values rather then the class labels?
Log Loss is the only metric which works on the actual probability values rather than class labels. ROC curve also takes the probability values in consideration(it uses AUC score, where AUC ranges in value from 0 to 1. A model whose predictions are 100% wrong has an AUC of 0.0; one whose predictions are 100% correct has an AUC of 1.0.)
3. What is the geometric interpretation of Decision Tree?
Geometrically a decision tree divides the space by axis parallel hyperplanes which inturn divides a space into hypercubes and hypercuboids.
4. How is Surprise and Probability related?
Surprise and probability are inversely proportional. If my probability is 1 then my surprise will be 0 and when my probability is 0 then my surprise will be maximum.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company Name : Elica
Role: ML Engineer
1. What is a True positive rate and a false positive rate?
True positive rate or Recall: It gives us the percentage of the true positives captured by the model out of all the Actual Positive class.
TPR = TP/ (TP+FN)
False Positive rate: It gives us the percentage of all the false positives by my model prediction from the all Actual Negative class.
FPR = FP/(FP+TN)
2. Which classification metric works on actual probability values rather then the class labels?
Log Loss is the only metric which works on the actual probability values rather than class labels. ROC curve also takes the probability values in consideration(it uses AUC score, where AUC ranges in value from 0 to 1. A model whose predictions are 100% wrong has an AUC of 0.0; one whose predictions are 100% correct has an AUC of 1.0.)
3. What is the geometric interpretation of Decision Tree?
Geometrically a decision tree divides the space by axis parallel hyperplanes which inturn divides a space into hypercubes and hypercuboids.
4. How is Surprise and Probability related?
Surprise and probability are inversely proportional. If my probability is 1 then my surprise will be 0 and when my probability is 0 then my surprise will be maximum.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
🚨JOB OPENING MAILS
Role: Business Analyst
Company: Snaphunt
Exp : 0-5 yr
Link: https://ai.cloudyml.com/3cRPYAk
Role: Jr. Data Scientist
Company: Talentify
Exp: 0-5 yr
Link: https://ai.cloudyml.com/3ozrTAy
Role: Data Analyst
Company: Cointab Software Private Limited
Exp: 0-5 yr
Link: https://ai.cloudyml.com/3cOtAYr
Role: Data Analyst
Company: Infonyx India Private Limited
Exp: 0-3 yr
Link: https://ai.cloudyml.com/3voeDmq
ALL THE BEST💙
Role: Business Analyst
Company: Snaphunt
Exp : 0-5 yr
Link: https://ai.cloudyml.com/3cRPYAk
Role: Jr. Data Scientist
Company: Talentify
Exp: 0-5 yr
Link: https://ai.cloudyml.com/3ozrTAy
Role: Data Analyst
Company: Cointab Software Private Limited
Exp: 0-5 yr
Link: https://ai.cloudyml.com/3cOtAYr
Role: Data Analyst
Company: Infonyx India Private Limited
Exp: 0-3 yr
Link: https://ai.cloudyml.com/3voeDmq
ALL THE BEST💙
🔴 Python Interview Questions asked by MICROSOFT !
Check our latest YouTube Video in which we have covered Python Interview Questions with explained solutions for Data Science Job Roles at MICROSOFT COMPANY. Link Given Below
👉🏻 https://youtu.be/TY1BEGZKUno
Check our latest YouTube Video in which we have covered Python Interview Questions with explained solutions for Data Science Job Roles at MICROSOFT COMPANY. Link Given Below
👉🏻 https://youtu.be/TY1BEGZKUno
Date: 29-07-2022
Company name: BMW
Role- Data Analyst
Topic - Powerbi, Excel
1. How would you define Power BI as an effective solution?
Power BI is a strong business analytical tool that creates useful insights and reports by collating data from unrelated sources. This data can be extracted from any source like Microsoft Excel or hybrid data warehouses. Power BI drives an extreme level of utility and purpose using interactive graphical interface and visualizations. You can create reports using the Excel BI toolkit and share them on-cloud with your colleagues.
2. Power BI can connect to which data sources?
The data source is the point from which the data has been retrieved. It can be anything like files in various formats (.xlsx, .csv, .pbix, .xml, .txt etc), databases (SQL database, SQL Data Warehouse, Spark on Azure HDInsight), or form content packets like Google Analytics or Twilio.
3. How to maintain stock in excel sheet format?
Navigate to the Search bar and type Inventory list.
Press Enter and a list of templates for inventory management will appear.
Select the inventory template that fit your requirement. It can be used to maintain stock in excel sheet format.
4. How to separate text in excel?
Select the cells or the range of cells with text.
Navigate to Data, Click Data Tools> Text to Columns.
In the Text to Column, select Delimited.
Click Next and select the Delimiters for data.
Click Finish.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company name: BMW
Role- Data Analyst
Topic - Powerbi, Excel
1. How would you define Power BI as an effective solution?
Power BI is a strong business analytical tool that creates useful insights and reports by collating data from unrelated sources. This data can be extracted from any source like Microsoft Excel or hybrid data warehouses. Power BI drives an extreme level of utility and purpose using interactive graphical interface and visualizations. You can create reports using the Excel BI toolkit and share them on-cloud with your colleagues.
2. Power BI can connect to which data sources?
The data source is the point from which the data has been retrieved. It can be anything like files in various formats (.xlsx, .csv, .pbix, .xml, .txt etc), databases (SQL database, SQL Data Warehouse, Spark on Azure HDInsight), or form content packets like Google Analytics or Twilio.
3. How to maintain stock in excel sheet format?
Navigate to the Search bar and type Inventory list.
Press Enter and a list of templates for inventory management will appear.
Select the inventory template that fit your requirement. It can be used to maintain stock in excel sheet format.
4. How to separate text in excel?
Select the cells or the range of cells with text.
Navigate to Data, Click Data Tools> Text to Columns.
In the Text to Column, select Delimited.
Click Next and select the Delimiters for data.
Click Finish.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Forwarded from CloudyML - Data Science & Analytics
SQL Interview QnA Hand Written Notes by CloudyML.pdf
3.2 MB
🚨Download Now🚨
Roadmap to Data Science & Analytics.pdf
6.2 MB
Data Science & Analytics has become one of the most high-in-demand jobs around the globe and important fact is that anyone from any background can switch to this domain by learning the required skills.
With us, you can learn all the tools required for this industry and get complete hands on practical learning experience. We have covered everything from basics to advanced level in this Data Science and Analytics Mega Combo Course with Tutorial Videos, Practice Assignments, Projects and case studies and 1-1 Live Doubt Clearance Support over Skype Chat everyday.
Course is designed in such a way that you can become Interview ready in 5-6 months. It is also a self paced course with lifetime content access so you can learn according to your time availability and all these thing you are getting at the cheapest market price in this offer.
Course Link - https://www.cloudyml.com/mega-combo-package/
NO PRIOR CODING EXPERIENCE IS REQUIRED TO JOIN.
Happy Learning with CloudyML!
With us, you can learn all the tools required for this industry and get complete hands on practical learning experience. We have covered everything from basics to advanced level in this Data Science and Analytics Mega Combo Course with Tutorial Videos, Practice Assignments, Projects and case studies and 1-1 Live Doubt Clearance Support over Skype Chat everyday.
Course is designed in such a way that you can become Interview ready in 5-6 months. It is also a self paced course with lifetime content access so you can learn according to your time availability and all these thing you are getting at the cheapest market price in this offer.
Course Link - https://www.cloudyml.com/mega-combo-package/
NO PRIOR CODING EXPERIENCE IS REQUIRED TO JOIN.
Happy Learning with CloudyML!
Date: 30-07-2022
Company : TCS
Role: Data Scientist
Topics: Statistics, SQL, Data pipeline, Basics of Tableau
1. Give some statistical methods that are useful for data analysts.
Ans. Two main statistical methods are used in data analysis: descriptive statistics, which summarizes data using indexes such as mean and median and another is inferential statistics, which draw conclusions from data using statistical tests such as student's t-test. The tests include ANOVA, Kruskal-Wallis H test, Friedman Test, etc.
2. Difference B/w Drop, Truncate and Delete?
Ans. Delete is used to delete one or more tuples of a table. With the help of the “DROP” command we can drop (delete) the whole structure in one go i.e. it removes the named elements of the schema. Truncate is used to delete all the rows of a table.
3. What is the importance of a dashboard in tableau?
Ans. Building dashboards with Tableau allows even non-technical users to create interactive, real-time visualizations in minutes. In just a few clicks, they can combine data sources, add filters, and drill down into specific information.
4. Explain the transformation phase of the data pipeline.
Ans. Transformation refers to operations that change data, which may include data standardization, sorting, deduplication, validation, and verification. The ultimate goal is to make it possible to analyze the data.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company : TCS
Role: Data Scientist
Topics: Statistics, SQL, Data pipeline, Basics of Tableau
1. Give some statistical methods that are useful for data analysts.
Ans. Two main statistical methods are used in data analysis: descriptive statistics, which summarizes data using indexes such as mean and median and another is inferential statistics, which draw conclusions from data using statistical tests such as student's t-test. The tests include ANOVA, Kruskal-Wallis H test, Friedman Test, etc.
2. Difference B/w Drop, Truncate and Delete?
Ans. Delete is used to delete one or more tuples of a table. With the help of the “DROP” command we can drop (delete) the whole structure in one go i.e. it removes the named elements of the schema. Truncate is used to delete all the rows of a table.
3. What is the importance of a dashboard in tableau?
Ans. Building dashboards with Tableau allows even non-technical users to create interactive, real-time visualizations in minutes. In just a few clicks, they can combine data sources, add filters, and drill down into specific information.
4. Explain the transformation phase of the data pipeline.
Ans. Transformation refers to operations that change data, which may include data standardization, sorting, deduplication, validation, and verification. The ultimate goal is to make it possible to analyze the data.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
🚨Job Opening at HDFC Bank
Role - Data Analyst
Department - Credit analytics unit of HDFC Bank
Expectation -
3-4 years work exp handling voluminous data using sql / python
Day to day work proficiency in python - need not be an expert to start with
Inferring data and reading data skill set must - top of priority item
Simple reports prep and disciplined way of working expected
Location - Chennai \ Mumbai \ Bangalore
Send Your Resume to this E-Mail ID
RamaJagan.SampathKumar@hdfcbank.com
NOTE - Preferably bfsi candidates but not mandatory as long as they have worked with voluminous data analysis and inference
Role - Data Analyst
Department - Credit analytics unit of HDFC Bank
Expectation -
3-4 years work exp handling voluminous data using sql / python
Day to day work proficiency in python - need not be an expert to start with
Inferring data and reading data skill set must - top of priority item
Simple reports prep and disciplined way of working expected
Location - Chennai \ Mumbai \ Bangalore
Send Your Resume to this E-Mail ID
RamaJagan.SampathKumar@hdfcbank.com
NOTE - Preferably bfsi candidates but not mandatory as long as they have worked with voluminous data analysis and inference
#Quiz
If we have a string variable named Weather = “Rainfall”, which of the following will print the substring or all characters before the “f”?
If we have a string variable named Weather = “Rainfall”, which of the following will print the substring or all characters before the “f”?
Anonymous Quiz
9%
print(Weather[4:])
16%
print(Weather[1:4])
62%
print(Weather[:4])
13%
print(Weather[:”f”])
SQL interview questions asked by ORACLE Company. Follow the link below and watch our latest YouTube video in which we have covered all the important questions with explained solution.
Check Now - https://youtu.be/YRKDfiljKV4
Check Now - https://youtu.be/YRKDfiljKV4
Today's Interview QnAs
Company - Wipro
Role- Data Analyst
1. What are different types of Collation Sensitivity?
Following are the different types of Collation Sensitivity:
- Case sensitive: A and a, B and b
- Kana sensitive: Japanese Kana characters
- Width sensitive: single byte characters and double-byte characters.
- Accent Sensitive.
2. What is OLTP ?
OLTP or Online Transaction Processing is a type of data processing that consists of executing a number of transactions occurring concurrently—online banking, shopping, order entry, or sending text messages, for example. These transactions traditionally are referred to as economic or financial transactions, recorded and secured so that an enterprise can access the information anytime for accounting or reporting purposes.
3. What is OLAP?
OLAP stands for On-Line Analytical Processing. OLAP is a classification of software technology which authorizes analysts, managers, and executives to gain insight into information through fast, consistent, interactive access in a wide variety of possible views of data that has been transformed from raw information to reflect the real dimensionality of the enterprise as understood by the clients.
OLAP implement the multidimensional analysis of business information and support the capability for complex estimations, trend analysis, and sophisticated data modeling.
4. How OLAP Works?
Fundamentally, OLAP has a very simple concept. It pre-calculates most of the queries that are typically very hard to execute over tabular databases, namely aggregation, joining, and grouping. These queries are calculated during a process that is usually called 'building' or 'processing' of the OLAP cube. This process happens overnight, and by the time end users get to work - data will have been updated.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company - Wipro
Role- Data Analyst
1. What are different types of Collation Sensitivity?
Following are the different types of Collation Sensitivity:
- Case sensitive: A and a, B and b
- Kana sensitive: Japanese Kana characters
- Width sensitive: single byte characters and double-byte characters.
- Accent Sensitive.
2. What is OLTP ?
OLTP or Online Transaction Processing is a type of data processing that consists of executing a number of transactions occurring concurrently—online banking, shopping, order entry, or sending text messages, for example. These transactions traditionally are referred to as economic or financial transactions, recorded and secured so that an enterprise can access the information anytime for accounting or reporting purposes.
3. What is OLAP?
OLAP stands for On-Line Analytical Processing. OLAP is a classification of software technology which authorizes analysts, managers, and executives to gain insight into information through fast, consistent, interactive access in a wide variety of possible views of data that has been transformed from raw information to reflect the real dimensionality of the enterprise as understood by the clients.
OLAP implement the multidimensional analysis of business information and support the capability for complex estimations, trend analysis, and sophisticated data modeling.
4. How OLAP Works?
Fundamentally, OLAP has a very simple concept. It pre-calculates most of the queries that are typically very hard to execute over tabular databases, namely aggregation, joining, and grouping. These queries are calculated during a process that is usually called 'building' or 'processing' of the OLAP cube. This process happens overnight, and by the time end users get to work - data will have been updated.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Watch our latest YouTube video in which we have covered Important Aptitude Problems aksed in LTI Company. Don't Miss. Follow this link below
➡️ https://youtu.be/vT-BLruIdKU
➡️ https://youtu.be/vT-BLruIdKU
Date: 01st August, 2022
Company - Spinny
Role - Data Analyst
Topics - Excel, SQL, PowerBI, Tableau
1.How to add drop down in excel?
Here is how to create a drop-down list in Excel –
Select the cells you want to contain in the drop-down list.
Go to ribbon and click “Data,” then “Data Validation.”
In the dialog box, select “Allow to List.”
Click on Source and type the numbers or text that you want in your drop-down lists.
Click OK to continue.
Note that commas should separate the numbers and texts.
2. What are the types of SQL Queries?
We have four types of SQL Queries:
DDL (Data Definition Language): the creation of objects
DML (Data Manipulation Language): manipulation of data
DCL (Data Control Language): assignment and removal of permissions
TCL (Transaction Control Language): saving and restoring changes to a database
3.What are the various refresh options available in Power BI?
There are essentially four major types of refresh options available in Power BI
Package refresh
Model/data refresh
Tile Refresh
Visual container refresh
4.What is bin in tableau?
Bins in tableau are containers of equal size used to store data values fitting in bin size. In other words, bins group the data into groups of equal size or data which can be used in systematic viewing of data. All the discrete fields in tableau can also be considered as set of bins.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company - Spinny
Role - Data Analyst
Topics - Excel, SQL, PowerBI, Tableau
1.How to add drop down in excel?
Here is how to create a drop-down list in Excel –
Select the cells you want to contain in the drop-down list.
Go to ribbon and click “Data,” then “Data Validation.”
In the dialog box, select “Allow to List.”
Click on Source and type the numbers or text that you want in your drop-down lists.
Click OK to continue.
Note that commas should separate the numbers and texts.
2. What are the types of SQL Queries?
We have four types of SQL Queries:
DDL (Data Definition Language): the creation of objects
DML (Data Manipulation Language): manipulation of data
DCL (Data Control Language): assignment and removal of permissions
TCL (Transaction Control Language): saving and restoring changes to a database
3.What are the various refresh options available in Power BI?
There are essentially four major types of refresh options available in Power BI
Package refresh
Model/data refresh
Tile Refresh
Visual container refresh
4.What is bin in tableau?
Bins in tableau are containers of equal size used to store data values fitting in bin size. In other words, bins group the data into groups of equal size or data which can be used in systematic viewing of data. All the discrete fields in tableau can also be considered as set of bins.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 7000+ HAPPY LEARNERS
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Amazon QuickSight, Google Data Studio, Excel, Case studies, Interview QnAs PDF, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo