Deloitte Data Analyst Interview Questions

Deloitte Recent Interview Insights for a Data Analyst Position(0-3 Years)

1. Tell us about yourself and your current job responsibilities.

2. Can you share some challenges you encountered in your recent project involving Power BI dashboards, and how did you resolve them?

3. What distinguishes a KPI (Key Performance Indicator) from a dimension?

4. Write a SQL query to find the third highest salary from an employee table with the following columns: EID, ESalary.

5. Create a SQL procedure using ESalary as a parameter that selects all EIDs from the Employee table where ESalary is less than 50,000.

6. For the Employee table (with columns EID and ESalary), retrieve all EIDs with odd salaries and join this with another table, empdetails (with columns EID and EDOB), to obtain EDOB.

7. How would you use the LEAD or LAG function in SQL to compare week-over-week data?

8. Can you explain how you would create a DAX measure in Power BI to calculate the year-over-year growth for a specific metric?

9. Identify a unique chart type in Power BI that differs from standard charts and explain its purpose.

10. Describe how you would implement a time intelligence feature in Power BI to analyze sales trends over different time periods.