Data Analytics Entry-Level Mock Technical Interview

Here is the list of interview questions extracted from the mock data analytics interview, categorized by topic:

General Background and Project Experience

Can you please introduce yourself?
Why do you only have basic knowledge of SQL and Python despite completing a data analytics course?
Have you prepared any projects during your course?

Data Analytics Concepts and Roles

What is the role of data analytics in a company?
What do you mean by “insight”?
Can you share examples of extracting meaningful insights from a dataset and explain what parameters or circumstances you use?
What meaningful insight did you extract in your project?
What is the difference between data analytics and data science? (The candidate was asked to provide three differences).
What is the role of business analytics compared to data analytics, and how do their day-to-day job responsibilities differ in an organization?
What do you mean by a financial analyst?

SQL Questions

What is the difference between Delete, Truncate, and Drop?
What is the difference between a Primary Key and a Unique Key?
What is a self-join? Can you give an example and write the syntax?
What is the difference between Rank and Dense Rank?
How would you write a query to filter information for employees where the department ID is null?
What is the difference between Union and Union All, and why would we use Union?
What is the difference between Where and Having? Can you give an example?
What is an inner join?
What is a subquery?
What is the query to find the second highest salary from an employee table and retrieve all their information?
What is a View in SQL?
What is the difference between CHAR and VARCHAR?
What is the query to add a new column (like ‘city’) to an existing ’employers’ table?

Python Questions

Data & Power BI Questions

You may have missed