Upload Button Icon Add office photos

Filter interviews by

Hamleys Business Analyst Interview Questions and Answers

Updated 21 May 2021

Hamleys Business Analyst Interview Experiences

1 interview found

Interview Questionnaire 

1 Question

  • Q1. Mention some key financial ratios
  • Ans. 

    Financial ratios are used to evaluate a company's financial performance and health.

    • Liquidity ratios: measure a company's ability to meet short-term obligations

    • Profitability ratios: measure a company's ability to generate profits

    • Solvency ratios: measure a company's ability to meet long-term obligations

    • Efficiency ratios: measure how well a company utilizes its assets and liabilities

    • Examples include current ratio, return ...

  • Answered by AI

Interview questions from similar companies

I applied via Naukri.com and was interviewed in May 2019. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. In brick and motor business which are the key metrics responsible for tracking growth ?
  • Ans. 

    Key metrics for tracking growth in brick and mortar business.

    • Sales revenue

    • Customer footfall

    • Average transaction value

    • Customer retention rate

    • Inventory turnover rate

    • Gross profit margin

    • Net promoter score

    • Employee productivity

    • Marketing ROI

  • Answered by AI
  • Q2. How are they interrelated to each other ? Basically a KPI tree ?
  • Ans. 

    KPIs are interrelated in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

    • KPIs are Key Performance Indicators that measure the success of a business or project.

    • KPIs can be organized in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

    • For example, a company's overall revenue might be a high-level KPI, with lower-level KPIs such as sales revenue and cust...

  • Answered by AI
  • Q3. Case study of advertising of a new store opening in location ?
  • Ans. 

    Advertising a new store opening in a location

    • Identify target audience and their preferences

    • Create a catchy slogan and design attractive visuals

    • Utilize social media platforms and local newspapers for promotion

    • Offer discounts and promotions to attract customers

    • Organize a grand opening event to create buzz and excitement

  • Answered by AI
  • Q4. Case study regarding targeting customers ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Should be prepared with in and out of brick and mortar business .

Interview Questionnaire 

1 Question

  • Q1. What is logistics regression
  • Ans. 

    Logistic regression is a statistical method used to analyze and model the relationship between a dependent variable and one or more independent variables.

    • It is a type of regression analysis used for predicting binary outcomes

    • It uses a logistic function to model the probability of the dependent variable

    • It is commonly used in fields such as healthcare, finance, and marketing

    • Example: Predicting whether a customer will buy...

  • Answered by AI

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is logistics regression
  • Ans. 

    Logistic regression is a statistical method used to analyze and model the relationship between a binary dependent variable and one or more independent variables.

    • It is a type of regression analysis used for predicting binary outcomes

    • It uses a logistic function to model the probability of the dependent variable

    • It is commonly used in fields such as healthcare, finance, and marketing

    • Example: Predicting whether a customer w...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics of statistics, SQL and Python

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Assignment 

Some power BI problems and excel problems

Round 2 - Technical 

(1 Question)

  • Q1. SQL query questions along with power bi
Round 3 - HR 

(1 Question)

  • Q1. Excel and Power Bi and Analytics
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. General question on powerbi and sql
  • Q2. Had solve sone queries on sql
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Subjective based
  • Q2. Situational awareness

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for situational based scenarios questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jul 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Experience in the industry
  • Ans. 

    I have 5 years of experience in the finance industry, analyzing market trends and creating financial reports.

    • Worked as a financial analyst at XYZ Company for 3 years

    • Analyzed market data to identify trends and make recommendations

    • Created financial reports for senior management

    • Attended industry conferences to stay updated on market developments

  • Answered by AI
  • Q2. Technical questions
Round 2 - HR 

(2 Questions)

  • Q1. Previous experience
  • Q2. Salary expectations
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. About sql, python, visualaization
Round 2 - Technical 

(1 Question)

  • Q1. About sql and business kpi's
Round 3 - Technical 

(1 Question)

  • Q1. Sql and business kpi's
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(5 Questions)

  • Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
  • Q2. Difference between Vlookup and Xlookup ?
  • Ans. 

    Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.

    • Vlookup searches vertically in a table and returns a value from a specified column.

    • Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

    • Vlookup requ...

  • Answered by AI
  • Q3. Difference between Subquery and CTE. Which is better?
  • Ans. 

    Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.

    • Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

    • CTE is defined using the WITH keyword and can be referenced multiple times in a query.

    • CTEs are more readable and easier to maintain compared to subqueries.

    • Subqueries are useful when t...

  • Answered by AI
  • Q4. No of records returned after applying left and inner join on 2 tables.
  • Q5. Pivot the table in SQL using case when statements.
  • Ans. 

    Pivoting a table in SQL using case when statements

    • Use the CASE WHEN statement to create new columns based on specific conditions

    • Use the SUM or COUNT function to aggregate data in the pivoted table

    • Group by the remaining columns to ensure correct aggregation

    • Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;

  • Answered by AI
Round 2 - Case Study 

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Interview Preparation Tips

Topics to prepare for Landmark Group Business Analyst interview:
  • SQL
  • EXCEL
Interview preparation tips for other job seekers - Solve as many Business case studies as you can. Prepare well for SQL questions. You might get asked situation-based questions. Follow and show a structured approach while solving these questions. and you are good to go.

Skills evaluated in this interview

Tell us how to improve this page.

Interview Questions from Similar Companies

Landmark Group Interview Questions
4.0
 • 148 Interviews
Lowe's Interview Questions
4.1
 • 127 Interviews
Tesco Interview Questions
3.8
 • 121 Interviews
Target Interview Questions
4.2
 • 110 Interviews
V2 Retail Interview Questions
3.4
 • 57 Interviews
Fabindia Interview Questions
4.0
 • 52 Interviews
Vijay Sales Interview Questions
4.1
 • 47 Interviews
View all
FUN Consultant
110 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Store Manager
49 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Supervisor
46 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Executive
37 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Section Supervisor
33 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Hamleys with

Landmark Group

4.0
Compare

Metro Cash & Carry

4.1
Compare

Tesco

3.8
Compare

Fabindia

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview