Interview Questions

Jiin S. - "I would firstly see what's the trend of the sales by monthly, daily, and yearly to see when was the decline started and what happened during that time. I would also look at the sales by different customer or product segmentation to see what segment had the most decline in sales. Then, I would make some hypothesis where like for this age range customers with this product segment had a decline in sales due to XXX and we would increase the sales by YYY with this new feature. Then I would design the"See full answer

Catherine T. - "We want sales to grow, in order to have a growth in revenue. And customer usage as well as it allows to see if our product lead more engagement from our users. So to be able to see this overall evolution I would make a line chart for both : Sales : with month on x-axis and sales revenue on y-axis Customer Usage : with month on x-axis and a KPI allowing to measure customer usage (nblogins or nbsessions or nbgamesplayed, ... depending on the industry) on y-axis Moreover, after knowing th"See full answer

Ankita G. - "Merge Sort"See full answer

Michael B. - "Problem: Given an input string txt consisting of alphanumeric characters and the parentheses characters '(' & ')', write a function which removes the minimum number of characters to return a version of the string with properly balanced parenthesis. Answer: You can do this with a counter. Psuedo-Python Start with counter = 0 output = [] Iterate through the string, every time you encounter a '(', increment the counter. Add the character to the output. If you encounter a ')', decrement the coun"See full answer

Alvin P. - "SELECT e1.empid AS manageremployee_id, e1.empname AS managername, COUNT(e2.empid) AS numberofdirectreports FROM employees AS e1 INNER JOIN employees AS e2 ON e2.managerid = e1.empid GROUP BY e1.emp_id HAVING COUNT(e2.emp_id) >= 2 ORDER BY numberofdirectreports DESC, managername ASC `"See full answer

Jatin S. - "A project charter is a formal document that authorizes a project and outlines its objectives, scope, stakeholders, and key details. It serves as an agreement among stakeholders and provides a clear foundation for the project by defining what needs to be done and why. Typically, the project sponsor issues the project charter to the project manager or team, formally initiating the project. A project charter typically includes the following key elements to ensure a comprehensive and clear unde"See full answer

RestlessMonk - "Below data was given in a an excel. Data of 6 weeks, at a weekly level of COVID samples collected and tested Age Group, Population size, # tested, # positive, gender My approach: Tried to understand the trend of positivity rate of each group across weeks and cumulative level There is no variation across weeks, and each cohort exhibited similar pattern in all the weeks. So looked at cumulative data of 6 weeks. No clear goal/objective set by the interviewer for vaccine distributio"See full answer

Vikas K. - "During a trip to Japan, I encountered a significant language barrier that influenced how I communicated with others. As I didn't speak Japanese fluently, I had to rely on basic phrases and non-verbal communication to interact with locals. This experience made me realize the importance of understanding cultural diversity. Despite the language barrier, I found that people were patient and understanding. They appreciated my efforts to communicate in their language, even if it was limited. This expe"See full answer

Anonymous Owl - "def flatten_dictionary(dictionary): \# return a flattened dictionary - int/string/another dictionary values \# if the key is empty, exclude from the output \# concat using a "." btwn them \# add to res which is { "key.a.b.etc": "value" } \# iterate through the key value pairs \# while there is a key value pair in the value \# continue going through that, until the value is an int/string flatDic = {} flatDicHelper("", dictionary, flatDic) print(flatDic) return flatDic def flatDicHelper(initialKey"See full answer