i
Decathlon
Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in Oct 2024. There were 6 interview rounds.
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
Retail data case study
Case study discussion
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 ...
I applied via LinkedIn and was interviewed in Apr 2024. There were 3 interview rounds.
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...
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
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...
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
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...
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
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...
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.
Top trending discussions
I applied via Referral and was interviewed in Dec 2022. There were 4 interview rounds.
Cas study on books library data
I applied via Approached by Company and was interviewed before Feb 2023. There were 3 interview rounds.
1. Guesstimates - How many Nike shoes are sold in India
I applied via Naukri.com and was interviewed in Jul 2022. There were 3 interview rounds.
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
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...
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
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 ...
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
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
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 ...
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...
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
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...
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
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...
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...
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...
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
I was interviewed in Sep 2023.
I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 3 interview rounds.
Sql questions - self join, window functions, CTEs
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...
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
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])))
based on 2 interviews
Interview experience
Sports Leader
361
salaries
| ₹0 L/yr - ₹0 L/yr |
Department Manager
290
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Manager
156
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Manager
84
salaries
| ₹0 L/yr - ₹0 L/yr |
Sports Lead
74
salaries
| ₹0 L/yr - ₹0 L/yr |
Adidas
NIKE
PUMA
Under Armour