Intelligence Analyst Manager Interview Questions

6,930 intelligence analyst manager interview questions shared by candidates

You have this table - orders (order_id, customer_id, order_datetime, order_amt): 1)select top 10 paying customers for given month 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

Business Intelligence

Interviewed at Amazon

3.5
Apr 6, 2018

You have this table - orders (order_id, customer_id, order_datetime, order_amt): 1)select top 10 paying customers for given month 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

Viewing 961 - 970 interview questions

Glassdoor has 6,930 interview questions and reports from Intelligence analyst manager interviews. Prepare for your interview. Get hired. Love your job.