I've only been moved forward until the second interview, in which there are four aspects. 1. SQL & Python live coding: Apart from basic functions, be prepared for advance functions like how to extract month from a date, how to calculate rolling average. Know how to define a function, and how to incorporate the defined function in another function. Know how to define outliers. 2. Statistics and experimentation: There are two graphs of the experimentation results. Explain what the two distributions mean and interpret the results with concepts like p value and confidence interval. 3. Plot interpretation: There are four types of plot, box and whisker plot, line plot, histogram, etc. Be aware of each plot's name and identify the issues in the visualization and provide suggestions on how to improve the visualization. 4. Regression analysis: There is a linear regression about the relationship between the tip and the order amount. Interpret the regression function and visualization, like intercept, correlation coefficient, r squared, etc.
Check out your Company Bowl for anonymous work chats.