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 Developer Interview Questions
6,930 business intelligence developer 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
Director Business IntelligenceBusiness Intelligence Reporting AnalystBusiness Objects DeveloperBi DeveloperDatabase DeveloperBusiness Intelligence EngineerSsis DeveloperBusiness Intelligence ConsultantIntelligence AnalystMicrostrategy DeveloperBi AnalystBusiness Intelligence ManagerTableau DeveloperEtl DeveloperSap Master Data Analyst