combine large datasets. Suppose you’re given two datasets Company Locations, with the columns Company ID and Location, a
Posted: Thu Jul 14, 2022 2:17 pm
combine large datasets. Suppose you’re given two datasetsCompany Locations, with the columns Company ID and Location, andCompany Headcount, with the columns Company ID and Headcount.
Questions: If you want to create a single dataset with a companyID, location, and headcount, how would you do it? Assume for nowthat each company ID shows up in both tables. What tools would youuse? Depending on the tool, what function/syntax/query would youuse? Suppose Company Locations has company IDs that don’t appear inCompany Headcount. How would you create a single dataset with acompany ID, location, and headcount, but headcount is set to 0 forcompanies absent from the Company Headcount table? Suppose we havea table that stores Offer data with the following columns: Offer,Candidate, Recruiter, Application_Create_Date, Offer_Extend_Date.Questions: How would you calculate the average time from start tooffer to an extension? How would you calculate the number of offerseach recruiter extended? Suppose you have a second table with OfferID and Job Name. Using these two tables, how can you calculate thenumber of offers made under each job name in the last year?
Questions: If you want to create a single dataset with a companyID, location, and headcount, how would you do it? Assume for nowthat each company ID shows up in both tables. What tools would youuse? Depending on the tool, what function/syntax/query would youuse? Suppose Company Locations has company IDs that don’t appear inCompany Headcount. How would you create a single dataset with acompany ID, location, and headcount, but headcount is set to 0 forcompanies absent from the Company Headcount table? Suppose we havea table that stores Offer data with the following columns: Offer,Candidate, Recruiter, Application_Create_Date, Offer_Extend_Date.Questions: How would you calculate the average time from start tooffer to an extension? How would you calculate the number of offerseach recruiter extended? Suppose you have a second table with OfferID and Job Name. Using these two tables, how can you calculate thenumber of offers made under each job name in the last year?