TradeIndia (Infocom Network Private Limited) Senior Business Associate Interview Questions and Answers

Round duration - 45 minutes
Round difficulty - Easy

Technical round with questions on DBMS, SQL , Tableu etc.

Q1. What is the difference between a dimension and a measure in Tableau?
Ans. 
Dimensions are categorical fields used for grouping and filtering data, while measures are numerical fields used for calculations and aggregation.
• Dimensions are qualitative data like names, dates, or categories.

• Measures are quantitative data like sales, profit, or quantity.

• Dimensions are used for slicing and dicing data, while measures are used for calculations and aggregations.

• Example: In a sales dataset, 'Product Cat...read more
Answered by AI
Add your answer
Q2. What are parameters in Tableau?
Ans. 
Parameters in Tableau are dynamic values that can replace constant values in calculations, filters, and reference lines.
• Parameters allow users to change the value of a calculation without modifying the calculation itself.

• They can be used in filters to allow users to dynamically control which data is displayed.

• Parameters can also be used in reference lines to dynamically set thresholds or targets.

• For example, a paramete...read more
Answered by AI
Add your answer
Q3. What is a subquery in SQL?
Ans. 
A subquery in SQL is a query nested within another query, used to return a subset of data from a larger dataset.
• A subquery is enclosed within parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

• It can be used to filter results based on a condition, retrieve data from multiple tables, or perform calculations.

• Example: SELECT * FROM table1 WHERE column1 IN (SELECT column2 FROM table2 WHERE conditio
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

HR round with typical behavioral problems.