Interview QnAs
Company-Blinkit
Role- Data Analyst
1.How to add custom colors in tableau?
Tableau offers various colour palettes which a user can use to define a legend or to be used in formatting. But sometimes due to client’s requirements we need to use some specific colours in our view. So instead of defining the colour each and every time you can create a custom palette which can be used whenever you open a workbook. To create a custom colour palette, go to “My tableau Repository” in the documents folder of your system. Open “Preference.tps” file in a text editor to create the custom palette. By default, the file will be empty with just opening and closing line of workbook. You need to define the colour palette in between these two lines and there are three types of colour categories that can be defined. One of them is categorical which is defined using type = “Regular” and second one is sequential and it comes under the type = “ordered-sequential” and last comes diverging colour which is of the type = “ordered-diverging”. Also, kindly note that the colour should be defined in the HTML #RRGGB order.
2.What is a legend in Power BI?
Legends are part of Power BI visuals. They represent categories in a visual and are usually color-coded. In some visuals, we can add a category dimension as legend explicitly. One example can be in stacked bar/column charts, where the stacks represent different categories, and these categories are color-coded. These categories are represented in the legend. And every visual where the legend is applicable has a separate formatting section where we can specify its font and font size, whether we need it to be visible or not, or even its position(top, bottom, left, right)
3.What is Power BI-Embedded?
Power BI Embedded is an analytics solution, provided as a Microsoft Azure Service, a platform-as-a-service (PaaS), wherein the developers & ISVs (Individual Software Vendors) can easily embed their dashboards, Visuals & reports into an application for their customers.
Fully interactive reports & visuals can be embedded into the applications.
The great thing about Power BI Embedded is that your customers are not required to have knowledge about Power BI. Power BI gives you the capability to create an embedded application using two different methods.
The first method is using a Power BI Pro account & the second method is using the service principal.
The Power BI Pro account acts as the master account of your application. This account will help you generate the required embed tokens for providing access to your customers to view the shared Power BI dashboards and reports.
The service principal embeds Power BI Dashboards/Reports/Visuals into an application using an app-only token. Now this will allow you to generate the embed tokens for providing access to your shared application’s Power BI dashboards and reports.
4.What is the Ribbon and what does it contain?
The Ribbon refers to the row of buttons and icons at the top of your worksheet. These include common tabs like Home, Insert, Page Layout, and Data.
You can customize the Ribbon and collapse or expand it using CTRL+F1. Some tabs only appear when you select a relevant item, such as a chart or table.
—————————-
If you wanna make your career in Data Science and Analytics then you must check our Mega Combo Course which covers topics like Python, SQL, Statistics and Maths, Machine Learning, Deep Learning, Tableau, PowerBi, Excel, Model Deployment, AWS Sagemaker, Capstone End-to-End ML and DL Projects, Analytics Case Studies, Interview QnA PDF Collection
Course Link - https://www.cloudyml.com/mega-combo-package/
Company-Blinkit
Role- Data Analyst
1.How to add custom colors in tableau?
Tableau offers various colour palettes which a user can use to define a legend or to be used in formatting. But sometimes due to client’s requirements we need to use some specific colours in our view. So instead of defining the colour each and every time you can create a custom palette which can be used whenever you open a workbook. To create a custom colour palette, go to “My tableau Repository” in the documents folder of your system. Open “Preference.tps” file in a text editor to create the custom palette. By default, the file will be empty with just opening and closing line of workbook. You need to define the colour palette in between these two lines and there are three types of colour categories that can be defined. One of them is categorical which is defined using type = “Regular” and second one is sequential and it comes under the type = “ordered-sequential” and last comes diverging colour which is of the type = “ordered-diverging”. Also, kindly note that the colour should be defined in the HTML #RRGGB order.
2.What is a legend in Power BI?
Legends are part of Power BI visuals. They represent categories in a visual and are usually color-coded. In some visuals, we can add a category dimension as legend explicitly. One example can be in stacked bar/column charts, where the stacks represent different categories, and these categories are color-coded. These categories are represented in the legend. And every visual where the legend is applicable has a separate formatting section where we can specify its font and font size, whether we need it to be visible or not, or even its position(top, bottom, left, right)
3.What is Power BI-Embedded?
Power BI Embedded is an analytics solution, provided as a Microsoft Azure Service, a platform-as-a-service (PaaS), wherein the developers & ISVs (Individual Software Vendors) can easily embed their dashboards, Visuals & reports into an application for their customers.
Fully interactive reports & visuals can be embedded into the applications.
The great thing about Power BI Embedded is that your customers are not required to have knowledge about Power BI. Power BI gives you the capability to create an embedded application using two different methods.
The first method is using a Power BI Pro account & the second method is using the service principal.
The Power BI Pro account acts as the master account of your application. This account will help you generate the required embed tokens for providing access to your customers to view the shared Power BI dashboards and reports.
The service principal embeds Power BI Dashboards/Reports/Visuals into an application using an app-only token. Now this will allow you to generate the embed tokens for providing access to your shared application’s Power BI dashboards and reports.
4.What is the Ribbon and what does it contain?
The Ribbon refers to the row of buttons and icons at the top of your worksheet. These include common tabs like Home, Insert, Page Layout, and Data.
You can customize the Ribbon and collapse or expand it using CTRL+F1. Some tabs only appear when you select a relevant item, such as a chart or table.
—————————-
If you wanna make your career in Data Science and Analytics then you must check our Mega Combo Course which covers topics like Python, SQL, Statistics and Maths, Machine Learning, Deep Learning, Tableau, PowerBi, Excel, Model Deployment, AWS Sagemaker, Capstone End-to-End ML and DL Projects, Analytics Case Studies, Interview QnA PDF Collection
Course Link - https://www.cloudyml.com/mega-combo-package/
Top NumPy Commands You Must know in Data Science.
Check out our latest YouTube video
➡️ https://youtu.be/7McbggU04ng
Check out our latest YouTube video
➡️ https://youtu.be/7McbggU04ng
🚨Interview QnAs
Company- Idexcel
Role- Data Analyst
1.Explain Pivot tables along with their features?
Pivot Tables are statistical tables that condense data of those tables that have extensive information. The summary can be based on any field such as sales, averages, sums, etc that the pivot table represents in a simple and intelligent manner.
Features:
Some of the features of Excel Pivot Tables are as follows:
Allow the display of exact data you have to analyze
Provide various angles to view the data
Allow you to focus on important details
Comparison of data is very handy
Pivot tables can detect different patterns, relationships, data trends, etc
They can create instant data
Accurate reports
Serve the base for Pivot charts
2.What is a Horizontal Lookup in Microsoft Excel?
Horizontal Lookup or HLOOKUP looks for a value from the topmost row of the table horizontally and then moves in a downward direction.
Syntax of HLOOKUP is, = HLOOKUP (Val, giventable, row_no, [rnge_look]),
Where,
Val is the value to be searched in the first row of the table.
giventable is the row/rows that are sorted in ascending order.
row_no is the row from which the lookup value is to be recovered.
[rnge_look] is not a mandatory argument where TRUE (default) means inexact match and FALSE means exact match.
3.What is the use of cycle fields in tableau?
Cycle fields help in switching and trying different colour combinations or views in a cyclic order. It will work only if we have a chart that allows more than one measure such as stacked bar chart and we are unable to finalize the visualizations then we can use cycle fields. To use cycle field, click on analysis menu in the toolbar then select cycle fields to take a quick look at an alternative visualization.
4.What is the calculated column in Power BI?
Calculated columns are built to extend the data attributes. They are those columns that are created when the available columns in the data do not serve our purpose or we are not able to generate any useful insight from the same. That is when calculated columns come into the picture. And these are created using different DAX functions as per need. We can have a simple example of a date where we do not want to work with the complete date but individual day, month, or year. For this, in the data part of the Power BI desktop, we have the option of a ‘New Column.’ When we click that, we get a formula bar on top (like excel), where it asks us to type the new column name with its calculation. So, if we consider the data example, it will be something like this: yearcol = YEAR([Date column]) where YEAR is a DAX function. And ‘yearcol’ is your calculated column.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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 Analyst
1.Explain Pivot tables along with their features?
Pivot Tables are statistical tables that condense data of those tables that have extensive information. The summary can be based on any field such as sales, averages, sums, etc that the pivot table represents in a simple and intelligent manner.
Features:
Some of the features of Excel Pivot Tables are as follows:
Allow the display of exact data you have to analyze
Provide various angles to view the data
Allow you to focus on important details
Comparison of data is very handy
Pivot tables can detect different patterns, relationships, data trends, etc
They can create instant data
Accurate reports
Serve the base for Pivot charts
2.What is a Horizontal Lookup in Microsoft Excel?
Horizontal Lookup or HLOOKUP looks for a value from the topmost row of the table horizontally and then moves in a downward direction.
Syntax of HLOOKUP is, = HLOOKUP (Val, giventable, row_no, [rnge_look]),
Where,
Val is the value to be searched in the first row of the table.
giventable is the row/rows that are sorted in ascending order.
row_no is the row from which the lookup value is to be recovered.
[rnge_look] is not a mandatory argument where TRUE (default) means inexact match and FALSE means exact match.
3.What is the use of cycle fields in tableau?
Cycle fields help in switching and trying different colour combinations or views in a cyclic order. It will work only if we have a chart that allows more than one measure such as stacked bar chart and we are unable to finalize the visualizations then we can use cycle fields. To use cycle field, click on analysis menu in the toolbar then select cycle fields to take a quick look at an alternative visualization.
4.What is the calculated column in Power BI?
Calculated columns are built to extend the data attributes. They are those columns that are created when the available columns in the data do not serve our purpose or we are not able to generate any useful insight from the same. That is when calculated columns come into the picture. And these are created using different DAX functions as per need. We can have a simple example of a date where we do not want to work with the complete date but individual day, month, or year. For this, in the data part of the Power BI desktop, we have the option of a ‘New Column.’ When we click that, we get a formula bar on top (like excel), where it asks us to type the new column name with its calculation. So, if we consider the data example, it will be something like this: yearcol = YEAR([Date column]) where YEAR is a DAX function. And ‘yearcol’ is your calculated column.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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
Hey everyone, do you wanna know HOW TO GET INTERNSHIP/JOB IN DATA SCIENCE DOMAIN ?
Check out our latest YouTube Video in which shared some Very Important Tips that will help you to get shortlisted by HR . Link Below
👉🏻 https://youtu.be/_AuxRvNyuVQ
Check out our latest YouTube Video in which shared some Very Important Tips that will help you to get shortlisted by HR . Link Below
👉🏻 https://youtu.be/_AuxRvNyuVQ
Anonymous Quiz
27%
FROM
23%
GET
50%
LIKE
👍1
🔵SQL Interview Question asked in AMAZON
Check Explained Solution Video on Our YouTube Channel. Link Below
👉🏻https://youtu.be/nsAKQFkOE4g
ALSO DO🔴SUBSCRIBE TO OUR YOUTUBE CHANNEL TO GET UPDATED !
Check Explained Solution Video on Our YouTube Channel. Link Below
👉🏻https://youtu.be/nsAKQFkOE4g
ALSO DO🔴SUBSCRIBE TO OUR YOUTUBE CHANNEL TO GET UPDATED !
🚨Interview QnAs🚨
Company- Blinkit
Role- Data Analyst
1.What is the use of cycle fields in tableau?
Cycle fields help in switching and trying different colour combinations or views in a cyclic order. It will work only if we have a chart that allows more than one measure such as stacked bar chart and we are unable to finalize the visualizations then we can use cycle fields. To use cycle field, click on analysis menu in the toolbar then select cycle fields to take a quick look at an alternative visualization.
2.How to integrate tableau with website?
To integrate Tableau with a website, developer needs to have complete understanding of Javascript API for tableau. It contains all the types of functions required to view and control a tableau worksheet and dashboard directly from the website instead of interacting directly with the worksheet. Tableau has provided a complete list of functions used in Javascript API and implementation of some of the important functions is explained in the tutorial section also which is free for all users. All the tableau dashboards or worksheets when published on tableau public or online or server are integrated with the Javascrip API by default developer only needs to call that API in the HTML code and start interacting with it.
3.How to use Power BI in excel?
To use Power BI in Excel, there is an Analyse in Excel option for every report in the Power BI service. To use it, you will need to enable editing and enable content for the report for the first time.
So, what this option provides us is that it gives us the underlying data set of our Power BI report. It comes as a data connection in excel. And we get to play with the data in excel. It is up to us how we analyze the same data, either through pivot tables, charts, etc. By default, when the data is extracted in excel for any report- it gives a Pivot table by default.
4.What is OData feed in Power BI?
OData stands for open data protocol. It is usually used to pull data from websites, SharePoint. It helps in getting data from URLs. It basically helps to extract data from a URL without getting into the details of URL-specific parameters like request, response, HTTP methods, etc. It takes care of these things in the back end, leaving us to focus on pulling the data and performing transformations, and creating useful analysis.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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- Blinkit
Role- Data Analyst
1.What is the use of cycle fields in tableau?
Cycle fields help in switching and trying different colour combinations or views in a cyclic order. It will work only if we have a chart that allows more than one measure such as stacked bar chart and we are unable to finalize the visualizations then we can use cycle fields. To use cycle field, click on analysis menu in the toolbar then select cycle fields to take a quick look at an alternative visualization.
2.How to integrate tableau with website?
To integrate Tableau with a website, developer needs to have complete understanding of Javascript API for tableau. It contains all the types of functions required to view and control a tableau worksheet and dashboard directly from the website instead of interacting directly with the worksheet. Tableau has provided a complete list of functions used in Javascript API and implementation of some of the important functions is explained in the tutorial section also which is free for all users. All the tableau dashboards or worksheets when published on tableau public or online or server are integrated with the Javascrip API by default developer only needs to call that API in the HTML code and start interacting with it.
3.How to use Power BI in excel?
To use Power BI in Excel, there is an Analyse in Excel option for every report in the Power BI service. To use it, you will need to enable editing and enable content for the report for the first time.
So, what this option provides us is that it gives us the underlying data set of our Power BI report. It comes as a data connection in excel. And we get to play with the data in excel. It is up to us how we analyze the same data, either through pivot tables, charts, etc. By default, when the data is extracted in excel for any report- it gives a Pivot table by default.
4.What is OData feed in Power BI?
OData stands for open data protocol. It is usually used to pull data from websites, SharePoint. It helps in getting data from URLs. It basically helps to extract data from a URL without getting into the details of URL-specific parameters like request, response, HTTP methods, etc. It takes care of these things in the back end, leaving us to focus on pulling the data and performing transformations, and creating useful analysis.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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
🚨Roadmap to Data Science🚨
Check out a career transition journey of a Yoga Instructor to Full Time Data Scientist. A story of a person who switch from totally non-coding background to Data Science Domain. Video link given below.
👉 https://youtu.be/B7URRlgREXc
Check out a career transition journey of a Yoga Instructor to Full Time Data Scientist. A story of a person who switch from totally non-coding background to Data Science Domain. Video link given below.
👉 https://youtu.be/B7URRlgREXc
Can you believe that you can learn all the topics mentioned on this poster with 1-1 Live Doubt Clearance Support Everyday, Course completion certificate, 1 Month Internship Offer, Job Referrals and resume review feature in a single package😳 ???
Check our Data Science and Analytics Mega Combo Course and become interview ready for the roles of Data Scientist, Data Analyst and Business Analyst in 5-6 Months.
It is a self-paced course with lifetime course content access so you can learn according to your time availability and we will resolve all of your Doubts and Queries while learning.
Our courses are trusted by 5500+ Happy learners and 35% of our learners are also from complete Non-Coding Background and lot of them have successfully switched to Data Science domain. There reviews you can check on our website.
Become Job-Ready from Scratch and Start This Journey Today.
Visit Course Now👉🏻https://ai.cloudyml.com/Mega-Combo
Check our Data Science and Analytics Mega Combo Course and become interview ready for the roles of Data Scientist, Data Analyst and Business Analyst in 5-6 Months.
It is a self-paced course with lifetime course content access so you can learn according to your time availability and we will resolve all of your Doubts and Queries while learning.
Our courses are trusted by 5500+ Happy learners and 35% of our learners are also from complete Non-Coding Background and lot of them have successfully switched to Data Science domain. There reviews you can check on our website.
Become Job-Ready from Scratch and Start This Journey Today.
Visit Course Now👉🏻https://ai.cloudyml.com/Mega-Combo
🚨Check out our latest YouTube Video in which we have explained the solution of Python interview problem which was asked in various tech companies like Amazon and Adobe
Link👉🏻 https://youtu.be/W4IJD80-A_I
Link👉🏻 https://youtu.be/W4IJD80-A_I
👏1
🚨Interview QnAs🚨
Company - Wipro
Role- Data Analyst
1.What is a legend in Power BI?
Legends are part of Power BI visuals. They represent categories in a visual and are usually color-coded. In some visuals, we can add a category dimension as legend explicitly. One example can be in stacked bar/column charts, where the stacks represent different categories, and these categories are color-coded. These categories are represented in the legend. And every visual where the legend is applicable has a separate formatting section where we can specify its font and font size, whether we need it to be visible or not, or even its position(top, bottom, left, right)
2.What is drill down in Power BI?
Drill down, as the name suggests, is going downwards. And in Power BI, it is going down a hierarchical category or dimension. Basically, when we have data attributes like a date where we have a default hierarchy of year->quarter->month->day, then when using the same field in a visual, in Power BI, it by default takes the hierarchy form of the field. This gives the option of a drill-down feature denoted by up and down arrows. Also, we can right-click on the element in visual and get the option of drill-down.
3.What is load testing in Tableau? How do you perform it?
You need to load testing in Tableau to understand the server's capacity concerning its environment, workload, data, and use. You should conduct load testing at least 3 to 4 times a year. That is because workload, data, usage upgrade, or content authoring change whenever a new user joins in.
You must know that Tabjolt was created by Tableau to conduct point and run load and performance testing, particularly in Tableau servers. The features of Tabjolt are:
Eliminates dependency on script maintenance or script development
Automates user-specified loads' processes
Scales linearly by adding more nodes to the cluster
4.What is the maximum number of tables you can join in Tableau?
It is not possible to join more than 32 tables together in Tableau. It means you can join a maximum of 32 tables in Tableau.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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 is a legend in Power BI?
Legends are part of Power BI visuals. They represent categories in a visual and are usually color-coded. In some visuals, we can add a category dimension as legend explicitly. One example can be in stacked bar/column charts, where the stacks represent different categories, and these categories are color-coded. These categories are represented in the legend. And every visual where the legend is applicable has a separate formatting section where we can specify its font and font size, whether we need it to be visible or not, or even its position(top, bottom, left, right)
2.What is drill down in Power BI?
Drill down, as the name suggests, is going downwards. And in Power BI, it is going down a hierarchical category or dimension. Basically, when we have data attributes like a date where we have a default hierarchy of year->quarter->month->day, then when using the same field in a visual, in Power BI, it by default takes the hierarchy form of the field. This gives the option of a drill-down feature denoted by up and down arrows. Also, we can right-click on the element in visual and get the option of drill-down.
3.What is load testing in Tableau? How do you perform it?
You need to load testing in Tableau to understand the server's capacity concerning its environment, workload, data, and use. You should conduct load testing at least 3 to 4 times a year. That is because workload, data, usage upgrade, or content authoring change whenever a new user joins in.
You must know that Tabjolt was created by Tableau to conduct point and run load and performance testing, particularly in Tableau servers. The features of Tabjolt are:
Eliminates dependency on script maintenance or script development
Automates user-specified loads' processes
Scales linearly by adding more nodes to the cluster
4.What is the maximum number of tables you can join in Tableau?
It is not possible to join more than 32 tables together in Tableau. It means you can join a maximum of 32 tables in Tableau.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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
SQL Interview Question asked in Walmart.
Check our latest YouTube Video in which we have explained the solution.
👉🏻 https://youtu.be/Tpafq9bmrHg
Check our latest YouTube Video in which we have explained the solution.
👉🏻 https://youtu.be/Tpafq9bmrHg
🚨Interview QnAs🚨
Company - Cognizant
Role- Jr. Data Scientist
1. For the given points, how will you calculate the Euclidean distance in Python?
plot1 = [1,3]
plot2 = [2,5]
The Euclidean distance can be calculated as follows:
euclidean_distance = sqrt( (plot1[0]-plot2[0])*2 + (plot1[1]-plot2[1])*2 )
2.Which of the following machine learning algorithms can be used for inputting missing values of both categorical and continuous variables?
K-means clustering
Linear regression
K-NN (k-nearest neighbor)
Decision trees
The K nearest neighbor algorithm can be used because it can compute the nearest neighbor and if it doesn't have a value, it just computes the nearest neighbor based on all the other features.
When you're dealing with K-means clustering or linear regression, you need to do that in your pre-processing, otherwise, they'll crash. Decision trees also have the same problem, although there is some variance.
3.How are confidence tests and hypothesis tests similar? How are they different?
Confidence intervals and hypothesis testing are both tools used for to make statistical inferences.
The confidence interval suggests a range of values for an unknown parameter and is then associated with a confidence level that the true parameter is within the suggested range of. Confidence intervals are often very important in medical research to provide researchers with a stronger basis for their estimations. A confidence interval can be shown as “10 +/- 0.5” or [9.5, 10.5] to give an example.
Hypothesis testing is the basis of any research question and often comes down to trying to prove something did not happen by chance. For example, you could try to prove when rolling a dye, one number was more likely to come up than the rest.
4. What is the difference between observational and experimental data?
Observational data comes from observational studies which are when you observe certain variables and try to determine if there is any correlation.
Experimental data comes from experimental studies which are when you control certain variables and hold them constant to determine if there is any causality.
An example of experimental design is the following: split a group up into two. The control group lives their lives normally. The test group is told to drink a glass of wine every night for 30 days. Then research can be conducted to see how wine affects sleep.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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 - Cognizant
Role- Jr. Data Scientist
1. For the given points, how will you calculate the Euclidean distance in Python?
plot1 = [1,3]
plot2 = [2,5]
The Euclidean distance can be calculated as follows:
euclidean_distance = sqrt( (plot1[0]-plot2[0])*2 + (plot1[1]-plot2[1])*2 )
2.Which of the following machine learning algorithms can be used for inputting missing values of both categorical and continuous variables?
K-means clustering
Linear regression
K-NN (k-nearest neighbor)
Decision trees
The K nearest neighbor algorithm can be used because it can compute the nearest neighbor and if it doesn't have a value, it just computes the nearest neighbor based on all the other features.
When you're dealing with K-means clustering or linear regression, you need to do that in your pre-processing, otherwise, they'll crash. Decision trees also have the same problem, although there is some variance.
3.How are confidence tests and hypothesis tests similar? How are they different?
Confidence intervals and hypothesis testing are both tools used for to make statistical inferences.
The confidence interval suggests a range of values for an unknown parameter and is then associated with a confidence level that the true parameter is within the suggested range of. Confidence intervals are often very important in medical research to provide researchers with a stronger basis for their estimations. A confidence interval can be shown as “10 +/- 0.5” or [9.5, 10.5] to give an example.
Hypothesis testing is the basis of any research question and often comes down to trying to prove something did not happen by chance. For example, you could try to prove when rolling a dye, one number was more likely to come up than the rest.
4. What is the difference between observational and experimental data?
Observational data comes from observational studies which are when you observe certain variables and try to determine if there is any correlation.
Experimental data comes from experimental studies which are when you control certain variables and hold them constant to determine if there is any causality.
An example of experimental design is the following: split a group up into two. The control group lives their lives normally. The test group is told to drink a glass of wine every night for 30 days. Then research can be conducted to see how wine affects sleep.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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
👍2
Anonymous Quiz
22%
array_join()
30%
join()
47%
concatenate()
Python For Data Science Tutorial Series
Topic: Variable and Operators
Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.
Link👉🏻 https://youtu.be/8004kgAXWk0
Topic: Variable and Operators
Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.
Link👉🏻 https://youtu.be/8004kgAXWk0
Python For Data Science Tutorial Series
Topic: Strings in Python
Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.
👉🏻https://youtu.be/X8qgKg8fNhk
Topic: Strings in Python
Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.
👉🏻https://youtu.be/X8qgKg8fNhk
#String_Quiz
Which method should I use to convert String "welcome to the beautiful world of python" to "Welcome To The Beautiful World Of Python"
Which method should I use to convert String "welcome to the beautiful world of python" to "Welcome To The Beautiful World Of Python"
Anonymous Quiz
54%
capitalize()
31%
title()
4%
letter()
11%
None of the above
Today's Interview QnAs
Company - The Math Company
Role- Data Analyst
1.How to create filters in Power BI?
Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.
Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)
2.How to sort data in Power BI?
Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.
3.How to convert pdf to excel?
Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.
4. How to enable macros in excel?
Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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 - The Math Company
Role- Data Analyst
1.How to create filters in Power BI?
Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.
Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)
2.How to sort data in Power BI?
Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.
3.How to convert pdf to excel?
Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.
4. How to enable macros in excel?
Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.
————————————————————-
🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.
This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, 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
Check our latest YouTube Video which will help you to improve your Aptitude. Link Below
👉🏻https://youtu.be/lbJYbEAa_28
👉🏻https://youtu.be/lbJYbEAa_28
Python For Data Science Tutorial Series
Topic: Conditional Statements (if-else in Python)
Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.
👉🏻 https://youtu.be/4dmnTu_2Te8
Topic: Conditional Statements (if-else in Python)
Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.
👉🏻 https://youtu.be/4dmnTu_2Te8