None, I was ghosted by the recruiter
Senior Data Analyst Interview Questions
2,903 senior data analyst interview questions shared by candidates
Identify the top 5 directors using KPIs of your choice.
Comentar un poco de la experiencia, preguntas básicas en inglés.
regarding aws s3 and redshift and scenario based questions and few sql questions
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
How do you ensure the quality of the data?
Since working in an EDW, what is the advantages of a star schema.
Advanced questions of array and data structures
Sql queries easy one, but dont know their criteria for selection
Experience in Data Analysis. How to handle large volumes of data?
Viewing 2361 - 2370 interview questions