If you want to understand how recursion works with examples then Click on the link below and check our latest video on YouTube in which we have Decoded Recursion in python😎
Link👉🏻 https://youtu.be/8d_YAW9l1QQ
Link👉🏻 https://youtu.be/8d_YAW9l1QQ
Today's Interview QnAs
Company - Mindtree
Role : Data Analyst
1. What are the different data types of Tableau.
Ans: There are 7 data types in Tableau
-Boolean (True/False)
-Date (Individual Value)
-Date and Time
-Geography
-Text or String
-Decimal Number
-Whole Number
2.What is a dual-axis?
Ans: It is a function in Tableau that showcases two scales of two measures in a single graph. This is very similar to the function found on Microsoft Office products where a single graph has line and bar elements. In most cases, it has either two X or two Y axes.
A dual-axis is typically used to show trend lines and historical data. An example would be total revenue vs profit across 12 months.
3. What is the shortcut to add a filter to a table?
Ans: The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L.
4. What are the wildcards available in Excel?
Ans: Wildcards only work with text data. Excel has three wildcards.
1. * (Asterisk)
This refers to any number of characters.
2.? (Question mark)
It represents one single character.
3.~ (Tilde)
It is used to identify a wildcard character (~, *, ?) in the text
—————————————————
🔴If you wanna switch your career from any domain to Data Analytics OR Business Analytics then check our DATA ANALYTICS/ BUSINESS ANALYTICS COMBO COURSE.
In this course, you will get complete roadmap towards your goal from scratch and it will make you technically strong enough so you can crack any Data Analyst OR Business Analyst Job Interview.
This course covers Python, SQL, Statistics, Tableau, PowerBi, Excel, Case studies with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/analytics
Company - Mindtree
Role : Data Analyst
1. What are the different data types of Tableau.
Ans: There are 7 data types in Tableau
-Boolean (True/False)
-Date (Individual Value)
-Date and Time
-Geography
-Text or String
-Decimal Number
-Whole Number
2.What is a dual-axis?
Ans: It is a function in Tableau that showcases two scales of two measures in a single graph. This is very similar to the function found on Microsoft Office products where a single graph has line and bar elements. In most cases, it has either two X or two Y axes.
A dual-axis is typically used to show trend lines and historical data. An example would be total revenue vs profit across 12 months.
3. What is the shortcut to add a filter to a table?
Ans: The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L.
4. What are the wildcards available in Excel?
Ans: Wildcards only work with text data. Excel has three wildcards.
1. * (Asterisk)
This refers to any number of characters.
2.? (Question mark)
It represents one single character.
3.~ (Tilde)
It is used to identify a wildcard character (~, *, ?) in the text
—————————————————
🔴If you wanna switch your career from any domain to Data Analytics OR Business Analytics then check our DATA ANALYTICS/ BUSINESS ANALYTICS COMBO COURSE.
In this course, you will get complete roadmap towards your goal from scratch and it will make you technically strong enough so you can crack any Data Analyst OR Business Analyst Job Interview.
This course covers Python, SQL, Statistics, Tableau, PowerBi, Excel, Case studies with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!
Course Link👉🏻 https://ai.cloudyml.com/analytics
👏1
Media is too big
VIEW IN TELEGRAM
Check out our Data Science and Analytics Mega Combo Course Now.
Link➡️ https://ai.cloudyml.com/Mega-Combo
Link➡️ https://ai.cloudyml.com/Mega-Combo
Wanna know about career in Data Science and company wise salaries ?🧐
Check out our new YouTube Video in which we have shared all the details of Highly Paying Companies in Data Science Domain🤩
Video Link👉🏻 https://youtu.be/xJCYWnc7l5w
Check out our new YouTube Video in which we have shared all the details of Highly Paying Companies in Data Science Domain🤩
Video Link👉🏻 https://youtu.be/xJCYWnc7l5w
Today's Interview QnAs
Company- United Breweries
Role- Data Analyst
1. What is analysis in tableau?
Tableau comes with inbuilt features to analyze the data plotted on a chart. We have various tools such as adding an average line to the chart which tableau calculates itself after we drop the tool on the chart. Some other features include clustering, percentages, forming bands of a particular range and various other tools to explore and inspect data. All these tools are available in analyze tab on each sheet used to create any chart. The features become visible only when they are applicable to the worksheet.
2. What is quick filter in tableau?
Whenever using a filter in Tableau, it comes with some options to change the functionality of filter very easily, such as using it as a single value drop down or single value list or multiple value list or multiple value drop down and various other options. After we set a filter to a sheet just right click on the sheet and there you can see all the quick filter options. Changes made to these options will also change the aesthetics of filter shown on the sheet.
3.How do you apply a single format to all the sheets present in a workbook?
To apply the same format to all the sheets of a workbook, follow the given steps:
-Right-click on any sheet present in that workbook
-Then, click on the Select All Sheets option
-Format any of the sheets and you will see that the format has been applied to all the other sheets as well
4.Explain SUM and SUMIF functions.
SUM: The SUM function is used to calculate the sum of all the values that are specified as a parameter to it. The syntax of this function is as follows:
SUM(number1, number2, …)
SUMIF: This function is used to calculate the sum of values that comply with a given condition.
SYNTAX:
SUMIF(range, criteria, [sum_range])
where,
range specifies the range of cells to be evaluated
criteria provides the condition to be met
sum_range is optional and provides the actual cells to be summed up
—————————————-
🔴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- United Breweries
Role- Data Analyst
1. What is analysis in tableau?
Tableau comes with inbuilt features to analyze the data plotted on a chart. We have various tools such as adding an average line to the chart which tableau calculates itself after we drop the tool on the chart. Some other features include clustering, percentages, forming bands of a particular range and various other tools to explore and inspect data. All these tools are available in analyze tab on each sheet used to create any chart. The features become visible only when they are applicable to the worksheet.
2. What is quick filter in tableau?
Whenever using a filter in Tableau, it comes with some options to change the functionality of filter very easily, such as using it as a single value drop down or single value list or multiple value list or multiple value drop down and various other options. After we set a filter to a sheet just right click on the sheet and there you can see all the quick filter options. Changes made to these options will also change the aesthetics of filter shown on the sheet.
3.How do you apply a single format to all the sheets present in a workbook?
To apply the same format to all the sheets of a workbook, follow the given steps:
-Right-click on any sheet present in that workbook
-Then, click on the Select All Sheets option
-Format any of the sheets and you will see that the format has been applied to all the other sheets as well
4.Explain SUM and SUMIF functions.
SUM: The SUM function is used to calculate the sum of all the values that are specified as a parameter to it. The syntax of this function is as follows:
SUM(number1, number2, …)
SUMIF: This function is used to calculate the sum of values that comply with a given condition.
SYNTAX:
SUMIF(range, criteria, [sum_range])
where,
range specifies the range of cells to be evaluated
criteria provides the condition to be met
sum_range is optional and provides the actual cells to be summed up
—————————————-
🔴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
Top Pandas commands you must know before going for Data Science interviews.
Watch our new YouTube video in which we have explained all the important Pandas commands in depth.
Link👉🏻 https://youtu.be/pKhajRGb_Ug
Watch our new YouTube video in which we have explained all the important Pandas commands in depth.
Link👉🏻 https://youtu.be/pKhajRGb_Ug
If you wanna become Job-Ready Data Scientist, Data Analyst OR Business Analyst then you should check our Data Science and Analytics MEGA COMBO COURSE. Link Below.
Course Link - https://www.cloudyml.com/mega-combo-package/
You gonna get complete Hands-on Practical Learning Experience from scratch.
In this package you are getting the topics mentioned below
✅Python
✅Machine Learning
✅SQL
✅Maths and Statistics
✅Deep Learning
✅AWS Sagemaker
✅Tableau
✅PowerBi
✅MS Excel
✅Model Deployment
✅Capstone End-to-End ML and DL Projects
✅Data Analytics Case Studies
With all these topics, you are also getting
✅1-1 Live Doubt Clearance Support
✅100% Internship Opportunity after course completion
✅Job referrals and job opening mails
✅Sample Resume and Resume Review Feature
✅Course Completion Certificate
So start your journey today and become technically strong enough so you can crack any Data Science OR Analytics Interview.
Join Now - https://www.cloudyml.com/mega-combo-package/
Trusted by 5500+ Happy Learners !
Course Link - https://www.cloudyml.com/mega-combo-package/
You gonna get complete Hands-on Practical Learning Experience from scratch.
In this package you are getting the topics mentioned below
✅Python
✅Machine Learning
✅SQL
✅Maths and Statistics
✅Deep Learning
✅AWS Sagemaker
✅Tableau
✅PowerBi
✅MS Excel
✅Model Deployment
✅Capstone End-to-End ML and DL Projects
✅Data Analytics Case Studies
With all these topics, you are also getting
✅1-1 Live Doubt Clearance Support
✅100% Internship Opportunity after course completion
✅Job referrals and job opening mails
✅Sample Resume and Resume Review Feature
✅Course Completion Certificate
So start your journey today and become technically strong enough so you can crack any Data Science OR Analytics Interview.
Join Now - https://www.cloudyml.com/mega-combo-package/
Trusted by 5500+ Happy Learners !
Today's Interview QnAs
Company- Tiger Analytics
Role- Data Analyst
1.What are the different types of functions generally used in Tableau?
In Tableau, we have a lot of processing and analytical freedom with the virtue of functions available.
With the help of different types of functions, we can perform a lot of analytical operations on the data.
The main categories of Tableau function are:
String function: These functions like ASCII, CHAR, FIND, ISDATE, LOWER, etc, are known as string functions because they work on the string values or characters to manipulate them.
Date function: We use date functions to apply logical as well as arithmetic operations on date values present at the data source.Using the date functions we can manipulate the date values by changing the old values, creating new ones or searching data on the basis of specific dates.
Some commonly used date functions in Tableau are DATEADD, MAKEDATE, ISDATE, MAKETIME, MONTH, MIN/MAX, TODAY, NOW, etc.
Logical function: We use logical functions to perform logical or relational operations on data in Tableau.
Some commonly used logical functions in Tableau are, CASE, IF, IFNULL, ISNULL, ZN, etc.
Aggregate function: We use aggregate functions to apply aggregation on data values in different ways.
Some important aggregation functions used in Tableau are; AVG, ATTR, MAX, MEDIAN, MIN, PERCENTILE, SUM, STDDEV, etc.
User function: We use functions to manage the users registered on Tableau Server or Tableau Online.
Commonly used user functions are, FULLNAME, ISFULLNAME, ISUSERNAME, USERDOMAIN, USERNAME, etc.
2.What do you understand by context filters?
Context filters are used to apply context on the data under analysis.
By applying a context we set a perspective according to which we can see the charts and graphs.
For example, we have sales data of an electronic store and we want to conduct our analysis only for the corporate sector or segment.
To do this, we have to apply a context filter on our Tableau sheet. Once we add the context for the Corporate segment from the Add to context option, all the charts present on the sheet will only show data relevant to the Corporate segment.
In this way, we can apply a context to our analysis in Tableau.
3. How do you add a Note to a cell?
To add a Note, select the cell and right-click on the same. then select the New Note option and type in any note that you wish to. In case you want to delete the Note, follow the same procedure and select the Delete Note option. Notes are indicated by a red triangle at the top-right corner of the cell.
4. What is DAX?
DAX stands for Data Analysis Expressions. It's a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have.
————————————————————-
🔴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- Tiger Analytics
Role- Data Analyst
1.What are the different types of functions generally used in Tableau?
In Tableau, we have a lot of processing and analytical freedom with the virtue of functions available.
With the help of different types of functions, we can perform a lot of analytical operations on the data.
The main categories of Tableau function are:
String function: These functions like ASCII, CHAR, FIND, ISDATE, LOWER, etc, are known as string functions because they work on the string values or characters to manipulate them.
Date function: We use date functions to apply logical as well as arithmetic operations on date values present at the data source.Using the date functions we can manipulate the date values by changing the old values, creating new ones or searching data on the basis of specific dates.
Some commonly used date functions in Tableau are DATEADD, MAKEDATE, ISDATE, MAKETIME, MONTH, MIN/MAX, TODAY, NOW, etc.
Logical function: We use logical functions to perform logical or relational operations on data in Tableau.
Some commonly used logical functions in Tableau are, CASE, IF, IFNULL, ISNULL, ZN, etc.
Aggregate function: We use aggregate functions to apply aggregation on data values in different ways.
Some important aggregation functions used in Tableau are; AVG, ATTR, MAX, MEDIAN, MIN, PERCENTILE, SUM, STDDEV, etc.
User function: We use functions to manage the users registered on Tableau Server or Tableau Online.
Commonly used user functions are, FULLNAME, ISFULLNAME, ISUSERNAME, USERDOMAIN, USERNAME, etc.
2.What do you understand by context filters?
Context filters are used to apply context on the data under analysis.
By applying a context we set a perspective according to which we can see the charts and graphs.
For example, we have sales data of an electronic store and we want to conduct our analysis only for the corporate sector or segment.
To do this, we have to apply a context filter on our Tableau sheet. Once we add the context for the Corporate segment from the Add to context option, all the charts present on the sheet will only show data relevant to the Corporate segment.
In this way, we can apply a context to our analysis in Tableau.
3. How do you add a Note to a cell?
To add a Note, select the cell and right-click on the same. then select the New Note option and type in any note that you wish to. In case you want to delete the Note, follow the same procedure and select the Delete Note option. Notes are indicated by a red triangle at the top-right corner of the cell.
4. What is DAX?
DAX stands for Data Analysis Expressions. It's a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have.
————————————————————-
🔴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
🔴JOB OPENING ALERT🔴
Role : Data Analyst - Python/Artificial Intelligence
Company : Imindyourbusiness
Exp - 0-1 yr
Link : https://ai.cloudyml.com/3lABoOt
Role : Data Analyst / Data Science Only Fresher Candidates Can Apply
Company : Infoweb
Exp - 0 yr
Link: https://ai.cloudyml.com/3PBoZYx
Role : Data Analyst
Company: Total Marketing Support India Private Limited
Exp - 0 -1 yr
Link: https://ai.cloudyml.com/3LDFhg8
Role : Artificial Intelligence (AI&ML) II Internship
Company : rooman tech pvt ltd
Exp : 0-2 yr
Link: https://ai.cloudyml.com/38H5wF2
Role : Data Analyst - Python/Artificial Intelligence
Company : Imindyourbusiness
Exp - 0-1 yr
Link : https://ai.cloudyml.com/3lABoOt
Role : Data Analyst / Data Science Only Fresher Candidates Can Apply
Company : Infoweb
Exp - 0 yr
Link: https://ai.cloudyml.com/3PBoZYx
Role : Data Analyst
Company: Total Marketing Support India Private Limited
Exp - 0 -1 yr
Link: https://ai.cloudyml.com/3LDFhg8
Role : Artificial Intelligence (AI&ML) II Internship
Company : rooman tech pvt ltd
Exp : 0-2 yr
Link: https://ai.cloudyml.com/38H5wF2
🔵Things You Must Master in Data Science and Programming !
Check out our latest YouTube Video in which we have explained top 3 skills that you must know and Master. Video link is given below.
👉🏻 https://youtu.be/h9gD7YwENVw
Check out our latest YouTube Video in which we have explained top 3 skills that you must know and Master. Video link is given below.
👉🏻 https://youtu.be/h9gD7YwENVw
Today's Interview QnAs
Company - PwC
Role- Business Analyst
1. What is analysis in tableau?
Ans: Tableau comes with inbuilt features to analyze the data plotted on a chart. We have various tools such as adding an average line to the chart which tableau calculates itself after we drop the tool on the chart. Some other features include clustering, percentages, forming bands of a particular range and various other tools to explore and inspect data. All these tools are available in analyze tab on each sheet used to create any chart. The features become visible only when they are applicable to the worksheet.
2.How to create sets in tableau?
Ans: Sets are custom fields used to compare and ask questions about a subset of data. For creating a set on dimension, right-click on a dimension in data pane and select create -> set. In general tab select the fields that will be considered for computing the set. Specify the conditions to create set in conditions tab and you also have the option to select top N members in dataset based on any field in the top tab. When a set is created it divides the measure into two parts namely in and out of the set based on the conditions applied by the user.
3.Why and how would you use a custom visual file?
A custom visual file is used when none of the pre existing visuals fit the business needs. Custom visual files are generally created by Developers which can be used in the same way as prepackaged files.
4. What are the various type of users who can use Power BI?
Ans: PowerBI can be used by anyone for their requirements but there is a particular group of users who are more likely to use it:
Report Consumers: They consume the reports based on a specific information they need
Report Analyst: Report Analysts need detailed data for their analysis from the reports
Self Service Data Analyst: They are more experienced business data users. They have an in-depth understanding of the data to work with.
Basic Data Analyst: They can build their own datasets and are experienced in PowerBI Service
Advanced Data Analyst: They know how to write SQL Queries and have hands-on experience on PowerBI. They have experience in Advanced PowerBI with DAX training and data modelling.
Company - PwC
Role- Business Analyst
1. What is analysis in tableau?
Ans: Tableau comes with inbuilt features to analyze the data plotted on a chart. We have various tools such as adding an average line to the chart which tableau calculates itself after we drop the tool on the chart. Some other features include clustering, percentages, forming bands of a particular range and various other tools to explore and inspect data. All these tools are available in analyze tab on each sheet used to create any chart. The features become visible only when they are applicable to the worksheet.
2.How to create sets in tableau?
Ans: Sets are custom fields used to compare and ask questions about a subset of data. For creating a set on dimension, right-click on a dimension in data pane and select create -> set. In general tab select the fields that will be considered for computing the set. Specify the conditions to create set in conditions tab and you also have the option to select top N members in dataset based on any field in the top tab. When a set is created it divides the measure into two parts namely in and out of the set based on the conditions applied by the user.
3.Why and how would you use a custom visual file?
A custom visual file is used when none of the pre existing visuals fit the business needs. Custom visual files are generally created by Developers which can be used in the same way as prepackaged files.
4. What are the various type of users who can use Power BI?
Ans: PowerBI can be used by anyone for their requirements but there is a particular group of users who are more likely to use it:
Report Consumers: They consume the reports based on a specific information they need
Report Analyst: Report Analysts need detailed data for their analysis from the reports
Self Service Data Analyst: They are more experienced business data users. They have an in-depth understanding of the data to work with.
Basic Data Analyst: They can build their own datasets and are experienced in PowerBI Service
Advanced Data Analyst: They know how to write SQL Queries and have hands-on experience on PowerBI. They have experience in Advanced PowerBI with DAX training and data modelling.
🔵 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