Upload Button Icon Add office photos
Engaged Employer

i

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

Decathlon Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Decathlon Senior Data Analyst Interview Questions, Process, and Tips

Updated 22 Nov 2024

Top Decathlon Senior Data Analyst Interview Questions and Answers

View all 9 questions

Decathlon Senior Data Analyst Interview Experiences

2 interviews found

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
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

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
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Dec 2022. There were 4 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. SQL basics and coding questions
Round 3 - Technical 

(1 Question)

  • Q1. Data Science mathematical concepts
Round 4 - HR 

(1 Question)

  • Q1. Why do you want to join

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare the basics of Data Science and Engineering.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Case Study 

Cas study on books library data

Round 2 - Technical 

(1 Question)

  • Q1. Basics of spark Discussion on case study approach SQL question on windows function

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on basics
Interview experience
3
Average
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. 1. Basic SQL questions including aggregations, window functions etc. 2. Project & resume walkthrough
Round 2 - Case Study 

1. Guesstimates - How many Nike shoes are sold in India

Round 3 - HR 

(1 Question)

  • Q1. Generic HR questions - why I want to quit the current company? Why Nike?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jul 2022. There were 3 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 Resume tips
Round 2 - Technical 

(8 Questions)

  • Q1. Limitations of Vlookup
  • Ans. 

    Vlookup limitations include limited search range, case sensitivity, and inability to handle multiple matches.

    • Vlookup only searches for values in the leftmost column of the table array

    • It is case sensitive and cannot handle spelling errors

    • It only returns the first match and cannot handle multiple matches

    • It cannot search for values to the left of the lookup column

    • It can be slow and inefficient for large datasets

  • Answered by AI
  • Q2. Vlookup vs Index-Match
  • Ans. 

    Vlookup and Index-Match are both Excel functions used for lookup and retrieval of data.

    • Vlookup is simpler and faster but has limitations in terms of flexibility and handling of large datasets.

    • Index-Match is more versatile and can handle complex data structures but is slower and requires more effort to set up.

    • Vlookup is best suited for simple lookups with small datasets while Index-Match is better for more complex looku...

  • Answered by AI
  • Q3. Define Excel Functions Sum , Sum if , Count , CountA , Count Blanks
  • Ans. 

    Excel functions are pre-built formulas that perform calculations or manipulate data in a spreadsheet.

    • Sum: adds up a range of numbers

    • Sum if: adds up a range of numbers based on a specified condition

    • Count: counts the number of cells in a range that contain numbers

    • CountA: counts the number of cells in a range that are not empty

    • Count Blanks: counts the number of empty cells in a range

  • Answered by AI
  • Q4. Limitations of Structural Query Language
  • Ans. 

    SQL limitations include lack of scalability, security vulnerabilities, and difficulty in handling unstructured data.

    • SQL is not suitable for handling unstructured data like images, videos, and audio files.

    • It can be difficult to scale SQL databases to handle large amounts of data.

    • SQL databases can be vulnerable to security threats like SQL injection attacks.

    • SQL is not always the best choice for real-time data processing ...

  • Answered by AI
  • Q5. Write code to find duplicate Records.
  • Ans. 

    Code to find duplicate records

    • Identify the key columns to check for duplicates

    • Use GROUP BY and HAVING clauses to filter out duplicates

    • Consider using window functions like ROW_NUMBER() to identify and remove duplicates

    • Use programming languages like SQL, Python, or R to write the code

  • Answered by AI
  • Q6. Write code to describe database and Columns from a particular table
  • Ans. 

    Code to describe database and columns from a table

    • Use SQL SELECT statement to retrieve column names and data types

    • Use DESC command to get table structure

    • Use INFORMATION_SCHEMA.COLUMNS to get detailed information about columns

    • Use SHOW CREATE TABLE to get table creation statement

  • Answered by AI
  • Q7. What is trigger in SQL?
  • Ans. 

    A trigger in SQL is a set of instructions that automatically executes in response to a specific event or action.

    • Triggers can be used to enforce business rules, audit changes, or replicate data.

    • They can be defined to execute before or after an INSERT, UPDATE, or DELETE statement.

    • Triggers can also be nested, meaning one trigger can execute another trigger.

    • Examples of triggers include sending an email notification when a ...

  • Answered by AI
  • Q8. What is the use if store procedure ?
  • Ans. 

    Stored procedures are precompiled SQL statements that can be reused and executed multiple times.

    • Stored procedures improve performance by reducing network traffic and improving security.

    • They can be used to encapsulate business logic and provide a consistent interface to the database.

    • Stored procedures can also be used to simplify complex queries and transactions.

    • Examples include procedures for inserting, updating, and de...

  • Answered by AI
