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 Interviews
Business Intelligence Developer Interview Questions
"Business intelligence developers are responsible for developing and maintaining the business data systems of a company. They must be well versed in SQL and other query tools, as well have have strong business analysis to work in tandem with the company's business data. During an interview, be prepared to be tested on these skills by both technical questions and case studies on how you would fix particular problems for a company."
6,932 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 Objects DeveloperBusiness Intelligence Reporting AnalystDatabase DeveloperBi DeveloperMicrostrategy DeveloperBusiness Intelligence ManagerIntelligence AnalystBusiness Intelligence EngineerBi AnalystSsis DeveloperBusiness Intelligence ConsultantEtl DeveloperSap Master Data AnalystTableau Developer