Tell me a time when you deep dive into a problem
Business Intelligence Engineer Interview Questions
1,083 business intelligence engineer interview questions shared by candidates
SQL: Window Functions, Joins, Theoretical Knowledge Python: basic scripting (for, while, if-else) + functions declaration + basic data structures knowledge Pandas: basic operations Behavioural: "Tell me a time when...." type questions.
SQL theoretical questions (joins, union, window functions) and SQL live code exercises.
SQL questions include joining multiple tables.
Which type of graph do you think it would be suitable to use for this dataset?
Talk about a time when you had to deliver something in a tight deadline, how did you manage? What are the challenges you faced and what sacrifices you had to make?
Table 1: FDCM Snapshot_day Report_day dim_ad_id Revenue Impressions clicks marketplace_id source ID Product_type (Freevee, Fire TV etc..,) Product roll_up (STV, OLV etc.,) Table 2: Twitch_bundled_ads Dim_ad_id snapshot_day 1. Write a query to show day over day(DOD) shift in revenue and impressions by marketplace
2. Write a query to identify Bundle vs non-bundle for Twitch and revenue associated with bundle and non-bundle YTD for US marketplace (Hint - Twitch source ID 650 and 651)
Did you ever work in a team? Any conflict?
basic screening about previous experience in data field
Viewing 691 - 700 interview questions