Numerator Client Service Analyst interview questions

This is a warning for anyone thinking about interviewing with Numerator, it is a COMPLETE WASTE OF YOUR TIME!! Phone screening with recruiter - pretty standard Teams call with the hiring manager for about 30 minutes. Mine went really well and an hour after I received an email that she really liked me and wanted me to do the case study. The case study is ridiculous. They send you two MASSIVE excel files, one of messy raw data, one with survey data, it's a lot. The case study itself isn't difficult solving a hypothetical business question/solution. I spent a LONG TIME on my presentation, and turned it in confidently. About two hours after turning it in, they scheduled a panel interview with four people for me to present and answer questions. I thought my presentation was very solid, and I thought all of my answers afterward were perfect. I walked away from the interview CONVINCED I was going to get an offer by the next week. INSTEAD the next day, the recruiter told me with no explanation they decided not to go with me. I literally thought I was being punked or read the email wrong, there was no way after that amazing interview and presentation, ALL THE TIME I SPENT on the case study, that I didn't get an offer? I would not waste my time with this company, I'm not even sure if they are actually hiring or need anyone - or if they are just bored and looking to waste peoples time who are on the job market. Please take it from me, do not....DO NOT waste your time on this case study.