Fanduel was by the worst interview process that I've been through. The main reason why I'm rating it as a negative is because of the poor communication from HR regarding the status of the interview, especially after they give an assignment, which the recruiter mentioned usually takes a week to complete. I applied for this role online, didn't even have a screening call with the recruiter. I was asked to complete a case study that had 3 parts. Part 1: Excel assignment Very simple, you were given an excel spreadsheet. They provided data on 11 sports stars, whey they have buy items against the clock. You have to perform tasks like Clean the name format of the players, compute the final price of the players given a discount, find the top spender in each category, create a control box chart. There were 11 total questions Part 2: SQL Given a schema of a database that consists of a user table, entry table, game table, and payments table. They asked the following questions: The CRM Manager has an idea for a test and wants to know how many users have made at least one deposit, registered in 2018, and played at least one NFL contest in 2018. What is the SQL code needed to answer this? You and the CRM Manager agree that the number of users is sufficient for this test. Now it’s time to generate the list of users to be sent the email. With the same constraints as above, you need to generate a list with the following fields, so that the CRM Manager can start to build custom segments: user_id email total entry fees for NFL in 2018 total entry fees for the other sports combined in 2018 the number of winning entries the user has ever had the percentage of entries on mobile across ALL sports in 2018 the last paid entry date of the user the total net deposit value, i.e. deposits – withdrawals The Marketing VP is concerned there has been a movement away from head-to-head (2 player) games over the last 3 years for NFL. S/he believes it may be a reason for declining retention and wants you to investigate. Specifically, s/he wants to know in each year between 2016 and 2018 what percentage of entries and entry fees were head-to-head games in each user’s first 30 days after registration. What is the SQL code needed to answer this? Part 3: Product Assessment FanDuel offers many DFS contests across many sports. The Contest Lobby is the place in our product where customers can find the DFS contests they want to enter. Contests in the Lobby are constantly being updated as contests fill (i.e. the maximum number of seats in the contest has been reached) and new contests become available. The order in which contests appear in the Lobby can change depending on which segments a customer belongs to (e.g. beginner, intermediate, advanced, a certain geography, etc.). If you haven’t already done so, feel free to create a FanDuel account and explore the Contest Lobby to get a feel for it. What key metrics would you look into to monitor the health of the Contest Lobby and why are these metrics important? Provide a list of specific ideas (at least 3) you have for improving the Contest Lobby along with any key metrics you feel would be relevant for measuring the success of these ideas, and your reasoning for why these metrics are relevant. In the second part of the product assessment, I was given a The attached fictitious dataset (titled: DATA for Product Assessment 2019) includes: FanDuel User ID Platform(s) used in the last 12 months (“native” = FanDuel iOS or Android app, “web” = desktop or mobile website) NFL entry fees in the last 12 months MLB entry fees in the last 12 months NBA entry fees in the last 12 months I had to answer the following questions: What does the data tell us about our business and our customers? Based on any findings or insights you’ve gleaned from the data, what specific recommendations do you have that could help the business grow, inform the prioritization of product and/or marketing efforts, etc.? For each of your recommendations, can you model out the value of what you’re proposing? Be sure to include notes about any assumptions you’ve made. The tasks weren't difficult; it was very time-consuming. After doing all this week, at least communicate the status after the interview.