Top Data Analyst Interview Questions

Rishabh L. - "with empbysalary as ( select id, firstname, lastname, salary, department_id, rank() over (partition by department_id order by salary desc) as rnk from employees ) select d.name as department_name, e.id as employee_id, e.firstname, e.lastname, e.salary from empbysalary e join departments d on e.department_id=d.id where e.rnk=1 order by 1; `"See full answer

Evan R. - "The user table no longer exists as expected - I get an error that user does not contain user_id. Note that querying the table results in only user:swuoevkivrjfta select * FROM user `"See full answer

Akshay D. - "SELECT u.user_id, u.user_name, u.email, ROUND(AVG(CASE WHEN b.status = 'Unmatched' THEN 1.0 ELSE 0 END), 2) AS avgunmatchedbookings FROM users u LEFT JOIN bookings b ON u.userid = b.userid GROUP BY u.user_id, u.user_name, u.email; `"See full answer

Victor N. - "--country names are UPPERCASE but the table in the in the question showing lowercase. That's why it took me a while to figure it out until I ran the country column WITH RECURSIVE Hierarchy AS ( SELECT e.Emp_ID, CONCAT(e.FirstName, ' ', e.MiddleName, ' ', e.LastName) AS FullName, e.Manager_ID, 0 AS Level, CASE WHEN e.Country = 'IRELAND' THEN s.Salary * 1.09 WHEN e.Country = 'INDIA' THEN s.Salary * 0.012 ELSE s.Salary "See full answer

Mohammedsiraj A. - " Here is the breakdown of the information in those images: \\1. The Amharic Letter (Financial Request)\** This is a formal letter from the \Dawa Zone Muslim Affairs Council\\ addressed to the \\Commercial Bank of Ethiopia (CBE)\. \Date:\\ 30/6/2018 (Ethiopian Calendar) \\Subject:\\ Opening a savings account. \\Purpose:\\ The letter requests the opening of a savings account for \\Nuur Mosque\**, located in Bale Zone, Dawa City. \Authorized Signatories:\\"See full answer

Yashasvi V. - "WITH RECURSIVE fibonacci_series AS ( SELECT 1 AS n, 0 AS fib1, 1 AS fib2 UNION ALL SELECT n + 1 AS n, fib2 AS fib1, fib1 + fib2 AS fib2 FROM fibonacci_series WHERE n < 20 -- Limit the series to 20 numbers ) SELECT n, fib1 AS fib FROM fibonacci_series ORDER BY n; `"See full answer

Ravindra R. - "First, I want to understand why Airbnb is considering expanding into the restaurant space. Is the goal more user engagement, or unlock new monetization paths, or make the travel journey more memorable by connecting people with food? Next, I want to define what success would look like for this expansion. That could mean high guest engagement or a boost in revenue. Third, I will look at things like the volume of Airbnb travelers to the region, how big the dining market is, who the local competitor"See full answer

Daniel C. - "select name, stock from products p left join transactions t on p.id = t.product_id order by date desc limit 1"See full answer

Erjan G. - "1) select avg(session) from table where session> 180 2) select round(sessiontime/300)*300 as sessionbin, count() as sessioncount from table group by round(sessiontime/300)300 order by session_bin 3) SELECT t1.country AS country_a, t2.country AS country_b FROM ( SELECT country, COUNT(*) AS session_count FROM yourtablename GROUP BY country ) AS t1 JOIN ( SELECT country, COUNT(*) AS session_count FROM yourtablename `GROUP BY countr"See full answer

Shashank K. - "Situation: Our company was going through tech stack updated and our team tasked to migrate existing code into Typescript(TS) and all future development to be written with TS within our codebase. TASK: Migrate existing codebase to TS and future integration to be TS compatible. ACTION: The team deep dived into picking up TS skill and learnt some basics and focused on delivering the migration in phases. I prioritised the files to migrate based on levels of complexity. I created a Fil"See full answer

Ankit kumar S. - "To analyze a year-over-year (YoY) slowdown in transactions, you should start by understanding the context, segmenting data, identifying potential drivers, and then formulating actionable recommendations. This involves a structured approach that includes a thorough examination of the data, both internally and externally. Understand the Context: Define "transactions": What specific transactions are being analyzed (e.g., website purchases, in-store purchases, total transactions)? Timeframe: Sp"See full answer

Kusheta K. - "In one of my projects, l analyzed customer purchase data for a retail company to under why sales were decrease"See full answer

Ankit kumar S. - " logo Contact Interview Preparation Application Process Career Advancement Onboarding and Orientation Common Interview Questions Dashboard Creation Interview Questions and Answers Dashboard Creation Interview Questions and Answers What is a dashboard? Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"See full answer

Kusheta K. - "After cleaning and organizing the data the dataset become retable and ready for analysis. This helped the tame make accurate decision based on clean data"See full answer

Christian B. - "with cte as (select ts.employee_id, e.name, t.id as test_id, max(distinct ts.score) as total from test_results as ts join tests as t on ts.test_id = t.id join employees as e on ts.employee_id = e.id group by ts.employee_id, e.name, t.id) select employee_id, name as employee_name, sum(total) as total_score from cte group by employee_id, employee_name order by total_score desc, employee_id asc ;"See full answer

Kusheta K. - "“I once worked with a dataset that had missing and inconsistent tracking. I first evaluated data quality, cleaned what was reliable, and documented assumptions. Then I collaborated with engineers to implement improved event tracking. This ensured more accurate analysis in the future and improved decision-making.”"See full answer

Ali H. - "SQL databases are relational, NoSQL databases are non-relational. SQL databases use structured query language and have a predefined schema. NoSQL databases have dynamic schemas for unstructured data. SQL databases are vertically scalable, while NoSQL databases are horizontally scalable."See full answer