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

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in Oct 2024. There were 6 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Difference between where and having
  • Ans. 

    WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.

    • WHERE is used with SELECT statement to filter rows based on a condition

    • HAVING is used with GROUP BY statement to filter groups based on a condition

    • WHERE is applied before grouping, HAVING is applied after grouping

    • Example: SELECT * FROM table WHERE column = 'value'

    • Example: SELECT column, COUNT(*) FROM table GROUP BY column HAVIN

  • Answered by AI
  • Q2. View and materialised view
Round 2 - Case Study 

Retail data case study

Round 3 - Assignment 

Case study discussion

Round 4 - Technical 

(2 Questions)

  • Q1. Retail situational based questions
  • Q2. Metrics used in retail business
  • Ans. 

    Metrics used in retail business include sales, customer acquisition cost, customer lifetime value, inventory turnover, and gross margin.

    • Sales: Total revenue generated from products or services sold

    • Customer acquisition cost: Cost incurred to acquire a new customer

    • Customer lifetime value: Predicted revenue a customer will generate over their lifetime

    • Inventory turnover: Number of times inventory is sold and replaced in a ...

  • Answered by AI
Round 5 - One-on-one 

(2 Questions)

  • Q1. Basic technical knowledge
  • Q2. Situational and managerial round questions
Round 6 - HR 

(2 Questions)

  • Q1. Basic salary negotiation
  • Q2. Situational base question

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL, Tableau and statistics basic

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - One-on-one 

(1 Question)

  • Q1. Basic experience related questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Similar to L1.Interviewed with senior manager.
Round 3 - One-on-one 

(1 Question)

  • Q1. Team fit round with Director
Round 4 - HR 

(1 Question)

  • Q1. Salary Discussion
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Sql questions on joins, window functions etc
  • Q2. Basic statistics questions on Central tendency
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Sql and python questions were asked

Round 2 - One-on-one 

(2 Questions)

  • Q1. Why are you fit for the role?
  • Ans. 

    I am fit for the role due to my extensive experience in data analysis, strong analytical skills, and ability to communicate insights effectively.

    • Extensive experience in data analysis

    • Strong analytical skills

    • Ability to communicate insights effectively

  • Answered by AI
  • Q2. Explain a project where you used data analytics to solve a business problem
  • Ans. 

    Implemented predictive analytics model to optimize inventory management for a retail company

    • Identified key factors affecting inventory levels such as seasonality, promotions, and supplier lead times

    • Utilized historical sales data to forecast demand and optimize inventory levels

    • Developed a predictive analytics model using machine learning algorithms to predict future sales and recommend optimal inventory levels

    • Implemente...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. What is your expected compensation?
  • Q2. When can you relocate?

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Technical 

(11 Questions)

  • Q1. Introduce Yourself
  • Q2. Your Day to Day responsibilities in current Job
  • Q3. Difference between View & Temp Table? what is view in sql?
  • Ans. 

    Views are virtual tables that display data from one or more tables, while temp tables are temporary tables that store data temporarily.

    • Views are virtual tables created by a query, while temp tables are physical tables created in the database.

    • Views do not store data themselves, but display data from underlying tables, while temp tables store data temporarily for a session or transaction.

    • Views can be used for security pu...

  • Answered by AI
  • Q4. Sql window functions
  • Q5. Sql 2 tables were given N was asked to write query.
  • Q6. Filters in Tableau
  • Ans. 

    Filters in Tableau allow users to narrow down data displayed in visualizations based on specific criteria.

    • Filters can be applied to dimensions or measures in Tableau.

    • Users can use filters to focus on specific subsets of data, such as a particular region or time period.

    • Filters can be set up as dropdown menus, sliders, or checkboxes for user interaction.

    • Example: Filtering sales data to show only results from the past yea

  • Answered by AI
  • Q7. Parameters in tableau
  • Ans. 

    Parameters in Tableau allow users to control the values in a visualization without modifying the underlying data.

    • Parameters can be used to filter data, change calculations, or modify the appearance of a visualization.

    • They can be created by defining a parameter in Tableau and then using it in calculated fields or filters.

    • Parameters can be set to different data types such as string, integer, float, date, etc.

    • Users can in...

  • Answered by AI
  • Q8. Types of bar charts in tableau, what is stacked bar?
  • Ans. 

    Types of bar charts in Tableau include standard bar, stacked bar, and side-by-side bar.

    • Standard bar chart displays individual bars for each category

    • Stacked bar chart shows the total value broken down into sub-categories

    • Side-by-side bar chart compares multiple measures across categories

    • Example: Stacked bar chart can be used to show sales by region, with each region broken down by product category

  • Answered by AI
  • Q9. Data blending Vs Joins in tableau
  • Ans. 

    Data blending combines data from different sources in Tableau, while joins combine data from the same source.

    • Data blending is used when data comes from different sources and cannot be joined directly.

    • Joins are used when data comes from the same source and can be combined based on a common key.

    • Data blending allows for more complex analysis by combining unrelated data sets.

    • Joins are more efficient for combining related d...

  • Answered by AI
  • Q10. Coin tossed 2 times what's prob to get both heads? what if coin is biased.
  • Ans. 

    The probability of getting both heads when a coin is tossed 2 times is 1/4. If the coin is biased, the probability may change.

    • The probability of getting both heads in a fair coin toss is 1/4 (1/2 * 1/2).

    • If the coin is biased, the probability of getting both heads may be different depending on the bias.

    • For example, if the coin is biased towards heads with a probability of 0.6, the probability of getting both heads would

  • Answered by AI
  • Q11. Difference in tree map & heat Map in tableau
  • Ans. 

    Tree map displays hierarchical data using nested rectangles, while heat map shows data values using color intensity.

    • Tree map visualizes hierarchical data with nested rectangles, where the size of each rectangle represents a measure.

    • Heat map displays data values using color intensity, with darker colors indicating higher values.

    • Tree map is useful for showing proportions within a whole, while heat map is effective for id...

  • Answered by AI
