Y PCA, what’s SMOTE and other techniques to fix data imbalance , feature selection techniques
Senior Data Analyst Interview Questions
3,103 senior data analyst interview questions shared by candidates
Scaling , model evaluation, parameters tuning
Different imputation techniques, to handle skewed data, to fix outliers
Why do you wanna join Emma?
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
Las típicas: ¿Por qué Holaluz? ¿Experiencias relevantes con el puesto? ¿Explica tu código? ¿Cual sería tu recomendación final respecto al caso de negocio?
Tell me about yourself Why do you want to work for us
Diffrance between Bagging and Boosting and many more questions
Three SQL questions: 1. Query involved window functions (SUM/COUNT), CTE, and date filtering using DATEADD 2. Worked with nested CTEs and GROUP BY. Had a good discussion about choosing LEFT JOIN over INNER JOIN - explained how it helps catch missing or incomplete data 3. Discussion about comparing data between tables using EXCEPT/INTERSECT and checksums Cultural fit: STAR stories about leading a project, requirement gathering etc.
Viewing 2551 - 2560 interview questions