ClicFlyer interview questions

🔹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?