After passing the home test there are several more interviews, a majority of them are about assessing your personality and understanding your professional past.
Bi Engineer Interview Questions
4,381 bi engineer interview questions shared by candidates
Basic to Medium Power BI related questions
It consists of 2 technical rounds and 1 managerial round Details about connectivity modes Composite modes Direct query Performance Tuning
Can you explain the difference between data warehouse, data lake, data mart?
They asked about how I would approach improving data quality across multiple teams, particularly when ownership of data sits outside the data function. They were interested in how I handle resistance and build alignment.
10 Questions about PowerBI, star schema, DAX, RLS, ...
Qs based on data warehousing, rdbms, sql performance tuning
Advanced SQL questions.
Stage 1: deductive, inductive, and numerical reasoning test Subsequent stages: Tell us something about yourself that's not written in your CV, what would you enjoy/not enjoy working with a clone of yourself, tell us what market we could venture into based on some given data, give a guesstimate of how many mattresses were sold in Germany in January 2022 etc. In general I think the interviewers try to see your thinking process, and they were really understanding.
What is SCD? Star/snowflake schema.
Viewing 3631 - 3640 interview questions