i
NIKE
Filter interviews by
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
Top trending discussions
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 Nov 2024. There was 1 interview round.
Sql and python questions were asked
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
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...
MySQL basics,
Sorting,
group by,
pivot
Case studies basic to advanced MySQL.
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.
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
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
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
I applied via Referral and was interviewed in Sep 2024. There were 4 interview rounds.
SQL - 3 set of sql questions
1 Design Question, do ER diagram, 1 JSON parsing question
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...
based on 1 interview
Interview experience
Software Engineer2
52
salaries
| ₹14 L/yr - ₹40.2 L/yr |
Software Engineer III
48
salaries
| ₹28.7 L/yr - ₹47 L/yr |
Senior Software Engineer
47
salaries
| ₹24 L/yr - ₹39.7 L/yr |
Store Manager
42
salaries
| ₹3.4 L/yr - ₹9 L/yr |
Sales Executive
41
salaries
| ₹1.5 L/yr - ₹4.2 L/yr |
Adidas
PUMA
Under Armour
Reebok