Deloitte Data Analytics Management Reporting Analyst interview questions

- applied online; HR contacted and gave HR interview: basic technical & behavioral questions related to my software skills; - next was in-person interview with hiring manager; she was nice asked me questions on SQL coding; technical behavioral; career goals; after her interview she took a SQL quiz with 4 questions (moderately difficult); I somehow managed to pass em - final round was an excel case with the whole team. the excel case was easy but i completely messed it up because i didnt read the question properly and i did some other analysis then what i was told to do. it was a case about revenue & costing to see how can we analyze the data and recommend items to check and try to reduce costs and raise profit and what not - Excel case wasnt difficult but i messed it up; case presentation went well and I was honest to tell them that I did some other analysis than what i was told to do (but you know honesty didnt help) - few weeks passed and they said they took some1 else. I went to the final round and messed up the main case :(