Tredence Data Analyst Interview Questions, Process, and Tips

Q1. What is joins and types?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include inner join, left join, right join, and full outer join

• Inner join returns rows when there is at least one match in both tables

• Left join returns all rows from the left table and the matched rows from the right table

• Right join returns all rows from the right table and the matched rows from the left table

• Ful...read more
Answered by AI
Add your answer

Q1. Find the customer_id with maximum number of purchases consecutively?
Ans. 
Customer_id with maximum consecutive purchases
• Identify consecutive purchases for each customer

• Track the maximum consecutive purchases and corresponding customer_id

• Consider edge cases like ties or no consecutive purchases
Answered by AI
Add your answer
Q2. Find the product_id that got returned more than 10 times in a month and more than 3 times in a year?
Ans. 
Identify product_id with more than 10 returns in a month and 3 returns in a year.
• Filter the dataset by returns in a month and returns in a year

• Group the data by product_id and count the number of returns

• Identify product_id with counts exceeding the thresholds
Answered by AI
Add your answer

Pair Sum
1hr 45 mins

Q1. Guesstimate certain situations
Ans. 
Estimate the number of cars passing through a busy intersection in a day
• Estimate the average number of cars passing through the intersection per hour

• Consider peak traffic hours and adjust the estimate accordingly

• Factor in any special events or holidays that may affect traffic flow
Answered by AI
Add your answer
Q2. Puzzle problem with various modification
Add your answer

It consisted verbal, logical , quant, 1 programming question & 1 guesstimate

Some english communication skills were tested

Q1. How to cut a cake in parts with 3 slices
Ans. 
Cut the cake into 3 equal parts using 2 straight cuts
• Make the first cut horizontally through the middle of the cake

• Make the second cut vertically through the middle of the cake, perpendicular to the first cut

• Each slice will be a third of the cake
Answered by AI
Add your answer
Q2. Find unique elements in an array
Ans. 
Use a set to find unique elements in an array of strings
• Create a set from the array to automatically remove duplicates

• Convert the set back to an array to get unique elements

• Example: ['apple', 'banana', 'apple', 'orange'] -> ['apple', 'banana', 'orange']
Answered by AI
Add your answer