LatentView Analytics Senior Analyst Interview Questions, Process, and Tips

Query to retrieve the third transaction of every user

• Use a subquery to rank the transactions for each user

• Filter the results to only include the third transaction for each user

Query to output the name of credit card and number of cards issued in launch month

• Use GROUP BY to group by launch month

• Count the number of cards issued in each launch month

• Select the name of the credit card and the count of cards issued

Random forest decides variables based on feature importance and information gain.

• Random forest calculates feature importance by measuring how much the tree nodes that use a particular feature reduce impurity.

• Variables with higher feature importance are considered more important in making predictions.

• Random forest also uses information gain to decide which variables to split on at each node in the trees.

• The variables th...read more

Gini index is a measure of impurity used in decision trees for variable selection.

• Gini index ranges from 0 (pure node) to 0.5 (impure node)

• Variables with lower Gini index are preferred for splitting

• Higher Gini index indicates higher impurity and less predictive power