1) Python code to find out the Domain name in terms of highest total views 2) Maximum number in a list 3) Join two tables in SQL without using OUTER keyword 4) Join two tables city and country to get the population of cities from highest to lowest 5) LIKE function in SQL to find the name of city with certain name 6) Outliers and usage of Scatter plot 7) Mean, median, mode 8) Probability 9) DAX functions in Power BI to find out the Total Sales for different products based on product category 10 DAX function in Power BI to find out the previous year sales
Senior Data Analyst Interview Questions
2,962 senior data analyst interview questions shared by candidates
some sql queries to write
Tell me about a time you came up with a solution to a problem
T-SQL question.
It was mostly around your experience . And the way you did the case study . The team was too junior to even judge you for a senior analyst position. No head of Data or Product involved during any stage .Overall not a positive feeling. They are not sure of what they want . Also They agree to your high salary range go till the end and reject saying found better cheaper candidates .
How do you estimate the minimum sample size for a statistically significant AB test?
Tell us about the datasets you worked previously
There was a technical section that was basic excel and basic insurance calculations.
How would you reconcile data in two different tables/schemas using SQL?
How do you complete a team task?
Viewing 2171 - 2180 interview questions