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
Bi Developer Interview Questions
1,369 bi developer interview questions shared by candidates
Sdlc related questions.
How would you rate your sql skills? Which methodology you use? SQL code
Basics of SQL Joins Query Optimization Very specific questions on their data and their database
SQL questions -Joins,sub queries, etl and business.
How did you test your code/logic?
Questions from your resume. Your past projects and work experience.
Why do you want to leave your current job?
Basic questions related to Power BI and data base
Depende de quien te entrevisté
Viewing 681 - 690 interview questions
See Interview Questions for Similar Jobs
Ssis DeveloperBi AnalystSql DeveloperSql Server DeveloperBusiness Intelligence EngineerBi ManagerBusiness Intelligence DeveloperSiebel DeveloperMicrostrategy DeveloperBusiness Intelligence AnalystEtl DeveloperBi ConsultantBi Project ManagerSenior Sharepoint DeveloperBusiness Objects DeveloperEdi Developer