[CASE 1] Given a grouping of high spending vs low spending customers, Capital One will give XYZ company a different 1 time, onboarding amount for the new customer (i.e. give XYZ $800 for each high spending customer and $100 for each low spending customer). What percentage of high spending customers would be needed to be worth it?
Associate Data Analyst Interview Questions
396 associate data analyst interview questions shared by candidates
Modeling a job assignment problem
Develop a predictive algorithm to determine how much would new clients spend in a week based on historical data.
If you have a table in DB with column customerID, taskID, how could you get a table of the sum of the task for every customer?
Explain internship project
Technical questions were asked on Excel Formulas (e.g. VLOOKUP, COUNTIF, SUMIF etc) and Pivot Table.
SQL queries, machine learning modeling
How do you handle a lot of tasks and a scattered schedule?
Where do I see myself in the next 5years.
What are my accomplishments in the last years?
Viewing 11 - 20 interview questions