Decathlon Senior Data Analyst Interview Questions and Answers

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...read more
Answered by AI
Add your answer
Q2. View and materialised view
Add your answer

Retail data case study

Case study discussion

Q1. Retail situational based questions
Add your answer
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 ...read more
Answered by AI
Add your answer

Q1. Basic technical knowledge
Add your answer
Q2. Situational and managerial round questions
Add your answer

Q1. Basic salary negotiation
Add your answer
Q2. Situational base question
Add your answer

Q1. Introduce Yourself
Ans. 
I am a Senior Data Analyst with extensive experience in data visualization, statistical analysis, and business intelligence.
• Data Visualization: I have created interactive dashboards using tools like Tableau and Power BI to help stakeholders make data-driven decisions.

• Statistical Analysis: I utilize statistical methods to analyze trends and patterns in large datasets, such as using regression analysis to forecast sales.

• ...read more
Answered by AI
Add your answer
Q2. Your Day to Day responsibilities in current Job
Ans. 
As a Senior Data Analyst, I analyze data trends, create reports, and collaborate with teams to drive data-informed decisions.
• Data Analysis: I regularly analyze large datasets to identify trends and insights that inform business strategies, such as customer behavior analysis.

• Reporting: I create detailed reports and dashboards using tools like Tableau and Power BI to visualize data findings for stakeholders.

• Collaboration...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
Q4. Sql window functions
Add your answer
Q5. Sql 2 tables were given N was asked to write query.
Ans. 
SQL query to join two tables and extract relevant data based on specified conditions.
• Use JOIN clause to combine rows from both tables based on a related column.

• Example: SELECT * FROM table1 JOIN table2 ON table1.id = table2.foreign_id;

• Consider using INNER JOIN for matching records only, or LEFT JOIN for all records from the left table.

• Use WHERE clause to filter results based on specific criteria.

• Example: SELECT * FROM ...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer

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.

Q1. Managerial Round (Technical)
Add your answer