Round 2 - Case Study 

Present the case study through PPT which you already prepared before round 1. Hr reached out to me to complete case study before round 1.

Round 3 - Technical 

(1 Question)

  • Q1. Managerial Round (Technical)

Interview Preparation Tips

Topics to prepare for Decathlon Senior Data Analyst interview:
  • SQL
  • Tableau
Interview preparation tips for other job seekers - Make sure you are good at basics of SQL & Tableau. They didn't ask me single question on Python.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Case Study 

Given a excel data and asked to find the sumif, pivot table, calculated field creation

given logical thinking questions

Questions on the generic costing as it is for vendor cost management team
-About inventory turnover ratio
-inflation impact on the cost increase in raw material or Finished product
-aptitude question

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What interest you in analytics
  • Ans. 

    I am fascinated by the ability of analytics to uncover insights and drive informed decision-making.

    • I enjoy the challenge of working with large datasets and finding patterns within them

    • I am passionate about using data to solve complex problems and improve processes

    • I find it rewarding to see the impact of data-driven decisions on business outcomes

  • Answered by AI
  • Q2. Which tool you used for your project
Round 2 - One-on-one 

(1 Question)

  • Q1. How do you upskill yourself

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Sep 2024. There were 4 interview rounds.

Round 1 - Coding Test 

SQL - 3 set of sql questions

Round 2 - Group Discussion 

1 Design Question, do ER diagram, 1 JSON parsing question

Round 3 - One-on-one 

(1 Question)

  • Q1. Mandate to be on-site
  • Ans. 

    Being on-site is essential for effective collaboration, communication, and access to necessary resources.

    • On-site presence allows for real-time collaboration with team members and stakeholders.

    • Face-to-face communication can help clarify requirements and expectations more effectively.

    • Access to physical resources such as servers or data centers may be necessary for certain tasks.

    • Being on-site can also facilitate quicker d...

  • Answered by AI
Round 4 - HR 

(2 Questions)

  • Q1. Salary question expectations were asked
  • Q2. Timeline question to join and move to required state

Interview Preparation Tips

Topics to prepare for Walmart Senior Data Analyst interview:
  • SQL
  • Data Modelling
  • Basic Python

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
 • 401 Interviews
Walmart Interview Questions
3.8
 • 386 Interviews
Tata Group Interview Questions
4.2
 • 358 Interviews
Landmark Group Interview Questions
4.0
 • 147 Interviews
V-Mart Interview Questions
4.1
 • 146 Interviews
Lowe's Interview Questions
4.2
 • 127 Interviews
Croma Interview Questions
4.0
 • 127 Interviews
Tesco Interview Questions
3.8
 • 121 Interviews
Reliance Digital Interview Questions
4.1
 • 117 Interviews
View all
Reliance Retail Senior Data Analyst Salary
based on 10 salaries
₹4.5 L/yr - ₹10 L/yr
28% less than the average Senior Data Analyst Salary in India
View more details
Assistant Manager
4.2k salaries
unlock blur

₹3 L/yr - ₹10.4 L/yr

Store Manager
4.1k salaries
unlock blur

₹1.9 L/yr - ₹9.7 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

Future Retail

4.3
Compare

Tata Group

4.2
Compare

Aditya Birla Fashion and Retail

4.1
Compare

Spencer's Retail

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