Data Analyst interview (0-3 Years exp.) : SQL, Power BI (40 Questions)
Here are 40 interview questions to prepare for a Data Analyst interview, focusing on SQL and Power BI, tailored for candidates with 0-3 years of experience: SQL Questions What is a primary key? Can a table have multiple primary keys? Explain the difference between INNER JOIN and OUTER JOIN. How would you retrieve the first 10 records from a table? What is the purpose of the GROUP BY clause in SQL? How do you use the HAVING clause in SQL? What are aggregate functions? Give examples. Explain the difference between WHERE and HAVING clauses. How can you remove duplicate records from a table? What is a foreign key in SQL? Describe how to use the CASE statement in SQL. How do you create a new table in SQL? What is the difference between UNION and UNION ALL? How would you find the second highest salary from a table? Explain the concept of indexing in SQL. What are views in SQL? How are they used? Describe the JOIN types available in SQL. What is the difference between DELETE and TRUNCATE comm...