10+ 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

Excel formulas are used for calculations and data analysis.

• SUM: adds up a range of cells

• AVERAGE: calculates the average of a range of cells

• IF: returns one value if a condition is true and another value if it's false

• VLOOKUP: searches for a value in a table and returns a corresponding value from another column

• COUNT: counts the number of cells in a range that contain numbers

• MAX: returns the highest value in a range of cells

• MIN: returns the lowest value in a range of cells

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

Real-time case studies for Sr. Business Intelligence Analyst

• Scenario 1: Analyzing customer behavior and sales data to identify trends and make data-driven recommendations for marketing strategies.

• Scenario 2: Monitoring and analyzing website traffic and user engagement metrics to optimize website performance and user experience.

• Scenario 3: Utilizing predictive analytics to forecast demand and optimize inventory management for a retail company.

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

Sets are a collection of unique values while groups are a collection of related values.

• Sets contain only unique values while groups can have repeated values.

• Sets are used for filtering data while groups are used for aggregating data.

• Sets are used in Tableau for creating custom fields while groups are used for creating hierarchies.

• Example of a set: a set of customers who have made a purchase in the last month.

• Example of a group: grouping sales data by region or product categor...read more