Round 3 - Behavioral 

(7 Questions)

  • Q1. How you get your data in your organization
  • Ans. 

    Data is collected from various sources including databases, APIs, and user input.

    • We have access to multiple databases where we can extract relevant data

    • We use APIs to gather data from external sources such as social media platforms

    • Users can input data through forms or surveys

    • We also collect data through web scraping techniques

  • Answered by AI
  • Q2. What type of challenges you face in your day today work
  • Ans. 

    As a data analyst, I face challenges such as data quality issues, incomplete or inconsistent data, and time constraints.

    • Data quality issues: Dealing with missing or inaccurate data that can affect the analysis.

    • Incomplete or inconsistent data: Working with datasets that are not complete or have inconsistencies, requiring data cleaning and manipulation.

    • Time constraints: Balancing multiple projects and deadlines, often ne...

  • Answered by AI
  • Q3. Sequence of Execution of SQL codes. Select - Where-from-Having- order by etc
  • Ans. 

    The sequence of execution of SQL codes is Select-From-Where-Group By-Having-Order By.

    • Select: choose the columns to display

    • From: specify the table(s) to retrieve data from

    • Where: filter the data based on conditions

    • Group By: group the data based on a column

    • Having: filter the grouped data based on conditions

    • Order By: sort the data based on a column

  • Answered by AI
  • Q4. Difference between having and where clause
  • Ans. 

    HAVING is used with GROUP BY to filter the results after grouping. WHERE is used to filter the results before grouping.

    • HAVING is used with GROUP BY clause while WHERE is used with SELECT clause.

    • HAVING is used to filter the results of aggregate functions while WHERE is used to filter individual rows.

    • HAVING is used to filter the results after grouping while WHERE is used to filter the results before grouping.

    • HAVING can o...

  • Answered by AI
  • Q5. Difference between CSV file and Excel file
  • Ans. 

    CSV files are plain text files that store tabular data, while Excel files are binary files that can contain multiple sheets and complex formatting.

    • CSV files are simpler and more lightweight compared to Excel files.

    • CSV files can be easily opened and edited using a text editor, while Excel files require specific software like Microsoft Excel.

    • CSV files do not support formulas, macros, or formatting options like colors and...

  • Answered by AI
  • Q6. How much amount of data you Handel till now.
  • Ans. 

    I have handled large amounts of data in my previous roles.

    • I have experience handling terabytes of data in my previous role as a data analyst at XYZ company.

    • I have worked with data from various sources such as databases, spreadsheets, and APIs.

    • I have also used tools like SQL, Python, and Excel to manipulate and analyze data.

    • I am comfortable working with both structured and unstructured data.

    • I have experience cleaning an...

  • Answered by AI
  • Q7. What are the different approach you use for data cleaning.
  • Ans. 

    Different approaches for data cleaning include removing duplicates, handling missing values, correcting inconsistent data, and standardizing formats.

    • Remove duplicates

    • Handle missing values

    • Correct inconsistent data

    • Standardize formats

    • Use statistical methods to identify outliers

    • Check for data accuracy and completeness

    • Normalize data

    • Transform data types

    • Apply data validation rules

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Walmart Data Analyst interview:
  • Excel
  • SQL
  • MS PowerPoint
Interview preparation tips for other job seekers - Good Communication
Presence of mind is required to clear interview

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
6-8 weeks
Result
-

