Monthly Revenue : company_name,month,revenue Write a query to pull the monthly revenue as columns instead of rows.
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
Ranking a table by revenue (Add a Rank Column), without using Rank()
Tell me about a time when you persuade others
salary(department_id,employee_id,salary) List all employees with salary greater than the everage department salary and also greather than $50K
Along with the usuals, he asked "If it's 11:20 on an Analog clock, what is the angle between the two hands?" (note: that includes the slight rotation of the hour hand between the hours). I got it wrong three times, but he didn't care. He said he just had to ask because it was required.
A product has a probability of 60% showing up in warehouse A, and 80% in warehouse B. What is the probability that two products show up at the same warehouse?
DML / DDL definitons and examples, why AWS? Tell me a creative thing you have done in your current job. SQL query - if there are store with store id and Total_sales and order date, he wanted to compare last weeks revenue to this week by store Id(which I assume because he never wrote the question properly and he just told on the fly, we have board where both of us can write but he have could written the question atleast , its hard to understand the question on the phone with his accent)
Write a query to find the top 5 number of orders each vendor had within a time frame
How is variance calculated in a PCA?
None. All questions were relevant to experience and goals.
Viewing 11 - 20 interview questions