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

1. What is a primary key? Can a table have multiple primary keys?
2. Explain the difference between INNER JOIN and OUTER JOIN.
3. How would you retrieve the first 10 records from a table?
4. What is the purpose of the GROUP BY clause in SQL?
5. How do you use the HAVING clause in SQL?
6. What are aggregate functions? Give examples.
7. Explain the difference between WHERE and HAVING clauses.
8. How can you remove duplicate records from a table?
9. What is a foreign key in SQL?
10. Describe how to use the CASE statement in SQL.
11. How do you create a new table in SQL?
12. What is the difference between UNION and UNION ALL?
13. How would you find the second highest salary from a table?
14. Explain the concept of indexing in SQL.
15. What are views in SQL? How are they used?
16. Describe the JOIN types available in SQL.
17. What is the difference between DELETE and TRUNCATE commands?
18. How can you optimize a slow-running query?
19. Explain the difference between COUNT(*), COUNT(column), and COUNT(DISTINCT column).
20. How do you handle NULL values in SQL?

Power BI Questions

1. What is Power BI?
2. Describe the different components of Power BI.
3. How do you connect Power BI to a data source?
4. What are the different types of visualizations available in Power BI?
5. Explain the concept of DAX in Power BI.
6. How do you create a calculated column in Power BI?
7. What is the difference between a calculated column and a measure in Power BI?
8. How do you use slicers in Power BI reports?
9. What is the Power Query Editor in Power BI?
10. Explain how you can create relationships between tables in Power BI.
11. How would you handle data refresh in Power BI?
12. What are some best practices for designing a Power BI dashboard?
13. How do you implement row-level security in Power BI?
14. What is the use of the "Publish to Web" feature in Power BI?
15. Explain how you can integrate Power BI with other Microsoft services.
16. How do you create a report in Power BI using multiple data sources?
17. What are some common performance optimization techniques in Power BI?
18. How would you share a Power BI report with others?
19. Describe the use of bookmarks in Power BI.
20. What is the role of Power BI Service, and how does it differ from Power BI Desktop?