LatentView Analytics Senior Data Analyst Interview Questions and Answers

Q1. Self intro and technical questions
Add your answer

Q1. Its all about statistical analysis
Add your answer

60 minutes 60 questions

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join this company
Add your answer

Q1. Few dax and sql queries
Add your answer

Q1. Salary discussion
Add your answer

Easy question was asked along with some aptitude questions.

Q1. Explain your project and the challenge you faced while doing the project?
Ans. 
Developed a predictive model for customer churn in a telecom company.
• Collected and cleaned customer data including demographics, usage patterns, and customer service interactions.

• Used machine learning algorithms such as logistic regression and random forest to predict customer churn.

• Challenges faced included imbalanced dataset, feature selection, and model evaluation.

• Implemented techniques like SMOTE for handling imbal...read more
Answered by AI
Add your answer
Q2. Basic join questions of SQL were asked
Add your answer

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

Some english communication skills were tested

Round duration - 90 minutes
Round difficulty - Easy

It was in Afternoon and location was at your own place.
The online test was conducted on Hacker Earth on your Laptop
It was a monitored test

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 =...read more
Ans. 
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 '%'.
Answered by AI
Add your answer
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:
...read more
Ans. 
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.
Answered by AI
Add your answer

Round duration - 25 minutes
Round difficulty - Medium

Timing was in Afternoon.
It was held on Microsoft Teams platform
Interviewer was really helpful and made me feel comfortable first

Round duration - 25 minutes
Round difficulty - Easy

It was a HR as well as behavioral round.
It was held at 2 pm
The interviewer was friendly and engaging.

Q1. How much petrol is used in one day in your city?
Ans. 
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.

• ...read more
Answered by AI
Add your answer
Q2. You have 10 coins, and one of them has a greater weight than the others. Using a measuring device, what is the minimum number of comparisons required to identify the heavier coin?
Add your answer
Q3. How would you manage the warehouse of a brand with stores in various cities during times of high demand and low supply, such as during the COVID pandemic?
Ans. 
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 ...read more
Answered by AI
Add your answer

Q1. How you will be handling the projects
Add your answer

Was maths quants etc

Q1. Problem solving on the spot
Add your answer