i
EXL Service
Filter interviews by
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
Pivot and Recursive CTE are advanced SQL techniques used for data transformation and hierarchical querying.
Pivot is used to convert rows into columns based on a specific column value.
Recursive CTE is used to query hierarchical data, such as organizational structures or bill of materials.
Example of Pivot: SELECT * FROM table_name PIVOT (SUM(value) FOR column_name IN (value1, value2, value3))
Example of Recursive CTE: WIT...
Top trending discussions
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...
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...
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 ...
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
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...
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...
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 ...
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
Interview experience
Senior Executive
4.3k
salaries
| ₹0.9 L/yr - ₹7 L/yr |
Assistant Manager
2.9k
salaries
| ₹4 L/yr - ₹15 L/yr |
Senior Associate
2.5k
salaries
| ₹1.2 L/yr - ₹8 L/yr |
Lead Assistant Manager
1.9k
salaries
| ₹6.4 L/yr - ₹22 L/yr |
Associate
1.7k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
Genpact
WNS
TCS
Infosys