Streamhub Senior Consultant Interview Questions and Answers

Key Performance Indicators (KPIs) for Customer Lifetime Income (CLI) and Customer Lifetime Duration (CLD)

• CLI KPIs could include average revenue per customer, customer retention rate, customer lifetime value

• CLD KPIs could include average customer lifespan, customer churn rate, customer engagement metrics

• Tracking CLI and CLD KPIs can help measure the financial impact and longevity of customer relationships

Credit score variables impact strategy by influencing lending decisions and interest rates.

• Credit score variables include payment history, credit utilization, length of credit history, types of credit used, and new credit accounts.

• Higher credit scores typically result in lower interest rates and more favorable lending terms.

• Lenders use credit scores to assess risk and determine the likelihood of repayment.

• Strategies ma...read more

My biggest strengths include strong analytical skills and effective communication. My weaknesses are sometimes being too detail-oriented and struggling with delegation.

• Strengths: strong analytical skills

• Strengths: effective communication

• Weaknesses: being too detail-oriented

• Weaknesses: struggling with delegation

Yes, I have led multiple teams in previous roles.

• Led a team of 5 consultants in a project for a major client

• Managed a team of analysts in developing a new data analytics tool

• Coordinated a team of developers in implementing a software upgrade

Rank assigns unique ranks to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.

• Rank function is used to assign a unique rank to each distinct row based on the specified column(s).

• Dense rank function is used to assign consecutive ranks to rows with the same values, without any gaps.

• For example, if we have scores of 90, 85, 85, 80, then rank would assign ranks as 1, 2, 2, 4 while