Write the logic for the spiral matrix.
Sr Analyst Interview Questions
31,639 sr analyst interview questions shared by candidates
whats is a service?
🔹Excel What is the difference between VLOOKUP and INDEX-MATCH? How do you create a Pivot Table and why is it useful in retail analysis? How would you use Excel to find top 5 selling products by category? What are dynamic named ranges and how do you use them in dashboards? 🔹 SQL Write a query to get total sales per store from a sales table. What is the difference between INNER JOIN, LEFT JOIN, and FULL OUTER JOIN? How would you rank products within categories using SQL? Explain the use of GROUP BY and HAVING. 🔹 Power BI What are the main components of Power BI? How do you handle data refresh failures in Power BI Service? What is DAX? Can you write a simple CALCULATE expression? How do you optimize Power BI reports for performance? 🔹 Python (Basic level) How do you handle missing data in a DataFrame using pandas? How would you load an Excel file and summarize total sales per product? What libraries do you use for data visualization? Can you explain the difference between a list and a dictionary? 🔹 Retail Analytics Focus What are some key metrics you track for retail performance? How would you use analytics to reduce stockouts? Explain a time when you used data to influence a retail decision. How do you analyze weekly sales trends and seasonality?
Design a launch strategy for a infra red thermometer?
Analytical questions
It was mainly around resume and some behavioral, like how did you handle this/give me an example of a time when you had to do this and that.
Financial concepts, my overall work experience
Basic STAR questions around how I delt with challenges, how I managed a project or how I made process improvemnts.
Why do you choose prudential?
Asked about my background from my previous job.
Viewing 921 - 930 interview questions