Business Intelligence Engineer Interview Questions
Practice the exact questions companies are asking right now.
Identify Top-Buying Customers Daily with SQL Query
PRIME +-------------+------------+----------+ | Customer_ID | Start_Date | End_Date | +-------------+------------+----------+ | 1 | 2025-01-...
Identify Top-Buying Customers Daily with SQL Query
PRIME +-------------+------------+----------+ | Customer_ID | Start_Date | End_Date | +-------------+------------+----------+ | 1 | 2025-01-...
Count Customers Buying Both 'Kindle' and 'Alexa'
ITEMS +---------+-----------+ | ITEM_ID | ITEM_NAME | +---------+-----------+ | 101 | Kindle | | 202 | Alexa | | 303 | Fire TV | ...
Create Monthly Revenue Report for Each Department
DEPARTMENT_REVENUE +------------+---------+-------+ | Department | Revenue | Month | +------------+---------+-------+ | A | 8000 | Jan |...
Analyze Top Book Sales and Unique Customer Purchases
BOOK_TRANSACTION +---------------+------------+-------------+------+----------+ | MARKETPLACE_ID| TXN_DAY | CUSTOMER_ID | ASIN | QUANTITY | +------...
Illustrate SQL Join Results with Duplicate Keys
TABLE1 +------+ | col1 | +------+ | 1 | | 1 | | 1 | +------+ TABLE2 +------+ | col1 | +------+ | 1 | | 1 | | 1 | | 1 | | 1 |...
Calculate Rolling 7-Day Sum of Answers by Device
ANSWERS +------------+--------+---------+ | date | device | answers | +------------+--------+---------+ | 2019-01-01 | echo | 10 | | 2019...
Identify Employees with Invalid Department References
EMPLOYEE +-----+-----+--------+ | eid | did | ename | +-----+-----+--------+ | 1 | 10 | Alice | | 2 | 11 | Bob | | 3 | 99 | Carol | +--...
Compute First Order Proportions by Day and Category
ORDERS +----------+------------+----------+-------------+ | order_id | date | category | customer_id | +----------+------------+----------+-----...
Identify Most Popular First-Watched Movie in Viewing History
MOVIE_VIEWS +------------+--------------------+------------+ | customer_id| title | date | +------------+--------------------+-----...
Identify Customers Purchasing Every Product in Catalog
X_PURCHASES +-------------+---------+ | customer_id | pro_key | +-------------+---------+ | 1 | A | | 1 | B | | 2 ...
Analyze Seller Compliance and Customer Purchase Patterns
SELLER_STATUS +-----------+------------+-----------+ | seller_id | date | status | +-----------+------------+-----------+ | 1 |2019-0...
Find Top Three Books by City in Recent Months
BOOK_SALES +------+--------+------------+------------+ | city | asin | sale_date | units_sold | +------+--------+------------+------------+ | NYC ...
Identify Unique Unordered City Pairs in Flight Log
FLIGHTS +----------------+---------------+ | departure_city | arrival_city | +----------------+---------------+ | NYC | LAX | | ...
Calculate Weekly Event Sums from Daily Counts
EVENT_LOG +------------+------+ | event_date | cnt | +------------+------+ | 2025-05-01 | 17 | | 2025-05-02 | 12 | | 2025-05-08 | 30 | +-------...
Identify Frequent Actor-Director Collaborations in Film Database
FILMOGRAPHY +-------+---------+------------+ | actor | dir | date | +-------+---------+------------+ | Tom | Nolan | 2020-01-01 | | Tom ...