Tuesday, June 29, 2010

Hofstede Strikes Again!

This is going to be short and sweet.

I first heard about Hofstede and his work on cross-cultural dimensions in my OB class first semester. Lo and behold, he did not stop there. The next time he appeared, it was in my OT class. The last time I saw him, it was during my cross-cultural management class last semester. Now, I wasn't entirely surprised to see him in any of those classes, but here I am, minding my own business, and boom! He's back. I've been studying for the IT waiver exam and, once again, the man appears. It's rather impressive. His research ends up in almost all of the management texts that deal with cross-cultural differences. You can check out some of his work here. I did not expect to see him again, especially not in an IT text. But there you have it. He's a legend.

No news on the internship front...same old, same old. Peace out.

Sunday, June 20, 2010

Finding a Place to Live on Another Contintent is Difficult...

...It turns out. The last two weeks have been a little bit of a mess, so I apologize for the late post. Between work and finding a place to live in Germany, I've had very little time to myself.

Over the last two weeks, I've come very close to finishing the performance metrics project I've been working on for the last couple of months. All I have left is completing the new charts, which makes me so happy. As fun as going through all this data has been, I'm ready to move on. My next project is creating a pivot table for the 2009 media buying financials, which I've been working on intermittently throughout the last month.

The much more exciting part of my life is figuring out where I'm going to live while I'm studying at EBS in Germany. It's been quite the experience. First, EBS doesn't have any dorms per se, instead, they own a number of buildings with various flats in them. That being said, the university housing is limited. Second, housing is leased on a first come, first serve basis. What does that mean for someone living on the West coast? Emails get sent out between 2 and 4 am with housing offers. By the time I get to work and am able to check email, all of the housing has already been rented. Finally, I found a way to beat the system: keep my phone on all night and check email as it comes in. Needless to say, it took be four tries, but I finally got this great single flat in a back house in Hallgarten about 3 km away from EBS. This is great news because I have an over-whelming need to control and plan things, and this was something I was losing sleep over.

I hope all your fathers out there are having a great father's day. I've got four more weeks of my internship, so things are quickly coming to a close. Have a great week!

Monday, June 7, 2010

Data: Why are you so difficult to track down?

My first order of business to let everyone know that my friend Lindsay and I have been writing about our gastro-escapades at our 321 Eat! blog (click here to check it out). We've had a great time eating! We hope you may have a great time reading...and then eating :).

Okay, moving on. The last few weeks have been rough at my internship, mainly because our data keeps on changing, which is extremely frustrating for me because I have to keep updating our databases. Basically, this project has gotten a bit more complex. Initially, I was just creating a performance index, but I have been working on a number of other metrics as well including admissions per capita and cost per admissions using an adjusted media spend by title and country. To give you a taste for how much data we're talking about, I'm doing an analysis of 11 films on 23 countries with about 20 variables per film. That's a lot of numbers! Now, initially I thought my job was done, because I had done a quality control on the spreadsheet and found all of the kinks, but then I found out my boss wanted me to create a fully-updating document, which means rebuilding the entire spreadsheet to include source documents and a whole lot of linked cells. Great, I can totally do that. It will take time, but it's definitely something that I can handle (y'all will get so good with Excel. It's like, a miracle program!).

First, I need to gather all the source documents, most of which are at Fox and not readily available to Fox. So we start contacting people and I get the first round of data in. I'm a bit OCD, so I start checking this new data with the original data we had (I did not build the first spreadsheet, I just updated and QC'd it, so I wasn't sure if the numbers were good). Of course, I find tons of discrepancies. This is troubling. We want the data to be as up-to-date and reliable as possible. Making a long story short, I've gone through a number of data revisions due to the fact that none of the data from the various databases match up. I'm just crossing my fingers that this is the most updated version of the data and I will no longer have to swap the data out.

The great thing about this spreadsheet is that it is going to be fully update-able in the future. All one has to do is switch out the original data, as long as everything is in the same format. There are dozens of charts and formulas that will be updated every time data is switched out and/or updated. Life will be so easy! Also, the spreadsheet has all of the original source materials in it, which makes it easier to track down where the numbers came from and check quality. There will also be two different ways to display the data: by territory and by title. This allows users to not only see how a film did across territories, but also see how different films did within a single territory by benchmarking against territory-wide standards.

Anyways, it sounds tedious, and it is. But it's also really interesting to see the patterns that begin to emerge. U.S. films are doing really well in some of the emerging markets including Russia, Brazil, and Malaysia. Europe is a more difficult region to compete in, especially because their domestic film markets are doing really well. I get to go back to work tomorrow. I'm hoping to finish the project up this week (I'm keeping my fingers crossed).