Skip to contentSkip to footer

Bi Manager Interview Questions

Salaries
Interviews

4,384 bi manager 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 2091 - 2100 interview questions

Glassdoor has 4,384 interview questions and reports from Bi manager interviews. Prepare for your interview. Get hired. Love your job.