10+ Tredence Data Analyst Interview Questions and Answers

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 '%'.

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

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

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

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

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

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']

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