PharmEasy Junior Data Analyst Interview Questions and Answers

Q1. Tell me About yourself
Add your answer
Q2. Excel formula sum if countif
Ans. 
Using Excel formula SUMIF and COUNTIF to calculate a sum based on a condition.
• SUMIF function adds the values in a range that meet a specified condition.

• COUNTIF function counts the number of cells in a range that meet a specified condition.

• Combine both functions to calculate the sum based on a condition.
Answered by AI
Add your answer

SQL query optimisation

Q1. Regular discussion, about job role, why swiggy
Add your answer

Number sires, clock, logic, arithmetic, geometry

Code test basic, ans the basic knowledge, write code

Q1. What is python?
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.

• It emphasizes code readability and uses indentation to define code blocks.

• Python has a large standard library and a vibrant community of developers.

• Example: print('Hello, World!')

• Example: import pandas as pd
Answered by AI
View 1 more answer
Q2. What is python used for?
Ans. 
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
• Data analysis and visualization

• Web development (Django, Flask)

• Artificial intelligence and machine learning (TensorFlow, PyTorch)

• Automation and scripting

• Scientific computing (NumPy, SciPy)
Answered by AI
View 1 more answer
Q3. What type of language is python?
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is an interpreted language, meaning it does not need to be compiled before running.

• It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.

• Python has a large standard library and a thriving community, making it versatile and widely used.

• Example: Python is used for web develop...read more
Answered by AI
Add your answer
Q4. What is oops in python?
Ans. 
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
• OOP allows for the organization of code into reusable components called classes.

• Classes can have attributes (variables) and methods (functions) associated with them.

• In Python, everything is an object, and classes can be defined using the 'class' keyword.

• Encapsulation, inheritance, and polymorph
Answered by AI
Add your answer
Q5. What is array in python?
Ans. 
An array in Python is a data structure that stores a collection of elements of the same type.
• Arrays can store elements such as integers, floats, or strings.

• Arrays are indexed starting from 0, with elements accessed using their index.

• Example: arr = ['apple', 'banana', 'cherry']
Answered by AI
Add your answer

SQL and Tableau were asked. 4 questions each.

Case study was asked related to covid

8 SQl questions of easy, medium and hard diffiulty

Q1. SQL Question on join
Add your answer
Q2. SQL question on window funtions
Add your answer

SQL case study - tough questions

Q1. Culter fit and Hr round
Add your answer

Q1. Questions on SQL joins, window functions etc.
Add your answer

Q1. SQL Theory - joins, order of execution, window functions
Add your answer
Q2. Hands-on SQL - handling corner cases, solving practical problems
Add your answer
Q3. Python/Excel (if on resume). Important functions and packages e.g. (VLOOKUP, pandas, etc.)
Add your answer
Q4. Data visualization - basic understanding of storytelling with data, when to use what visualization
Add your answer
Q5. Schema design (if having experience) - what factors to consider, normalization, fact vs transaction tables
Add your answer

Q1. Basic stats - central tendencies, distributions, skewness, outlier detection
Add your answer
Q2. Experiment design, hypothesis testing
Add your answer
Q3. Analytical case studies - how to solve problems and when to apply different approaches such as segmentation, clustering, forecasting, etc.
Add your answer

Open-ended case study to understand your approach and considerations. Use common sense, explain your thinking and be rigorous. Can come from any field but does not require field-intensive knowledge

Q1. Personality questions, motivations, company culture fit
Add your answer
Q2. Can re-touch on anything from previous round
Add your answer
Q3. In-depth exploration of any project or skill on resume
Add your answer