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?
Junior Bi Analyst Interview Questions
2,669 junior bi analyst interview questions shared by candidates
[Especialista] (Depois de eu contar a minha rotina no estágio que estava trabalhando na época) Você chegou a automatizar os processos da área?
[Especialista] Vi que você possui alguma experiência na área de BI, conte-me mais sobre o que você fez/faz nelas.
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?
"Você já se inscreveu na vaga?" "Qual seu nome completo?" "Você consegue acessar e responder esse questionário online?"
Please help to Introduce yourself
Asked to complete a presentation based on fictional data.
- what did you do in the last internship?
No hard questions. When do you want to start your new project?
How will you bring data in power bi desktop from SQL database
Viewing 81 - 90 interview questions
See Interview Questions for Similar Jobs
Junior Bi DeveloperSenior Bi AnalystJunior Bi-analytikerPower Bi DeveloperSas AnalystBusiness Data AnalystPl Sql Developer JúniorMsbi DeveloperBusiness Intellignece AnalystJunior Etl DeveloperOperations Data AnalystSenior Bi DeveloperJunior Data AnalystSql Bi DeveloperBusiness Intelligence AnalystJunior Sql DeveloperBusiness Intelligence Reporting AnalystBusiness Intelligence Engineer