Bi Developer Interview Questions

1,369 bi developer interview questions shared by candidates

Write SQL queries to generate the following reports: 1. CustomerID, # of invoices per customer, Did customer purchase product A (boolean), Income from product A per customer 2. CustomerID, Date, Difference between Current Income and Previous Income 3. For each product, which was the second customer who made a purchase 4. Top 10 customers by income, for customers that only purchased in 2016 (and not in other years) 5. Total Income per Customer, for customers who purchased an average of at least 2 products in a month
avatar

Senior BI Developer

Interviewed at Bright Data

3.7
Nov 3, 2023

Write SQL queries to generate the following reports: 1. CustomerID, # of invoices per customer, Did customer purchase product A (boolean), Income from product A per customer 2. CustomerID, Date, Difference between Current Income and Previous Income 3. For each product, which was the second customer who made a purchase 4. Top 10 customers by income, for customers that only purchased in 2016 (and not in other years) 5. Total Income per Customer, for customers who purchased an average of at least 2 products in a month

Viewing 681 - 690 interview questions

Glassdoor has 1,369 interview questions and reports from Bi developer interviews. Prepare for your interview. Get hired. Love your job.