Retrieve only last 7 days data from table.
Senior Data Analyst Interview Questions
2,892 senior data analyst interview questions shared by candidates
General competency based, experiences working on various projects, technical and a few specific questions related to the data.
give an example of your work with big data
What would you have done differently on a project which didn't go perfectly?
What is the difference between the mean, median and mode?
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
Build a BI dashboard to help a film producer choose a director for a new movie.
Tell me more about yourself Questions related to the task
How would you handle potentially under-performing predictive models?
SQL test exercise, statistics and data visualization examples
Viewing 2801 - 2810 interview questions