I work for a media / advertising company and my responsibility is to provide consumer insights for marketing planning and analyse the results / profitability of the marketing activities.
There is no such thing as an average day or duration of it in this business. There can be very hectic days when I deal with more than ten different client projects but sometimes I get to work on just one big project. On a typical day before my holdays this summer I was concentrating on big consumer segmentation projects however at the same time taking care of a large consumer study getting checked and coded and ready for use at our company.
It is so different every day - different tasks- different clients - different industries- different analysis methods you can use. It is very interesting and I love analysing consumer behaviour.
It can be very very hectic sometimes and sometimes you cannot put all the time you would like in interesting projects.
Practise, google, ask for help, google again. SPSS guides online are excellent. Maybe for excel you could take a lesson from someone who really knows how to use it like the shortcut keys etc.
I did not have any expectations as did not know such jobs exist.