Example of an analytical project you've worked on
Sr Data Analyst Interview Questions
2,955 sr data analyst interview questions shared by candidates
Tell me about your work experience
Screening Round – SQL & Data Visualization: 1. Easy to medium SQL questions focused on filtering, joins, and aggregations. 2. What checks would you perform to ensure data quality and cleanliness? 3. How to compare two tables to confirm if they have the same data. 4. Given a table with one categorical and two numerical columns, how would you visualize it? 5. What chart would you use to analyze correlation? SQL (Live or HackerRank format) 1. Table: Cust_visit(transaction_id, transaction_date, customer_id, total_amount, total_unit) Question: Identify premium customers who spent at least $300 and had at least 2 transactions in the past 3 months. 2. Tables: transactions(transaction_date, customer_id, product_id, sale) products(product_id, product_name, department) Question: Identify cross-department customers who have purchased from every department in the products table. 3. Tables: shipments(shipment_date, shipment_id, package_type, warehouse_id, customer_id, num_items, country) returns(return_id, return_date, customer_id) Question: Find the number of customers who had both a shipment and a return in the last 30 days. Final Round – Behavioral Focused on real-world experience: 1. TMAY 2. What types of analysis do you work on 3. What kinds of dashboards have you built - Follow-up questions around tools, business goals, and challenges
Open ended questions mostly based on how relevant your professional history is
Assessment using Python and need to complete the assessment within 5 days
Comment gérer une situation où un collaborateur se montre réfractaire au changement que vous proposez ?
Favorite programming language or the one you preferred the most
What were you in your previous life?
Questions on Tableau, SQL and the current roles and responsibilities.
Started with basic SQL and then went on to Data Structures and Algorithms
Viewing 2471 - 2480 interview questions