Business School Dashboard 2010-US

Hussain15 · **Posted:** Wed Nov 10, 2010 5:22 am

Hi team, here we go with the excel based business school dashboard. After a great response of the gmat prep analysis tool, I was thinking of some thing big with greater scope & covering a detailed area. Nothing could be more important than the b.schools' data itself, so I thought for an Excel based B.School Dashboard project. Here I am presenting the very first version to get some feedback from the community. Based upon your suggestions, I will plug in more data & functions & then will share the updated version in 2011.

Dashboard 1

1.I have gathered the data of these 17 schools only & will add new schools if required
Booth,Columbia,Cornell,Darden,Fuqua,Haas,
HBS,Kellogg,McCombs,MIT,Ross,Stanford,
Stern,Tuck,UCLA,Wharton,Yale

2. There are currently six areas of information that are presented in the form of graphs. The new information points can be added depending on your suggestions.
3. The data is taken from Business Week website.
4. Comaprison can be seen for 4 schools at a time.

Dashboard 2

1.Individual school info is presented.
2.Four categories are there showing the information regarding "total applicants vs enrolled class", "male vs female", "under grad majors" & Post MBa job functions of the most recent MBA classes of each school.
3.No comparison is shown here, instead all the info can be seen against a single school at a time.

School Rankings

1.BW & USN rankings of this decade have been presented in two separate sheets.
2.Two options are there, a single school ranking or ranking comparison between two schools can be viewed.

Specaility Rankings

1. US News speciality rankings for 2010 can be viewed.
2.Accounting, Finance, Entrepreneurship, Marketing, Management & Non-Profit wise rankings are presented.

I hope you will find this dashboard useful & will share your valuable feedback with us.

Check this link for opening the file in xls format.
http://www.microsoft.com/downloads/en/d ... laylang=en

bb · **Posted:** Wed Nov 10, 2010 6:30 am

This looks absolutely fantastic!
Thank you for your work on this and putting your soul and mind into it.

srjaidev · **Posted:** Wed Nov 10, 2010 6:51 am

I don't have the latest version to open the xlsx, is there a xls version?

malbec · **Posted:** Wed Nov 10, 2010 11:52 am

great file!! thanks for sharing it and kudos for you!

srjaidev wrote:

:( I don't have the latest version to open the xlsx, is there a xls version?

you can download a compatibility pack to see files of the new version from here:
http://www.microsoft.com/downloads/en/d ... laylang=en

srjaidev · **Posted:** Wed Nov 10, 2010 11:59 am

ty!!!!!!!!!!!!! +1 for the link!

sisqokc · **Posted:** Thu Nov 11, 2010 2:06 pm

Wow ... Great job!
My first post (not sure .. but I guess) is for u ;-)

srivicool · **Posted:** Thu Nov 11, 2010 7:43 pm

thanks for all the details... gr88 job!!!

MBACrystalBall · **Posted:** Thu Nov 11, 2010 8:16 pm

Great work, Hussain.

Jaidev's suggestion of using an earlier version of excel (.xls instead of .xlsx) might be worth looking into. Many GC members may not have the latest version.

subhabrata1986 · **Posted:** Thu Nov 11, 2010 9:36 pm

Great Addition!!! KUDOS

Hussain15 · **Posted:** Thu Nov 11, 2010 10:45 pm

Thanks for all the comments!

I have added the link posted by malbec in my post, the link will guide you to the MS Office compatibility pack. I will also try to add the xls file soon.

Rux10 · **Posted:** Sat Nov 13, 2010 7:41 am

Thanks for this! Very cool. Encapsulates the nature of the community here! KUDOS

bb · **Posted:** Sat Nov 13, 2010 8:50 pm

Hussain15 wrote:

Thanks for all the comments!

I have added the link posted by malbec in my post, the link will guide you to the MS Office compatibility pack. I will also try to add the xls file soon.

If I can cast a vote - I would suggest keeping only one version of the file (otherwise, you get into issues with version management, etc). The compatibility pack works very well (I have used myself) and should be enough for everyone with office pre-2007.

Hussain15 · **Posted:** Sun Nov 14, 2010 1:27 am

bb wrote:

Hussain15 wrote:

Thanks for all the comments!

I have added the link posted by malbec in my post, the link will guide you to the MS Office compatibility pack. I will also try to add the xls file soon.

If I can cast a vote - I would suggest keeping only one version of the file (otherwise, you get into issues with version management, etc). The compatibility pack works very well (I have used myself) and should be enough for everyone with office pre-2007.

Agreed!!!

samark · **Posted:** Sun Nov 14, 2010 9:34 am

This is terrific! Outstanding work...

+5 to you!

prashantbacchewar · **Posted:** Mon Nov 15, 2010 3:38 am

1. Is it possible to include some of the European schools such as LBS,INSEAD,HEC, IMD, and asian schools such as NUS,ISB.

2. Also if we can have figures if avg outgoing salary

Hussain15 · **Posted:** Mon Nov 15, 2010 3:45 am

prashantbacchewar wrote:

1. Is it possible to include some of the European schools such as LBS,INSEAD,HEC, IMD, and asian schools such as NUS,ISB.

2. Also if we can have figures if avg outgoing salary

The dashboard of International business schools is in pipe line. & yes we can add the avg post MBA salary of each school in the dashboard. I will do so in the next version.

kyro · **Posted:** Mon Nov 15, 2010 1:38 pm

Fantastic

piyushagarwal · **Posted:** Tue Nov 16, 2010 2:56 pm

You really rock man....really great work.. +1

Werewolf · **Posted:** Wed Nov 17, 2010 1:14 am

thanks! great job!!

gtr022001 · **Posted:** Sat Nov 20, 2010 1:11 pm

+1 too bad its not web based but its still awesome!

Similar topics	Author	Replies	Views	Last post
International Business School Dashboard 2011 in The B-School Application - Canada, South America, Asia, Australia and Europe	Hussain15	10	4328	Sun Jan 23, 2011 11:37 am
A typical busy day at business school.... in Business School Life	refurb	5	1631	Fri Sep 25, 2009 3:02 pm
Rutgers Business School vs Lubin Business School? in Part Time MBA Programs	oliverm	2	750	Tue Nov 20, 2007 7:34 pm
Medical School VS Business School in Off Topic Discussions and Everything Else	candylynn83	5	1262	Fri Nov 10, 2006 5:48 pm

Business School Dashboard 2010-US

Who is online

Main Navigation

GMAT Resources

Partners

MBA Resources