SCM Garments Data Analyst Interview Questions and Answers

Q1. Difference between where and having clause?.
Ans. 
WHERE clause filters rows before grouping while HAVING clause filters groups after grouping.
• WHERE clause is used to filter rows based on a condition before grouping them.

• HAVING clause is used to filter groups based on a condition after grouping them.

• WHERE clause is used with SELECT, UPDATE, DELETE statements while HAVING clause is used with GROUP BY clause.

• WHERE clause is faster than HAVING clause as it filters rows be...read more
Answered by AI
Add your answer
Q2. Lead lag questions . Explain windows functions and stored procedure
Add your answer

Q1. Tell me about your projects
Ans. 
I have worked on various projects involving data analysis, process improvement, and system implementation.
• Implemented a new CRM system to streamline customer data management

• Conducted data analysis to identify trends and opportunities for cost savings

• Led a cross-functional team to improve inventory management processes

• Developed KPI dashboards to track project performance and ROI
Answered by AI
Add your answer
Q2. What are your day to day activities
Ans. 
As a Business Analyst, my day to day activities include gathering and analyzing data, creating reports, identifying business trends, and collaborating with stakeholders.
• Gathering and analyzing data to identify business opportunities and trends

• Creating reports and presentations to communicate findings to stakeholders

• Collaborating with stakeholders to understand business needs and requirements

• Conducting meetings and inte...read more
Answered by AI
Add your answer

Asked me to prepare a PPT on reliance retail

Q1. We can give only 30% hike.. why would I hire you?
Ans. 
I bring a unique combination of skills, experience, and passion for the role that will drive value beyond just the salary increase.
• My track record of delivering successful projects on time and within budget showcases my ability to add significant value to the organization.

• I possess a diverse skill set including data analysis, problem-solving, and stakeholder management which are crucial for a Business Analyst role.

• My p...read more
Answered by AI
Add your answer

Q1. Tell about project that you have been Working on
Ans. 
Developed a data analysis tool for tracking customer behavior on e-commerce platform
• Used Python and SQL to extract and analyze data from the database

• Implemented machine learning algorithms to predict customer preferences

• Created visualizations to present findings to stakeholders
Answered by AI
Add your answer

Q1. What is Gross profit
Ans. 
Gross profit is the total revenue minus the cost of goods sold.
• Gross profit = Total revenue - Cost of goods sold

• It represents the profit a company makes from its core business activities before deducting operating expenses.

• It does not include expenses such as taxes, interest, and other non-operating costs.

• Gross profit margin is calculated as (Gross profit / Total revenue) * 100%

• Example: If a company has total revenue o...read more
Answered by AI
Add your answer
Q2. GP = Sales - COGS
Add your answer

Q1. Hahsk kdks ksksk sks
Add your answer
Q2. Jeks ksks dkkd dd fr ss
Add your answer

Q1. Tell us about yourself
Add your answer

Q1. Can you describe your previous work experience?
Ans. 
I have 5 years of experience as a Business Analyst in the finance industry.
• Led cross-functional teams to analyze market trends and develop strategic plans

• Conducted financial modeling and forecasting to support decision-making

• Collaborated with stakeholders to gather requirements and define project scope

• Implemented process improvements to increase efficiency and reduce costs
Answered by AI
Add your answer

50 questions in 12 minutes to be solved.

Q1. Based on CV tell me about yourself five-year plan
Ans. 
I am an experienced Analyst with a strong background in data analysis and problem-solving. My five-year plan includes advancing my skills in predictive modeling and becoming a team leader in my field.
• Experienced Analyst with expertise in data analysis and problem-solving

• Strong background in predictive modeling

• Goal to become a team leader in the next five years
Answered by AI
Add your answer
Q2. Situational based question
Add your answer