🔵 Interview QnA Explained Video
Tableau interview question asked in Tight Analytics.
Check our latest YouTube video in which we have explained the solution.
link👉🏻 https://youtu.be/UCx0Fgbbnlw
Tableau interview question asked in Tight Analytics.
Check our latest YouTube video in which we have explained the solution.
link👉🏻 https://youtu.be/UCx0Fgbbnlw
Today's Interview QnAs
Company- Hirect
Role- Data Analyst
1.Can you name the wildcards in Excel?
Ans: There are 3 wildcards in Excel that can ve used in formulas.
Asterisk (*) – 0 or more characters. For example, Ex* could mean Excel, Extra, Expertise, etc.
Question mark (?) – Represents any 1 character. For example, R?ain may mean Rain or Ruin.
Tilde (~) – Used to identify a wildcard character (~, *, ?). For example, If you need to find the exact phrase India* in a list. If you use India* as the search string, you may get any word with India at the beginning followed by different characters (such as Indian, Indiana). If you have to look for India” exclusively, use ~.
Hence, the search string will be india~*. ~ is used to ensure that the spreadsheet reads the following character as is, and not as a wildcard.
2.What is cascading filter in tableau?
Ans: Cascading filters can also be understood as giving preference to a particular filter and then applying other filters on previously filtered data source. Right-click on the filter you want to use as a main filter and make sure it is set as all values in dashboard then select the subsequent filter and select only relevant values to cascade the filters. This will improve the performance of the dashboard as you have decreased the time wasted in running all the filters over complete data source.
3.What is the difference between .twb and .twbx extension?
Ans:
A .twb file contains information on all the sheets, dashboards and stories, but it won’t contain any information regarding data source. Whereas .twbx file contains all the sheets, dashboards, stories and also compressed data sources. For saving a .twbx extract needs to be performed on the data source. If we forward .twb file to someone else than they will be able to see the worksheets and dashboards but won’t be able to look into the dataset.
4.What are the various Power BI versions?
Power BI Premium capacity-based license, for example, allows users with a free license to act on content in workspaces with Premium capacity. A user with a free license can only use the Power BI service to connect to data and produce reports and dashboards in My Workspace outside of Premium capacity. They are unable to exchange material or publish it in other workspaces. To process material, a Power BI license with a free or Pro per-user license only uses a shared and restricted capacity. Users with a Power BI Pro license can only work with other Power BI Pro users if the material is stored in that shared capacity. They may consume user-generated information, post material to app workspaces, share dashboards, and subscribe to dashboards and reports. Pro users can share material with users who don’t have a Power BI Pro subscription while workspaces are at Premium capacity.
————————————————————-
🔴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- Hirect
Role- Data Analyst
1.Can you name the wildcards in Excel?
Ans: There are 3 wildcards in Excel that can ve used in formulas.
Asterisk (*) – 0 or more characters. For example, Ex* could mean Excel, Extra, Expertise, etc.
Question mark (?) – Represents any 1 character. For example, R?ain may mean Rain or Ruin.
Tilde (~) – Used to identify a wildcard character (~, *, ?). For example, If you need to find the exact phrase India* in a list. If you use India* as the search string, you may get any word with India at the beginning followed by different characters (such as Indian, Indiana). If you have to look for India” exclusively, use ~.
Hence, the search string will be india~*. ~ is used to ensure that the spreadsheet reads the following character as is, and not as a wildcard.
2.What is cascading filter in tableau?
Ans: Cascading filters can also be understood as giving preference to a particular filter and then applying other filters on previously filtered data source. Right-click on the filter you want to use as a main filter and make sure it is set as all values in dashboard then select the subsequent filter and select only relevant values to cascade the filters. This will improve the performance of the dashboard as you have decreased the time wasted in running all the filters over complete data source.
3.What is the difference between .twb and .twbx extension?
Ans:
A .twb file contains information on all the sheets, dashboards and stories, but it won’t contain any information regarding data source. Whereas .twbx file contains all the sheets, dashboards, stories and also compressed data sources. For saving a .twbx extract needs to be performed on the data source. If we forward .twb file to someone else than they will be able to see the worksheets and dashboards but won’t be able to look into the dataset.
4.What are the various Power BI versions?
Power BI Premium capacity-based license, for example, allows users with a free license to act on content in workspaces with Premium capacity. A user with a free license can only use the Power BI service to connect to data and produce reports and dashboards in My Workspace outside of Premium capacity. They are unable to exchange material or publish it in other workspaces. To process material, a Power BI license with a free or Pro per-user license only uses a shared and restricted capacity. Users with a Power BI Pro license can only work with other Power BI Pro users if the material is stored in that shared capacity. They may consume user-generated information, post material to app workspaces, share dashboards, and subscribe to dashboards and reports. Pro users can share material with users who don’t have a Power BI Pro subscription while workspaces are at Premium capacity.
————————————————————-
🔴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 check out our latest YouTube video on Companies that are Hiring Freshers in Data Science 🤩
Check Now👉🏻 https://youtu.be/I2lksYx5zuE
Check Now👉🏻 https://youtu.be/I2lksYx5zuE
Today's Interview QnAs
Company- Tiger Analytics
Role- Data Analyst
1.What is Excel BI Toolkit.
Ans: Excel BI toolkit is the other half of the Microsoft self-service BI (one half being Power BI). This toolkit is composed of Excel and a few more add-ins such as Power Query, Power Pivot, Power View, Power Map. All the tools in the Excel BI toolkit serve a special purpose like importing, modeling, preparing and visualizing data. Generally, the tools are used to create reports by consolidating data from multiple data sources and to model the datasets. Excel and other add-ins can be used independently or along with each other to optimize BI capabilities of the toolkit.
2.Where is the Power BI data stored?
Ans: All the data that we import in Power BI from different data sources get stored in either of the two tables in a data warehouse; Fact tables and Dimension tables. The fact tables are the central/main table of a start schema which contains all the measure (quantitative data) values. It has primary keys and all the dimension tables are linked to the fact table. The fact table is not usually normalized.
While a dimension table is a table in a database which contains all the attribute values (information about data) for the data stored in fact table. Every dimension table in a star schema is linked to a fact table.
3.What are sets and groups?
Ans: Sets and groups are used group data based on some specific conditions. The main difference between these two is that a group can divide the dataset into multiple groups whereas a set can have only two options which is either in or out. A user should choose to apply group or sets based on the requirements.
4. What is the difference between a function and a formula in Excel?
Ans: A formula is a user-defined expression that calculates a value. A function is pre-defined built-in operation that can take the specified number of arguments. A user can create formulas that can be complex and can have multiple functions in it. For example, =A1+A2 is a formula and =SUM(A1:A10) is a function.
Company- Tiger Analytics
Role- Data Analyst
1.What is Excel BI Toolkit.
Ans: Excel BI toolkit is the other half of the Microsoft self-service BI (one half being Power BI). This toolkit is composed of Excel and a few more add-ins such as Power Query, Power Pivot, Power View, Power Map. All the tools in the Excel BI toolkit serve a special purpose like importing, modeling, preparing and visualizing data. Generally, the tools are used to create reports by consolidating data from multiple data sources and to model the datasets. Excel and other add-ins can be used independently or along with each other to optimize BI capabilities of the toolkit.
2.Where is the Power BI data stored?
Ans: All the data that we import in Power BI from different data sources get stored in either of the two tables in a data warehouse; Fact tables and Dimension tables. The fact tables are the central/main table of a start schema which contains all the measure (quantitative data) values. It has primary keys and all the dimension tables are linked to the fact table. The fact table is not usually normalized.
While a dimension table is a table in a database which contains all the attribute values (information about data) for the data stored in fact table. Every dimension table in a star schema is linked to a fact table.
3.What are sets and groups?
Ans: Sets and groups are used group data based on some specific conditions. The main difference between these two is that a group can divide the dataset into multiple groups whereas a set can have only two options which is either in or out. A user should choose to apply group or sets based on the requirements.
4. What is the difference between a function and a formula in Excel?
Ans: A formula is a user-defined expression that calculates a value. A function is pre-defined built-in operation that can take the specified number of arguments. A user can create formulas that can be complex and can have multiple functions in it. For example, =A1+A2 is a formula and =SUM(A1:A10) is a function.
🔴Job Opening Alert !
Role : Data Analyst
Company : Capgemini
Exp : 0-1 yr
Link : https://ai.cloudyml.com/3t2YbXj
Role: Freshers- Business/Data Analytics
Company: 4onlinemedia
Exp : 0-3 yr
Link: https://ai.cloudyml.com/3lP4mdF
Role : Power BI Freshers
Company: Lumina Datamatics
Exp : 0-2 yr
Link: https://ai.cloudyml.com/3sYbxEk
Role: Product Analyst
Company: Quizizz Inc.
Exp: 0-3 yr
Link: https://ai.cloudyml.com/3z8rfAD
Role : Data Analyst
Company : Capgemini
Exp : 0-1 yr
Link : https://ai.cloudyml.com/3t2YbXj
Role: Freshers- Business/Data Analytics
Company: 4onlinemedia
Exp : 0-3 yr
Link: https://ai.cloudyml.com/3lP4mdF
Role : Power BI Freshers
Company: Lumina Datamatics
Exp : 0-2 yr
Link: https://ai.cloudyml.com/3sYbxEk
Role: Product Analyst
Company: Quizizz Inc.
Exp: 0-3 yr
Link: https://ai.cloudyml.com/3z8rfAD
If you are someone who is from non-coding background and want to switch their career into Data Science and Analytics field then you must check our Data Science Courses.
We at CloudyML provide hands-on courses on Data Science and Analytics from scratch. A complete roadmap for everyone. Either you are from coding background or Non-coding background, you will get a complete structured learning path which will make you technically strong enough so you can crack any Data Science interview. Also we provide 1-1 Live Doubt Clearance Support over skype chat everyday.
Right now, we have 3 Main Combo Courses for particular job roles.
➡️1. Data Science and Analytics Mega Combo Course (Offer Price - Rs.6999/-)
- This is our MOST POPULAR COURSE Now. In this package we have covered 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. This course will make you interview ready for the roles like Data Scientist, Data Analyst, Business Analyst, Research Analyst etc.
Course Link - https://www.cloudyml.com/mega-combo-package/
➡️2. Data Science Combo Course (Offer Price - Rs.3999/-)
- In this package we have covered Python, SQL, Statistics and Maths, Machine Learning, Deep Learning, Model Deployment, AWS Sagemaker, Capstone End-to-End ML and DL Projects, Interview QnA PDF Collection. This course is dedicated to the role of Data Scientist.
Course Link - https://www.cloudyml.com/course-combo-package/
➡️3. Data Analytics/ Business Analytics Combo Course (Offer Price - Rs.3990/-)
- In this package we have covered Python, SQL, Statistics and Maths, Tableau, PowerBi, Excel, Analytics Case Studies. After completing this course, you will be able to crack job interviews of Data Analyst and Business Analyst.
Course Link - https://www.cloudyml.com/analytics-course-package/
All of these course will help you to understand the concepts of Data Science from scratch and we will also clear all of your doubts and queries. Also we provide 1 Month Internship after course completion
Our courses are trusted by more than 5500 Happy Learners and 1200+ Learners already switched to Data Science and Analytics field after completing our courses. You can check a lot of reviews of our learners on our website.
Don't miss this opportunity and start your journey today.
Happy Learning!
CloudyML Team
We at CloudyML provide hands-on courses on Data Science and Analytics from scratch. A complete roadmap for everyone. Either you are from coding background or Non-coding background, you will get a complete structured learning path which will make you technically strong enough so you can crack any Data Science interview. Also we provide 1-1 Live Doubt Clearance Support over skype chat everyday.
Right now, we have 3 Main Combo Courses for particular job roles.
➡️1. Data Science and Analytics Mega Combo Course (Offer Price - Rs.6999/-)
- This is our MOST POPULAR COURSE Now. In this package we have covered 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. This course will make you interview ready for the roles like Data Scientist, Data Analyst, Business Analyst, Research Analyst etc.
Course Link - https://www.cloudyml.com/mega-combo-package/
➡️2. Data Science Combo Course (Offer Price - Rs.3999/-)
- In this package we have covered Python, SQL, Statistics and Maths, Machine Learning, Deep Learning, Model Deployment, AWS Sagemaker, Capstone End-to-End ML and DL Projects, Interview QnA PDF Collection. This course is dedicated to the role of Data Scientist.
Course Link - https://www.cloudyml.com/course-combo-package/
➡️3. Data Analytics/ Business Analytics Combo Course (Offer Price - Rs.3990/-)
- In this package we have covered Python, SQL, Statistics and Maths, Tableau, PowerBi, Excel, Analytics Case Studies. After completing this course, you will be able to crack job interviews of Data Analyst and Business Analyst.
Course Link - https://www.cloudyml.com/analytics-course-package/
All of these course will help you to understand the concepts of Data Science from scratch and we will also clear all of your doubts and queries. Also we provide 1 Month Internship after course completion
Our courses are trusted by more than 5500 Happy Learners and 1200+ Learners already switched to Data Science and Analytics field after completing our courses. You can check a lot of reviews of our learners on our website.
Don't miss this opportunity and start your journey today.
Happy Learning!
CloudyML Team
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