What are the tools you know.
Bi Engineer Interview Questions
1,657 bi engineer interview questions shared by candidates
My experience creating reports and cleaning data.
There is a table named GEO, having state and city as it's attribute! Write a query to select the states having the same corresponding city?
1. What is the difference between WHERE and HAVING Clause? And when we use where or Having explain with an example? 2. Write a query to find 3rd Maximum salary ? (Easy one) 3. Explain Normalization Types? 4. What is the difference between OLAP and OLTP? 5. Interviewer Provide me a scenario for query writing, I think it was like " Find those employees whos Average salary is greater than 100k department wise" 6. What is the difference between Union and Union ALL? 7. What is the difference between Delete and Truncate statement? 8. Difference between Fact and Dimensions? 9. Different type of Joins? 10. Types of SCD with Example?
Please help to Introduce yourself
How will you bring data in power bi desktop from SQL database
Describe some ways to improve performance on large table
How to delete duplicate rows from table, so that for each row only a one of them will remain
What is Dax and how to use?
I was asked several questions based on the results of the personality test
Viewing 31 - 40 interview questions
See Interview Questions for Similar Jobs
Senior Bi DeveloperMsbi DeveloperSenior Pl Sql DeveloperSap Systems AnalystPl Sql DeveloperInformatica Etl DeveloperSap Business AnalystSenior Oracle Database AdministratorSenior Oracle DeveloperEtl DeveloperSenior Etl DeveloperSql DeveloperSap SupportProgrammer AnalystApplications AnalystTechnical ExpertSenior Bi ConsultantSql Bi Developer