1. Sample data was given from their Database, we had to draw insights using excel and explain our approach
2. Presentation round was more about explaining the insights, discussing how else we could have approached the same questions
3. A few business scenarios were discussed and our approach was judged
4. There was also a very easy SQL case study in the final interview round