Promilo Business Analyst Interview Questions and Answers

Q1. How would you handle missing dataduring analysis?
Ans. 
Handling missing data involves identifying, assessing, and applying appropriate techniques to manage gaps in datasets.
• Identify missing data: Use methods like 'isnull()' in Python to find missing values.

• Assess the impact: Determine how missing data affects your analysis and results.

• Imputation: Replace missing values with mean, median, or mode. For example, use the median for skewed distributions.

• Remove missing data: If ...read more
Answered by AI
Add your answer
Q2. Explain the difference inner join and left join in SQL ? and example
Ans. 
Inner join returns matching records from both tables, while left join returns all records from the left table and matching from the right.
• Inner Join: Combines rows from two tables where there is a match in both tables.

• Left Join: Returns all rows from the left table and matched rows from the right table; unmatched rows from the right will show NULL.

• Example of Inner Join: SELECT * FROM TableA INNER JOIN TableB ON TableA....read more
Answered by AI
Add your answer
Q3. Which visualisation have tools used and how do you decide which chart to used for a given dataset?
Ans. 
Choosing the right visualization depends on data type, audience, and insights needed.
• Use bar charts for categorical comparisons (e.g., sales by region).

• Line charts are ideal for trends over time (e.g., monthly revenue).

• Pie charts can show proportions but are less effective for many categories.

• Scatter plots help identify relationships between two variables (e.g., age vs. income).

• Heatmaps visualize data density or correl...read more
Answered by AI
Add your answer

Coding test, technical round, HR round

Q1. Where do you see yourself after 5 years.
Ans. 
In five years, I envision myself as a skilled professional, contributing significantly to my field and leading innovative projects.
• I aim to have advanced my skills through continuous learning and professional development, such as obtaining relevant certifications.

• I see myself taking on leadership roles, perhaps managing a team or leading projects that drive impactful results.

• I hope to be involved in innovative projects...read more
Answered by AI
Add your answer
Q2. What's your weakness
Ans. 
I tend to be overly critical of my work, which can slow down my progress but helps me maintain high standards.
• I often spend extra time reviewing my work to ensure it's perfect, which can lead to missed deadlines.

• For example, during a group project, I focused too much on perfecting my section, causing delays for the team.

• I've learned to set time limits for revisions to balance quality and efficiency.

• I also seek feedback...read more
Answered by AI
Add your answer

Q1. Tell us about a project you've worked on using the MERN stack.
Ans. 
Developed a task management application using the MERN stack to streamline team collaboration and project tracking.
• Utilized MongoDB for database management, storing user tasks and project details.

• Implemented Express.js to create RESTful APIs for task CRUD operations.

• Used React.js for building a responsive user interface, allowing users to add, edit, and delete tasks seamlessly.

• Incorporated Node.js for server-side logic...read more
Answered by AI
Add your answer
Q2. How do you manage routes in a MERN stack application?
Ans. 
Managing routes in a MERN stack involves defining API endpoints and client-side routes for seamless navigation and data handling.
• Use Express.js for backend routing: Define routes in a separate file, e.g., 'routes/user.js'.

• Implement RESTful API conventions: Use GET, POST, PUT, DELETE methods for CRUD operations.

• Utilize React Router for client-side routing: Set up routes in 'App.js' using <BrowserRouter> and <Ro...read more
Answered by AI
Add your answer

Q1. React hooks related How to use them
Ans. 
React hooks are functions that let you use state and lifecycle features in functional components.
• useState: Allows you to add state to functional components. Example: const [count, setCount] = useState(0);

• useEffect: Lets you perform side effects in function components. Example: useEffect(() => { document.title = `Count: ${count}`; }, [count]);

• useContext: Provides a way to pass data through the component tree without ...read more
Answered by AI
Add your answer
Q2. About web socket real time messaging
Add your answer
Q3. About react router dom
Add your answer

Q1. What is supervised learing
Ans. 
Supervised learning is a machine learning approach where a model is trained on labeled data to make predictions or classifications.
• Involves training a model on a dataset with input-output pairs.

• Common algorithms include linear regression, decision trees, and support vector machines.

• Used for tasks like spam detection (classifying emails) and image recognition (identifying objects in images).

• The model learns from the lab...read more
Answered by AI
Add your answer
Q2. What is mse
Ans. 
MSE, or Mean Squared Error, is a common metric used to measure the average squared difference between predicted and actual values.
• MSE is calculated as the average of the squares of the errors: MSE = (1/n) * Σ(actual - predicted)².

• A lower MSE indicates a better fit of the model to the data.

• For example, if actual values are [3, -0.5, 2] and predicted values are [2.5, 0.0, 2], MSE = (1/3) * ((3-2.5)² + (-0.5-0)² + (2-2)²)...read more
Answered by AI
Add your answer

Q1. What is the main difference btwn java and java script?
Add your answer
Q2. Differentiate thread and process
Add your answer