Classic case question with sizing calculations. Some questions about project/cross-functional experience

The take home test was a bit different from others I have done in the past. You don't get a large data set to do a thorough analysis, but the test was still very interesting. It was very open ended so you can make it as complex/simple as you want. Onsite started with SQL test - subqueries was the max level expertise tested. The onsite had another analytics challenge, which was 1hr of you working on it and 45min of presenting. It felt like overkill given there was already a take home test, but it wasn't hard. The onsite also had a case study where you work with the interviewer and you would be working on a spreadsheet.