Well, from it sounds like, the lower decks for the poor folks were locked off which made it impossible to get outside. So, don't go there.
From what I've seen, the boat rose up and then cracked in half. The middle would be bad because you're going to end up plummeting into the water along with a whole mess of wood, metal, and screaming bodies. I don't recommend that either.
The prow rose the highest and that is probably not a roller coaster ride you would enjoy. If you don't have a way of bracing yourself, that is probably not a good place either.
The furthest part in the back is also probably bad because the impact with the iceberg is going to cause everything to shake violently and anyone on the rear decks are probably going swimming.
Likewise, large rooms filled with glass windows are going to be deadly as everything shatters. Not to mention you're going to have to walk through that.
Crowds in general are going to do what crowds do which means you get a fluid-like dynamics in the panic. This means that your danger is less being crushed by people. The biggest danger is when the "ripples" of people push back, you are most likely to be knocked off your feet. So, having some sort of wall to brace against will help with this too.
So, I'd say near the back and near the lifeboats. Somewhere relatively small and able to handle jostling, such as a linen closet or somewhere you can bounce off the walls, recover, and head to the boats right away.
If you are one of the first on the boat to help others, that would be best for getting on and out of there. I'd also make sure there were better supplies under the seats if you could.
Now, if you happen to fall in the water, I highly recommend you avoid massive wooden doors with just one person on them. They don't share and you are going to dramatically drown.