The Grandstand is located at the Northern End of Wankhede Stadium. Technically, it is located right behind the bowler's arm and is considered the best place for viewing the game.
In the above image, the Grand Stand is the one highlighted in Red.