{"id":234,"date":"2022-04-29T16:18:46","date_gmt":"2022-04-29T16:18:46","guid":{"rendered":"https:\/\/gauthamit.com\/blog\/?p=234"},"modified":"2022-05-20T03:52:11","modified_gmt":"2022-05-20T03:52:11","slug":"tableau-interview-questions-and-answers","status":"publish","type":"post","link":"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/","title":{"rendered":"Tableau Interview Questions and Answers"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#Tableau_Interview_Questions_and_Answers\" title=\"Tableau Interview Questions and Answers\">Tableau Interview Questions and Answers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#1_What_is_Tableau\" title=\"1. What is Tableau?\">1. What is Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#2_What_are_Measures_and_Dimensions\" title=\"2. What are Measures and Dimensions?\">2. What are Measures and Dimensions?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#3_What_are_the_different_Tableau_Products_and_what_is_the_latest_version_of_Tableau\" title=\"3.\u00a0What are the different Tableau Products and what is the latest version of Tableau?\">3.\u00a0What are the different Tableau Products and what is the latest version of Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#4_What_is_the_difference_between_twb_and_twbx_extension\" title=\"4. What is the difference between .twb and .twbx extension?\">4. What is the difference between .twb and .twbx extension?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#5What_are_the_different_types_of_joins_in_Tableau\" title=\"5.What are the different types of joins in Tableau?\">5.What are the different types of joins in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#6_How_many_maximum_tables_can_you_join_in_Tableau\" title=\"6. How many maximum tables can you join in Tableau?\">6. How many maximum tables can you join in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#7_What_are_the_different_connections_you_can_make_with_your_dataset\" title=\"7. What are the different connections you can make with your dataset?\">7. What are the different connections you can make with your dataset?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#8What_are_shelves\" title=\"8.What are shelves?\">8.What are shelves?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#9_What_are_sets\" title=\"9. What are sets?\">9. What are sets?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#10_What_are_groups\" title=\"10. What are groups?\">10. What are groups?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#11_What_is_a_hierarchical_field\" title=\"11. What is a hierarchical field?\">11. What is a hierarchical field?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#12_What_is_Tableau_Data_Server\" title=\"12. What is Tableau Data Server?\">12. What is Tableau Data Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#13What_is_Tableau_Data_Engine\" title=\"13.What is Tableau Data Engine?\">13.What is Tableau Data Engine?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#14_What_are_the_different_filters_in_Tableau_and_how_are_they_different_from_each_other\" title=\"14. What are the different filters in Tableau and how are they different from each other?\">14. What are the different filters in Tableau and how are they different from each other?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#15_How_to_create_a_calculated_field_in_Tableau\" title=\"15. \u00a0How to create a calculated field in Tableau?\">15. \u00a0How to create a calculated field in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#16What_is_a_dual_axis\" title=\"16.What is a dual axis?\">16.What is a dual axis?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#17_What_is_the_difference_between_a_tree_map_and_heat_map\" title=\"17. What is the difference between a tree map and heat map?\">17. What is the difference between a tree map and heat map?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#18What_is_disaggregation_and_aggregation_of_data\" title=\"18.What is disaggregation and aggregation of data?\">18.What is disaggregation and aggregation of data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#19What_is_the_difference_between_joining_and_blending_in_Tableau\" title=\"19.What is the difference between joining and blending in Tableau?\">19.What is the difference between joining and blending in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#20_What_are_Extracts_and_Schedules_in_Tableau_server\" title=\"20. What are Extracts and Schedules in Tableau server?\">20. What are Extracts and Schedules in Tableau server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#21_How_to_view_underlying_SQL_Queries_in_Tableau\" title=\"21. How to view underlying SQL Queries in Tableau?\">21. How to view underlying SQL Queries in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#22_How_to_do_Performance_Testing_in_Tableau\" title=\"22. How to do Performance Testing in Tableau?\">22. How to do Performance Testing in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#23_Name_the_components_of_a_Dashboard\" title=\"23.\u00a0 Name the components of a Dashboard.\">23.\u00a0 Name the components of a Dashboard.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#24How_to_remove_%E2%80%98All_options_from_a_Tableau_auto-filter\" title=\"24.How to remove \u2018All\u2019 options from a Tableau auto-filter?\">24.How to remove \u2018All\u2019 options from a Tableau auto-filter?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#25How_to_add_Custom_Color_to_Tableau\" title=\"25.How to add Custom Color to Tableau?\">25.How to add Custom Color to Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#26What_is_TDE_file\" title=\"26.What is TDE file?\">26.What is TDE file?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#27Mention_whether_you_can_create_relational_joins_in_Tableau_without_creating_a_new_table\" title=\"27.Mention whether you can create relational joins in Tableau without creating a new table?\">27.Mention whether you can create relational joins in Tableau without creating a new table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#28_How_to_automate_reports\" title=\"28. How to automate reports?\">28. How to automate reports?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#29What_is_Assume_referential_integrity\" title=\"29.What is Assume referential integrity?\">29.What is Assume referential integrity?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#30Explain_when_would_you_use_Joins_vs_Blending_in_Tableau\" title=\"30.Explain when would you use Joins vs. Blending in Tableau?\">30.Explain when would you use Joins vs. Blending in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#31What_is_default_Data_Blending_Join\" title=\"31.What is default Data Blending Join?\">31.What is default Data Blending Join?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#32What_do_you_understand_by_blended_axis\" title=\"32.What do you understand by blended axis?\">32.What do you understand by blended axis?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#33What_is_story_in_Tableau\" title=\"33.What is story in Tableau?\">33.What is story in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#34What_is_the_difference_between_discrete_and_continuous_in_Tableau\" title=\"34.What is the difference between discrete and continuous in Tableau?\">34.What is the difference between discrete and continuous in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#35How_to_create_stories_in_Tableau\" title=\"35.How to create stories in Tableau?\">35.How to create stories in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#36What_is_the_DRIVE_Program_Methodology\" title=\"36.What is the DRIVE Program Methodology?\">36.What is the DRIVE Program Methodology?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#37How_to_use_group_in_calculated_fieldUsing_groups_in_a_calculation\" title=\"37.How to use group in calculated field?Using groups in a calculation.\">37.How to use group in calculated field?Using groups in a calculation.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#38Mention_what_are_different_Tableau_files\" title=\"38.Mention what are different Tableau files?\">38.Mention what are different Tableau files?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#39How_to_embed_views_onto_Webpages\" title=\"39.How to embed views onto Webpages?\">39.How to embed views onto Webpages?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#40Design_a_view_in_a_map_such_that_if_user_selects_any_state_the_cities_under_that_state_has_to_show_profit_and_sales\" title=\"40.Design a view in a map such that if user selects any state, the cities under that state has to show profit and sales.\">40.Design a view in a map such that if user selects any state, the cities under that state has to show profit and sales.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#41Suppose_my_license_expires_today_will_users_be_able_to_view_dashboards_or_workbooks_which_I_published_in_the_server_earlier\" title=\"41.Suppose my license expires today, will users be able to view dashboards or workbooks which I published in the server earlier?\">41.Suppose my license expires today, will users be able to view dashboards or workbooks which I published in the server earlier?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#42Is_Tableau_software_good_for_strategic_acquisition\" title=\"42.Is Tableau software good for strategic acquisition?\">42.Is Tableau software good for strategic acquisition?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#43Can_we_place_an_excel_file_in_a_shared_location_and_and_use_it_to_develop_a_report_and_refresh_it_in_regular_intervals\" title=\"43.Can we place an excel file in a shared location and and use it to develop a report and refresh it in regular intervals?\">43.Can we place an excel file in a shared location and and use it to develop a report and refresh it in regular intervals?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#44Can_Tableau_be_installed_on_MacOS\" title=\"44.Can Tableau be installed on MacOS?\">44.Can Tableau be installed on MacOS?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#45What_is_the_maximum_no_of_rows_Tableau_can_utilize_at_one_time\" title=\"45.What is the maximum no. of rows Tableau can utilize at one time?\">45.What is the maximum no. of rows Tableau can utilize at one time?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#46When_publishing_workbooks_on_Tableau_online_sometimes_a_error_about_needing_to_extract_appears_Why_does_it_happen_occasionally\" title=\"46.When publishing workbooks on Tableau online, sometimes a error about needing to extract appears. Why does it happen occasionally?\">46.When publishing workbooks on Tableau online, sometimes a error about needing to extract appears. Why does it happen occasionally?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#47What_is_data_visualization_in_Tableau\" title=\"47.What is data visualization in Tableau?\">47.What is data visualization in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-49\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#48What_is_the_difference_between_various_BI_tools_and_Tableau\" title=\"48.What is the difference between various BI tools and Tableau?\">48.What is the difference between various BI tools and Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-50\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#49What_are_different_Tableau_productsTableau_Desktop\" title=\"49.What are different Tableau products?Tableau Desktop:\">49.What are different Tableau products?Tableau Desktop:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-51\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#50What_is_a_parameter_in_Tableau\" title=\"50.What is a parameter in Tableau?\">50.What is a parameter in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-52\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#51Tell_me_something_about_measures_and_dimensions\" title=\"51.Tell me something about measures and dimensions?\">51.Tell me something about measures and dimensions?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-53\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#52What_is_aggregation_and_disaggregation_of_data\" title=\"52.What is aggregation and disaggregation of data?\">52.What is aggregation and disaggregation of data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-54\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#53What_are_continuous_and_discrete_field_types\" title=\"53.What are continuous and discrete field types?\">53.What are continuous and discrete field types?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-55\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#54What_are_the_different_types_of_joins_in_Tableau\" title=\"54.What are the different types of joins in Tableau?\">54.What are the different types of joins in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-56\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#55Tell_me_the_different_connections_to_make_with_a_dataset\" title=\"55.Tell me the different connections to make with a dataset?\">55.Tell me the different connections to make with a dataset?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-57\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#56What_are_the_supported_file_extensions_in_Tableau\" title=\"56.What are the supported file extensions in Tableau?\">56.What are the supported file extensions in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-58\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#57What_are_the_supported_data_types_in_TableauThe_following_data_types_are_supported_in_Tableau\" title=\"57.What are the supported data types in Tableau?The following data types are supported in Tableau:\">57.What are the supported data types in Tableau?The following data types are supported in Tableau:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-59\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#58What_are_sets\" title=\"58.What are sets?\">58.What are sets?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-60\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#60What_are_groups_in_Tableau\" title=\"60.What are groups in Tableau?\">60.What are groups in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-61\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#61What_are_shelves\" title=\"61.What are shelves?\">61.What are shelves?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-62\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#62Tell_me_something_about_Data_blending_in_Tableau\" title=\"62.Tell me something about Data blending in Tableau?\">62.Tell me something about Data blending in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-63\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#63How_do_you_generally_perform_load_testing_in_Tableau\" title=\"63.How do you generally perform load testing in Tableau?\">63.How do you generally perform load testing in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-64\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#64Why_would_someone_not_use_Tableau\" title=\"64.Why would someone not use Tableau?\">64.Why would someone not use Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-65\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#65What_is_Tableau_data_engine\" title=\"65.What is Tableau data engine?\">65.What is Tableau data engine?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-66\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#66What_are_the_various_types_of_filters_in_Tableau\" title=\"66.What are the various types of filters in Tableau?\">66.What are the various types of filters in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-67\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#67What_are_extracts_and_schedules_in_Tableau_server\" title=\"67.What are extracts and schedules in Tableau server?\">67.What are extracts and schedules in Tableau server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-68\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#68What_are_dual_axes\" title=\"68.What are dual axes?\">68.What are dual axes?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-69\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#69What_is_a_TDE_file\" title=\"69.What is a TDE file?\">69.What is a TDE file?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-70\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#70What_is_the_story_in_Tableau\" title=\"70.What is the story in Tableau?\">70.What is the story in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-71\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#71What_are_different_Tableau_files\" title=\"71.What are different Tableau files?\">71.What are different Tableau files?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-72\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#72How_do_you_embed_views_into_webpages\" title=\"72.How do you embed views into webpages?\">72.How do you embed views into webpages?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-73\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#74Mention_what_is_the_difference_between_published_data_sources_and_embedded_data_sources_in_Tableau\" title=\"74.Mention what is the difference between published data sources and \u00a0 embedded data sources in Tableau?\">74.Mention what is the difference between published data sources and \u00a0 embedded data sources in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-74\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#75What_is_the_DRIVE_Program_Methodology\" title=\"75.What is the DRIVE Program Methodology?\">75.What is the DRIVE Program Methodology?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-75\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#76How_to_use_groups_in_a_calculated_field\" title=\"76.How to use groups in a calculated field?\">76.How to use groups in a calculated field?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-76\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#77Explain_when_would_you_use_Joins_vs_Blending_in_Tableau\" title=\"77.Explain when would you use Joins vs. Blending in Tableau?\">77.Explain when would you use Joins vs. Blending in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-77\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#78What_is_Assume_referential_integrity\" title=\"78.What is Assume referential integrity?\">78.What is Assume referential integrity?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-78\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#79What_is_a_Calculated_Field_and_How_Will_You_Create_One\" title=\"79.What is a Calculated Field, and How Will You Create One?\">79.What is a Calculated Field, and How Will You Create One?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-79\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#80How_Can_You_Display_the_Top_Five_and_Bottom_Five_Sales_in_the_Same_View\" title=\"80.How Can You Display the Top Five and Bottom Five Sales in the Same View?\">80.How Can You Display the Top Five and Bottom Five Sales in the Same View?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-80\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#81What_is_the_Rank_Function_in_Tableau\" title=\"81.What is the Rank Function in Tableau?\">81.What is the Rank Function in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-81\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#82What_is_the_difference_between_Tableau_and_other_similar_tools_like_QlikView_or_IBM_Cognos\" title=\"82.What is the difference between Tableau and other similar tools like QlikView or IBM Cognos?\">82.What is the difference between Tableau and other similar tools like QlikView or IBM Cognos?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-82\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#83What_is_data_visualization\" title=\"83.What is data visualization?\">83.What is data visualization?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-83\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#84List_out_Tableau_File_Extensions\" title=\"84.List out Tableau File Extensions.\">84.List out Tableau File Extensions.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-84\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#85What_is_the_latest_version_of_Tableau_Desktop\" title=\"85.What is the latest version of Tableau Desktop?\">85.What is the latest version of Tableau Desktop?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-85\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#86Define_LOD_Expression\" title=\"86.Define LOD Expression?\">86.Define LOD Expression?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-86\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#87Define_Heat_Map\" title=\"87.Define Heat Map?\">87.Define Heat Map?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-87\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#88Define_TreeMap\" title=\"88.Define TreeMap?\">88.Define TreeMap?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-88\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#89What_are_the_different_data_types_in_Tableau\" title=\"89.What are the different data types in Tableau?\">89.What are the different data types in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-89\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#90Give_a_brief_about_the_tableau_dashboard\" title=\"90.Give a brief about the tableau dashboard?\">90.Give a brief about the tableau dashboard?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-90\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#91Define_Page_Shelf_in_Tableau\" title=\"91.Define Page Shelf in Tableau?\">91.Define Page Shelf in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-91\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#92Define_the_story_in_Tableau\" title=\"92.Define the story in Tableau?\">92.Define the story in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-92\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#93Give_an_overview_of_the_fact_and_dimensions_of_the_table\" title=\"93.Give an overview of the fact and dimensions of the table?\">93.Give an overview of the fact and dimensions of the table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-93\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#94State_some_ways_to_improve_the_performance_of_Tableau\" title=\"94.State some ways to improve the performance of Tableau\">94.State some ways to improve the performance of Tableau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-94\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#95Explain_different_connection_types_in_Tableau\" title=\"95.Explain different connection types in Tableau?\">95.Explain different connection types in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-95\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#96What_are_the_different_Joins_in_Tableau\" title=\"96.What are the different Joins in Tableau?\">96.What are the different Joins in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-96\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#97What_is_Data_Modelling\" title=\"97.What is Data Modelling?\">97.What is Data Modelling?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-97\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#98Define_blended_axis\" title=\"98.Define blended axis?\">98.Define blended axis?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-98\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#99Define_shelves_and_sets\" title=\"99.Define shelves and sets?\">99.Define shelves and sets?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-99\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#100Define_Dual-axis\" title=\"100.Define Dual-axis?\">100.Define Dual-axis?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-100\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#101Explain_the_limitation_of_context_filters_in_Tableau\" title=\"101.Explain the limitation of context filters in Tableau?\">101.Explain the limitation of context filters in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-101\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#102What_is_Mark_Card_in_Tableau\" title=\"102.What is Mark Card in Tableau?\">102.What is Mark Card in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-102\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#103Define_published_data_source\" title=\"103.Define published data source?\">103.Define published data source?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-103\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#104Define_dual_axis\" title=\"104.Define dual axis?\">104.Define dual axis?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-104\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#105Define_Bullet_graph\" title=\"105.Define Bullet graph?\">105.Define Bullet graph?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-105\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#106Define_Gantt_chart\" title=\"106.Define Gantt chart?\">106.Define Gantt chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-106\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#107Define_a_Histogram_chart\" title=\"107.Define a Histogram chart?\">107.Define a Histogram chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-107\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#108What_are_the_file_size_limitations_with_Tableau\" title=\"108.What are the file size limitations with Tableau?\">108.What are the file size limitations with Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-108\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#109What_is_Tableau_Reader\" title=\"109.What is Tableau Reader?\">109.What is Tableau Reader?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-109\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#110What_is_the_difference_between_published_data_and_embedded_data_sources\" title=\"110.What is the difference between published data and embedded data sources?\">110.What is the difference between published data and embedded data sources?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-110\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#111What_is_the_Hierarchy_in_Tableau\" title=\"111.What is the Hierarchy in Tableau?\">111.What is the Hierarchy in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-111\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#112What_is_a_Column_chart\" title=\"112.What is a Column chart?\">112.What is a Column chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-112\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#113What_is_the_Bar_Chart_in_Tableau\" title=\"113.What is the Bar Chart in Tableau?\">113.What is the Bar Chart in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-113\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#114What_is_the_Line_Chart\" title=\"114.What is the Line Chart?\">114.What is the Line Chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-114\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#115What_is_a_Stacked_Bar_chart\" title=\"115.What is a Stacked Bar chart?\">115.What is a Stacked Bar chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-115\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#116What_is_a_Stacked_Column_Chart\" title=\"116.What is a Stacked Column Chart?\">116.What is a Stacked Column Chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-116\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#117What_is_an_Area_Chart\" title=\"117.What is an Area Chart?\">117.What is an Area Chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-117\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#118How_to_download_Tableau_Public\" title=\"118.How to download Tableau Public?\">118.How to download Tableau Public?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-118\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#119What_is_Context_Filter_and_show_the_steps_on_how_to_create_the_Context_Filter_Tableau\" title=\"119.What is Context Filter and show the steps on how to create the Context Filter Tableau?\">119.What is Context Filter and show the steps on how to create the Context Filter Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-119\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#120What_are_the_products_offered_by_Tableau_Explain_a_few_things_about_them\" title=\"120.What are the products offered by Tableau? Explain a few things about them.\">120.What are the products offered by Tableau? Explain a few things about them.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-120\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#121Differentiate_parameters_and_filters_in_Tableau\" title=\"121.Differentiate parameters and filters in Tableau\">121.Differentiate parameters and filters in Tableau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-121\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#122Explain_how_many_types_of_filters_are_available_in_Tableau\" title=\"122.Explain how many types of filters are available in Tableau?\">122.Explain how many types of filters are available in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-122\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#123Differentiate_between_Tiled_and_Floating_in_dashboards\" title=\"123.Differentiate between Tiled and Floating in dashboards?\">123.Differentiate between Tiled and Floating in dashboards?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-123\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#124Categorize_dimensions_in_Tableau\" title=\"124.Categorize dimensions in Tableau?\">124.Categorize dimensions in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-124\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#125Explain_the_disaggregation_and_aggregation_of_data_in_Tableau\" title=\"125.Explain the disaggregation and aggregation of data in Tableau?\">125.Explain the disaggregation and aggregation of data in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-125\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#126State_the_components_of_the_dashboard\" title=\"126.State the components of the dashboard?\">126.State the components of the dashboard?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-126\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#127Differentiate_discrete_and_continuous_data_roles_in_Tableau\" title=\"127.Differentiate discrete and continuous data roles in Tableau\">127.Differentiate discrete and continuous data roles in Tableau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-127\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#128What_is_the_difference_between_Traditional_BI_Tools_and_Tableau\" title=\"128.What is the difference between Traditional BI Tools and Tableau?\">128.What is the difference between Traditional BI Tools and Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-128\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#129Define_performance_testing_in_terms_of_Tableau\" title=\"129.Define performance testing in terms of Tableau\">129.Define performance testing in terms of Tableau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-129\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#130What_is_the_difference_between_twb_and_twbx_extensions\" title=\"130.What is the difference between .twb and .twbx extensions?\">130.What is the difference between .twb and .twbx extensions?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-130\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#131Why_Tableau\" title=\"131.Why Tableau?\">131.Why Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-131\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#132How_to_create_a_calculated_field_in_Tableau\" title=\"132.How to create a calculated field in Tableau?\">132.How to create a calculated field in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-132\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#133Are_there_any_limitations_of_parameters_in_Tableau_If_yes_give_details\" title=\"133.Are there any limitations of parameters in Tableau? If yes, give details.\">133.Are there any limitations of parameters in Tableau? If yes, give details.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-133\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#134State_some_reasons_for_the_low_performance_of_Tableau_Explain_in_detail\" title=\"134.State some reasons for the low performance of Tableau? Explain in detail.\">134.State some reasons for the low performance of Tableau? Explain in detail.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-134\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#135State_some_ways_to_improve_the_performance_of_Tableau\" title=\"135.State some ways to improve the performance of Tableau.\">135.State some ways to improve the performance of Tableau.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-135\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#136Tell_me_different_ways_to_use_parameters_in_Tableau\" title=\"136.Tell me different ways to use parameters in Tableau\">136.Tell me different ways to use parameters in Tableau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-136\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#137Can_we_see_SQL_generated_by_Tableau_Desktop\" title=\"137.Can we see SQL generated by Tableau Desktop?\">137.Can we see SQL generated by Tableau Desktop?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-137\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#138Can_we_remove_the_All_options_from_a_Tableau_auto-filter\" title=\"138.Can we remove the All options from a Tableau auto-filter?\">138.Can we remove the All options from a Tableau auto-filter?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-138\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#139Which_one_is_better_Extract_or_Live_connection\" title=\"139.Which one is better? Extract or Live connection?\">139.Which one is better? Extract or Live connection?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-139\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#140Tell_me_something_about_the_workbook_version_controlled_in_Tableau\" title=\"140.Tell me something about the workbook version controlled in Tableau.\">140.Tell me something about the workbook version controlled in Tableau.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-140\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#141Where_can_we_apply_global_filters\" title=\"141.Where can we apply global filters?\">141.Where can we apply global filters?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-141\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#142How_to_add_custom_color_to_Tableau\" title=\"142.How to add custom color to Tableau?\">142.How to add custom color to Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-142\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#143Can_we_create_cascading_filters_without_using_context_filters\" title=\"143.Can we create cascading filters without using context filters?\">143.Can we create cascading filters without using context filters?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-143\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#144How_can_we_display_the_top_and_bottom_5_of_records_in_a_single_Tableau_view\" title=\"144.How can we display the top and bottom 5 of records in a single Tableau view?\">144.How can we display the top and bottom 5 of records in a single Tableau view?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-144\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#145State_a_few_charts_which_we_should_not_use_with_valid_reasons\" title=\"145.State a few charts which we should not use with valid reasons\">145.State a few charts which we should not use with valid reasons<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-145\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#146Do_we_have_any_way_to_handle_null_values_in_Tableau\" title=\"146.Do we have any way to handle null values in Tableau?\">146.Do we have any way to handle null values in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-146\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#147Can_we_download_views_or_workbooks_from_the_server_If_yes_in_which_data_formats\" title=\"147.Can we download views or workbooks from the server? If yes, in which data formats?\">147.Can we download views or workbooks from the server? If yes, in which data formats?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-147\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#148Do_we_have_any_data_limitations_in_Tableau_Public\" title=\"148.Do we have any data limitations in Tableau Public?\">148.Do we have any data limitations in Tableau Public?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-148\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#149Can_we_use_unused_columns_Columns_that_are_not_used_in_reports_but_data_source_has_columns_in_Tableau_Filters\" title=\"149.Can we use unused columns (Columns that are not used in reports but data source has columns) in Tableau Filters?\">149.Can we use unused columns (Columns that are not used in reports but data source has columns) in Tableau Filters?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-149\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#150What_is_the_benefit_of_the_Tableau_extract_file_over_the_live_connection\" title=\"150.What is the benefit of the Tableau extract file over the live connection?\">150.What is the benefit of the Tableau extract file over the live connection?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-150\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#151How_many_tables_join_are_possible_in_Tableau\" title=\"151.How many tables join are possible in Tableau?\">151.How many tables join are possible in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-151\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#152Can_we_place_an_excel_file_in_a_shared_location_and_use_it_to_develop_a_report_and_refresh_it_in_regular_intervals\" title=\"152.Can we place an excel file in a shared location and use it to develop a report and refresh it in regular intervals?\">152.Can we place an excel file in a shared location and use it to develop a report and refresh it in regular intervals?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-152\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#153How_do_we_do_testing_in_Tableau\" title=\"153.How do we do testing in Tableau?\">153.How do we do testing in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-153\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#154Design_a_view_in_a_map_such_that_if_a_user_selects_any_state_the_cities_under_that_state_have_to_show_profit_and_sales\" title=\"154.Design a view in a map such that if a user selects any state the cities under that state have to show profit and sales.\">154.Design a view in a map such that if a user selects any state the cities under that state have to show profit and sales.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-154\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#155How_can_u_set_permissions_or_protect_the_data_in_tableau_public\" title=\"155.How can u set permissions or protect the data in tableau public?\">155.How can u set permissions or protect the data in tableau public?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-155\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#156If_I_delete_a_workbook_from_tableau_public_and_there_are_links_to_other_blogs_and_other_web_locations_What_happens_to_them\" title=\"156.If I delete a workbook from tableau public and there are links to other blogs and other web locations. What happens to them?\">156.If I delete a workbook from tableau public and there are links to other blogs and other web locations. What happens to them?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-156\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#157Mention_whether_you_can_create_relational_joins_in_Tableau_without_creating_a_new_table\" title=\"157.Mention whether you can create relational joins in Tableau without creating a new table?\">157.Mention whether you can create relational joins in Tableau without creating a new table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-157\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#158Can_parameters_have_a_drop-down_list\" title=\"158.Can parameters have a drop-down list?\">158.Can parameters have a drop-down list?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-158\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#159How_do_you_optimize_the_performance_of_the_dashboard\" title=\"159.How do you optimize the performance of the dashboard?\">159.How do you optimize the performance of the dashboard?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-159\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#160Can_Tableau_be_installed_on_macOS\" title=\"160.Can Tableau be installed on macOS?\">160.Can Tableau be installed on macOS?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-160\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#161How_to_automate_reports_in_Tableau\" title=\"161.How to automate reports in Tableau?\">161.How to automate reports in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-161\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#162Which_databases_give_the_best_performance_when_connected_live\" title=\"162.Which databases give the best performance when connected live?\">162.Which databases give the best performance when connected live?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-162\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#163What_are_the_challenges_faced_when_working_with_huge_volumes_of_data\" title=\"163.What are the challenges faced when working with huge volumes of data?\">163.What are the challenges faced when working with huge volumes of data?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-163\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#164State_limitation_of_context_filters_in_Tableau\" title=\"164.State limitation of context filters in Tableau\">164.State limitation of context filters in Tableau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-164\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#165What_is_a_marks_card_in_Tableau\" title=\"165.What is a marks card in Tableau?\">165.What is a marks card in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-165\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#166Define_a_published_data_source\" title=\"166.Define a published data source\">166.Define a published data source<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-166\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#167Define_blended_axis\" title=\"167.Define blended axis\">167.Define blended axis<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-167\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#168Can_we_remove_the_%E2%80%9CAll%E2%80%9D_option_from_the_auto-filter_in_Tableau\" title=\"168.Can we remove the \u201cAll\u201d option from the auto-filter in Tableau?\">168.Can we remove the \u201cAll\u201d option from the auto-filter in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-168\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#169Define_Bullet_graph\" title=\"169.Define Bullet graph\">169.Define Bullet graph<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-169\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#170Define_Gantt_chart\" title=\"170.Define Gantt chart\">170.Define Gantt chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-170\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#171Define_Histogram_chart\" title=\"171.Define Histogram chart\">171.Define Histogram chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-171\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#172What_is_Tableau_Public\" title=\"172.What is Tableau Public?\">172.What is Tableau Public?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-172\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#173What_Are_the_Data_Types_Supported_in_Tableau\" title=\"173.What Are the Data Types Supported in Tableau?\">173.What Are the Data Types Supported in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-173\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#174How_Will_You_Understand_Dimensions_and_Measures\" title=\"174.How Will You Understand Dimensions and Measures?\">174.How Will You Understand Dimensions and Measures?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-174\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#175What_is_Meant_by_%E2%80%98discrete_and_%E2%80%98continuous_in_Tableau\" title=\"175.What is Meant by \u2018discrete\u2019 and \u2018continuous\u2019 in Tableau?\">175.What is Meant by \u2018discrete\u2019 and \u2018continuous\u2019 in Tableau?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-175\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#Discrete\" title=\"Discrete\">Discrete<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-176\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#Continuous\" title=\"Continuous\">Continuous<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-177\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#176What_Are_the_Filters_Name_the_Different_Filters_in_Tableau\" title=\"176.What Are the Filters? Name the Different Filters in Tableau.\">176.What Are the Filters? Name the Different Filters in Tableau.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-178\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#The_Different_Types_of_Tableau_Filters_are\" title=\"The Different Types of Tableau Filters are:\">The Different Types of Tableau Filters are:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-179\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#177What_Are_the_Different_Joins_in_Tableau\" title=\"177.What Are the Different Joins in Tableau?\">177.What Are the Different Joins in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-180\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#178There_Are_Three_Customer_Segments_in_the_Superstore_Dataset_What_Percent_of_the_Total_Profits_Are_Associated_with_the_Corporate_Segment\" title=\"178.There Are Three Customer Segments in the Superstore Dataset. What Percent of the Total Profits Are Associated with the Corporate Segment?\">178.There Are Three Customer Segments in the Superstore Dataset. What Percent of the Total Profits Are Associated with the Corporate Segment?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-181\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#179What_is_the_Difference_Between_Joining_and_Blending\" title=\"179.What is the Difference Between Joining and Blending?\">179.What is the Difference Between Joining and Blending?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-182\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#180What_is_the_Difference_Between_a_Live_Connection_and_an_Extract\" title=\"180.What is the Difference Between a Live Connection and an Extract?\">180.What is the Difference Between a Live Connection and an Extract?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-183\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#181What_is_a_Calculated_Field_and_How_Will_You_Create_One\" title=\"181.What is a Calculated Field, and How Will You Create One?\">181.What is a Calculated Field, and How Will You Create One?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-184\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#182How_Can_You_Display_the_Top_Five_and_Bottom_Five_Sales_in_the_Same_View\" title=\"182.How Can You Display the Top Five and Bottom Five Sales in the Same View?\">182.How Can You Display the Top Five and Bottom Five Sales in the Same View?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-185\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#183Is_There_a_Difference_Between_Sets_and_Groups_in_Tableau\" title=\"183.Is There a Difference Between Sets and Groups in Tableau?\">183.Is There a Difference Between Sets and Groups in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-186\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#184What_is_a_Parameter_in_Tableau_Give_an_Example\" title=\"184.What is a Parameter in Tableau? Give an Example.\">184.What is a Parameter in Tableau? Give an Example.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-187\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#185What_is_the_Difference_Between_Treemaps_and_Heat_Maps\" title=\"185.What is the Difference Between Treemaps and Heat Maps?\">185.What is the Difference Between Treemaps and Heat Maps?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-188\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#186What_is_the_Rank_Function_in_Tableau\" title=\"186.What is the Rank Function in Tableau?\">186.What is the Rank Function in Tableau?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-189\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#187What_Would_You_Do_If_Some_CountriesProvinces_Any_Geographical_Entity_are_Missing_and_Displaying_a_Null_When_You_Use_Map_View\" title=\"187.What Would You Do If Some Countries\/Provinces (Any Geographical Entity) are Missing and Displaying a Null When You Use Map View?\">187.What Would You Do If Some Countries\/Provinces (Any Geographical Entity) are Missing and Displaying a Null When You Use Map View?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-190\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#Edit_Locations\" title=\"Edit Locations\">Edit Locations<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-191\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#Filter_Data_%E2%80%93\" title=\"Filter Data\u00a0&#8211;\">Filter Data\u00a0&#8211;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-192\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#Show_Data_at_Default_Position_%E2%80%93\" title=\"Show Data at Default Position &#8211;\">Show Data at Default Position &#8211;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-193\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#188What_is_the_Level_of_Detail_LOD_Expression\" title=\"188.What is the Level of Detail (LOD) Expression?\">188.What is the Level of Detail (LOD) Expression?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-194\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#189How_Do_You_Calculate_the_Daily_Profit_Measures_Using_LOD\" title=\"189.How Do You Calculate the Daily Profit Measures Using LOD?\">189.How Do You Calculate the Daily Profit Measures Using LOD?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-195\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#190How_Can_You_Schedule_a_Workbook_in_Tableau_after_Publishing_It\" title=\"190.How Can You Schedule a Workbook in Tableau after Publishing It?\">190.How Can You Schedule a Workbook in Tableau after Publishing It?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-196\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#191How_Do_You_Handle_Null_and_Other_Special_Values\" title=\"191.How Do You Handle Null and Other Special Values?\">191.How Do You Handle Null and Other Special Values?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-197\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#192Find_the_Customer_with_the_Lowest_Overall_Profit_What_is_Their_Profit_Ratio\" title=\"192.Find the Customer with the Lowest Overall Profit. What is Their Profit Ratio?\">192.Find the Customer with the Lowest Overall Profit. What is Their Profit Ratio?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-198\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#193How_Can_You_Embed_a_Webpage_in_a_Dashboard\" title=\"193.How Can You Embed a Webpage in a Dashboard?\">193.How Can You Embed a Webpage in a Dashboard?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-199\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#194How_Do_You_Make_the_Webpage_Dynamic\" title=\"194.How Do You Make the Webpage Dynamic?\">194.How Do You Make the Webpage Dynamic?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-200\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#195Design_a_View_to_Show_Region_Wise_Profit_and_Sales\" title=\"195.Design a View to Show Region Wise Profit and Sales.\">195.Design a View to Show Region Wise Profit and Sales.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-201\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#196How_Can_You_Optimize_the_Performance_of_a_Dashboard\" title=\"196.How Can You Optimize the Performance of a Dashboard?\">196.How Can You Optimize the Performance of a Dashboard?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-202\" href=\"https:\/\/gauthamit.com\/blog\/tableau-interview-questions-and-answers\/#197Which_Visualization_Will_Be_Used_in_the_given_Scenarios\" title=\"197.Which Visualization Will Be Used in the given Scenarios?\">197.Which Visualization Will Be Used in the given Scenarios?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tableau_Interview_Questions_and_Answers\"><\/span><strong>Tableau Interview Questions and Answers<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"1_What_is_Tableau\"><\/span>1. What is Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau is a business intelligence software.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">It allows anyone to connect to the respective data.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Visualizes and creates interactive, shareable dashboards.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_What_are_Measures_and_Dimensions\"><\/span>2. What are Measures and Dimensions?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Measures<\/b><span style=\"font-weight: 400;\">\u00a0are the numeric metrics or measurable quantities of the data, which can be analyzed by dimension table. Measures are stored in a\u00a0table that contain foreign keys referring uniquely to the associated dimension tables. The table supports data storage at atomic level and thus, allows more number of records to be inserted at one time. For instance, a Sales table can have product key, customer key, promotion key, items sold, referring to a specific event.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_What_are_the_different_Tableau_Products_and_what_is_the_latest_version_of_Tableau\"><\/span>3.\u00a0What are the different Tableau Products and what is the latest version of Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Tableau Desktop:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">It is a self service business analytics and data visualization that anyone can use. It translates pictures of data into optimized queries. With tableau desktop, you can directly connect to data from your data warehouse for live upto date data analysis. You can also perform queries without writing a single line of code. Import all your data into Tableau\u2019s data engine from multiple sources &amp; integrate altogether by combining multiple views in a interactive dashboard.<\/span><b><\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_What_is_the_difference_between_twb_and_twbx_extension\"><\/span>4. What is the difference between .twb and .twbx extension?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A .twb is an xml document which contains all the selections and layout made you have made in your Tableau workbook. It does not contain any data.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A .twbx is a \u2018zipped\u2019 archive containing a .twb and any external files such as extracts and background images.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"5What_are_the_different_types_of_joins_in_Tableau\"><\/span>5.What are the different types of joins in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The joins in Tableau are same as SQL joins. Take a look at the diagram below to understand it.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"6_How_many_maximum_tables_can_you_join_in_Tableau\"><\/span>6. How many maximum tables can you join in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">You can join a maximum of 32 tables in Tableau.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"7_What_are_the_different_connections_you_can_make_with_your_dataset\"><\/span>7. What are the different connections you can make with your dataset?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">We can either connect live to our data set or extract data onto Tableau.<\/span><\/p>\n<ul>\n<li aria-level=\"1\"><b>Live:<\/b><span style=\"font-weight: 400;\">\u00a0Connecting live to a data set leverages its computational processing and storage. New queries will go to the database and will be reflected as new or updated within the data.<\/span><\/li>\n<li aria-level=\"1\"><b>Extract:<\/b><span style=\"font-weight: 400;\">\u00a0An extract will make a static snapshot of the data to be used by Tableau\u2019s data engine. The snapshot of the data can be refreshed on a recurring schedule as a whole or incrementally append data. One way to set up these schedules is via the Tableau server.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"8What_are_shelves\"><\/span>8.What are shelves?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">They are Named areas to the left and top of the view. You build views by placing fields onto the shelves. Some shelves are available only when you select certain mark types.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"9_What_are_sets\"><\/span>9. What are sets?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Sets<\/b><span style=\"font-weight: 400;\">\u00a0are custom fields that define a subset of data based on some conditions. A\u00a0<\/span><b>set\u00a0<\/b><span style=\"font-weight: 400;\">can be based on a computed condition, for example, a\u00a0<\/span><b>set<\/b><span style=\"font-weight: 400;\">\u00a0may contain customers with sales over a certain threshold. Computed\u00a0<\/span><b>sets<\/b><span style=\"font-weight: 400;\">\u00a0update as your data changes. Alternatively, a\u00a0<\/span><b>set<\/b><span style=\"font-weight: 400;\">\u00a0can be based on specific data point in your view.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"10_What_are_groups\"><\/span>10. What are groups?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A group is a combination of dimension members that make higher level categories. For example, if you are working with a view that shows average test scores by major, you may want to group certain majors together to create major categories.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"11_What_is_a_hierarchical_field\"><\/span>11. What is a hierarchical field?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A hierarchical field in tableau is used for drilling down data. It means viewing your data in a more granular level.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"12_What_is_Tableau_Data_Server\"><\/span>12. What is Tableau Data Server?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau server acts a middle man between Tableau users and the data. Tableau Data Server allows you to upload and share data extracts, preserve database connections, as well as reuse calculations and field metadata. This means any changes you make to the data-set, calculated fields, parameters, aliases, or definitions, can be saved and shared with others, allowing for a secure, centrally managed and standardized dataset. Additionally, you can leverage your server\u2019s resources to run queries on extracts without having to first transfer them to your local machine.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"13What_is_Tableau_Data_Engine\"><\/span>13.What is Tableau Data Engine?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau Data Engine is a really cool feature in Tableau. Its an analytical database designed to achieve instant query response, predictive performance, integrate seamlessly into existing data infrastructure and is not limited to load entire data sets into memory<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"14_What_are_the_different_filters_in_Tableau_and_how_are_they_different_from_each_other\"><\/span>14. What are the different filters in Tableau and how are they different from each other?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b><i>Normal Filter<\/i><\/b><span style=\"font-weight: 400;\">\u00a0is used to restrict the data from database based on selected dimension or measure. A Traditional Filter can be created by simply dragging a field onto the \u2018Filters\u2019 shelf.<\/span><\/p>\n<p><b><i>Quick filter<\/i><\/b><span style=\"font-weight: 400;\">\u00a0is used to view the filtering options and filter each worksheet on a dashboard while changing the values dynamically (within the range defined) during the run time.<\/span><\/p>\n<p><b><i>Context Filter<\/i><\/b><span style=\"font-weight: 400;\">\u00a0is used to filter the data that is transferred to each individual worksheet. When a worksheet queries the data source, it creates a temporary,\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"15_How_to_create_a_calculated_field_in_Tableau\"><\/span>15. \u00a0How to create a calculated field in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Click the drop down to the right of Dimensions on the\u00a0Data\u00a0pane and select \u201cCreate &gt; Calculated Field\u201d\u00a0to open the calculation editor.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Name the new field\u00a0and create a formula.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Take a look at the example below:<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"16What_is_a_dual_axis\"><\/span>16.What is a dual axis?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Dual Axis is an excellent phenomenon supported by Tableau that helps users view two scales of two measures in the same graph. Many websites like Indeed.com and other make use of dual axis to show the comparison between two measures and their growth rate in a septic set of years.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"17_What_is_the_difference_between_a_tree_map_and_heat_map\"><\/span>17. What is the difference between a tree map and heat map?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A heat map can be used for comparing categories with color and size. With heat maps, you can compare two different measures together.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A tree map also does the same except it is considered a very powerful visualization as it can be used for illustrating hierarchical data and part-to-whole relationships.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"18What_is_disaggregation_and_aggregation_of_data\"><\/span>18.What is disaggregation and aggregation of data?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The process of viewing numeric values or measures at higher and more summarized levels of the data is called aggregation. When you place a measure on a shelf, Tableau automatically aggregates the data, usually by summing it. You can easily determine the aggregation applied to a field because the function always appears in front of the field\u2019s name when it is placed on a shelf. For example, Sales becomes SUM(Sales).\u00a0 You can aggregate measures using Tableau only for relational data sources. Multidimensional data sources contain aggregated data only. In Tableau, multidimensional data sources are supported only in Windows.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"19What_is_the_difference_between_joining_and_blending_in_Tableau\"><\/span>19.What is the difference between joining and blending in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Joining term is used when you are combining data from the same source, for example, worksheet in an Excel file or tables in Oracle database<\/span><\/p>\n<p><span style=\"font-weight: 400;\">While blending requires two completely defined data sources in your report.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"20_What_are_Extracts_and_Schedules_in_Tableau_server\"><\/span>20. What are Extracts and Schedules in Tableau server?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Data extracts are the first copies or subdivisions of the actual data from original data sources. The workbooks using data extracts instead of those using live DB connections are faster since the extracted data is imported in Tableau Engine.After this extraction of data, users can publish the workbook, which also publishes the extracts in Tableau Server.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"21_How_to_view_underlying_SQL_Queries_in_Tableau\"><\/span>21. How to view underlying SQL Queries in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Create a Performance Recording<\/b><span style=\"font-weight: 400;\">\u00a0to record performance information about the main events you interact with workbook. Users can view the performance metrics in a workbook created by Tableau.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Help -&gt; Settings and Performance -&gt; Start Performance Recording<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Help -&gt; Setting and Performance -&gt; Stop Performance Recording.<\/span><\/p>\n<p><b>Reviewing the Tableau Desktop Logs<\/b><span style=\"font-weight: 400;\">\u00a0located at C:UsersMy DocumentsMy Tableau Repository. For live connection to data source, you can check log.txt and tabprotosrv.txt files. For an extract, check tdeserver.txt file.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"22_How_to_do_Performance_Testing_in_Tableau\"><\/span>22. How to do Performance Testing in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Performance testing is again an important part of implementing tableau. This can be done by loading Testing Tableau Server with TabJolt, which is a \u201cPoint and Run\u201d load generator created to perform QA. While TabJolt is not supported by tableau directly, it has to be installed using other open source products.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"23_Name_the_components_of_a_Dashboard\"><\/span>23.\u00a0 Name the components of a Dashboard.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Horizontal \u2013<\/b><span style=\"font-weight: 400;\">\u00a0Horizontal layout containers allow the designer to group worksheets and dashboard components left to right across your page and edit the height of all elements at once.<\/span><\/p>\n<p><b>Vertical \u2013<\/b><span style=\"font-weight: 400;\">\u00a0Vertical containers allow the user to group worksheets and dashboard components top to bottom down your page and edit the width of all elements at once.<\/span><\/p>\n<p><b>Text \u2013\u00a0<\/b><span style=\"font-weight: 400;\">All textual fields.<\/span><\/p>\n<p><b>Image Extract \u00a0\u2013<\/b><span style=\"font-weight: 400;\">\u00a0A Tableau workbook is in XML format. In order to extracts images, Tableau applies some codes to extract an image which can be stored in XML.<\/span><\/p>\n<p><b>Web [URL ACTION] \u2013<\/b><span style=\"font-weight: 400;\">\u00a0A URL action is a hyperlink that points to a Web page, file, or other web-based resource outside of Tableau. You can use URL actions to link to more information about your data that may be hosted outside of your data source. To make the link relevant to your data, you can substitute field values of a selection into the URL as parameters.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"24How_to_remove_%E2%80%98All_options_from_a_Tableau_auto-filter\"><\/span>24.How to remove \u2018All\u2019 options from a Tableau auto-filter?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The auto-filter provides a feature of removing \u2018All\u2019 options by simply clicking the down arrow in the auto-filter heading. You can scroll down to \u2018Customize\u2019 in the dropdown and then uncheck the \u2018Show \u201cAll\u201d Value\u2019 attribute. It can be activated by checking the field again.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"25How_to_add_Custom_Color_to_Tableau\"><\/span>25.How to add Custom Color to Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Adding a Custom Color refers to a power tool in Tableau. Restart you Tableau desktop once you save .tps file. From the Measures pane, drag the one you want to add color to\u00a0<\/span><b>Color<\/b><span style=\"font-weight: 400;\">. From the color legend menu arrow, select\u00a0<\/span><b>Edit Colors<\/b><span style=\"font-weight: 400;\">. When a dialog box opens, select the palette drop-down list and customize as per requirement.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"26What_is_TDE_file\"><\/span>26.What is TDE file?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Firstly, TDE is a columnar store.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The second is how they are structured which impacts how they are loaded into memory and used by Tableau. This is an important aspect of how TDEs are \u201carchitecture aware\u201d. Architecture-awareness means that TDEs use all parts of your computer memory, from RAM to hard disk, and put each part to work what best fits its characteristics.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"27Mention_whether_you_can_create_relational_joins_in_Tableau_without_creating_a_new_table\"><\/span>27.Mention whether you can create relational joins in Tableau without creating a new table?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Yes, one can create relational joins in tableau without creating a new table.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"28_How_to_automate_reports\"><\/span>28. How to automate reports?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">You need to publish report to tableau server, while publishing you will find one option to schedule reports.You just need to select the time when you want to refresh data.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"29What_is_Assume_referential_integrity\"><\/span>29.What is Assume referential integrity?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">In some cases, you can improve query performance by selecting the option to Assume Referential Integrity from the Data menu. When you use this option, Tableau will include the joined table in the query only if it is specifically referenced by fields in the view.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"30Explain_when_would_you_use_Joins_vs_Blending_in_Tableau\"><\/span>30.Explain when would you use Joins vs. Blending in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">If data resides in a single source, it is always desirable to use Joins.\u00a0 When your data is not in one place blending is the most viable way to create a left join like the connection between your primary and secondary data sources.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"31What_is_default_Data_Blending_Join\"><\/span>31.What is default Data Blending Join?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Data blending is the ability to bring data from multiple data sources into one Tableau view, without the need for any special coding. A default blend is equivalent to a left outer join. However, by switching which data source is primary, or by filtering nulls, it is possible to emulate left, right and inner joins.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"32What_do_you_understand_by_blended_axis\"><\/span>32.What do you understand by blended axis?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In Tableau, measures can share a single axis so that all the marks are shown in a single pane. Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"33What_is_story_in_Tableau\"><\/span>33.What is story in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A story is a sheet that contains a sequence of worksheets or dashboards that work together to convey information. You can create stories to show how facts are connected, provide context, demonstrate how decisions relate to outcomes, or simply make a compelling case. Each individual sheet in a story is called a story point.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"34What_is_the_difference_between_discrete_and_continuous_in_Tableau\"><\/span>34.What is the difference between discrete and continuous in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Discrete data roles are values that are counted as distinct and separate and can only take individual values within a range. Examples: number of threads in a sheet, customer name or row ID or State. Discrete values are shown as blue pills on the shelves and blue icons in the data window.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Continuous data roles are used to measure continuous data and can take on any value within a finite or infinite interval. Examples: unit price, time and profit or order quantity. Continuous variables behave in a similar way in that they can take on any value. Continuous values are shown as green pills.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"35How_to_create_stories_in_Tableau\"><\/span>35.How to create stories in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Click the\u00a0New Story\u00a0tab.In the lower-left corner of the screen, choose a size for your story. Choose from one of the predefined sizes, or set a custom size, in pixels.By default, your story gets its title from its sheet name. To edit it, double-click the title. You can also change your title\u2019s font, color, and alignment. Click\u00a0Apply\u00a0to view your changes.To start building your story, drag a sheet from the Story tab on the left and drop it into the center of the viewClick\u00a0Add a caption\u00a0to summarize the story point.To highlight a key takeaway for your viewers, drag a text object over to the story worksheet and type your comment.To further highlight the main idea of this story point, you can change a filter or sort on a field in the view, then save your changes by clicking\u00a0Update\u00a0above the navigator box.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"36What_is_the_DRIVE_Program_Methodology\"><\/span>36.What is the DRIVE Program Methodology?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau Drive is a methodology for scaling out self-service analytics. Drive is based on best practices from successful enterprise deployments. The methodology relies on iterative, agile methods that are faster and more effective than traditional long-cycle deployment.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A cornerstone of this approach is a new model of partnership between business and IT.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"37How_to_use_group_in_calculated_fieldUsing_groups_in_a_calculation\"><\/span>37.How to use group in calculated field?Using groups in a calculation.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">You cannot reference ad-hoc groups in a calculation.<\/span><b>Blend data using groups created in the secondary data source:<\/b><span style=\"font-weight: 400;\">\u00a0Only calculated groups can be used in data blending if the group was created in the secondary data source.<\/span><b>Use a group in another workbook.<\/b><span style=\"font-weight: 400;\">\u00a0You can easily replicate a group in another workbook by copy and pasting a calculation.<\/span><b>39. Mention what is the difference between published data sources and embedded data sources in Tableau?<\/b><\/p>\n<p><b>Published data source<\/b><span style=\"font-weight: 400;\">: It contains connection information that is independent of any workbook and can be used by multiple workbooks.<\/span><\/p>\n<p><b>Embedded data source<\/b><span style=\"font-weight: 400;\">: It contains connection information and is associated with a workbook.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"38Mention_what_are_different_Tableau_files\"><\/span>38.Mention what are different Tableau files?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Workbooks:<\/b><span style=\"font-weight: 400;\">\u00a0Workbooks hold one or more worksheets and dashboards<\/span><\/p>\n<p><b>Bookmarks<\/b><span style=\"font-weight: 400;\">: It contains a single worksheet and its an easy way to quickly share your work<\/span><\/p>\n<p><b>Packaged Workbooks:<\/b><span style=\"font-weight: 400;\">\u00a0It contains a workbook along with any supporting local file data and background images<\/span><\/p>\n<p><b>Data Extraction Files:<\/b><span style=\"font-weight: 400;\">\u00a0Extract files are a local copy of a subset or entire data source<\/span><\/p>\n<p><b>Data Connection Files:<\/b><span style=\"font-weight: 400;\"> It\u2019s a small XML file with various connection information&#8217;<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"39How_to_embed_views_onto_Webpages\"><\/span>39.How to embed views onto Webpages?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">You can embed interactive Tableau views and dashboards into web pages, blogs, wiki pages, web applications, and intranet portals. Embedded views update as the underlying data changes, or as their workbooks are updated on Tableau Server. Embedded views follow the same licensing and permission restrictions used on Tableau Server. That is, to see a Tableau view that\u2019s embedded in a web page, the person accessing the view must also have an account on Tableau Server.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"40Design_a_view_in_a_map_such_that_if_user_selects_any_state_the_cities_under_that_state_has_to_show_profit_and_sales\"><\/span>40.Design a view in a map such that if user selects any state, the cities under that state has to show profit and sales.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Step 1:<\/b><span style=\"font-weight: 400;\">\u00a0Double click on the state field<\/span><\/p>\n<p><b>Step 2:<\/b><span style=\"font-weight: 400;\">\u00a0Drag the city and drop it into Marks card.<\/span><\/p>\n<p><b>Step 3:<\/b><span style=\"font-weight: 400;\">\u00a0Drag the sales and drop it into size.<\/span><\/p>\n<p><b>Step 4:<\/b><span style=\"font-weight: 400;\">\u00a0Drag profit and drop it into color.<\/span><\/p>\n<p><b>Step 5:<\/b><span style=\"font-weight: 400;\">\u00a0Click on size legend and increase the size.<\/span><\/p>\n<p><b>Step 6:<\/b><span style=\"font-weight: 400;\">\u00a0Right click on state field and select show quick filter.<\/span><\/p>\n<p><b>Step 7:<\/b><span style=\"font-weight: 400;\"> \u00a0Select any state now and check the view.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"41Suppose_my_license_expires_today_will_users_be_able_to_view_dashboards_or_workbooks_which_I_published_in_the_server_earlier\"><\/span>41.Suppose my license expires today, will users be able to view dashboards or workbooks which I published in the server earlier?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">If your server license expires today, your username on the server will have the role \u2018unlicensed\u2019 which means you cannot access but others can. The site admin can change the ownership to another person so that the extracts do not fail.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"42Is_Tableau_software_good_for_strategic_acquisition\"><\/span>42.Is Tableau software good for strategic acquisition?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Yes! For sure. It gives you data insight to the extent that other tools can\u2019t. Moreover, it also helps you to plan and point the anomalies and improvise your process for betterment of your company.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"43Can_we_place_an_excel_file_in_a_shared_location_and_and_use_it_to_develop_a_report_and_refresh_it_in_regular_intervals\"><\/span>43.Can we place an excel file in a shared location and and use it to develop a report and refresh it in regular intervals?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Can we place an excel file in a shared location and and use it to develop a report and refresh it in regular intervals?<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"44Can_Tableau_be_installed_on_MacOS\"><\/span>44.Can Tableau be installed on MacOS?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Yes, Tableau Desktop can be installed on both on Mac and Windows Operating System.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"45What_is_the_maximum_no_of_rows_Tableau_can_utilize_at_one_time\"><\/span>45.What is the maximum no. of rows Tableau can utilize at one time?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">ableau is not restricted by the no. of rows in the table. Customers use Tableau to access petabytes of data because it only retrieves the rows and columns needed to answer your questions.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"46When_publishing_workbooks_on_Tableau_online_sometimes_a_error_about_needing_to_extract_appears_Why_does_it_happen_occasionally\"><\/span>46.When publishing workbooks on Tableau online, sometimes a error about needing to extract appears. Why does it happen occasionally?<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">This happens when a user is trying to publish a workbook that is connected to an internal server or a file stored on a local drive, such as a SQL server that is within a company\u2019s network.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">I hope that this Tableau Interview Questions were helpful to you. I will be coming up withmore blogs on Tableau for you all very soon.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"47What_is_data_visualization_in_Tableau\"><\/span>47.What is data visualization in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Data visualization is a way to represent data that is\u00a0<\/span><b>visually appealing and interactive<\/b><span style=\"font-weight: 400;\">. With advancements in technology, the number of business intelligence tools has increased which helps users understand data, data sets, data points, charts, graphs, and focus on its impact rather than understanding the tool itself.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"48What_is_the_difference_between_various_BI_tools_and_Tableau\"><\/span>48.What is the difference between various BI tools and Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The architecture of Traditional BI tools has hardware limitations. While Tableau does not have any sort of dependencies<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The traditional BI tools work on complex technologies while Tableau uses simple associative search to make it dynamic.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Traditional BI tools do not support multi-thread, in-memory, or multi-core computing while Tableau supports all these features after integrating complex technologies.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Traditional BI tools have a pre-defined data view while Tableau does a predictive analysis for business operations.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"49What_are_different_Tableau_productsTableau_Desktop\"><\/span>49.What are different Tableau products?Tableau Desktop:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Desktop product is used to create optimized queries out from pictures of data. Once the queries are ready, you can perform those queries without the need to code. Tableau desktop encompasses data from various sources into its data engine and creates an interactive dashboard. <b>Tableau Server:<\/b>\u00a0When you have published dashboards using Tableau Desktop, Tableau servers help in sharing them throughout the organization. It is an enterprise-level feature that is installed on a Windows or Linux server.\u00a0<b>Tableau Reader:<\/b>\u00a0Tableau Reader is a free feature available on Desktop that lets you open and views data visualizations. You can filter or drill down the data but restricts editing any formulas or performing any kind of actions on it. It is also used to extract connection files.\u00a0<b>Tableau Online:<\/b>\u00a0Tableau online is also a paid feature but doesn\u2019t need exclusive installation. It comes with the software and is used to share the published dashboards anywhere and everywhere.\u00a0<b>Tableau Public:<\/b> Tableau public is yet another free feature to view your data visualizations by saving them as worksheets or workbooks on Tableau Server.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"50What_is_a_parameter_in_Tableau\"><\/span>50.What is a parameter in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>All:<\/b><span style=\"font-weight: 400;\">\u00a0Simple text field<\/span><\/p>\n<p><b>List:<\/b><span style=\"font-weight: 400;\">\u00a0List of possible values to select from<\/span><\/p>\n<p><b>Range:<\/b><span style=\"font-weight: 400;\">\u00a0Select values from a specified range<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"51Tell_me_something_about_measures_and_dimensions\"><\/span>51.Tell me something about measures and dimensions?<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">In Tableau, when we\u00a0<\/span><b>connect to a new data source<\/b><span style=\"font-weight: 400;\">, each field in the data source is either mapped as\u00a0<\/span><b>measures<\/b><span style=\"font-weight: 400;\">\u00a0or\u00a0<\/span><b>dimensions<\/b><span style=\"font-weight: 400;\">. These fields are the columns defined in the data source. Each field is assigned a dataType (integer, string, etc.) and a role (discrete dimension or continuous measure).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Measures contain numeric values that are analyzed by a dimension table. Measures are stored in a table that allows storage of multiple records and contains foreign keys referring uniquely to the associated dimension tables.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"52What_is_aggregation_and_disaggregation_of_data\"><\/span>52.What is aggregation and disaggregation of data?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>SUM (expression):<\/b><span style=\"font-weight: 400;\">\u00a0Adds up all the values used in the expression. Used only for numeric values.<\/span><\/p>\n<p><b>AVG (expression):<\/b><span style=\"font-weight: 400;\">\u00a0Calculates the average of all the values used in the expression. Used only for numeric values.<\/span><\/p>\n<p><b>Median (expression):<\/b><span style=\"font-weight: 400;\">\u00a0Calculates the median of all the values across all the records used in the expression. Used only for numeric values.<\/span><\/p>\n<p><b>Count (expression):<\/b><span style=\"font-weight: 400;\">\u00a0Returns the number of values in the set of expressions. Excludes null values.<\/span><\/p>\n<p><b>Count (distinct):<\/b><span style=\"font-weight: 400;\">\u00a0Returns the number of unique values in the set of expressions.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"53What_are_continuous_and_discrete_field_types\"><\/span>53.What are continuous and discrete field types?<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau\u2019s specialty lies in displaying data differently either in continuous format or discrete. Both of them are mathematical terms used to define data where continuous means without interruptions and discrete means are individually separate and distinct.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">While the blue color indicates discrete behavior, the green color indicates continuous behavior. On one hand, the discrete view defines the headers and can be easily sorted, while continuous defines the axis in a graph view and cannot be sorted.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"54What_are_the_different_types_of_joins_in_Tableau\"><\/span>54.What are the different types of joins in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Left Outer Join:<\/b><span style=\"font-weight: 400;\">\u00a0Extracts all the records from the left table and the matching rows from the right table.<\/span><\/p>\n<p><b>Right Outer Join:<\/b><span style=\"font-weight: 400;\">\u00a0Extracts all the records from the right table and the matching rows from the left table.<\/span><\/p>\n<p><b>Full Outer Join:<\/b><span style=\"font-weight: 400;\">\u00a0Extracts the records from both the left and right tables. All unmatched rows go with the NULL value.\u00a0<\/span><\/p>\n<p><b>Inner Join:<\/b><span style=\"font-weight: 400;\">\u00a0Extracts the records from both tables.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"55Tell_me_the_different_connections_to_make_with_a_dataset\"><\/span>55.Tell me the different connections to make with a dataset?<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>LIVE:<\/b><span style=\"font-weight: 400;\">\u00a0Live connection is a dynamic way to extract real-time data by directly connecting to the data source. Tableau directly creates queries against the database entries and retrieves the query results in a workbook.<\/span><\/p>\n<p><b>EXTRACT:<\/b><span style=\"font-weight: 400;\"> A snapshot of the data, extract the file (.tde or .hyper file) contains data from a relational database. The data is extracted from a static source of data like an Excel Spreadsheet. You can schedule to refresh the snapshots which are done using the Tableau server. This doesn\u2019t need any connection with the database<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"56What_are_the_supported_file_extensions_in_Tableau\"><\/span>56.What are the supported file extensions in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Tableau Workbook (TWB)<\/b><span style=\"font-weight: 400;\">: contains all worksheets, story points, dashboards, etc.<\/span><\/p>\n<p><b>Tableau Data Source (TDS):<\/b><span style=\"font-weight: 400;\">\u00a0contains connection information and metadata about your data source<\/span><\/p>\n<p><b>Tableau Data Extract (TDE):<\/b><span style=\"font-weight: 400;\">\u00a0contains data that has been extracted from other data sources.<\/span><\/p>\n<p><b>Tableau Packaged Workbook (TWBX):<\/b><span style=\"font-weight: 400;\">\u00a0contains a combination of the workbook, connection data, and metadata, and the data itself in the form of TDE. \u00a0It can be zipped and shared.<\/span><\/p>\n<p><b>Tableau Packaged Data Source (TDSX):<\/b><span style=\"font-weight: 400;\">\u00a0contains a combination of different files.<\/span><\/p>\n<p><b>Tableau Bookmark (TBM):<\/b><span style=\"font-weight: 400;\"> to earmark a specific worksheet<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"57What_are_the_supported_data_types_in_TableauThe_following_data_types_are_supported_in_Tableau\"><\/span>57.What are the supported data types in Tableau?The following data types are supported in Tableau:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">DataType<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Possible Values<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Boolean<\/span><\/td>\n<td><span style=\"font-weight: 400;\">True\/False<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Date<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Date Value (December 28, 2016)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Date &amp; Time<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Date &amp; Timestamp values (December 28, 2016\u00a0<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">06:00:00 PM)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Geographical Values<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Geographical Mapping (Beijing, Mumbai)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Text\/String<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Text\/String<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Number<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Decimal (8.00)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Number<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Whole Number (5)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"58What_are_sets\"><\/span>58.What are sets?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Sets are custom fields created as a subset of the data in your Tableau desktop. Sets can be computed based on conditions or created manually based on the dimensions of the data source.\u00a0<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">For example, A set of customers that earned revenue more than some value. Now, set data may update dynamically based on the conditions applied.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"60What_are_groups_in_Tableau\"><\/span>60.What are groups in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Groups are created to visualize larger memberships using dimensions. Groups can create their own fields to categorize values in that specific dimension.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"61What_are_shelves\"><\/span>61.What are shelves?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau worksheets contain various named elements like columns, rows, marks, filters, pages, etc. which are called shelves. You can place fields on shelves to create visualizations, increase the level of detail, or add context to it<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"62Tell_me_something_about_Data_blending_in_Tableau\"><\/span>62.Tell me something about Data blending in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Data blending is viewing and analyzing data from multiple sources in one place. Primary and secondary are two types of data sources that are involved in data blending<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"63How_do_you_generally_perform_load_testing_in_Tableau\"><\/span>63.How do you generally perform load testing in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Load testing in Tableau is done to understand the server\u2019s capacity with respect to its environment, data, workload, and use. It is preferable to conduct load testing at least 3-4 times in a year because with every new user, upgrade, or content authoring, the usage, data, and workload change.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tabjolt was created by Tableau to conduct point-and-run load and performance testing specifically for Tableau servers. Tabjolt:<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Automates the process of user-specified loads<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Eliminates dependency on script development or script maintenance<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scales linearly with an increase in the load by adding more nodes to the cluster<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"64Why_would_someone_not_use_Tableau\"><\/span>64.Why would someone not use Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The limitations of using Tableau are:<\/span><\/p>\n<p><b>Not cost-effective:<\/b><span style=\"font-weight: 400;\">\u00a0Tableau is not that cost-effective when we compare it well with the other available data visualization tools. In addition to this, it has software upgrades, proper deployment, maintenance, and also training people for using the tool.<\/span><\/p>\n<p><b>Not so secure:<\/b><span style=\"font-weight: 400;\">\u00a0When it comes to data, everyone is extra cautious. Tableau focussed on security issues but fails to provide centralized data-level security. It pushes for row-level security and creates an account for every user which makes it more prone to security glitches.<\/span><\/p>\n<p><b>BI capabilities are not enough:<\/b><span style=\"font-weight: 400;\"> Tableau lacks basic BI capabilities like large-scale reporting, building data tables, or creating static layouts. It has limited result-sharing capabilities, email notification configuration is limited to admins, and the vendor doesn\u2019t support trigger-based notifications.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"65What_is_Tableau_data_engine\"><\/span>65.What is Tableau data engine?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>An analytical database that computes instant query responses, predictive analysis of the server, and integrated data. The data engine is useful when you need to create, refresh, or query extracts. It can be used for cross-database joins as well<\/p>\n<h2><span class=\"ez-toc-section\" id=\"66What_are_the_various_types_of_filters_in_Tableau\"><\/span>66.What are the various types of filters in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">ableau has 6 different types of filters:<\/span><\/p>\n<p><b>Extract Filter:<\/b><span style=\"font-weight: 400;\">\u00a0This filter retrieves a subset of data from the data source.<\/span><\/p>\n<p><b>Dimension Filter:<\/b><span style=\"font-weight: 400;\">\u00a0This filter is for non-aggregated data (discrete).<\/span><\/p>\n<p><b>Data Source Filter:<\/b><span style=\"font-weight: 400;\">\u00a0This filter refrains users from viewing sensitive information and thus reduces data feeds.<\/span><b>\u00a0<\/b><\/p>\n<p><b>Context Filter:<\/b><span style=\"font-weight: 400;\">\u00a0This filter creates datasets by applying presets in Tableau.<\/span><\/p>\n<p><b>Measure Filter:<\/b><span style=\"font-weight: 400;\">\u00a0This filter applies various operations like sum, median, avg, etc.<\/span><\/p>\n<p><b>Table Calculation Filter:<\/b><span style=\"font-weight: 400;\">\u00a0This filter is applied after the view has been created<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"67What_are_extracts_and_schedules_in_Tableau_server\"><\/span>67.What are extracts and schedules in Tableau server?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Data extracts are the subsets of data created from data sources. Schedules are scheduled refreshes made on extracts after publishing the workbook. This keeps the data up-to-date. Schedules are strictly managed by the server administrators<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"68What_are_dual_axes\"><\/span>68.What are dual axes?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Dual axes are used to analyze two different measures at two different scales in the same graph. This lets you compare multiple attributes on one graph with two independent axes layered one above the other.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To add a measure as a dual-axis, drag the field to the right side of the view and drop it when you see a black dashed line appear. You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"69What_is_a_TDE_file\"><\/span>69.What is a TDE file?<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">TDE is Tableau Desktop Extension with extension .tde. TDE file points to a file that contains data from external sources like MS Excel, MS Access, or CSV files. TDE makes it easier to analyze and discover data.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"70What_is_the_story_in_Tableau\"><\/span>70.What is the story in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Click the New Story on the dashboard.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Choose the right size of the story from the bottom-left corner or choose a custom size.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Start building the story by double-clicking the sheet and add it to the story point.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Add a caption to the story by clicking Add a caption.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can update the highlights by clicking Update in the toolbar. You can also add layout options, format a story, or fit the story to your dashboard.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"71What_are_different_Tableau_files\"><\/span>71.What are different Tableau files?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Workbooks:<\/b><span style=\"font-weight: 400;\">\u00a0Workbooks contain one or more worksheets and dashboard elements.<\/span><\/p>\n<p><b>Bookmarks:<\/b><span style=\"font-weight: 400;\">\u00a0Contains a single worksheet that is easier to share.<\/span><\/p>\n<p><b>Packaged Workbooks:<\/b><span style=\"font-weight: 400;\">\u00a0Contains a workbook along with supporting local file data and background images.<\/span><\/p>\n<p><b>Data Extraction Files:<\/b><span style=\"font-weight: 400;\">\u00a0Extract files that contain a subset of data.<\/span><\/p>\n<p><b>Data Connection Files:<\/b><span style=\"font-weight: 400;\"> Small XML file with various connection information<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"72How_do_you_embed_views_into_webpages\"><\/span>72.How do you embed views into webpages?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">You can easily integrate interactive views from your Tableau Server or Tableau online onto webpages, blogs, web applications, or internet portals. But to have a look at the views, the permissions demand the viewer to create an account on the Tableau Server. To embed views, click the Share button on the top of the view and copy the embed code to paste it on the web page.<\/span><span style=\"font-weight: 400;\">You can also customize the embedded code or Tableau Javascript APIs to embed views.<\/span><\/p>\n<p><span style=\"color: #111111; font-family: Roboto, sans-serif; font-size: 27px;\">73.What is the maximum no. of rows Tableau can utilize at one time?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The maximum number of rows or columns is indefinite because even though Tableau contains petabytes of data, it intelligently uses only those rows and columns which you need to extract for your purpose.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"74Mention_what_is_the_difference_between_published_data_sources_and_embedded_data_sources_in_Tableau\"><\/span>74.Mention what is the difference between published data sources and \u00a0 embedded data sources in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Connection information is the details of data that you want to bring into Tableau. Before publishing it, you can create an extract of the same.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Published Data Source: It contains connection information that is independent of any workbook.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Embedded Data Source: It contains connection information which is connected to a workbook<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"75What_is_the_DRIVE_Program_Methodology\"><\/span>75.What is the DRIVE Program Methodology?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">DRIVE program methodology creates a structure around data analytics derived from enterprise deployments. The drive methodology is iterative in nature and includes agile methods that are faster and effective<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"76How_to_use_groups_in_a_calculated_field\"><\/span>76.How to use groups in a calculated field?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Using groups in a calculation. You cannot reference ad-hoc groups in a calculation.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Blend data using groups created in the secondary data source: Only calculated groups can be used in data blending if the group was created in the secondary data source.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Use a group in another workbook. You can easily replicate a group in another workbook by copy and pasting a calculation.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"77Explain_when_would_you_use_Joins_vs_Blending_in_Tableau\"><\/span>77.Explain when would you use Joins vs. Blending in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">While the two terms may sound similar, there is a difference in their meaning and use in Tableau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">While Join is used to combine two or more tables within the same data source.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Blending is used to combine data from multiple data sources such as Oracle, Excel, SQL server, etc.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"78What_is_Assume_referential_integrity\"><\/span>78.What is Assume referential integrity?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">In some cases, you can improve query performance by selecting the option to Assume Referential Integrity from the Data menu. When you use this option, Tableau will include the joined table in the query only if it is specifically referenced by fields in the view.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"79What_is_a_Calculated_Field_and_How_Will_You_Create_One\"><\/span>79.What is a Calculated Field, and How Will You Create One?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Calculated fields are created using formulas based on other fields. These fields do not exist but are created by you<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>You can create these fields to:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Segment data<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Convert the data type of a field, such as converting a string to a date.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Aggregate data<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Filter results<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Calculate ratios<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"80How_Can_You_Display_the_Top_Five_and_Bottom_Five_Sales_in_the_Same_View\"><\/span>80.How Can You Display the Top Five and Bottom Five Sales in the Same View?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Drag \u2018customer name\u2019 to row and sales to the column.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Sort Sum(sales) in descending order.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Create a calculated field \u2018Rank of Sales\u2019.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"81What_is_the_Rank_Function_in_Tableau\"><\/span>81.What is the Rank Function in Tableau?<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Rank: The rank function in Tableau accepts two arguments: aggregated measure and ranking order (optional) with a default value of desc.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Rank_dense: The rank_dense also accepts the two arguments: aggregated measure and ranking order. This assigns the same rank to the same values but doesn\u2019t stop there and keeps incrementing with the other values. For instance, if you have values 10, 20, 20, 30, then ranks will be 1, 2, 2, 3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Rank_modified: The rank_modified assigns the same rank to similar values.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Rank_unique: The rank_unique assigns a unique rank to each and every value. For example, If the values are 10, 20, 20, 30 then the assigned ranks will be 1,2,3,4 respectively<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"82What_is_the_difference_between_Tableau_and_other_similar_tools_like_QlikView_or_IBM_Cognos\"><\/span>82.What is the difference between Tableau and other similar tools like QlikView or IBM Cognos?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau is an intuitive data visualization tool simplifying the story creation by simple drag and drop techniques. On the other hand, BI tools like QlikView or Cognos convert data into metadata to let the users explore data relations. If your presentation runs around presenting data in aesthetic visualizations then opt for Tableau. If not, and might need a full BI platform then go for Cognos\/QlikView<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The ease of use or extracting data details is easier in Tableau than compared to extensive BI tools like Cognos. With Tableau, your team members, be it a guy from sales can easily read the data and give insights. But with Cognos, only members with extensive tool knowledge are appreciated and welcomed.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"83What_is_data_visualization\"><\/span>83.What is data visualization?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Data visualization means the graphical representation of data or information. We can use visual objects like graphs, charts, bars, and a lot more. Data visualization tools provide an accessible way to see and understand the data easily.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"84List_out_Tableau_File_Extensions\"><\/span>84.List out Tableau File Extensions.<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau Workbook (.twb)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tableau Data extract (.tde)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tableau Datasource (.tds)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tableau Packaged Datasource (.tdsx)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tableau Bookmark (.tbm)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tableau Map Source (.tms)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tableau Packaged Workbook (.twbx) \u2013 zip file containing .twb and external files.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tableau Preferences (.tps)<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"85What_is_the_latest_version_of_Tableau_Desktop\"><\/span>85.What is the latest version of Tableau Desktop?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau Desktop&#8217;s latest version is 2021.3(as of, 7thSep 2021).<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"86Define_LOD_Expression\"><\/span>86.Define LOD Expression?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">LOD Expression stands for Level of Detail Expression, and it is used to run complex queries involving many dimensions at the data sourcing level.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"87Define_Heat_Map\"><\/span>87.Define Heat Map?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A heat map is a graphical representation of data that uses the color-coding technique to represent different values of data. As the marks heat up due to their higher value, dark colors will be shown on the map.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"88Define_TreeMap\"><\/span>88.Define TreeMap?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">TreeMap is a visualization that organizes data hierarchically and shows them as a set of nested rectangles. The size and colors of rectangles are respective to the values of the data points they project. Parent rectangles will be tiled with their child elements.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"89What_are_the_different_data_types_in_Tableau\"><\/span>89.What are the different data types in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau supports below data types.Data TypeMeaningExamplesStringCharacter Sequence. Enclosed in &#8221;.Tableau&#8217;, &#8216;World&#8217;Number (Whole)Integers9Number (decimal)Floating values.123.45BooleanThey are logical values.TRUE, FALSEDateDate&#8221;02\/01\/2015&#8243;Date &amp; TimeDate and Time01 January 2019 05:55:00 PMGeographic ValuesGeographical ValuesIndia, Italy, Canada<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"90Give_a_brief_about_the_tableau_dashboard\"><\/span>90.Give a brief about the tableau dashboard?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/mindmajix.com\/tableau\/how-to-build-your-first-advanced-dashboard-in-tableau\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Tableau dashboard<\/span><\/a><span style=\"font-weight: 400;\"> is a group of various views which allows you to compare different types of data simultaneously. Datasheets and dashboards are connected if any modification happens to the data that directly reflects in dashboards. It is the most efficient approach to visualize the data and analyze it.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"91Define_Page_Shelf_in_Tableau\"><\/span>91.Define Page Shelf in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Page shelf breaks the views into a series of pages. It displays an alternate view on each page. Due to this feature, you can analyze the effect of each field on the rest of the data in the view.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"92Define_the_story_in_Tableau\"><\/span>92.Define the story in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The story can be defined as a sheet which is a collection of series of worksheets and dashboards used to convey the insights of data. A story can be used to show the connection between facts and outcomes that impacts the decision-making process. A story can be published on the web or can be presented to the audience.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"93Give_an_overview_of_the_fact_and_dimensions_of_the_table\"><\/span>93.Give an overview of the fact and dimensions of the table?<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Facts are numeric measures of data. They are stored in fact tables. Fact tables store that type of data that will be analyzed by dimension tables. Fact tables have foreign keys associating with dimension tables.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Dimensions are descriptive attributes of data. Those will be stored in the dimensions table. For example, customer\u2019s information like name, number, and email will be stored in the dimension table.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"94State_some_ways_to_improve_the_performance_of_Tableau\"><\/span>94.State some ways to improve the performance of Tableau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Use an Extract to make workbooks run faster<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Reduce the scope of data to decrease the volume of data<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Reduce the number of marks on the view to avoid information overload<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Try to use integers or Booleans in calculations as they are much faster than strings<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Hide unused fields<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Use Context filters<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Reduce filter usage and use some alternative way to achieve the same result<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Use indexing in tables and use the same fields for filtering<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Remove unnecessary calculations and sheets<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"95Explain_different_connection_types_in_Tableau\"><\/span>95.Explain different connection types in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Extract<\/b><span style=\"font-weight: 400;\">: Extract is a snapshot of data that will be extracted from the data source and put into the Tableau repository. This snapshot can be refreshed periodically fully or incrementally. This can be scheduled in\u00a0<\/span><a href=\"https:\/\/mindmajix.com\/tableau-server\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Tableau Server<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><b>Live<\/b><span style=\"font-weight: 400;\">: It creates a direct connection to the data source and data will be fetched directly from tables. So, data will be up to date and consistent. But, this also affects access speed.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"96What_are_the_different_Joins_in_Tableau\"><\/span>96.What are the different Joins in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau works the same as SQL. So, it supports all Joins possible in SQL<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Left Outer Join<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Right Outer Join<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Full Outer Join<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Inner Join<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"97What_is_Data_Modelling\"><\/span>97.What is Data Modelling?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Data modeling is the analysis of data objects that are used in a business or other context and also used as identification of the relationships among these data objects. It is the first step of doing object-oriented programming<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"98Define_blended_axis\"><\/span>98.Define blended axis?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Multiple measures can share in a single axis so that all the marks will be shown in a single pane. We can blend measures by dragging the 1st measure on one axis and the 2nd on the existing axis.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"99Define_shelves_and_sets\"><\/span>99.Define shelves and sets?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Shelves:<\/b><span style=\"font-weight: 400;\">\u00a0Every worksheet in Tableau will have shelves such as columns, rows, marks, filters, pages, and more. By placing filters on shelves we can build our own visualization structure. We can control the marks by including or excluding data.<\/span><\/p>\n<p><b>Sets:<\/b><span style=\"font-weight: 400;\"> The sets are used to compute a condition on which the dataset will be prepared. Data will be grouped together based on a condition. Fields which is responsible for grouping are known assets. For example \u2013 students having grades of more than 70%.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"100Define_Dual-axis\"><\/span>100.Define Dual-axis?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Dual-axis is used to show 2 measures in a single graph. It allows you to compare 2 measures at once. Many websites like indeed use this Dual-axis to show the comparisons and growth rate.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"101Explain_the_limitation_of_context_filters_in_Tableau\"><\/span>101.Explain the limitation of context filters in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Whenever we set a context filter, Tableau generates a temp table that needs to refresh each and every time, whenever the view is triggered. So, if the context filter is changed in the database, it needs to recompute the temp table, so the performance will be decreased.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"102What_is_Mark_Card_in_Tableau\"><\/span>102.What is Mark Card in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">There is a card to the left of the view where we can drag fields and control mark properties like color, size, type, shape, detail, label, and tooltip.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"103Define_published_data_source\"><\/span>103.Define published data source?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">When you are ready to make a data source available to other tableau desktop users. You can publish it to the tableau server or online. Or else you can make it available by saving the same like embedded excel or text file.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"104Define_dual_axis\"><\/span>104.Define dual axis?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Dual-axis is used to show 2 measures in a single graph. It allows you to compare 2 measures at once. Many websites like indeed use this dual-axis to show the comparisons and growth rate.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"105Define_Bullet_graph\"><\/span>105.Define Bullet graph?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A bullet graph is a variant of Bar graph. It is responsible for comparing the performance of one measure with other measures.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"106Define_Gantt_chart\"><\/span>106.Define Gantt chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Gantt Chart displays the progress of value over the period. It consists of bars along with the time axis. It is a project management tool. Here, each bar is a measure of a task in the project framework.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"107Define_a_Histogram_chart\"><\/span>107.Define a Histogram chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A histogram chart shows the distribution of continuous information over a certain period of time. This chart helps us to find extreme points, gaps, unusual values, and more concentrated values.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"108What_are_the_file_size_limitations_with_Tableau\"><\/span>108.What are the file size limitations with Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">In Tableau, there are no limitations with the file sizes. And moreover, there is no row or column limit to import the data.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"109What_is_Tableau_Reader\"><\/span>109.What is Tableau Reader?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Tableau Reader<\/b><span style=\"font-weight: 400;\"> is a free desktop application, where you can read and interact with the Tableau packaged workbooks. It can only open the files but cannot create new connections to the workbook.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"110What_is_the_difference_between_published_data_and_embedded_data_sources\"><\/span>110.What is the difference between published data and embedded data sources?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The published data source contains connection information that is independent of workbooks and can be used by multiple workbooks.<\/span><span style=\"font-weight: 400;\">The embedded data source contains connection information but it is associated with the workbooks<\/span><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"111What_is_the_Hierarchy_in_Tableau\"><\/span>111.What is the Hierarchy in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">When we are working with large volumes of data, incredibly data may be messed. With Tableau, you can easily create hierarchies to keep your data neat. Even if you don\u2019t need it, it is built into your data, which you can easily manage or organize the data and you can track the data easily.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"112What_is_a_Column_chart\"><\/span>112.What is a Column chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A column chat visualizes the data as a set of rectangle columns, as their lengths are proportional to values when they represent the data. The horizontal axis shows the category to which they belong, and the vertical axis shows the values.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"113What_is_the_Bar_Chart_in_Tableau\"><\/span>113.What is the Bar Chart in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The bar chart visualizes the data as a set of rectangle bars, as their values are proportional to lengths when they represent the data. The vertical axis shows the category to which they belong to and the horizontal axis shows the values. So, the bar chart is a vertical version of the Column chart.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"114What_is_the_Line_Chart\"><\/span>114.What is the Line Chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The line chart is a popular type of diagrammatic way for visualizing the data, it connects the individual data points to view the data. We can easily visualize the series of values, we can see trends over time or predict future values. The horizontal axis holds the category to which it belongs and the vertical axis holds the values.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"115What_is_a_Stacked_Bar_chart\"><\/span>115.What is a Stacked Bar chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Stacked Bar Chart, composed of multiple bars stacked horizontally, one below the other. The length of the bar depends on the value in the data point. A stacked bar chart makes the work easier, they will help us to know the changes in all variables presented, side by side. We can watch the changes in their total and forecast future values.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"116What_is_a_Stacked_Column_Chart\"><\/span>116.What is a Stacked Column Chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Stacked Column Chart, composed of multiple bars stacked vertically, one on another. The length of the bar depends on the value in the data point. A stacked column chart is the best one to know the changes in all variables. This type of chart should be checked when the number of series is higher than two.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"117What_is_an_Area_Chart\"><\/span>117.What is an Area Chart?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">An area chart is nothing but line chat, the area between the x-axis and lines will be color or patterns. These charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"118How_to_download_Tableau_Public\"><\/span>118.How to download Tableau Public?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Step 1: Go to\u00a0<a href=\"http:\/\/public.tableau.com\/\" target=\"_blank\" rel=\"noopener\">public.tableau.com<\/a>\u00a0and enter your e-mail address and click \u201c Download the App \u201c.Step 2: After downloading the file, run the file and follow the prompts to install the Tableau.Step 3: Now, you can see the Tableau shortcut on your desktop.Step 4: Double click on the icon, to load tableau public. Now you see the screen as below.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"119What_is_Context_Filter_and_show_the_steps_on_how_to_create_the_Context_Filter_Tableau\"><\/span>119.What is Context Filter and show the steps on how to create the Context Filter Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Context Filters are applied to the data rows before any other filters. They are limited to views, but they can be applied on selected sheets. They define Aggregation and Disaggregation of data in Tableau<\/span><\/p>\n<p><b>Step 1:<\/b><span style=\"font-weight: 400;\">\u00a0Drag the subcategory dimensions to the row shelf and measure sales to the column shelf. Now choose the horizontal bar chart as chart type and again drag the sub-category dimensions to the filter shelf. Then we will get the following chart.<\/span><\/p>\n<p><b>Step 2:<\/b><span style=\"font-weight: 400;\">\u00a0Right-click on the Sub-Category field in the filter shelf and go to the Top fourth tab. Choose the option field, from the next drop-down and choose the option Top 10 by Sales Sum as shown in the following screenshot.<\/span><\/p>\n<p><b>Step 3:<\/b><span style=\"font-weight: 400;\">\u00a0Drag the dimension Category to the filter shelf. Give right-click on the general tab to edit and under that choose Furniture from the list. As you can see the result shows three subcategories of products.<\/span><\/p>\n<p><b>Step 4:<\/b><span style=\"font-weight: 400;\">\u00a0Right-click the Category: Furniture filter and select the option Add to Context. This produces the final result, which shows the subcategory of products from the category Furniture which are among the top 10 subcategories across all the products.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"120What_are_the_products_offered_by_Tableau_Explain_a_few_things_about_them\"><\/span>120.What are the products offered by Tableau? Explain a few things about them.<b><\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tableau has 4 main products.<\/span><\/p>\n<p><b>Tableau Prep:<\/b><span style=\"font-weight: 400;\">\u00a0Tableau Prep is responsible for preparing data for analysis. This tool provides 3 coordinated views which provide us with a complete picture of data.<\/span><\/p>\n<p><b>Tableau Desktop:<\/b><span style=\"font-weight: 400;\">\u00a0Tableau Desktop is the place where the analysis happens. It has powerful drag and drops analytics which is very easy to use. Through the desktop, you get your data insights quickly.<\/span><\/p>\n<p><b>Tableau Online:<\/b><span style=\"font-weight: 400;\">\u00a0Tableau Online is a secure and scalable self-service analytics cloud tool. You can use it anywhere, anytime and it has eliminated the complexities of IT.<\/span><\/p>\n<p><b>Tableau Server:<\/b><span style=\"font-weight: 400;\"> From small to large enterprises, Tableau server is used for fulfilling their BI requirements. This is an on-premise solution. This tool can take data from anywhere and shared it across the organization through the desktop or mobile browsers.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"121Differentiate_parameters_and_filters_in_Tableau\"><\/span>121.Differentiate parameters and filters in Tableau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Filters<\/b><span style=\"font-weight: 400;\">\u00a0are the simpler and straightforward feature in Tableau. It applies to dimensions or measures directly. For example, to only show Gujarat or Karnataka in a State dimension, we can apply the filter on that. In Tableau, there are multiple UI options available for filters like radio buttons, drop-down lists, checkboxes, sliders, and more. Filters on sheets are also available in Tableau.<\/span><\/p>\n<p><b>Parameters<\/b><span style=\"font-weight: 400;\"> are like variables. They are complex and more powerful. Like a variable, a parameter can be used in calculations. So, that means, it only allows a single value. Parameters have the same UI options except for checkboxes because checkboxes don\u2019t have a single value. For example, we can create a parameter for interest rate and period, and then we can use these parameters to calculate interest and principal payments.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"122Explain_how_many_types_of_filters_are_available_in_Tableau\"><\/span>122.Explain how many types of filters are available in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Filters are used to provide the correct information to viewers after removing unnecessary data. There are various types of filters available in Tableau.<b>Extract Filters<\/b>\u00a0\u2013 Extract filters are used to apply filters on extracted data from the data source. For this filter, data is extracted from the data source and placed into the Tableau data repository.<b>Datasource Filters<\/b>\u00a0\u2013 Datasource filters are the same as extract filters. They also work on the extracted dataset. But, the only difference is it works with both live and extract connections.<b>Context Filters<\/b>\u00a0\u2013 Context Filters are applied on the data rows before any other filters. They are limited to views, but they can be applied on selected sheets. They define Aggregation and Disaggregation of data in Tableau<b>Dimension Filters<\/b>\u00a0\u2013 Dimension filters are used to apply filters on dimensions in worksheets. Dimension filters are applied through the top or bottom conditions, formula, and wildcard match.<b>Measure Filters<\/b> \u2013 Measure filters are applied to the values present in the measures.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"123Differentiate_between_Tiled_and_Floating_in_dashboards\"><\/span>123.Differentiate between Tiled and Floating in dashboards?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">In a tiled layout, items don\u2019t overlap. The layout will be adjusted according to dashboard size. In the floating layout, items can be placed on some other layers. Floating items can have fixed positions and sizes.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"124Categorize_dimensions_in_Tableau\"><\/span>124.Categorize dimensions in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Slowly ever-changing dimension<\/b><span style=\"font-weight: 400;\">: The value of the dimension changes over an amount of time for slowly ever-changing dimensions.<\/span><\/p>\n<p><b>Example\u00a0<\/b><i><span style=\"font-weight: 400;\">\u2013\u00a0<\/span><\/i><span style=\"font-weight: 400;\">student of worker<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"125Explain_the_disaggregation_and_aggregation_of_data_in_Tableau\"><\/span>125.Explain the disaggregation and aggregation of data in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Aggregation<\/b><span style=\"font-weight: 400;\">\u00a0\u2192 The process of summarizing the data and viewing a single numeric value is called aggregation. Example \u2013 sum\/avg of salary for each employee<\/span><\/p>\n<p><b>Disaggregation<\/b><span style=\"font-weight: 400;\"> \u2192The process of viewing each transaction for analyzing all the measures both dependently and independently. Example \u2013 individual salary transactions for each employee.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"126State_the_components_of_the_dashboard\"><\/span>126.State the components of the dashboard?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Web:<\/b><span style=\"font-weight: 400;\">\u00a0it consists of a web page embedded in the dashboard.<\/span><\/p>\n<p><b>Horizontal component:<\/b><span style=\"font-weight: 400;\">\u00a0it is a horizontal layout container in which we can add objects.<\/span><\/p>\n<p><b>Vertical component:<\/b><span style=\"font-weight: 400;\">\u00a0it is a vertical layout container in which we can add objects.<\/span><\/p>\n<p><b>Image Extract:<\/b><span style=\"font-weight: 400;\">\u00a0it allows you to upload an image to the dashboard from a computer.<\/span><\/p>\n<p><b>Text:<\/b><span style=\"font-weight: 400;\">\u00a0it is a small Wordpad where we can format and edit the text.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"127Differentiate_discrete_and_continuous_data_roles_in_Tableau\"><\/span>127.Differentiate discrete and continuous data roles in Tableau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Discrete data roles consist of values that are separate and distinct. Discrete data roles can take individual values within a range. For Example \u2013 cancer patients in the hospital, no. of threads in a sheet, state. Discrete values are displayed as blue icons in the data window and blue pills on shelves. Discrete fields can be sorted.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"128What_is_the_difference_between_Traditional_BI_Tools_and_Tableau\"><\/span>128.What is the difference between Traditional BI Tools and Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Traditional BI\u00a0<a href=\"https:\/\/mindmajix.com\/tableau-architecture\" target=\"_blank\" rel=\"noopener\">Tableau BI Architecture<\/a> has hardware limitations. Tableau does not have dependencies. It does not support in-memory, multi-thread, and multi-core computing. It supports memory when using advanced technologies. It has a predefined view of data. It uses predictive analysis for various business operations. We should need a good knowledge of BI and skills. It is easy working and understanding without the knowledge of BI and the skills data security is provided data security is not provided for the public, whereas in the professional version.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"129Define_performance_testing_in_terms_of_Tableau\"><\/span>129.Define performance testing in terms of Tableau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">We can create performance recordings to keep track of performance details of main events while interacting with workbooks. Then, these performance metrics can be viewed by the user and analyzed. Navigation to start\/stop performance recording is Help\u2192Settings and Performance&gt;\u2192 Start Performance Recording Help\u2192 Setting and Performance \u2192 Stop Performance Recording<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Review the logs created by Tableau Desktop. The location for log files is C:UsersMy DocumentsMy Tableau Repository.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For live connection, check the log files log.txt and tabprotosrv.txt.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For Extract connection, check the log file tdeserver.txt<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"130What_is_the_difference_between_twb_and_twbx_extensions\"><\/span>130.What is the difference between .twb and .twbx extensions?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>.twb means Tableau workbook.\u00a0<b>.twb<\/b>\u00a0is an XML sheet, it stores the data about your documents, stories, and dashboards. This file is the reference to the source file such as Excel or tde. This file will be linked to your source file when you save the TWB file. If you want to share your workbook you need to send both the workbook and data source file<\/p>\n<h2><span class=\"ez-toc-section\" id=\"131Why_Tableau\"><\/span>131.Why Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tableau is very simple and user-friendly.<\/p>\n<p>Tableau helps in analyzing the data and using this one can change the raw data into an understandable format.<\/p>\n<p>Users can blend the data with the other data to create their own views on the data and to share it with the customers, and colleagues.<\/p>\n<p>Users can manage a large amount of data.<\/p>\n<p>It can easily integrate with multiple data sources.<\/p>\n<p>Tableau can create complex graphs which simply look like pivot table graphs in Excel.<\/p>\n<p>It gives quick calculations on datasets.<\/p>\n<p>Users can create the visuals easily and switch between the types, to find the model to represent the user messages.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"132How_to_create_a_calculated_field_in_Tableau\"><\/span>132.How to create a calculated field in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Step 1:<\/b>\u00a0Select Analysis -&gt; drop down will open -&gt; Select create calculated field<\/p>\n<p><b>Step 2:<\/b>\u00a0Calculation Editor Box will open, give the name to the calculated field.<\/p>\n<p><b>Step 3:<\/b>\u00a0Enter a formula in the calculation editor.<\/p>\n<p>Example: Sum(Profits)\/Sum(Sales). (Calculation Editor validates the formula)<\/p>\n<p><b>Step 4:<\/b>\u00a0Click, Ok.<\/p>\n<p>Now, the new calculated field added to the data pane.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"133Are_there_any_limitations_of_parameters_in_Tableau_If_yes_give_details\"><\/span>133.Are there any limitations of parameters in Tableau? If yes, give details.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tableau dashboard allows the representation of parameters in four ways only. They don\u2019t allow any multiple values like a filter can do. They only allow a single value.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"134State_some_reasons_for_the_low_performance_of_Tableau_Explain_in_detail\"><\/span>134.State some reasons for the low performance of Tableau? Explain in detail.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Filters<\/b>\u00a0&#8211; filters need to create an extra query and if it used in large numbers and inefficiently then they can reduce the performance. So, it is advised to use filters whenever it is mandatory<\/p>\n<p><b>Live connection<\/b>\u00a0&#8211; Tableau extract works much better in comparison with a live connection.<\/p>\n<p><b>Data sources<\/b>\u00a0&#8211; a wrong query to a wrong data source can reduce performance. Also, the data source\u2019s performance can also affect Tableau\u2019s performance.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"135State_some_ways_to_improve_the_performance_of_Tableau\"><\/span>135.State some ways to improve the performance of Tableau.<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Use an Extract to make workbooks run faster<\/p>\n<p>Reduce the scope of data to decrease the volume of data<\/p>\n<p>Reduce the number of marks on the view to avoid information overload<\/p>\n<p>Try to use integers or Booleans in calculations as they are much faster than strings<\/p>\n<p>Hide unused fields<\/p>\n<p>Use Context filters<\/p>\n<p>Reduce filter usage and use some alternative way to achieve the same result<\/p>\n<p>Use indexing in tables and use the same fields for filtering<\/p>\n<p>Remove unnecessary calculations and sheets<\/p>\n<h2><span class=\"ez-toc-section\" id=\"136Tell_me_different_ways_to_use_parameters_in_Tableau\"><\/span>136.Tell me different ways to use parameters in Tableau<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Filters<br \/>\nCalculated fields<br \/>\nActions<br \/>\nMeasure-swaps<br \/>\nChanging views<br \/>\nAuto-updates<\/p>\n<h2><span class=\"ez-toc-section\" id=\"137Can_we_see_SQL_generated_by_Tableau_Desktop\"><\/span>137.Can we see SQL generated by Tableau Desktop?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tableau Desktop Log files are placed in C: UsersMy DocumentsMy Tableau Repository. In case of live connection to any data source, check the log file \u201clog.txt\u201d and \u201ctabprotosrv.txt\u201d files. In case of extract connection to any data source, check the \u201ctdeserver.txt\u201d file which has detailed information about queries.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"138Can_we_remove_the_All_options_from_a_Tableau_auto-filter\"><\/span>138.Can we remove the All options from a Tableau auto-filter?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Go to the Segment filter, Click on the small drop arrow which is on the right side.<br \/>\nSelect Customize.<br \/>\nThen we can visible a small dropbox under customize, uncheck the option for \u201c All\u201d Value.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"139Which_one_is_better_Extract_or_Live_connection\"><\/span>139.Which one is better? Extract or Live connection?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Extract connection is better than live connection because extract connection can be used from anywhere, anytime without\u00a0<a href=\"https:\/\/mindmajix.com\/connect-data-generated-values-tableau\" target=\"_blank\" rel=\"noopener\">connecting to the database<\/a>. We can construct our own visualizations on it irrespective of the database connection.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"140Tell_me_something_about_the_workbook_version_controlled_in_Tableau\"><\/span>140.Tell me something about the workbook version controlled in Tableau.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Versioning of workbooks can be done in 2 ways in Tableau.<br \/>\nAt the desktop level, you keep copies of your changes and files or using 3rd party system like Microsoft TFS.<br \/>\nAt the server level, where you publish the data source and version will be saved in revision history on Tableau Server or Online. Reverting to a previous version is also possible here.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"141Where_can_we_apply_global_filters\"><\/span>141.Where can we apply global filters?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Global filters can be applied to sheets, stories, and dashboards.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"142How_to_add_custom_color_to_Tableau\"><\/span>142.How to add custom color to Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Generate custom color code and create it in \u201cPreferences.tps\u201d<br \/>\nNavigate to Documents\u2192 My Table Repository\u2192 Preferences.tps<br \/>\nAdd a note for custom color code<\/p>\n<h2><span class=\"ez-toc-section\" id=\"143Can_we_create_cascading_filters_without_using_context_filters\"><\/span>143.Can we create cascading filters without using context filters?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cascading filters means filter2 values are dependent on filter1 values. For Example, filter1 is country and if we select \u201cIndia\u201d for filter1, filter2 values should show all Indian states. This feature we can achieve by using the option \u201c<b>Only Relevant Values<\/b>\u201d.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"144How_can_we_display_the_top_and_bottom_5_of_records_in_a_single_Tableau_view\"><\/span>144.How can we display the top and bottom 5 of records in a single Tableau view?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>View1 which contains the top 5 records<br \/>\nView2 which contains the bottom 5 records<br \/>\nView3 which is a join of View1 and View2<\/p>\n<h2><span class=\"ez-toc-section\" id=\"145State_a_few_charts_which_we_should_not_use_with_valid_reasons\"><\/span>145.State a few charts which we should not use with valid reasons<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>3D Charts:<\/b>\u00a0Visual representation of numbers in 3D charts will be skewed and it makes it difficult to compare and analyze.<\/p>\n<p><b>Pie Charts:<\/b>\u00a0Pie charts are not that much accurate as bar charts. In Pie charts, we have areas and angles to compare instead of length in a bar chart. Areas and angles cannot be analyzed with ease.<\/p>\n<p><b>Donut Charts:<\/b>\u00a0This is the same as Pie chart, but here, we have a hole in the middle to make it look like a donut. Due to that hole, we need to compare arc length with other arcs to analyze the values. Comparing arcs lengths is also a difficult task for our eyes.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"146Do_we_have_any_way_to_handle_null_values_in_Tableau\"><\/span>146.Do we have any way to handle null values in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>Filter Data<\/b>\u00a0\u2013 If you choose this option, null values will be filtered out from the view.<\/p>\n<p><b>Show Data at Default Position<\/b>\u00a0\u2013 It replaces the null value with the default value and shows the data at the default position on-axis. These default values depend on the data type of field. Below here are the defaults of a specific data type.<\/p>\n<p>Numbers \u21920<\/p>\n<p>Dates \u2192 12-31-1899<\/p>\n<p>Geographic Location \u2192 (0,0)<\/p>\n<p>Negative Values \u2192 1<\/p>\n<h2><span class=\"ez-toc-section\" id=\"147Can_we_download_views_or_workbooks_from_the_server_If_yes_in_which_data_formats\"><\/span>147.Can we download views or workbooks from the server? If yes, in which data formats?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We can download views or workbooks from the server. But, data formats available to us depend on the permissions granted by site administrators or content owners.<\/p>\n<p>Image: .png format<\/p>\n<p>Data: .csv file.<\/p>\n<p>We can also download selected sheets into PDF format, but while generating PDF, web page objects won\u2019t be included.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"148Do_we_have_any_data_limitations_in_Tableau_Public\"><\/span>148.Do we have any data limitations in Tableau Public?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, Tableau Public can only allow 10 million rows to users for\u00a0<a href=\"https:\/\/mindmajix.com\/data-science\/data-visualization\" target=\"_blank\" rel=\"noopener\">data visualization<\/a>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"149Can_we_use_unused_columns_Columns_that_are_not_used_in_reports_but_data_source_has_columns_in_Tableau_Filters\"><\/span>149.Can we use unused columns (Columns that are not used in reports but data source has columns) in Tableau Filters?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, we can use unused columns in tableau filters.<\/p>\n<p>Let us consider one example.<\/p>\n<p>In data source, I have column like emp_id, emp_name, emp_sal, emp_dep, emp_designation. But, in reports, I am using emp_name in columns and emp-sal in rows. I can use emp_designation on filters.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"150What_is_the_benefit_of_the_Tableau_extract_file_over_the_live_connection\"><\/span>150.What is the benefit of the Tableau extract file over the live connection?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Extract files can be used without any connections and you can build your own visualization without connecting to the database.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"151How_many_tables_join_are_possible_in_Tableau\"><\/span>151.How many tables join are possible in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We can join 32 tables in Tableau.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"152Can_we_place_an_excel_file_in_a_shared_location_and_use_it_to_develop_a_report_and_refresh_it_in_regular_intervals\"><\/span>152.Can we place an excel file in a shared location and use it to develop a report and refresh it in regular intervals?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, we can place an excel file in a shared location and we can use it to develop a report, but for better performance, we need to extract the file.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"153How_do_we_do_testing_in_Tableau\"><\/span>153.How do we do testing in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, we can do testing in Tableau by using tools and the easiest way is using the desktop application. We need to check it before we publish it on the Tableau server.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"154Design_a_view_in_a_map_such_that_if_a_user_selects_any_state_the_cities_under_that_state_have_to_show_profit_and_sales\"><\/span>154.Design a view in a map such that if a user selects any state the cities under that state have to show profit and sales.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Double click on the state filed.<br \/>\nDrag the city and drop it under the state(Mark Card).<br \/>\nDrag the Sales and drop into the size.<br \/>\nDrag the Profit and drop it into the color.<br \/>\nClick on the size legend and increase the size (75%).<br \/>\nGive a right-click on State filed and select show filter.<br \/>\nSelect the state and check whether you got the required view or not.<br \/>\nIn the View, Size indicates the Sales, and Color indicates the profit of the respective state(which you have selected).<\/p>\n<h2><span class=\"ez-toc-section\" id=\"155How_can_u_set_permissions_or_protect_the_data_in_tableau_public\"><\/span>155.How can u set permissions or protect the data in tableau public?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tableau does not have any security permissions or to protect the data in Tableau public. Whatever we shared in Tableau public those files, workbooks can be viewed by all users. There is no security option in Tableau public.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"156If_I_delete_a_workbook_from_tableau_public_and_there_are_links_to_other_blogs_and_other_web_locations_What_happens_to_them\"><\/span>156.If I delete a workbook from tableau public and there are links to other blogs and other web locations. What happens to them?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tableau public is like a repository, if you delete anything in the Tableau public the data will be lost, even if links are in other locations and blogs. We cannot access those links.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"157Mention_whether_you_can_create_relational_joins_in_Tableau_without_creating_a_new_table\"><\/span>157.Mention whether you can create relational joins in Tableau without creating a new table?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, we can create relational joins in Tableau without creating a new table<\/p>\n<h2><span class=\"ez-toc-section\" id=\"158Can_parameters_have_a_drop-down_list\"><\/span>158.Can parameters have a drop-down list?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, Parameters have their own drop-down list, which enables the users to view the data entries which are available in the parameter during the creation.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"159How_do_you_optimize_the_performance_of_the_dashboard\"><\/span>159.How do you optimize the performance of the dashboard?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Minimize the number of fields.<br \/>\nMinimize the number of records.<br \/>\nReduce the marks (data points) in your view( remove unneeded dimensions).<br \/>\nReduce the number of filters.<br \/>\nUse an include filter.<br \/>\nUse a continuous data filter.<br \/>\nUse action filters and parameters.<br \/>\nReduce the number of nested calculations.<br \/>\nRemove custom SQL.<br \/>\nClean up your workbooks.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"160Can_Tableau_be_installed_on_macOS\"><\/span>160.Can Tableau be installed on macOS?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, Tableau can be installed on both the Windows Operating system and macOS.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"161How_to_automate_reports_in_Tableau\"><\/span>161.How to automate reports in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When we are publishing the reports to Tableau Server, there we will find an option to schedule the report, just select the time when you want to refresh the data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"162Which_databases_give_the_best_performance_when_connected_live\"><\/span>162.Which databases give the best performance when connected live?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Native Database gives the best performance when connected live.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"163What_are_the_challenges_faced_when_working_with_huge_volumes_of_data\"><\/span>163.What are the challenges faced when working with huge volumes of data?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>View running will be slow.<br \/>\nData Extraction.<br \/>\nAlignment issues with data.<br \/>\nTesting Data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"164State_limitation_of_context_filters_in_Tableau\"><\/span>164.State limitation of context filters in Tableau<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Whenever we set a context filter, Tableau generates a temp table that needs to refresh each and every time the view is triggered. So, if the context filter will be changed, the database needs to recompute and rewrite the temp table, which in turn slows down the performance.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"165What_is_a_marks_card_in_Tableau\"><\/span>165.What is a marks card in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There is a card to the left of the view where we can drag fields and control mark properties like color, size, type, shape, detail, label, and tooltip.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"166Define_a_published_data_source\"><\/span>166.Define a published data source<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The published data source has connection information in it. It is independent of any workbook and can be accessed by multiple workbooks.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"167Define_blended_axis\"><\/span>167.Define blended axis<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Multiple measures can share a single axis so that all the marks will be shown in a single pane. We can blend measures by dragging the 1st measure on one axis and the 2nd on the existing axis.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"168Can_we_remove_the_%E2%80%9CAll%E2%80%9D_option_from_the_auto-filter_in_Tableau\"><\/span>168.Can we remove the \u201cAll\u201d option from the auto-filter in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Yes, we can. Navigate to filter\u2192 Right-click on it\u2192 select customize\u2192 uncheck the option \u201cShow All\u201d<\/p>\n<h2><span class=\"ez-toc-section\" id=\"169Define_Bullet_graph\"><\/span>169.Define Bullet graph<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A bullet graph is a variant of a Bar graph. It is responsible for comparing the performance of one measure with other measures.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"170Define_Gantt_chart\"><\/span>170.Define Gantt chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Gantt Chart displays the progress of value over the period. It consists of bars along with the time axis. It is a project management tool. Here, each bar is a measure of a task in the project framework.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"171Define_Histogram_chart\"><\/span>171.Define Histogram chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A histogram chart shows the distribution of continuous information over a certain period of time. This chart helps us to find extreme points, gaps, unusual values, and more concentrated values.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"172What_is_Tableau_Public\"><\/span>172.What is Tableau Public?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tableau Public is an open-source and free service that allows anyone to publish the data source and visualizations to the web. These visualizations can then be embedded into blogs or web pages. They can also be distributed through email or social media.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"173What_Are_the_Data_Types_Supported_in_Tableau\"><\/span>173.What Are the Data Types Supported in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Text (string) values<\/li>\n<li>Date values<\/li>\n<li>Date and time values<\/li>\n<li>Numerical values<\/li>\n<li>Boolean values (relational only)<\/li>\n<li>Geographical values (used with maps)<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"174How_Will_You_Understand_Dimensions_and_Measures\"><\/span>174.How Will You Understand Dimensions and Measures?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table width=\"910\">\n<tbody>\n<tr>\n<td width=\"548\">Dimensions<\/td>\n<td width=\"362\">Measures<\/td>\n<\/tr>\n<tr>\n<td width=\"548\">\u2022Dimensions contain qualitative values (such as names, dates, or geographical data)<\/p>\n<p>\u2022You can use dimensions to categorize, segment, and reveal the details in your data.<\/p>\n<p>\u2022Example: Category, City, Country, Customer ID, Customer Name, Order Date, Order ID<\/td>\n<td width=\"362\">\u2022Measures contain numeric, quantitative values that you can measure (such as Sales, Profit)<\/p>\n<p>\u2022Measures can be aggregated<\/p>\n<p>\u2022Example: Profit, Quantity, Rank, Sales, Sales per Customer, Total Orders<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"175What_is_Meant_by_%E2%80%98discrete_and_%E2%80%98continuous_in_Tableau\"><\/span>175.What is Meant by \u2018discrete\u2019 and \u2018continuous\u2019 in Tableau?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tableau represents data depending on whether the field is discrete (blue) or continuous (green).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Discrete\"><\/span>Discrete<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>&#8211;\u00a0&#8220;individually separate and distinct.&#8221;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Continuous\"><\/span>Continuous<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>&#8211;\u00a0&#8220;forming an unbroken whole without interruption.&#8221;<\/p>\n<p>The values are as shown:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"176What_Are_the_Filters_Name_the_Different_Filters_in_Tableau\"><\/span>176.What Are the Filters? Name the Different Filters in Tableau.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This is one of the most frequently Tableau interview questions. And you must try giving a thorough answer to this one! Tableau filters are a way of restricting the content of the data that may enter a Tableau workbook, dashboard, or view.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"The_Different_Types_of_Tableau_Filters_are\"><\/span>The Different Types of Tableau Filters are:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Extract filters<br \/>\nContext filters<br \/>\nData source filters<br \/>\nFilters on measures<br \/>\nFilters on dimensions<br \/>\nTable calculation filter<\/p>\n<h2><span class=\"ez-toc-section\" id=\"177What_Are_the_Different_Joins_in_Tableau\"><\/span>177.What Are the Different Joins in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Joining is a method for combining related data on a common key. Below is a table that lists the different types of joins:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"178There_Are_Three_Customer_Segments_in_the_Superstore_Dataset_What_Percent_of_the_Total_Profits_Are_Associated_with_the_Corporate_Segment\"><\/span>178.There Are Three Customer Segments in the Superstore Dataset. What Percent of the Total Profits Are Associated with the Corporate Segment?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Follow these steps:<\/p>\n<p>Drag segment field to the rows shelf. Here, segment consists of Consumer, Corporate, and Home Office<\/p>\n<p>Double-click on the profit field under Measures.<\/p>\n<p>Right-click on SUM (Profit) under marks card, select Quick Table Calculation and click on Percent of the total.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"179What_is_the_Difference_Between_Joining_and_Blending\"><\/span>179.What is the Difference Between Joining and Blending?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Combining the data from two or more different sources is data blending, such as Oracle, Excel, and SQL Server. In data blending, each data source contains its own set of dimensions and measures.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"180What_is_the_Difference_Between_a_Live_Connection_and_an_Extract\"><\/span>180.What is the Difference Between a Live Connection and an Extract?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This is another frequently asked Tableau interview question. Tableau Data Extracts are snapshots of data optimized for aggregation and loaded into system memory to be quickly recalled for visualization.<\/p>\n<p>Example: Hospitals that monitor incoming patient data need to make real-time decisions.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"181What_is_a_Calculated_Field_and_How_Will_You_Create_One\"><\/span>181.What is a Calculated Field, and How Will You Create One?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A calculated field is used to create new (modified) fields from existing data in the data source. It can be used to create more robust visualizations and doesn\u2019t affect the original dataset.<br \/>\nFor example, let\u2019s calculate the \u201caverage delay to ship.\u201d<br \/>\nThe data set considered here has information regarding order date and ship date for four different regions. To create a calculated field:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"182How_Can_You_Display_the_Top_Five_and_Bottom_Five_Sales_in_the_Same_View\"><\/span>182.How Can You Display the Top Five and Bottom Five Sales in the Same View?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Drag the Customer Name field to Rows shelf and Profit field to Columns shelf to get the visualization.<\/p>\n<p>Create a set by right-clicking on the Customer Name field. Choose to create an option and click on Set.<\/p>\n<p>Provide the name \u2018Top Customers\u2019 to the set. Configure the set by clicking on Top tab, selecting By field, and filling the values as Top, 5, Profit, and Sum.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"183Is_There_a_Difference_Between_Sets_and_Groups_in_Tableau\"><\/span>183.Is There a Difference Between Sets and Groups in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Continuing with the above example of Sets, select the Bottom Customers set where customer names are arranged based on profit.<br \/>\nGo to the \u2018Groups\u2019 tab and select the top five entries from the list.<br \/>\nRight-click and select create a group option.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"184What_is_a_Parameter_in_Tableau_Give_an_Example\"><\/span>184.What is a Parameter in Tableau? Give an Example.<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Select the drop-down arrow on the top right corner of the Data pane.<br \/>\nClick on Create Parameter and fill in the details:<br \/>\nName &#8211; Number of top\/bottom customers<br \/>\nSelect \u2018Range\u2019 for Allowable Values and fill the fields as:<br \/>\nMinimum &#8211; 5<br \/>\nMaximum &#8211; 20<br \/>\nStep &#8211; 5<\/p>\n<h2><span class=\"ez-toc-section\" id=\"185What_is_the_Difference_Between_Treemaps_and_Heat_Maps\"><\/span>185.What is the Difference Between Treemaps and Heat Maps?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Drag Region field to Columns shelf, and Category and Sub-Category fields in Rows shelf.<br \/>\nUse the ShowMe tool and select the Heat Map.<br \/>\nObserve the hotter and colder regions in the heat map produced:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"186What_is_the_Rank_Function_in_Tableau\"><\/span>186.What is the Rank Function in Tableau?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The ranking is assigning something a position usually within a category and based on a measure. Tableau can rank in several ways like:<br \/>\nrank<br \/>\nrank_dense<br \/>\nrank_modified<br \/>\nrank_unique<\/p>\n<h2><span class=\"ez-toc-section\" id=\"187What_Would_You_Do_If_Some_CountriesProvinces_Any_Geographical_Entity_are_Missing_and_Displaying_a_Null_When_You_Use_Map_View\"><\/span>187.What Would You Do If Some Countries\/Provinces (Any Geographical Entity) are Missing and Displaying a Null When You Use Map View?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Click the indicator and choose from the following options:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Edit_Locations\"><\/span>Edit Locations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>&#8211; correct the locations by mapping your data to known locations<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Filter_Data_%E2%80%93\"><\/span>Filter Data\u00a0&#8211;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>exclude the unknown locations from the view using a filter. The locations will not be included in calculations<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Show_Data_at_Default_Position_%E2%80%93\"><\/span>Show Data at Default Position &#8211;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>show the values at the default position of (0, 0) on the map.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"188What_is_the_Level_of_Detail_LOD_Expression\"><\/span>188.What is the Level of Detail (LOD) Expression?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Here, the scales are shown for a category like Furniture and its sub-categories (Chairs, Tables, etc.). To look at sales for the furniture category as a whole and not its sub-categories, remove the sub-category from the calculation field as shown:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"189How_Do_You_Calculate_the_Daily_Profit_Measures_Using_LOD\"><\/span>189.How Do You Calculate the Daily Profit Measures Using LOD?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>LOD expressions allow us to easily create bins on aggregated data such as profit per day.<\/p>\n<p>Scenario: We want to measure our success by the total profit per business day.<\/p>\n<p>Create a calculated field named LOD &#8211; Profit per day and enter the formula:<\/p>\n<p>FIXED [Order Date] : SUM ([Profit])<\/p>\n<p>Create another calculated field named LOD &#8211; Daily Profit KPI and enter the formula:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"190How_Can_You_Schedule_a_Workbook_in_Tableau_after_Publishing_It\"><\/span>190.How Can You Schedule a Workbook in Tableau after Publishing It?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you\u2019re signed in to Tableau Server, go to Content &gt; data sources or Content &gt; Workbooks, depending on the type of content you want to refresh.<br \/>\nSelect the checkbox for the data source or workbook you want to refresh, and then select Actions &gt; Extract Refresh.<br \/>\nIn the Refresh Extracts dialog, select Schedule a Refresh, and complete the following steps:<br \/>\nSelect the schedule you want.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"191How_Do_You_Handle_Null_and_Other_Special_Values\"><\/span>191.How Do You Handle Null and Other Special Values?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Filter Data<br \/>\nExcludes the null values from the visualization using a filter. In that case, the null values are also excluded from any calculations used in the view.<\/p>\n<p>Show Data at Default Position<br \/>\nShows the data at a default location on the axis.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"192Find_the_Customer_with_the_Lowest_Overall_Profit_What_is_Their_Profit_Ratio\"><\/span>192.Find the Customer with the Lowest Overall Profit. What is Their Profit Ratio?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Create a calculated field named Profit Ratio.<br \/>\nRight-click on Profit Ratio under Measures and select Edit.<br \/>\nEnter the formula: SUM (PROFIT) \/ SUM (SALES)<br \/>\nNext, drag the Profit Ratio to the Label to find out Cindy\u2019s profit ratio<\/p>\n<h2><span class=\"ez-toc-section\" id=\"193How_Can_You_Embed_a_Webpage_in_a_Dashboard\"><\/span>193.How Can You Embed a Webpage in a Dashboard?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Go to dashboard<br \/>\nDouble click the \u2018Webpage\u2019 option available under \u2018Objects.\u2019<br \/>\nEnter the URL (here\u00a0https:\/\/en.m.wikipedia.org\/wiki\/) of the webpage in the dialog box that appears<br \/>\nYou can see the webpage appears on the dashboard.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"194How_Do_You_Make_the_Webpage_Dynamic\"><\/span>194.How Do You Make the Webpage Dynamic?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Go to the dashboard.<br \/>\nDouble click the \u2018Webpage\u2019 option available under \u2018Objects.\u2019<br \/>\nDo not provide a URL in the dialog box that appears and click on Ok.<br \/>\nClick on the Dashboard in the menu and select \u2018Action.\u2019<br \/>\nClick on \u2018Add Action\u2019 and select \u2018Go to URL.\u2019<\/p>\n<h2><span class=\"ez-toc-section\" id=\"195Design_a_View_to_Show_Region_Wise_Profit_and_Sales\"><\/span>195.Design a View to Show Region Wise Profit and Sales.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Drag Profit and Sales field to the Rows shelf<\/p>\n<p>Drag Region field to the Columns shelf<\/p>\n<p>But for such Tableau interview questions, the interviewer may be looking for your mapping capabilities in Tableau. So, you need to follow these steps to show region wise profit and sales in a better way:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"196How_Can_You_Optimize_the_Performance_of_a_Dashboard\"><\/span>196.How Can You Optimize the Performance of a Dashboard?<b><br \/>\n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maximize the number of fields and records. You can exclude unused fields from your visualization or use extract filters.<\/p>\n<p>Limit the number of filters used, by avoiding quick filters and using action and parameter filters instead. These filters reduce query loads.<\/p>\n<p>use Min\/Max instead of Average because average functions require more processing time than Min\/Max<\/p>\n<h2><span class=\"ez-toc-section\" id=\"197Which_Visualization_Will_Be_Used_in_the_given_Scenarios\"><\/span>197.Which Visualization Will Be Used in the given Scenarios?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To show aggregated sales totals across a range of product categories and subcategories<\/p>\n<p>To show the duration of events or activities<\/p>\n<p>To show quarter wise profit growth<\/p>\n<p>&nbsp;<\/p>\n<p>Let get connected for the best <a href=\"https:\/\/gauthamit.com\/contact\/\">trainer for your future<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tableau Interview Questions and Answers 1. What is Tableau? Tableau is a business intelligence software. It allows anyone to connect to the respective data. Visualizes and creates interactive, shareable dashboards. 2. What are Measures and Dimensions? Measures\u00a0are the numeric metrics or measurable quantities of the data, which can be analyzed by dimension table. Measures are [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":267,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,7],"tags":[],"class_list":["post-234","post","type-post","status-publish","format-standard","has-post-thumbnail","category-interview-questions","category-tableau"],"_links":{"self":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/posts\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":0,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/posts\/234\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/media\/267"}],"wp:attachment":[{"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/categories?post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gauthamit.com\/blog\/wp-json\/wp\/v2\/tags?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}