Skip to contentSkip to footer

Business Intelligence Engineer Interview Questions

Salaries
Interviews

1,082 business intelligence engineer interview questions shared by candidates

container_edits: container|units|status |move_time XYZ | 5 |Start |2018-01-01 00:00:15 XYZ | 2 |Add |2018-01-01 00:01:10 XYZ | 3 |Add |2018-01-01 00:02:00 XYZ | |Complete |2018-01-01 00:03:00 XYZ | 5 |Start |2018-01-01 00:04:15 XYZ | 3 |Add |2018-01-01 00:05:10 XYZ | 4 |Add |2018-01-01 00:06:00 XYZ | 5 |Add |2018-01-01 00:07:10 XYZ | 6 |Add |2018-01-01 00:08:00 XYZ | |Complete |2018-01-01 00:09:00 For the above dataset the record should look like loop: container|loop_num|units|start_time |end_time XYZ |1 |10 |2018-01-01 00:00:15|2018-01-01 00:03:00 XYZ |2 |23 |2018-01-01 00:04:15|2018-01-01 00:09:00
avatar

Business Intelligence Developer

Interviewed at Amazon

3.5★
Jul 11, 2020

container_edits: container|units|status |move_time XYZ | 5 |Start |2018-01-01 00:00:15 XYZ | 2 |Add |2018-01-01 00:01:10 XYZ | 3 |Add |2018-01-01 00:02:00 XYZ | |Complete |2018-01-01 00:03:00 XYZ | 5 |Start |2018-01-01 00:04:15 XYZ | 3 |Add |2018-01-01 00:05:10 XYZ | 4 |Add |2018-01-01 00:06:00 XYZ | 5 |Add |2018-01-01 00:07:10 XYZ | 6 |Add |2018-01-01 00:08:00 XYZ | |Complete |2018-01-01 00:09:00 For the above dataset the record should look like loop: container|loop_num|units|start_time |end_time XYZ |1 |10 |2018-01-01 00:00:15|2018-01-01 00:03:00 XYZ |2 |23 |2018-01-01 00:04:15|2018-01-01 00:09:00

2) create daily revenue report between given start_date and end_date output schema: (order_date, number_of_customers, number_of_orders, daily_total_order_amount, mtd_order_amount) mtd_order_amount - total order_amt from the beginning of the month till order_date
avatar

Data Engineer - Business Intelligence

Interviewed at Amazon

3.5★
Apr 6, 2018

2) create daily revenue report between given start_date and end_date output schema: (order_date, number_of_customers, number_of_orders, daily_total_order_amount, mtd_order_amount) mtd_order_amount - total order_amt from the beginning of the month till order_date

Why this position? You have sales data for last 5 years. Predict the monthly sales for 2016. data: order (order_id, order_date, sale_amount) Tell me a time you give insights beyond the data. Design a data model for the tennis match. Answer who are the players that played with each other more than once. And who is the best/worst player? You did an analysis, your client thinks the result is not right. What to do?
avatar

Business Intelligence Engineer

Interviewed at Amazon

3.5★
Jul 2, 2016

Why this position? You have sales data for last 5 years. Predict the monthly sales for 2016. data: order (order_id, order_date, sale_amount) Tell me a time you give insights beyond the data. Design a data model for the tennis match. Answer who are the players that played with each other more than once. And who is the best/worst player? You did an analysis, your client thinks the result is not right. What to do?

Viewing 21 - 30 interview questions

Glassdoor has 1,082 interview questions and reports from Business intelligence engineer interviews. Prepare for your interview. Get hired. Love your job.