What is the difference between the mean, median and mode?
Senior Data Analyst Interview Questions
2,891 senior data analyst interview questions shared by candidates
- Business cases - Questions on projects I worked on - Competency-based questions - No technical questions but I was asked if I knew how to use some specific SQL functions and to briefly described their functioning
Pretty Average.
Excel - sumifs, rank, lookup, pivot, slicer, match, index SQL - queries on joins, rank, partition, group, order, having clause etc Data Analytics - Modelling techniques, steps, model validation, types of models etc Power BI - Aggregations, modelling, slicers, sorting, filtering Case study - Expense/Cost optimization General - Past experience, data management, data cleansing, ETL, retail concepts, finance concepts
what is your weakness
1. Bias-Variance tradeoff 2. supervised learning algo 3. Random forest working 4. program to check if given number is power of 3.
Mostly about scenarios
Talk about statistical methods such as regression
Experience with SQL Soft skills ....
1st round - Online test (coding + MCQs on data science) 2nd round - Technical interview. Questions related to your past work and projects. 3rd round - Technical interview. Questions on common ML algorithms, parameters, bias-variance, metrics, quant problems, statistics, probability etc.
Viewing 2841 - 2850 interview questions