Barclays Global Service Centre Senior Business Intelligence Analyst Interview Questions and Answers

Live vs Extract in Tableau and why Extract is faster

• Live connection directly queries the data source while Extract creates a static snapshot of the data

• Extracts are faster because they reduce the amount of data transferred over the network

• Extracts can be scheduled to refresh at specific intervals

• Extracts can be compressed to reduce file size and improve performance

Use a parameter to filter data and create two separate tables, then combine them using a union.

• Create a parameter to select the number of top and bottom rankings to display

• Create a table for the top rankings using the parameter and the RANKX function

• Create a table for the bottom rankings using the parameter and the RANKX function

• Combine the two tables using a union

• Add a column to differentiate between top and bottom rankings

Dashboard Actions are interactive elements that allow users to interact with the data on a dashboard.

• Dashboard Actions are used to filter, highlight, or navigate to other dashboards or web pages.

• Steps to apply Dashboard Actions include selecting the element to apply the action to, choosing the type of action, and configuring the action settings.

• Examples of Dashboard Actions include clicking on a chart to filter the data displayed on other charts, hovering over a data point to...read more

Relationships are used to connect tables in Tableau Prep while Joins are used to combine tables in Tableau Desktop.

• Relationships are used in Tableau Prep to connect tables based on common fields.

• Joins are used in Tableau Desktop to combine tables based on common fields.

• Relationships are used to create a flow of data between tables in Tableau Prep.

• Joins are used to create a single table from multiple tables in Tableau Desktop.

• Relationships are used to reduce data duplication a...read more

Optimize data source, reduce number of rows/columns, use extracts, optimize queries, use filters.

• Optimize data source by removing unnecessary columns and rows

• Reduce number of rows and columns to only necessary data

• Use extracts instead of live connections

• Optimize queries by using custom SQL or aggregating data

• Use filters to limit the amount of data being extracted

Large data extracts in Tableau are handled by optimizing data sources, using filters, and aggregating data.

• Optimize data sources by removing unnecessary columns and filtering data before extracting.

• Use filters to limit the amount of data extracted.

• Aggregate data to reduce the number of rows and columns.

• Consider using Tableau's data engine to improve performance.

• Use incremental extracts to only extract new or updated data.

• Schedule extracts to run during off-peak hours.

• Consider...read more

Yes, it is possible to update data in Tableau Extract.

• Tableau Extracts can be refreshed to update data

• Data can be added, removed or modified in the data source and then refreshed in Tableau

• Extracts can be set to refresh automatically or manually