why wayfair
Business Intelligence Analyst Interviews
Business Intelligence Analyst Interview Questions
"Business intelligence analysts use their analysis of market trends and internal data to recommend where a business can improve profits and reduce expenses. Prepare for your interview by brushing up on your financial math and SQL skills, as well as your knowledge of the company's competitive space. A few years of experience and a degree in business, finance, or computer science is required for this position."
6,923 business intelligence analyst interview questions shared by candidates
Why wayfair?
Removing duplicates from table without using Distinct
Are you emotionally unstable? How often do you feel anxious? How often do you feel depressed? How highly do you think of yourself? Does your mood change often? Do you worry often? Do you feel sad or blue often? How would you compare yourself to others?... You'll just keep looping through multiple variations on diagnostic questions. There are no workplace scenarios or attitudes/values questions.
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
How woud you visualize week-over-week revenue?
3 SQL questions, 1 python problem, and behavioral questions.
Basic Statistics, Medium/Advanced SQL & Behavioral Questions
Signed NDA document
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 51 - 60 interview questions