
Tredence


10+ Tredence Data Analyst Interview Questions and Answers
Q1. Find First Repeated Character in a String
Given a string 'STR' composed of lowercase English letters, identify the character that repeats first in terms of its initial occurrence.
Example:
Input:
STR = "abccba"...read more
Find the first repeated character in a given string composed of lowercase English letters.
Iterate through the string and keep track of characters seen so far in a set.
Return the first character that is already in the set.
If no repeated character is found, return '%'.
Q2. Pair Sum Problem Statement
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Note:
Each pa...read more
Find pairs of elements in an array that sum up to a given value, sorted in a specific order.
Iterate through the array and use a hash set to store elements seen so far.
For each element, check if the complement (S - current element) is in the set.
If found, add the pair to the result list and continue.
Sort the result list based on the criteria mentioned in the problem statement.
The amount of petrol used in a city in one day varies depending on factors like population, transportation infrastructure, and fuel prices.
Petrol usage depends on the number of vehicles in the city.
Public transportation options can impact petrol consumption.
Economic factors such as fuel prices and income levels play a role in petrol usage.
Industrial activities and power generation also contribute to petrol consumption.
Environmental policies and initiatives can influence petro...read more
The minimum number of comparisons required to identify the heavier coin is 3.
Divide the 10 coins into 3 groups of 3, 3, and 4 coins.
Compare the first two groups of 3 coins each. If one group is heavier, move to the next step with that group.
Compare the 3 coins in the heavier group individually to find the heaviest coin.
Implement inventory management strategies like demand forecasting, safety stock, and efficient logistics.
Utilize demand forecasting techniques to predict future demand based on historical data and market trends.
Maintain safety stock levels to buffer against fluctuations in supply and demand.
Implement efficient logistics and supply chain management to ensure timely delivery of products to stores.
Utilize technology such as inventory management software to track inventory levels...read more
Q6. what do you know about tredence youtube recommendation system - explain how it recommend videos ,factors it consider to do so mainly from resume & hobby as usual hr question
Tredence YouTube recommendation system uses algorithms to suggest videos based on user preferences and behavior.
Tredence YouTube recommendation system uses machine learning algorithms to analyze user data such as watch history, likes, and dislikes.
It considers factors like video content, user demographics, and engagement metrics to recommend relevant videos.
For example, if a user frequently watches cooking videos, the system may suggest more cooking-related content.
Tredence's...read more
Q7. Find the product_id that got returned more than 10 times in a month and more than 3 times in a year?
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
Q8. Find the customer_id with maximum number of purchases consecutively?
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
Q9. How to cut a cake in parts with 3 slices
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
Q10. Find unique elements in an array
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']
Q11. What is joins and types?
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
Full outer join returns all rows when there is a match in eit...read more
Q12. Guesstimate certain situations
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
Interview Process at Tredence Data Analyst

Top Data Analyst Interview Questions from Similar Companies








Reviews
Interviews
Salaries
Users/Month

