Tableu

What is the Difference Between Treemaps and Heat Maps?

A Heat map is used to compare categories using color and size. In this, we can distinguish two measures. A heat map is not only defined by color, but you can also use its size. A Treemap is used to represent hierarchical data. The space in the view is divided into rectangles that are sized and ordered by a measure.

Is There a Difference Between Sets and Groups in Tableau?

A Tableau group is one dimensional, used to create a higher level category by using lower-level category members. Tableau sets can have conditions and can be grouped across multiple dimensions/measures.

What is the Level of Detail (LOD) Expression?

A level of detail expression is used to run complex queries involving many dimensions at the data source level instead of bringing all the data to Tableau interface.

What is a union join?

Another method for combining two or more tables by appending rows of data from one table to another

How Do You Make the Webpage Dynamic?

Begin by bringing Map by Sales into view. It shows the state's name and its sales. Go to the dashboard. Double click the 'Webpage' option available under 'Objects.' Do not provide a URL in the dialog box that appears and click on Ok. Click on the Dashboard in the menu and select 'Action.' Click on 'Add Action' and select 'Go to URL.' Enter 'https://en.wikipedia.org/wiki/' under the URL option. Click on the arrow adjacent to it and select 'State.' Click on 'Select option' and hit 'Ok.' Now, when you click on any state like California, it brings up the California Wikipedia page. This is how to make it dynamic.

What Do You Understand the Blended Axis?

Blended Axis is used to blend two measures that share an axis when they have the same scale.

What is the Difference Between Joining and Blending?

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. Combining the data between two or more tables or sheets within the same data source is data joining. All the combined tables or sheets contain a common set of dimensions and measures.

How Will You Understand Dimensions?

Dimensions contain qualitative values (such as names, dates, or geographical data) You can use dimensions to categorize, segment, and reveal the details in your data. Example: Category, City, Country, Customer ID, Customer Name, Order Date, Order ID

What is the Use of Dual-axis? How Do You Create One?

Dual Axis allows you to compare measures, and this is useful when you want to compare two measures that have different scales. Considering the same example used in the above question, first create a visualization with sales over time and profit over time. To create a dual-axis, right-click on the second pill of the measures and select Dual Axis. Observe that sales and profit do not share the same axis, and profit is much higher towards the end. The difference between a blended axis and a dual-axis chart is that the blended axis uses the same scale, while a dual-axis could have two different scales and two marks cards.

The Different Types of Tableau Filters are:

Extract filters Context filters Data source filters Filters on measures Filters on dimensions Table calculation filter

How Can You Embed a Webpage in a Dashboard?

