🔵Top 5 Python Functions YOU MUST KNOW !!!
Check our explained video on our YouTube channel. Link Below.
➡️ https://youtu.be/D9TVCmUxVNg
Check our explained video on our YouTube channel. Link Below.
➡️ https://youtu.be/D9TVCmUxVNg
#quiz
Which of the query below is used to put a value in a variable we need to define for our SQL query?
Which of the query below is used to put a value in a variable we need to define for our SQL query?
Anonymous Quiz
16%
Id = 6;
29%
SET @id = 6;
10%
SET #id = 6;
45%
SET id = 6;
Here we are with our latest blog about the uses of Artificial intelligence in every field🤖😳
➡️CHECK IT OUT NOW !
Blog link👉🏻 https://ai.cloudyml.com/Uses-of-AI
➡️CHECK IT OUT NOW !
Blog link👉🏻 https://ai.cloudyml.com/Uses-of-AI
Cloudyml
Use Of AI in Facility Management
AI is now the most used technology in the world of technology. Read more here on how AI can be used in various fields and how it is changing the way we live.
🔵 Interview QnA Explained Video
Python Interview Question asked in MICROSOFT
Check explained solution on our YouTube channel, link below.
👉🏻 https://youtu.be/cdUCV4j9guo
Python Interview Question asked in MICROSOFT
Check explained solution on our YouTube channel, link below.
👉🏻 https://youtu.be/cdUCV4j9guo
Get hands-on learning experience and become master in Python, SQL, Statistics, Tableau, Excel, PowerBi with 10+ analytics Case Studies😎
🔴Visit our Data Analytics/ Business Analytics Combo Course Now
Link👉🏻 https://ai.cloudyml.com/analytics
🔴Visit our Data Analytics/ Business Analytics Combo Course Now
Link👉🏻 https://ai.cloudyml.com/analytics
"Hello World" of Data Science !
Check our latest video on YouTube in which we have worked on Kaggle Titanic Datatset that you should check before working on any other challenge.
Video Link👉🏻 https://youtu.be/Mlq41Wd61nc
Check our latest video on YouTube in which we have worked on Kaggle Titanic Datatset that you should check before working on any other challenge.
Video Link👉🏻 https://youtu.be/Mlq41Wd61nc
Today's Interview QnAs
Company- Tiger Analytics
Role - Data Analyst
1.How to create sets in tableau?
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.
2. What is live and extract in tableau?
Extract is a snapshot of the data optimized for aggregation. Extracts are loaded into the system and hence improve the performance of tableau. Whereas extracts won’t help in situations where data is updated continuously because then we manually need to refresh the data for all the updates but using a live connection might slow the processing but will definitely update the data source itself. So, live connection should be used only when data is continuously updating otherwise extract file is preferred.
3.Differentiate between K-Means and KNN algorithms?
KNN algorithms is Supervised Learning where-as K-Means is Unsupervised Learning. With KNN, we predict the label of the unidentified element based on its nearest neighbour and further extend this approach for solving classification/regression-based problems.
K-Means is Unsupervised Learning, where we don’t have any Labels present, in other words, no Target Variables and thus we try to cluster the data based upon their coordinates and try to establish the nature of the cluster based on the elements filtered for that cluster.
4.What is absolute cell reference in excel?
Absolute cell reference is a locked reference and ensures that the rows and columns will not change on copying the cell. We add a '$' symbol in front of the row and column number. When the cell is $A$2, both rows and columns remain unchanged on copying. But if it is $A2, it means that the column remains unchanged, but the row changes on copying. Similarly, for A$2, the column changes, but the row remains unchanged on copying.
—————————————————
🔴Become a Pro in Tableau, PowerBi and Excel. Check our Data Visualization Course Package Now. Link Below
👉🏻 https://ai.cloudyml.com/data-visualization
Company- Tiger Analytics
Role - Data Analyst
1.How to create sets in tableau?
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.
2. What is live and extract in tableau?
Extract is a snapshot of the data optimized for aggregation. Extracts are loaded into the system and hence improve the performance of tableau. Whereas extracts won’t help in situations where data is updated continuously because then we manually need to refresh the data for all the updates but using a live connection might slow the processing but will definitely update the data source itself. So, live connection should be used only when data is continuously updating otherwise extract file is preferred.
3.Differentiate between K-Means and KNN algorithms?
KNN algorithms is Supervised Learning where-as K-Means is Unsupervised Learning. With KNN, we predict the label of the unidentified element based on its nearest neighbour and further extend this approach for solving classification/regression-based problems.
K-Means is Unsupervised Learning, where we don’t have any Labels present, in other words, no Target Variables and thus we try to cluster the data based upon their coordinates and try to establish the nature of the cluster based on the elements filtered for that cluster.
4.What is absolute cell reference in excel?
Absolute cell reference is a locked reference and ensures that the rows and columns will not change on copying the cell. We add a '$' symbol in front of the row and column number. When the cell is $A$2, both rows and columns remain unchanged on copying. But if it is $A2, it means that the column remains unchanged, but the row changes on copying. Similarly, for A$2, the column changes, but the row remains unchanged on copying.
—————————————————
🔴Become a Pro in Tableau, PowerBi and Excel. Check our Data Visualization Course Package Now. Link Below
👉🏻 https://ai.cloudyml.com/data-visualization
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.