What percent of all products in the grocery chain's catalog are both low fat and recyclable?
Data Interview Questions
132,990 data interview questions shared by candidates
Write a query that returns product_family, units_sold, percentage of promoted.
How do you educate yourself?
Are you interested in hearing more about the role?
The rest 30minutes was for algorithmic programming in language of your choice. I completed 3.5 questions in 30minutes.
Product questions heavily focused on FB products. How would you measure success of a new product? SQL assignment was to write a query which computes conversion rates for 2 products given the log of users actions with type of action for each product type.
Suppose the Recommended Friends team has updated the algorithm to analyze if the new algorithm is better than the old algorithm.
If the number of Facebook friend requests dropped by 10%, how would you investigate the problem as a data scientist?
Data Model: LinkedIn data model - model for 1st degree connection Python: 1. Dedup items in the list - retaining the order of items. ==> cannot use dict/set since order will not be retained. Follow up question on this - How would you handle nested lists? (they are looking for recursion) 2. Find the number of words in a sentence /avg length of word SQL On the product-sales-customers data model that is preloaded in coderpad.io, write the following queries 1. Count of stores in OR state with area_sqft > 25000 2. avg number of Female Customers group by state 3. Customer FirstName, Last Name and count of unqiue products purchased by state followup question - Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id))
Basic data structure and sql statement at a very high level short answers
Viewing 1151 - 1160 interview questions
See Interview Questions for Similar Jobs
Noc OperatorDatacenter TechnicianCirculation ManagerConfiguration Management AnalystComputer OperatorMedical Office SpecialistMedical Claims ProcessorManual Software TesterManager Marketing AnalyticsMedical Billing ClerkMarketing Analytics ManagerMedical ClerkMailroom ClerkMail Room ClerkMail SorterMedical Record Retrieval SpecialistMedical Office ReceptionistMedical Office ClerkManager Analytics