SQL, With window functions. Guesstimates
Associate Data Analist Interview Questions
372 associate data analist interview questions shared by candidates
Which Delaware primary care practice performed the highest volume of Medicare Annual Wellness Visits (SQL assessment, given 3 data sets)?
The case study was quiet complex, the time given was not enough to analyse and come up with solution. So as they are only looking for your approach don't spend much time in analysing the content move on heuristic approach, you can modify your prejudice in later stages as there is no elimination.
How have you used projects you've done (revolving around data) to make business decisions?
You are on a team of 5 members and have a project that is due in two weeks. One of the team members leaves the group and will not return with the project not finished. As group leader, what do you do moving forward?
They primarily focused on technical aspects.
Question were from SQL (Joins, window functions)
A problem related to relative speed.
Describe the credit card default problem you worked on.
Initial Codesignal assessment: 14 MCQs and 1 SQL query question. Mini-case interview: A rideshare company wants to expand into a new canadian city XYZ, how would you assess the feasibility? Then I was given some data to assess if the company is profitable? Do the numbers make sense? You realized that insurance is higher than anticipated, what is the contribution margin now? What is your final conclusion? Technical Fit: They give you a schema (1 - 3 tables) and ask you to write queries for: 1) • Tell us• how much • Cash• payments• (total•$) •we • receive each day? 2) • Identify all customers who have more payments • ($) • in cash • than they have electronically? 3) • Identify all customers who have made • over $10,000• in cash • payments during any two day period.
Viewing 291 - 300 interview questions