Victoria's Secret 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

1 hour test. The test consists of 3 sections. First section is aptitude and second section is verbal and the third section is logical thinking.

Speak about a topic. 5 minutes of time will be given.. After 5 minutes start speaking about the given topic.

Most likely to least likely

Sql coding for situation

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