Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Reliance Retail Team. If you also belong to the team, you can get access from here

Reliance Retail Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Reliance Retail Senior Data Analyst Interview Questions and Answers

Updated 23 Oct 2024

Reliance Retail Senior Data Analyst Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

MySQL basics,
Sorting,
group by,
pivot

Round 2 - Coding Test 

Case studies basic to advanced MySQL.

Senior Data Analyst Interview Questions & Answers

user image Shubhangi Dubey

posted on 23 Feb 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Coding Test 

Sql questions, phython, learn case statements like there is milk category and sub caetgories on this they will ask questions, also problem solving

Senior Data Analyst Interview Questions Asked at Other Companies

Q1. What is the difference between Least Squares Method and the maxim ... read more
Q2. How do you improve the performance of Linear Regression
asked in Proftware
Q3. Imagine you are presented with a complex dataset from a multinati ... read more
Q4. How do you handle overfitting and underfitting in Decision Trees
Q5. What metrics do you use to evaluate classification models

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Question related IT and Business

Interview Preparation Tips

Interview preparation tips for other job seekers - it was overall good experiance

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

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 experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Nov 2023.

Round 1 - Case Study 

Case study +aptitute+SQL

Round 2 - Case Study 

Case study +problem solving round

Round 3 - HR 

(2 Questions)

  • Q1. Salary negotiation
  • Q2. Behavioural questions
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
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Python questions dataframe creata
  • Q2. SQL questions joins , windows function,cte

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

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

Reliance Retail Interview FAQs

How many rounds are there in Reliance Retail Senior Data Analyst interview?
Reliance Retail interview process usually has 1-2 rounds. The most common rounds in the Reliance Retail interview process are Coding Test and Assignment.

Tell us how to improve this page.

Reliance Retail Senior Data Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

DMart Interview Questions
3.9
 • 405 Interviews
Walmart Interview Questions
3.7
 • 387 Interviews
Landmark Group Interview Questions
4.0
 • 150 Interviews
Lowe's Interview Questions
4.2
 • 129 Interviews
Croma Interview Questions
4.0
 • 127 Interviews
Tesco Interview Questions
3.8
 • 122 Interviews
Reliance Digital Interview Questions
4.1
 • 120 Interviews
Target Interview Questions
4.2
 • 111 Interviews
Reliance Trends Interview Questions
4.2
 • 103 Interviews
Decathlon Interview Questions
3.8
 • 101 Interviews
View all
Reliance Retail Senior Data Analyst Salary
based on 10 salaries
₹4.5 L/yr - ₹10 L/yr
29% less than the average Senior Data Analyst Salary in India
View more details
Assistant Manager
4.2k salaries
unlock blur

₹3 L/yr - ₹10.3 L/yr

Store Manager
4.1k salaries
unlock blur

₹2 L/yr - ₹9.8 L/yr

Department Manager
3.6k salaries
unlock blur

₹1.7 L/yr - ₹6.2 L/yr

Deputy Manager
2.5k salaries
unlock blur

₹4.2 L/yr - ₹15 L/yr

Senior Executive
1.9k salaries
unlock blur

₹1.5 L/yr - ₹8.5 L/yr

Explore more salaries
Compare Reliance Retail with

DMart

3.9
Compare

Future Group

4.3
Compare

Reliance Digital

4.1
Compare

Croma

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