Perficient Data Analyst Interview Questions and Answers

Provided sales case study, asked to analyse the same ans provide insights

Q1. Introduce yourself
Add your answer

Simple topics like present situations

Some basic mathematics and sql and python basic questions

Q1. Some sql functions,group by , window functions, some query based on lag and lead functions
Add your answer

Q1. Basic questions about SQL, for ex, what are the various types of joins, what are the various window functions, difference between rank and dense rank, difference between union and union all
View 2 more answers

Q1. Introduction, followed by SQL questions, like what is the order of execution in SQL, and how do various joins work
Add your answer

Q1. Basic SQL questions, including the ones in the last round, also some query writing, with easy to medium difficulty
Add your answer

Q1. Elaborate and in-depth discussion about your past experiences, followed by SQL questions, including the ones in the past rounds, and also writing a few queries based on the problem statement
Add your answer
Q2. This round was taken by the Indium's client company, by your prospective manager there.
Add your answer

Q1. In this they'll decide on the offer to make.
Add your answer

Q1. Briefing about my last job
Add your answer

Q1. On python data manipulation(easy)
Add your answer
Q2. Sql(intermediate)
Add your answer

Q1. Sql question and also some data engineer level questions
Add your answer

Q1. Explain about joins, window functions, puzzles.
Add your answer