I was interviewed in Sep 2023.

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 Resume tips
Round 2 - HR 

(1 Question)

  • Q1. Some basic questions about my previous job
Round 3 - Technical 

(1 Question)

  • Q1. Advance SQL questions
Round 4 - Technical 

(1 Question)

  • Q1. Advanced sql questions and questions on prior projects
Round 5 - One-on-one 

(2 Questions)

  • Q1. Scenario from previous work of what you did when you experienced a conflict
  • Q2. Questions related your prior work
Round 6 - Behavioral 

(3 Questions)

  • Q1. Why you chose Walmart
  • Q2. Reason for previous job change
  • Q3. Why should we hire you
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Prepare from the job description
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Sql questions - self join, window functions, CTEs

Round 2 - Technical 

(2 Questions)

  • Q1. Explain p value in layman terms
  • Ans. 

    P value is a measure that helps determine the significance of results in a statistical hypothesis test.

    • P value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

    • A small p value (typically ≤ 0.05) indicates strong evidence against the null hypothesis, leading to its rejection.

    • A large p value (> 0.05) suggests weak evidence against the null hypothesis, failin...

  • Answered by AI
  • Q2. AB testing - null hypothesis
Round 3 - HR 

(2 Questions)

  • Q1. Culture fit questions
  • Q2. Hiring manager explained the profile
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Average totals for last 3 months
  • Q2. Running totals in a year using dax
  • Ans. 

    Running totals in a year using DAX

    • Use the DAX function CALCULATE to create running totals

    • Use the FILTER function to specify the date range for the running total

    • Example: CALCULATE(SUM(Sales[Amount]), FILTER(ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date])))

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Walmart Data Analyst interview:
  • Powerbi
  • SQL
  • Dax

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Decathlon Interview FAQs

How many rounds are there in Decathlon Senior Data Analyst interview?
Decathlon interview process usually has 4-5 rounds. The most common rounds in the Decathlon interview process are Technical, Case Study and Assignment.
How to prepare for Decathlon Senior Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Decathlon. The most common topics and skills that interviewers at Decathlon expect are SQL, AWS, Analytical Chemistry, Business Process Management and Data Analysis.
What are the top questions asked in Decathlon Senior Data Analyst interview?

Some of the top questions asked at the Decathlon Senior Data Analyst interview -

  1. Coin tossed 2 times what's prob to get both heads? what if coin is bias...read more
  2. Difference between View & Temp Table? what is view in s...read more
  3. types of bar charts in tableau, what is stacked b...read more

Recently Viewed

REVIEWS

Fabindia

No Reviews

INTERVIEWS

Fabindia

No Interviews

INTERVIEWS

Fabindia

No Interviews

INTERVIEWS

Decathlon

No Interviews

INTERVIEWS

Decathlon

No Interviews

REVIEWS

Big Bazaar

No Reviews

REVIEWS

Future Retail

No Reviews

INTERVIEWS

Decathlon

No Interviews

REVIEWS

Fabindia

No Reviews

REVIEWS

Fabindia

No Reviews

Tell us how to improve this page.

Decathlon Senior Data Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

Reliance Retail Interview Questions
3.9
 • 1.5k Interviews
Walmart Interview Questions
3.8
 • 411 Interviews
Titan Company Interview Questions
4.3
 • 148 Interviews
Landmark Group Interview Questions
4.0
 • 148 Interviews
V-Mart Interview Questions
4.1
 • 146 Interviews
Lowe's Interview Questions
4.1
 • 131 Interviews
Croma Interview Questions
4.0
 • 127 Interviews
Tesco Interview Questions
3.8
 • 122 Interviews
Target Interview Questions
4.2
 • 119 Interviews
Reliance Digital Interview Questions
4.1
 • 117 Interviews
View all

Fast track your campus placements

View all
Sports Leader
361 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Department Manager
290 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Manager
156 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operations Manager
84 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sports Lead
74 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Decathlon with

Adidas

3.9
Compare

NIKE

4.2
Compare

PUMA

4.3
Compare

Under Armour

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