If you were stuck on a desert island with a database that contained all the knowledge ever created, but you only had 10 SQL statements that you could ever use, what would they be?
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,938 business intelligence analyst interview questions shared by candidates
Tell me about how you influenced the sales processes using competitive intelligence. What lasting differences were you able to incorporate?
Asked about my skills and tested my technical knowledge levels, communication level. programming questions on the languages I preferred!
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
Q3 How many units were sold in each category that cost less than $20, between $20 and $50, and more than $50? Output: category | units_0_20 | units_20_50 | units_50_plus
Q2 What items were ordered yesterday but not ordered today? Output: item_id
SQL query and a Python program with data provided.
4. Find the second highest earner
5. Find customers with 3+ orders in 2014
Viewing 951 - 960 interview questions
See Interview Questions for Similar Jobs
Business Intelligence ConsultantBusiness Intelligence SpecialistIntelligence AnalystBusiness Intelligence Project ManagerBusiness Intelligence DeveloperBusiness AnalystBi AnalystBi DeveloperReporting AnalystBusiness Intelligence EngineerData ScientistBusiness Intelligence ManagerData AnalystMarket Intelligence ManagerBusiness System AnalystBi Consultant