i
Petpooja
Filter interviews by
Clear (1)
I applied via Approached by Company and was interviewed in Jan 2022. There were 2 interview rounds.
Top trending discussions
I applied via Company Website and was interviewed in May 2024. There were 3 interview rounds.
Logic reasoning aptitude quant os dbms cn
Arrays, strings, linked list
I applied via Walk-in and was interviewed before May 2023. There were 2 interview rounds.
Calculate rolling average for order amount for merchants
Calculate the average order amount for each merchant over a specific time period
Update the average as new orders come in, dropping the oldest order amount from the calculation
Example: Merchant A had orders of $100, $150, $200 in the last 3 days. Rolling average would be ($100 + $150 + $200) / 3 = $150
SQL, Python, Case Studies, Window Functions
I applied via Campus Placement and was interviewed in Mar 2021. There was 1 interview round.
This pen is not just a writing instrument, it's a statement of luxury and exclusivity.
Highlight the pen's unique design and craftsmanship
Emphasize the use of high-quality materials
Mention any special features or functions
Create a sense of exclusivity and rarity
Appeal to the buyer's desire for luxury and status
Offer personalized engraving or customization options
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.
As a Business Analyst, previous BAU tasks included analyzing business processes, gathering requirements, creating documentation, and facilitating communication between stakeholders.
Analyzed current business processes to identify areas for improvement
Gathered requirements from stakeholders to understand their needs and priorities
Created documentation such as business requirements documents, functional specifications, an...
User stories for an MS Application
As a user, I want to be able to create new documents in Word.
As a user, I want to be able to format text in Excel.
As a user, I want to be able to set reminders in Outlook.
As a user, I want to be able to collaborate with others in PowerPoint.
As a user, I want to be able to customize templates in Publisher.
Relevant experience is crucial for a Business Analyst as it provides the necessary skills and knowledge to effectively analyze business processes and make informed recommendations.
Relevant experience includes working in a similar industry or role, understanding business processes, and using analytical tools.
Experience in data analysis, project management, and communication skills are also important for a Business Analy...
I want to switch to explore new challenges and opportunities for growth.
Seeking new challenges to expand my skill set
Interested in exploring different industries and sectors
Looking for opportunities for career advancement
Want to broaden my professional network
Highly interactive and technical
1 hr test with focus on math and analytical thinking
I was interviewed in Mar 2021.
Steps involved in analyzing decrease in sales for a particular area
Identify the time period for which sales have decreased
Analyze the sales data for the area and compare it with previous periods
Identify any external factors that may have contributed to the decrease in sales
Conduct customer surveys to identify any issues with products or services
Analyze competitor activity in the area
Develop a plan to address the issues...
SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.
Use AVG function to calculate mean waiting period
Subtract ordered time from delivered time to get waiting period
Filter data by driver ID and delivery partner
Group by delivery partner
Rolling sum query adds up a specified number of rows in a table based on a given condition.
Use the OVER() function to specify the window frame for the rolling sum.
Specify the number of rows to include in the window frame using ROWS BETWEEN.
Use ORDER BY to specify the order of rows in the window frame.
Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FR
Relationship Manager
265
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Support Engineer
85
salaries
| ₹0 L/yr - ₹0 L/yr |
Area Sales Manager
82
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Executive
55
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Development Executive
48
salaries
| ₹0 L/yr - ₹0 L/yr |
LimeTray
RestoLabs
EazyDiner
DineOut