Business Analyst Role Interview Questions | Glassdoor

Business Analyst Role Interview Questions

5

Business analyst role interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

Can you tell me the percentage of applications that result in a hire (let’s call it the hire rate) grouped by location? List the hire rate for US by state and by country if the position was international. Table 1: applications candidate_id application_id job_title job_location_office_name application_create_date flag_hired -->***‘’hired = 1’’ Not hired = "0" ***<--- Table 2: google_offices office_name city state Country

1 Answer

select case when o.country = 'US' then o.state else o.country end AS location, sum(flag_hired)*1.0/count(*) percentage_hired from applications a left join google_offices o on a.job_location_office_name = o.office_name group by case when o.country = 'US' then o.state else o.country end

How many Swiggy orders get placed in a day in pune?

1 Answer

How many Uber bookings done in a day in Mumbai?

1 Answer

How many Vadapavs get sold in a day in pune??

1 Answer
15 of 5 Interview Questions