Date: 16-09-2022
Company name: Blinkit
Role: ML Engineer
Topic: Machine Learning, Deep Learning
1. What is Clustering?
Clustering is the process of grouping a set of objects into a number of groups. Objects should be similar to one another within the same cluster and dissimilar to those in other clusters.
A few types of clustering are:
Hierarchical clustering
K means clustering
Density-based clustering
2. What is Reinforcement Learning?
Reinforcement learning is different from the other types of learning like supervised and unsupervised. In reinforcement learning, we are given neither data nor labels. Our learning is based on the rewards given to the agent by the environment.
3. Difference Between Sigmoid and Softmax functions?
Sigmoid is used for binary classification methods where we only have 2 classes, while SoftMax applies to multiclass problems. Sigmoid receives just one input and only outputs a single number that represents the probability of belonging to class1 (remember that we only have 2 classes so the probability of belonging to class2 = 1 - P(class1)). While on the other hand SoftMax is vectorized, meaning that takes a vector with the same number of entries as classes we have and outputs another vector where each component represents the probability of belonging to that class.
4. What is P-value?
P-values are used to make a decision about a hypothesis test. P-value is the minimum significant level at which you can reject the null hypothesis. The lower the p-value, the more likely you reject the null hypothesis.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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: Blinkit
Role: ML Engineer
Topic: Machine Learning, Deep Learning
1. What is Clustering?
Clustering is the process of grouping a set of objects into a number of groups. Objects should be similar to one another within the same cluster and dissimilar to those in other clusters.
A few types of clustering are:
Hierarchical clustering
K means clustering
Density-based clustering
2. What is Reinforcement Learning?
Reinforcement learning is different from the other types of learning like supervised and unsupervised. In reinforcement learning, we are given neither data nor labels. Our learning is based on the rewards given to the agent by the environment.
3. Difference Between Sigmoid and Softmax functions?
Sigmoid is used for binary classification methods where we only have 2 classes, while SoftMax applies to multiclass problems. Sigmoid receives just one input and only outputs a single number that represents the probability of belonging to class1 (remember that we only have 2 classes so the probability of belonging to class2 = 1 - P(class1)). While on the other hand SoftMax is vectorized, meaning that takes a vector with the same number of entries as classes we have and outputs another vector where each component represents the probability of belonging to that class.
4. What is P-value?
P-values are used to make a decision about a hypothesis test. P-value is the minimum significant level at which you can reject the null hypothesis. The lower the p-value, the more likely you reject the null hypothesis.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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
❤1
Check explanation video of SQL interview Round in LinkedIn. Watch our latest YouTube video, link given below.
👉🏻https://youtu.be/EhGWtmX8YLE
👉🏻https://youtu.be/EhGWtmX8YLE
Date: 17-09-2022
Company: Musigma
Role: Data Analyst
Topic: PowerBI, SQL, Data analysis
1. Where is the data stored in Power BI?
Primarily, PowerBI uses two repositories to store its data: Azure Blob Storage and Azure SQL Database. Azure Blob Storage typically stores the data that is uploaded by the users. Azure SQL Database stores all the metadata and artifacts for the system itself.
2. What do you understand by query optimization?
The phase that identifies a plan for evaluation query which has the least estimated cost is known as query optimization.
The advantages of query optimization are as follows:
The output is provided fasterA larger number of queries can be executed in less timeReduces time and space complexity
3. Which questions should you ask the user/client before you create a dashboard?
Though this depends on the user’s requirements, still some of the common questions that I would ask the client before creating a dashboard are :
What is the purpose of the dashboard?Should the dashboard be retrospective or real-time?How detailed the dashboard should be?How tech and data-savvy is the end-user?Does the data need to be segmented?Should I explain the dashboard design to you?
4. What are the common problems that data analysts encounter during analysis?
The common problems steps involved in any analytics project are:
Handling duplicate data
Collecting the meaningful right data at the right time
Handling data purging and storage problems
Making data secure and dealing with compliance issues
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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: Musigma
Role: Data Analyst
Topic: PowerBI, SQL, Data analysis
1. Where is the data stored in Power BI?
Primarily, PowerBI uses two repositories to store its data: Azure Blob Storage and Azure SQL Database. Azure Blob Storage typically stores the data that is uploaded by the users. Azure SQL Database stores all the metadata and artifacts for the system itself.
2. What do you understand by query optimization?
The phase that identifies a plan for evaluation query which has the least estimated cost is known as query optimization.
The advantages of query optimization are as follows:
The output is provided fasterA larger number of queries can be executed in less timeReduces time and space complexity
3. Which questions should you ask the user/client before you create a dashboard?
Though this depends on the user’s requirements, still some of the common questions that I would ask the client before creating a dashboard are :
What is the purpose of the dashboard?Should the dashboard be retrospective or real-time?How detailed the dashboard should be?How tech and data-savvy is the end-user?Does the data need to be segmented?Should I explain the dashboard design to you?
4. What are the common problems that data analysts encounter during analysis?
The common problems steps involved in any analytics project are:
Handling duplicate data
Collecting the meaningful right data at the right time
Handling data purging and storage problems
Making data secure and dealing with compliance issues
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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
Become Job-Ready for the roles like Data Scientist, Data Analyst, Business Analyst, Research Analyst, ML Engineer etc with our MEGA COMBO COURSE PACKAGE.
It covers everything which you need to know.
✅Python
✅SQL
✅Maths & Statistics
✅Machine Learning
✅Deep Learning
✅AWS Sagamaker
✅Model Deployment
✅Tableau
✅PowerBi
✅R Language
✅MS Excel
✅DSA
✅AWS QuickSight
✅Google Data Studio
✅Interview QnA PDFs
✅Capstone Projects
✅Case Studies
With Personal Chat Support for Doubt Clearance Everyday (Including weekends).
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Also you will get all future updates(new courses, new projects and new practice assignments) for FREE in our Mega Combo Offer.
THIS IS THE COMPLETE ROADMAP TO DATA SCIENCE DOMAIN AT CHEAPEST MARKET PRICE AVAILABLE.
Check Course Now👉🏻 https://ai.cloudyml.com/Mega-Combo
It covers everything which you need to know.
✅Python
✅SQL
✅Maths & Statistics
✅Machine Learning
✅Deep Learning
✅AWS Sagamaker
✅Model Deployment
✅Tableau
✅PowerBi
✅R Language
✅MS Excel
✅DSA
✅AWS QuickSight
✅Google Data Studio
✅Interview QnA PDFs
✅Capstone Projects
✅Case Studies
With Personal Chat Support for Doubt Clearance Everyday (Including weekends).
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Also you will get all future updates(new courses, new projects and new practice assignments) for FREE in our Mega Combo Offer.
THIS IS THE COMPLETE ROADMAP TO DATA SCIENCE DOMAIN AT CHEAPEST MARKET PRICE AVAILABLE.
Check Course Now👉🏻 https://ai.cloudyml.com/Mega-Combo
❤1
Date: 18-09-2022
Company : Elica
Role: Data Scientist
Topic: Machine learning, Python
1. What is a kernel function in SVM?
In the SVM algorithm, a kernel function is a special mathematical function. In simple terms, a kernel function takes data as input and converts it into a required form. This transformation of the data is based on something called a kernel trick, which is what gives the kernel function its name. Using the kernel function, we can transform the data that is not linearly separable (cannot be separated using a straight line) into one that is linearly separable.
2. What do you understand by the F1 score?
The F1 score represents the measurement of a model's performance. It is referred to as a weighted average of the precision and recall of a model. The results tending to 1 are considered as the best, and those tending to 0 are the worst. It could be used in classification tests, where true negatives don't matter much.
3. What is the lambda function?
Lambda functions are an anonymous or nameless function.
These functions are called anonymous because they are not declared in the standard manner by using the def keyword. It doesn’t require the return keyword as well. These are implicit in the function.
The function can have any number of parameters but can have just one statement and return just one value in the form of an expression. They cannot contain commands or multiple expressions.
An anonymous function cannot be a direct call to print because lambda requires an expression.
Lambda functions have their own local namespace and cannot access variables other than those in their parameter list and those in the global namespace.
Example:
x = lambda i,j: i+j
print(x(7,8))
Output: 15
4. 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)
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company : Elica
Role: Data Scientist
Topic: Machine learning, Python
1. What is a kernel function in SVM?
In the SVM algorithm, a kernel function is a special mathematical function. In simple terms, a kernel function takes data as input and converts it into a required form. This transformation of the data is based on something called a kernel trick, which is what gives the kernel function its name. Using the kernel function, we can transform the data that is not linearly separable (cannot be separated using a straight line) into one that is linearly separable.
2. What do you understand by the F1 score?
The F1 score represents the measurement of a model's performance. It is referred to as a weighted average of the precision and recall of a model. The results tending to 1 are considered as the best, and those tending to 0 are the worst. It could be used in classification tests, where true negatives don't matter much.
3. What is the lambda function?
Lambda functions are an anonymous or nameless function.
These functions are called anonymous because they are not declared in the standard manner by using the def keyword. It doesn’t require the return keyword as well. These are implicit in the function.
The function can have any number of parameters but can have just one statement and return just one value in the form of an expression. They cannot contain commands or multiple expressions.
An anonymous function cannot be a direct call to print because lambda requires an expression.
Lambda functions have their own local namespace and cannot access variables other than those in their parameter list and those in the global namespace.
Example:
x = lambda i,j: i+j
print(x(7,8))
Output: 15
4. 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)
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Get a complete roadmap to Business Analytics domain. Watch our latest YouTube video now. link below
👉🏻https://youtu.be/UvLXsyaMptU
👉🏻https://youtu.be/UvLXsyaMptU
Date: 19-09-2022
Company name: Adecco
Role: Data Analyst
Topic: Tableau , PowerBi , SQL
1.What is a stored procedure?
Stored Procedure is a function consists of many SQL statements to access the database system. Several SQL statements are consolidated into a stored procedure and execute them whenever and wherever required.
2.What is Power Query?
Power Query is a business intelligence tool designed by Microsoft for Excel. Power Query allows you to import data from various data sources and will enable you to clean, transform and reshape your data as per the requirements. Power Query allows you to write your query once and then run it with a simple refresh.
3.What is the Use of Dual-axis in Tableau?
Ans: Dual Axis allows you to compare measures, and this is useful when you want to compare two measures that have different scales.
4.What is an Alias in SQL?
An alias is a feature of SQL that is supported by most, if not all, RDBMSs. It is a temporary name assigned to the table or table column for the purpose of a particular SQL query. In addition, aliasing can be employed as an confusion technique to secure the real names of database fields. A table alias is also called a correlation name.
An alias is represented explicitly by the AS keyword but in some cases, the same can be performed without it as well.
5.Gantt chart in Tableau ?
A Tableau Gantt chart illustrates the duration of events as well as the progression of value across the period. Along with the time axis, it has bars. The Gantt chart is primarily used as a project management tool, with each bar representing a project job.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company name: Adecco
Role: Data Analyst
Topic: Tableau , PowerBi , SQL
1.What is a stored procedure?
Stored Procedure is a function consists of many SQL statements to access the database system. Several SQL statements are consolidated into a stored procedure and execute them whenever and wherever required.
2.What is Power Query?
Power Query is a business intelligence tool designed by Microsoft for Excel. Power Query allows you to import data from various data sources and will enable you to clean, transform and reshape your data as per the requirements. Power Query allows you to write your query once and then run it with a simple refresh.
3.What is the Use of Dual-axis in Tableau?
Ans: Dual Axis allows you to compare measures, and this is useful when you want to compare two measures that have different scales.
4.What is an Alias in SQL?
An alias is a feature of SQL that is supported by most, if not all, RDBMSs. It is a temporary name assigned to the table or table column for the purpose of a particular SQL query. In addition, aliasing can be employed as an confusion technique to secure the real names of database fields. A table alias is also called a correlation name.
An alias is represented explicitly by the AS keyword but in some cases, the same can be performed without it as well.
5.Gantt chart in Tableau ?
A Tableau Gantt chart illustrates the duration of events as well as the progression of value across the period. Along with the time axis, it has bars. The Gantt chart is primarily used as a project management tool, with each bar representing a project job.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS WITH CLOUDYML FROM SCRATCH. TRUSTED BY 8000+ HAPPY LEARNERS
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
🚨JOB OPENING ALERT🚨
Role: Data Analyst
Company: Rystad Energy India Private Limited
Exp: Fresher
Link: https://ai.cloudyml.com/3RNnAid
Role: Machine Learning Engineer
Company: Resonating Mindz Private Limited
Exp: Fresher
Link: https://ai.cloudyml.com/3RWGcwn
Role: AI Engineer Company: (Computer Vision)
Diycam India Pvt Ltd
Exp: Fresher
Link: https://ai.cloudyml.com/3RW2MF9
Role: Business Analyst / Sr Business Analyst
Company: Cogniter Technologies.
Exp: Fresher
Link: https://ai.cloudyml.com/3UjDmTC
ALL THE BEST💙
Role: Data Analyst
Company: Rystad Energy India Private Limited
Exp: Fresher
Link: https://ai.cloudyml.com/3RNnAid
Role: Machine Learning Engineer
Company: Resonating Mindz Private Limited
Exp: Fresher
Link: https://ai.cloudyml.com/3RWGcwn
Role: AI Engineer Company: (Computer Vision)
Diycam India Pvt Ltd
Exp: Fresher
Link: https://ai.cloudyml.com/3RW2MF9
Role: Business Analyst / Sr Business Analyst
Company: Cogniter Technologies.
Exp: Fresher
Link: https://ai.cloudyml.com/3UjDmTC
ALL THE BEST💙
CloudyML Mega Combo Course Package Brochure-1.pdf
7.9 MB
Check our course brochure and switch your career to Data Science & Analytics with our Mega Combo Course.
Date: 20th Sept, 2022
Company name: Datanyze
Role: ML Engineer
Topic: Machine Learning
1. Explain how a ROC curve works.
Answer: The ROC curve is a graphical representation of the contrast between true positive rates and the false positive rate at various thresholds. It’s often used as a proxy for the trade-off between the sensitivity of the model (true positives) vs the fall-out or the probability it will trigger a false alarm (false positives).
2. How can you select K for K-means Clustering?
There are two kinds of methods that include direct methods and statistical testing methods:
• Direct methods: It contains elbow and silhouette
• Statistical testing methods: It has gap statistics.
The silhouette is the most frequently used while determining the optimal value of k
3. What is P-value?
P-values are used to make a decision about a hypothesis test. P-value is the minimum significant level at which you can reject the null hypothesis. The lower the p-value, the more likely you reject the null hypothesis.
4. What is Semi-supervised Machine Learning?
Supervised learning uses data that is completely labeled, whereas unsupervised learning uses no training data.
In the case of semi-supervised learning, the training data contains a small amount of labeled data and a large amount of unlabeled data.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS FROM SCRATCH. CHECK OUT OUR MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company name: Datanyze
Role: ML Engineer
Topic: Machine Learning
1. Explain how a ROC curve works.
Answer: The ROC curve is a graphical representation of the contrast between true positive rates and the false positive rate at various thresholds. It’s often used as a proxy for the trade-off between the sensitivity of the model (true positives) vs the fall-out or the probability it will trigger a false alarm (false positives).
2. How can you select K for K-means Clustering?
There are two kinds of methods that include direct methods and statistical testing methods:
• Direct methods: It contains elbow and silhouette
• Statistical testing methods: It has gap statistics.
The silhouette is the most frequently used while determining the optimal value of k
3. What is P-value?
P-values are used to make a decision about a hypothesis test. P-value is the minimum significant level at which you can reject the null hypothesis. The lower the p-value, the more likely you reject the null hypothesis.
4. What is Semi-supervised Machine Learning?
Supervised learning uses data that is completely labeled, whereas unsupervised learning uses no training data.
In the case of semi-supervised learning, the training data contains a small amount of labeled data and a large amount of unlabeled data.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS FROM SCRATCH. CHECK OUT OUR MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
🤩1
If you think that only experienced people can become a Data Scientist then you should watch our first podcast Episode of CAREER KI BAAT WITH AKASH RAJ and know how a fresher can become a Data Scientist on our YouTube channel. Link below
👉🏻https://youtu.be/ECmVjp-MCsc
👉🏻https://youtu.be/ECmVjp-MCsc
Date: 21st Sept, 2022
Company name: Wipro
Role: SQL Developer
1. Explain different character-manipulation functions in sql.
The character manipulation functions in SQL are as follows:
A) CONCAT (joining two or more values): This function is used to join two or more values together. The second string is always appended to the end of the first string.
B) SUBSTR: This function returns a segment of a string from a given start point to a given endpoint.
C) LENGTH: This function returns the length of the string in numerical form, including blank spaces.
D) INSTR: This function calculates the precise numeric location of a character or word in a string.
2. What is a UNIQUE constraint?
The UNIQUE Constraint prevents identical values in a column from appearing in two records. The UNIQUE constraint guarantees that every value in a column is unique.
3. What is BLOB and TEXT in MySQL?
BLOB stands for Binary Huge Objects and can be used to store binary data, whereas TEXT may be used to store a large number of strings. BLOB may be used to store binary data, which includes images, movies, audio, and applications.
TEXT values behave similarly to a character string or a non-binary string.
4. What do you mean by Denormalization?
Denormalization refers to a technique which is used to access data from higher to lower forms of a database. It helps the database managers to increase the performance of the entire infrastructure as it introduces redundancy into a table. It adds the redundant data into a table by incorporating database queries that combine data from various tables into a single table.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS FROM SCRATCH. CHECK OUT OUR MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company name: Wipro
Role: SQL Developer
1. Explain different character-manipulation functions in sql.
The character manipulation functions in SQL are as follows:
A) CONCAT (joining two or more values): This function is used to join two or more values together. The second string is always appended to the end of the first string.
B) SUBSTR: This function returns a segment of a string from a given start point to a given endpoint.
C) LENGTH: This function returns the length of the string in numerical form, including blank spaces.
D) INSTR: This function calculates the precise numeric location of a character or word in a string.
2. What is a UNIQUE constraint?
The UNIQUE Constraint prevents identical values in a column from appearing in two records. The UNIQUE constraint guarantees that every value in a column is unique.
3. What is BLOB and TEXT in MySQL?
BLOB stands for Binary Huge Objects and can be used to store binary data, whereas TEXT may be used to store a large number of strings. BLOB may be used to store binary data, which includes images, movies, audio, and applications.
TEXT values behave similarly to a character string or a non-binary string.
4. What do you mean by Denormalization?
Denormalization refers to a technique which is used to access data from higher to lower forms of a database. It helps the database managers to increase the performance of the entire infrastructure as it introduces redundancy into a table. It adds the redundant data into a table by incorporating database queries that combine data from various tables into a single table.
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS FROM SCRATCH. CHECK OUT OUR MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Date: 22-09-2022
Company Name - Nestle
Role: Data Analyst
Topic - SQL and Tableau
1. Explain character-manipulation functions? Explains its different types in SQL.
Change, extract, and edit the character string using character manipulation routines. The function will do its action on the input strings and return the result when one or more characters and words are supplied into it.
The character manipulation functions in SQL are as follows:
A) CONCAT (joining two or more values): This function is used to join two or more values together. The second string is always appended to the end of the first string.
B) SUBSTR: This function returns a segment of a string from a given start point to a given endpoint.
C) LENGTH: This function returns the length of the string in numerical form, including blank spaces.
D) INSTR: This function calculates the precise numeric location of a character or word in a string.
E) LPAD: For right-justified values, it returns the padding of the left-side character value.
F) RPAD: For a left-justified value, it returns the padding of the right-side character value.
G) TRIM: This function removes all defined characters from the beginning, end, or both ends of a string. It also reduced the amount of wasted space.
H) REPLACE: This function replaces all instances of a word or a section of a string (substring) with the other string value specified.
2. How Do You Calculate the Daily Profit Measures Using LOD?
LOD expressions allow us to easily create bins on aggregated data such as profit per day.
Scenario: We want to measure our success by the total profit per business day.
Create a calculated field named LOD - Profit per day and enter the formula:
FIXED [Order Date] : SUM ([Profit])
Create another calculated field named LOD - Daily Profit KPI and enter the formula:
IF [LOD - Profit per day] > 2000 then “Highly Profitable.”
ELSEIF [LOD - Profit per day] <= 0 then “Unprofitable”
ELSE “Profitable”
END
To calculate daily profit measure using LOD, follow these steps to draw the visualization:
Bring YEAR(Order Date) and MONTH(Order Date) to the Columns shelf
Drag Order Id field to Rows shelf. Right-click on it, select Measure and click on Count(Distinct)
Drag LOD - Daily Profit KPI to the Rows shelf
Bring LOD - Daily Profit KPI to marks card and change mark type from automatic to area.
3. What are Superkey and candidate key?
A super key may be a single or a combination of keys that help to identify a record in a table. Know that Super keys can have one or more attributes, even though all the attributes are not necessary to identify the records.
A candidate key is the subset of Superkey, which can have one or more than one attributes to identify records in a table. Unlike Superkey, all the attributes of the candidate key must be helpful to identify the records.
Note that all the candidate keys can be Super keys, but all the super keys cannot be candidate keys.
4.What is Database Cardinality?
Database Cardinality denotes the uniqueness of values in the tables. It supports optimizing query plans and hence improves query performance. There are three types of database cardinalities in SQL, as given below:
Higher Cardinality
Normal Cardinality
Lower Cardinality
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS FROM SCRATCH. CHECK OUT OUR MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Company Name - Nestle
Role: Data Analyst
Topic - SQL and Tableau
1. Explain character-manipulation functions? Explains its different types in SQL.
Change, extract, and edit the character string using character manipulation routines. The function will do its action on the input strings and return the result when one or more characters and words are supplied into it.
The character manipulation functions in SQL are as follows:
A) CONCAT (joining two or more values): This function is used to join two or more values together. The second string is always appended to the end of the first string.
B) SUBSTR: This function returns a segment of a string from a given start point to a given endpoint.
C) LENGTH: This function returns the length of the string in numerical form, including blank spaces.
D) INSTR: This function calculates the precise numeric location of a character or word in a string.
E) LPAD: For right-justified values, it returns the padding of the left-side character value.
F) RPAD: For a left-justified value, it returns the padding of the right-side character value.
G) TRIM: This function removes all defined characters from the beginning, end, or both ends of a string. It also reduced the amount of wasted space.
H) REPLACE: This function replaces all instances of a word or a section of a string (substring) with the other string value specified.
2. How Do You Calculate the Daily Profit Measures Using LOD?
LOD expressions allow us to easily create bins on aggregated data such as profit per day.
Scenario: We want to measure our success by the total profit per business day.
Create a calculated field named LOD - Profit per day and enter the formula:
FIXED [Order Date] : SUM ([Profit])
Create another calculated field named LOD - Daily Profit KPI and enter the formula:
IF [LOD - Profit per day] > 2000 then “Highly Profitable.”
ELSEIF [LOD - Profit per day] <= 0 then “Unprofitable”
ELSE “Profitable”
END
To calculate daily profit measure using LOD, follow these steps to draw the visualization:
Bring YEAR(Order Date) and MONTH(Order Date) to the Columns shelf
Drag Order Id field to Rows shelf. Right-click on it, select Measure and click on Count(Distinct)
Drag LOD - Daily Profit KPI to the Rows shelf
Bring LOD - Daily Profit KPI to marks card and change mark type from automatic to area.
3. What are Superkey and candidate key?
A super key may be a single or a combination of keys that help to identify a record in a table. Know that Super keys can have one or more attributes, even though all the attributes are not necessary to identify the records.
A candidate key is the subset of Superkey, which can have one or more than one attributes to identify records in a table. Unlike Superkey, all the attributes of the candidate key must be helpful to identify the records.
Note that all the candidate keys can be Super keys, but all the super keys cannot be candidate keys.
4.What is Database Cardinality?
Database Cardinality denotes the uniqueness of values in the tables. It supports optimizing query plans and hence improves query performance. There are three types of database cardinalities in SQL, as given below:
Higher Cardinality
Normal Cardinality
Lower Cardinality
————————————————————-
🚨MAKE YOUR CAREER IN DATA SCIENCE AND ANALYTICS FROM SCRATCH. CHECK OUT OUR MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, R, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, DSA, 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 Chat Support Everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo
Excel interview questions and answers asked in the Blinkit Interview round. Watch our latest YouTube video. Link below
👉🏻 https://youtu.be/-ambGYR0L-o
👉🏻 https://youtu.be/-ambGYR0L-o
👏1
Good Technical Skills, Good Projects and a Good Resume can make you ready for the Data Science Interviews and you are getting everything in our Data Science & Analytics Mega Combo Package
Visit our website and Check the course reviews and then Enroll.
👉🏻Course Link - https://ai.cloudyml.com/Mega-Combo
It Covers all the important topics which are required to become interview ready from scratch with 1-1 Live Doubt Clearance Support over chat.
✅Python
✅R
✅SQL
✅Maths & Statistics
✅Machine Learning
✅Deep Learning
✅AWS Sagamaker
✅Model Deployment
✅Tableau
✅PowerBi
✅MS Excel
✅DSA
✅AWS QuickSight
✅Google Data Studio
✅Interview QnA PDFs
✅Capstone Projects
Combined Price of all the courses is Rs. 48534/- but you can get all the courses at Mega Combo offer of Rs.7999/- for today.
Follow the link below and visit our website and become Interview Ready.
👉🏻Course Link - https://ai.cloudyml.com/Mega-Combo
Visit our website and Check the course reviews and then Enroll.
👉🏻Course Link - https://ai.cloudyml.com/Mega-Combo
It Covers all the important topics which are required to become interview ready from scratch with 1-1 Live Doubt Clearance Support over chat.
✅Python
✅R
✅SQL
✅Maths & Statistics
✅Machine Learning
✅Deep Learning
✅AWS Sagamaker
✅Model Deployment
✅Tableau
✅PowerBi
✅MS Excel
✅DSA
✅AWS QuickSight
✅Google Data Studio
✅Interview QnA PDFs
✅Capstone Projects
Combined Price of all the courses is Rs. 48534/- but you can get all the courses at Mega Combo offer of Rs.7999/- for today.
Follow the link below and visit our website and become Interview Ready.
👉🏻Course Link - https://ai.cloudyml.com/Mega-Combo
❤1
Date: 23rd September, 2022
Company - KraftHeinz
Role: ML Engineer
Topic: Clustering, Hyperparameter tuning, Joins from SQL
1. What is DBSCAN Clustering?
DBSCAN groups ‘densely grouped’ data points into a single cluster. It can identify clusters in large spatial datasets by looking at the local density of the data points. The most exciting feature of DBSCAN clustering is that it is robust to outliers. It also does not require the number of clusters to be told beforehand, unlike K-Means, where we have to specify the number of centroids.
2. What are the different forms of joins in a table?
SQL has many kinds of different joins including INNER JOIN, SELF JOIN, CROSS JOIN, and OUTER JOIN. In fact, each join type defines the way two tables are related in a query. OUTER JOINS can further be divided into LEFT OUTER JOINS, RIGHT OUTER JOINS, and FULL OUTER JOINS.
3. How is the grid search parameter different from the random search?
Model Hyperparameter tuning is very useful to enhance the performance of a machine learning model. The only difference between both the approaches is in grid search we define the combinations and do training of the model whereas in RandomizedSearchCV the model selects the combinations randomly. Both are very effective ways of tuning the parameters that increase the model generalizability.
Random search is a technique where random combinations of the hyperparameters are used to find the best solution for the built model. The drawback of random search is that it yields high variance during computing. Since the selection of parameters is completely random; and since no intelligence is used to sample these combinations, luck plays its part.
Company - KraftHeinz
Role: ML Engineer
Topic: Clustering, Hyperparameter tuning, Joins from SQL
1. What is DBSCAN Clustering?
DBSCAN groups ‘densely grouped’ data points into a single cluster. It can identify clusters in large spatial datasets by looking at the local density of the data points. The most exciting feature of DBSCAN clustering is that it is robust to outliers. It also does not require the number of clusters to be told beforehand, unlike K-Means, where we have to specify the number of centroids.
2. What are the different forms of joins in a table?
SQL has many kinds of different joins including INNER JOIN, SELF JOIN, CROSS JOIN, and OUTER JOIN. In fact, each join type defines the way two tables are related in a query. OUTER JOINS can further be divided into LEFT OUTER JOINS, RIGHT OUTER JOINS, and FULL OUTER JOINS.
3. How is the grid search parameter different from the random search?
Model Hyperparameter tuning is very useful to enhance the performance of a machine learning model. The only difference between both the approaches is in grid search we define the combinations and do training of the model whereas in RandomizedSearchCV the model selects the combinations randomly. Both are very effective ways of tuning the parameters that increase the model generalizability.
Random search is a technique where random combinations of the hyperparameters are used to find the best solution for the built model. The drawback of random search is that it yields high variance during computing. Since the selection of parameters is completely random; and since no intelligence is used to sample these combinations, luck plays its part.
If you wanna be a Data Analyst/Business Analyst then you should check our Data Analytics Combo Package which covers all the topics required to make you interview ready from scratch.
➡️ DOWNLOAD COURSE BROCHURE
➡️ VISIT OUR WEBSITE
No Prior Coding Experience Required To Join. Get Complete Hands-On Practical Learning Experience with Personal Chat Support for Doubt Clearance Daily.
➡️ VISIT OUR WEBSITE
➡️ DOWNLOAD COURSE BROCHURE
➡️ VISIT OUR WEBSITE
No Prior Coding Experience Required To Join. Get Complete Hands-On Practical Learning Experience with Personal Chat Support for Doubt Clearance Daily.
➡️ VISIT OUR WEBSITE