Previous projects and sql. Interviewer was less experienced person who brought incorrect sql tables. Customer table had payment id as primary key instead of customer id lolz.”
Analytics Senior Interview Questions
894 analytics senior interview questions shared by candidates
-Tell me about a time you had to solve for a problem but didn't have enough information - Calculate 3 month moving average using pandas - 3 tables and 3 SQL questions to solve for - joins, window function , aggregation, etc.
What frustrates you about work?
Describe the difference in join types in a SQL environment.
What experience has prepared you well to pursue a role in data analysis?
SQL
Mostly behavioral, why I was interested in the role, and some specific questions about my background
Can you walk me through your past experience and highlight key projects you’ve worked on? How do you usually handle conflicts or disagreements at work? In your current/previous role, how have you leveraged AI or data science to create impact? Why are you interested in this role, and what motivates you to join our company? What are your main reasons for looking to transition from your current job?
They gave one requirement and asked me how I would write SQL query. The requirement had 2 tables. Asked about the difference between rank and row_number function. One more question was to explain a python code and improve the code for edge condition.
Tell us about your background.
Viewing 501 - 510 interview questions
See Interview Questions for Similar Jobs
Manager AnalyticsVp Business IntelligenceAnaliticaAssociate Analytics ManagerText AnalyticsAnalytics ManagerAnalyticsWeb AnalyticsWeb Analytics ManagerAnalíticaProduct AnalyticsMedia AnalyticsMarketing Analytics ManagerBusiness Analytics ManagerHead Of AnalyticsReporting En Intelligence D'affairesData Analytics ManagerVp Bedrijfsinformatie