EXL Service Consultant II Interview Questions and Answers

Filters are used to limit the data displayed in a visualization. There are different types of filters in Tableau.

• Types of filters include: dimension filters, measure filters, context filters, table calculation filters, and extract filters.

• Dimension filters limit the data based on specific dimensions, such as date or region.

• Measure filters limit the data based on specific measures, such as sales or profit.

• Context filter...read more

Tableau supports various data types including string, integer, float, date, boolean, and geographic data.

• String: text data

• Integer: whole numbers

• Float: decimal numbers

• Date: date and time data

• Boolean: true/false data

• Geographic: latitude and longitude data

• Examples: 'John Smith' (string), 25 (integer), 3.14 (float), 01/01/2021 (date), true (boolean), (latitude, longitude) (geographic)

In Tableau, discrete and continuous are two types of data that can be used to categorize and analyze information.

• Discrete data consists of distinct, separate values that cannot be measured or divided further.

• Examples of discrete data in Tableau include categories like product names, customer segments, or regions.

• Continuous data represents measurements or values that can be divided infinitely and can take on any value w...read more

Tableau is more user-friendly and has better visualization capabilities than QlikView.

• Tableau has a more intuitive drag-and-drop interface

• Tableau has a wider range of visualization options

• Tableau has better integration with other data sources

• QlikView has better data modeling capabilities

• QlikView has better performance with large datasets

The latest version of Tableau is 2021.3.

• 2021.3 was released on September 14, 2021.

• New features include improved data modeling capabilities and enhanced analytics.

• Previous versions include 2021.2, 2021.1, and 2020.4.

Data visualization is the graphical representation of data to help understand patterns, trends, and insights.

• Data visualization uses charts, graphs, and maps to present data visually.

• It helps in identifying patterns, correlations, and outliers in data.

• Examples include bar charts, line graphs, scatter plots, and heat maps.

Aggregation is the process of combining data into a summary form, while disaggregation is the opposite, breaking down summary data into its individual components.

• Aggregation involves grouping data and performing calculations on the grouped data.

• Disaggregation involves breaking down summary data to reveal the individual data points.

• Aggregation is useful for analyzing trends and patterns at a higher level.

• Disaggregation ...read more

Context filters can slow down performance and limit interactivity.

• Context filters create a temporary table that affects the performance of the workbook.

• Using multiple context filters can further degrade performance.

• Context filters limit the interactivity of other filters and actions.

• Context filters may not work well with certain data sources or complex calculations.

• Removing or modifying context filters requires re-comp