Had to do some SQL queries regarding a book DB. E.g. what was the most popular author?
Data Analyst Interview Questions
46,291 data analyst interview questions shared by candidates
1. a frog can either jump 1 or 2 steps. there are 100 steps, how many methods are there can this frog jump from step 1 to step 100.
What did you do during your biotech days? (from HM) Completely irrelevant since I pivoted into tech. Plus, the pace of this interview was equivalent to the flow of molasses. I almost dozed off during this step, but made it to the Technical Screen. I'm pretty sure they are using my ideas I gave them for free because my repo keeps getting cloned.
Tell me a time where you introduced a new process?
how remove duplicate in excel
For the last round of interview with the regional COO, they sent an excel file with paid listings data and asked how could the revenue be improved?
Can you use PowerBi or Dinamic Table on Excel?
query using rank in sql
Give us a data architecture for data given via map.
I don't remember anything specifically, but I do remember in one of my case studies that one of the senior data analysts asked me why we split data into a testing and training set. This was in the final superday interview, so brush up on data science terms for this.
Viewing 701 - 710 interview questions
See Interview Questions for Similar Jobs
Data ScientistSas AnalystData SpecialistBusiness AnalystSql AnalystResearch AnalystData ScienceTableau DeveloperReporting AnalystAssociate AnalystDatabase Marketing AnalystApplication AnalystShipping And Receiving SupervisorStatistical AnalystSales AnalystPricing AnalystData ModelerDatabase AnalystOperations Analyst