Fractal Analytics Consultant-I (Analytics Profile) Interview Questions and Answers

Interview preparation tips for other job seekers - There are total 4 rounds. First was test, one SQL test by Doselect, which had some MCQs based on SQL and some queries, mainly of group by and joins. One was aptitude test.
Second round was technical round. It was based on CV and interviewer asked some questions of Excel, some of SQL and few from Tableau as I have written it in my CV.
Third round was Managerial + Technical, The person asked few questions like Why Analytics, One business related scenario and 2 SQL queries. I answered everything well but could not solve one query of SQL. I wasn't able to clear this round. I got rejection mail next day.
If I were able to clear this round, there was another round(last) HR round.