Follow these simple steps to embed a webpage in a dashboard: Go to dashboard Double click the 'Webpage' option available under 'Objects.' Enter the URL (here https://en.wikipedia.org/wiki/) of the webpage in the dialog box that appears You can see the webpage appears on the dashboard.

30. Design a View to Show Region Wise Profit and Sales.

Follow these simple steps to show region wise profit and sales: Drag Profit and Sales field to the Rows shelf Drag Region field to the Columns shelf But for such 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: Double click on the State field to get its view Go to Marks card and change the mark type from Automatic to Map. Bring Region field to Color on the Marks card Drag Profit, Sales, and State fields to Label on the Marks card

How Do You Handle Null and Other Special Values?

If the field contains null values or if there are zeros or negative values on a logarithmic axis, Tableau cannot plot them. Tableau displays an indicator in the lower right corner of the view, and you can click the indicator and choose from the following options: Filter Data Excludes 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. Show Data at Default PositionShows the data at a default location on the axis.

What are the different Joins in Tableau?

Inner Left Right Outer Union

What Will the Following Function Return? Left(3, "Tableau") Choose the correct answer: Tab Eau Error None of the above

It will return an error because the correct syntax is: left(string, num_chars). So, it should be: Left("Tableau," 3) Left returns a specific number of characters from the start of the given string. If the correct syntax is followed, the result would be 'Tab.'

How Will You Understand Measures?

Measures contain numeric, quantitative values that you can measure (such as Sales, Profit) Measures can be aggregated Example: Profit, Quantity, Rank, Sales, Sales per Customer, Total Orders

What is an outer join?

Resultant table contains all values from both tables

What is a left join?

Resultant table contains all values from the left table and corresponding matches from the right table

What is the Difference Between a Live Connection and an Extract?

Tableau Data Extracts are snapshots of data optimized for aggregation and loaded into system memory to be quickly recalled for visualization. Example: Hospitals that monitor incoming patient data need to make real-time decisions. Live connections offer the convenience of real-time updates, with any changes in the data source reflected in Tableau. Example: Hospitals need to monitor the patient's weekly or monthly trends that require data extracts.

What Are the Filters?

Tableau filters are a way of restricting the content of the data that may enter a Tableau workbook, dashboard, or view.

What is Meant by 'discrete' and 'continuous' in Tableau?

Tableau represents data depending on whether the field is discrete (blue) or continuous (green). Discrete - "individually separate and distinct." Continuous - "forming an unbroken whole without interruption."

Explain the Difference Between Tableau Worksheet, Dashboard, Story, and Workbook?

Tableau uses a workbook and sheet file structure, much like Microsoft Excel. A workbook contains sheets, which can be a worksheet, dashboard, or a story. A worksheet contains a single view along with shelves, legends, and the Data pane. A dashboard is a collection of views from multiple worksheets. A story contains a sequence of worksheets or dashboards that work together to convey information.

1. What Are the Data Types Supported in Tableau?

Text (string) values Date values Date and time values Numerical values Boolean values (relational only) Geographical values (used with maps)

What Are the Different Types of Tableau?

The different types of Tableau are Desktop, Prep, Online, and Server.

What is the Rank Function in Tableau?

The ranking is assigning something a position usually within a category and based on a measure. Tableau can rank in several ways like: rank rank_dense rank_modified rank_unique

How Can You Optimize the Performance of a Dashboard?

There are multiple ways to optimize the performance of the dashboard like: Maximize the number of fields and records. You can exclude unused fields from your visualization or use extract filters. Limit the number of filters used, by avoiding quick filters and using action and parameter filters instead. These filters reduce query loads. use Min/Max instead of Average because average functions require more processing time than Min/Max Use boolean or numerical calculations more than string calculations. Computers can process integers and boolean much faster than strings. Boolean > int > float > date-time > string

How Can You Display the Top Five and Bottom Five Sales in the Same View?

We can display it using the In/Out functionality of sets. Follow these steps: Drag the Customer Name field to Rows shelf and Profit field to Columns shelf to get the visualization. Create a set by right-clicking on the Customer Name field. Choose to create an option and click on Set. Provide the name 'Top Customers' to the set. Configure the set by clicking on Top tab, selecting By field, and filling the values as Top, 5, Profit, and Sum. Similarly, create a second set called 'Bottom Customers' and fill the By Field values as Bottom, 5, Profit, and Sum. Select these two sets and right-click on it. Use the option Create Combined Set. Name it 'Top and Bottom Customers' and include all members of both sets. Pull the Top and Bottom Customers onto Filters.

Which Visualization Will Be Used in the given Scenarios? To show aggregated sales totals across a range of product categories and subcategories To show the duration of events or activities To show quarter wise profit growth

We would use the following visualizations for the given scenarios: Treemap Gantt chart Waterfall chart

What is the Difference Between .twbx And .twb?

he .twbx contains all of the necessary information to build the visualization along with the data source. This is called a packaged workbook, and it compresses the package of files altogether. The .twb contains instructions about how to interact with the data source. When it's building a visualization, Tableau will look at the data source and then build the visualization with an extract. It can't be shared alone as it contains only instructions, and the data source needs to be attached separately.

What is a right join?

resultant table contains all values from the right table and corresponding matches from the left table

What is an inner join?

resultant table contains values that have matches in both tables

What is a Calculated Field, and how will you create one?

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't affect the original dataset. For example, let's calculate the "average delay to ship." The data set considered here has information regarding order date and ship date for four different regions. To create a calculated field: Go to Analysis and select Create Calculated Field. A calculation editor pops up on the screen. Provide a name to the calculated field: Shipping Delay. Enter the formula: DATEDIFF ('day', [Order Date], [Ship Date]) Click on Ok. Bring Shipping Delay to the view. Repeat steps 1 to 5 to create a new calculated field 'Average Shipping Delay' using the formula: AVG (DATEDIFF ('day,' [Order Date], [Ship Date])) Drag Region field to Rows shelf and SUM(Average Shipping Delay) to the marks card; the average delay for each region gets displayed.

What is a Parameter in Tableau?

A parameter is a dynamic value that a customer could select, and you can use it to replace constant values in calculations, filters, and reference lines. For example, when creating a filter to show the top 10 products based on total profit instead of the fixed value, you can update the filter to show the top 10, 20, or 30 products using a parameter. Continuing with the same example of top-five and bottom five customers, follow these steps: Select the drop-down arrow on the top right corner of the Data pane. Click on Create Parameter and fill in the details: Name - Number of top/bottom customers Select 'Range' for Allowable Values and fill the fields as: Minimum - 5 Maximum - 20 Step - 5 Edit the set 'Top Customers' by changing the 'By Field' value of 5 with 'Select number of top/bottom customers.' Do the same changes in the 'Bottom Customers' set. Go to the created parameter on the Data pane, right-click on it and select 'Show Parameter Control.' Now, if you increase the step within the range, the data appears as per the parameter value set.

How Do You Calculate the Daily Profit Measures Using LOD?

LOD expressions allow us to easily create bins on aggregated data such as profit per day. Scenario: We want to measure our success by the total profit per business day. Create a calculated field named LOD - Profit per day and enter the formula: FIXED [Order Date] : SUM ([Profit]) Create another calculated field named LOD - Daily Profit KPI and enter the formula: IF [LOD - Profit per day] > 2000 then "Highly Profitable." ELSEIF [LOD - Profit per day] <= 0 then "Unprofitable" ELSE "Profitable" END To calculate daily profit measure using LOD, follow these steps to draw the visualization: Bring YEAR(Order Date) and MONTH(Order Date) to the Columns shelf Drag Order Id field to Rows shelf. Right-click on it, select Measure and click on Count(Distinct) Drag LOD - Daily Profit KPI to the Rows shelf Bring LOD - Daily Profit KPI to marks card and change mark type from automatic to area.

What Would You Do If Some Countries/Provinces (Any Geographical Entity) are Missing and Displaying a Null When You Use Map View?

When working with maps and geographical fields, unknown or ambiguous locations are identified by the indicator in the lower right corner of the view. Click the indicator and choose from the following options: Edit Locations - correct the locations by mapping your data to known locations Filter Data - exclude the unknown locations from the view using a filter. The locations will not be included in calculations Show Data at Default Position - show the values at the default position of (0, 0) on the map.

How Can You Schedule a Workbook in Tableau after Publishing It?

When you're signed in to Tableau Server, go to Content > data sources or Content > Workbooks, depending on the type of content you want to refresh. Select the checkbox for the data source or workbook you want to refresh, and then select Actions > Extract Refresh. In the Refresh Extracts dialog, select Schedule a Refresh, and complete the following steps: Select the schedule you want. If available, specify whether you want a full or incremental refresh.