Difference between clustered and non clustered index?
Bi Developer Interview Questions
1,371 bi developer interview questions shared by candidates
Was asked about previous experience and projects on resume. What was the most challenging part of those projects.
None
Asked about my work experience in data science, ETL and BI domain What new technologies I can implement in this project Different cloud technologies I know and follow up questions.
Tell me about a time when you delved deeply into a problem to uncover insights. What did you discover?
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
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
How did you test your code/logic?
Viewing 671 - 680 interview questions
See Interview Questions for Similar Jobs
Business Intelligence DeveloperSql DeveloperBi AnalystBi ManagerBusiness Intelligence EngineerSql Server DeveloperSsis DeveloperSiebel DeveloperMicrostrategy DeveloperBusiness Intelligence AnalystEtl DeveloperBi ConsultantSenior Sharepoint DeveloperBi Project ManagerBusiness Objects DeveloperEdi Developer