Skip to contentSkip to footer

Analyste Bi Interview Questions

Salaries
Interviews

4,381 analyste bi interview questions shared by candidates

Q.Tell me about yourself? Two SQL Questions: Shipment Table (table name - “shipments”): It contains information at a shipment level, with data such as number of items in package, package type, warehouse, country, and the customer ID. Primary key - shipment_id shipment_date shipment_id package_type warehouse_id customer_id num_items country 2020-01-01 112344 BOX WAR1 YYTGBCSDFG 1 US 2020-01-04 927612192 PADDED MAILER WAR2 HIGDSGKJAF 1 UK 2020-04-03 812618726 POLYBAG WAR9 HJFGJLFFHJK 3 IN 2020-06-01 921629712 BOX WAR13 TEEWRJGHKJKG 2 UK 2020-12-05 4982472376 OWN_BOX WAR1 KHGHJFDKLJHFF 10 US Returns table (table name - "returns"): contains information on returns by Amazon customers. Primary key – return_id return_id return_date customer_id 716219621 2017-09-26 ASKGASKAJSA 918261982 2017-03-30 UKHJDLKGSDG 984673876 2017-12-16 UPFASFJSHDV 836453323 2018-09-24 AWETUYOIUBV Q1.Find the number of customers who have had a shipment and made a return during the last 30 days? Q2.Which package type has the highest % of shipments in US in 2020?
avatar

BI Engineer

Interviewed at Amazon

3.5★
Jun 19, 2021

Q.Tell me about yourself? Two SQL Questions: Shipment Table (table name - “shipments”): It contains information at a shipment level, with data such as number of items in package, package type, warehouse, country, and the customer ID. Primary key - shipment_id shipment_date shipment_id package_type warehouse_id customer_id num_items country 2020-01-01 112344 BOX WAR1 YYTGBCSDFG 1 US 2020-01-04 927612192 PADDED MAILER WAR2 HIGDSGKJAF 1 UK 2020-04-03 812618726 POLYBAG WAR9 HJFGJLFFHJK 3 IN 2020-06-01 921629712 BOX WAR13 TEEWRJGHKJKG 2 UK 2020-12-05 4982472376 OWN_BOX WAR1 KHGHJFDKLJHFF 10 US Returns table (table name - "returns"): contains information on returns by Amazon customers. Primary key – return_id return_id return_date customer_id 716219621 2017-09-26 ASKGASKAJSA 918261982 2017-03-30 UKHJDLKGSDG 984673876 2017-12-16 UPFASFJSHDV 836453323 2018-09-24 AWETUYOIUBV Q1.Find the number of customers who have had a shipment and made a return during the last 30 days? Q2.Which package type has the highest % of shipments in US in 2020?

Viewing 2851 - 2860 interview questions

Glassdoor has 4,381 interview questions and reports from Analyste bi interviews. Prepare for your interview. Get hired. Love your job.