|
Author |
Message |
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1296
Concentration: Strategy, General Management
|
Business School Dashboard 2010-US [#permalink]
Show Tags
 10 Nov 2010, 05:22
45
This post received
KUDOS
1
This post was
BOOKMARKED
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
_________________
[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]
I Can, I Will
GMAT Club Premium Membership - big benefits and savings
|
|
|
|
|
|
Founder
Joined: 04 Dec 2002
Posts: 15143
Location: United States (WA)
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
10 Nov 2010, 06:30
This looks absolutely fantastic! Thank you for your work on this and putting your soul and mind into it.
_________________
Founder of GMAT Club
US News Rankings progression - last 10 years in a snapshot - New!
Just starting out with GMAT? Start here...
Need GMAT Book Recommendations? Best GMAT Books
Co-author of the GMAT Club tests
|
|
|
|
|
|
Senior Manager
Joined: 25 Jul 2010
Posts: 300
Location: India
Concentration: Strategy, Technology
GPA: 3.2
WE: Engineering (Computer Software)
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
10 Nov 2010, 06:51
 I don't have the latest version to open the xlsx, is there a xls version?
|
|
|
|
|
|
Current Student
Joined: 31 May 2010
Posts: 138
Schools: Columbia - Class of 2013
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
10 Nov 2010, 11:52
2
This post received
KUDOS
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
_________________
GMAT Club Premium Membership - big benefits and savings
|
|
|
|
|
|
Senior Manager
Joined: 25 Jul 2010
Posts: 300
Location: India
Concentration: Strategy, Technology
GPA: 3.2
WE: Engineering (Computer Software)
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
10 Nov 2010, 11:59
ty!!!!!!!!!!!!! +1 for the link!
|
|
|
|
|
|
Intern
Joined: 29 Oct 2009
Posts: 10
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
11 Nov 2010, 14:06
Wow ... Great job! My first post (not sure .. but I guess) is for u 
|
|
|
|
|
|
Manager
Joined: 01 Apr 2010
Posts: 164
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
11 Nov 2010, 19:43
thanks for all the details... gr88 job!!!
|
|
|
|
|
|
Senior Manager
Joined: 06 Feb 2010
Posts: 435
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
11 Nov 2010, 20:16
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.
_________________
Sameer Kamat | Founder - MBA Crystal Ball | Email: info at mbacrystalball dot com
|
|
|
|
|
|
Manager
Joined: 27 Sep 2010
Posts: 72
Location: Kolkata, India
Schools: ISB, Terry MBA, University of Miami, HULT MBA, York University
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
11 Nov 2010, 21:36
Great Addition!!! KUDOS
_________________
If Life's a Game, I Play it in my way
|
|
|
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1296
Concentration: Strategy, General Management
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
11 Nov 2010, 22:45
2
This post received
KUDOS
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.
_________________
[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]
I Can, I Will
GMAT Club Premium Membership - big benefits and savings
|
|
|
|
|
|
Manager
Joined: 15 May 2010
Posts: 139
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
13 Nov 2010, 07:41
Thanks for this! Very cool. Encapsulates the nature of the community here! KUDOS
_________________
Rule #76: No excuses. Play like a champion!
|
|
|
|
|
|
Founder
Joined: 04 Dec 2002
Posts: 15143
Location: United States (WA)
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
13 Nov 2010, 20:50
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.
_________________
Founder of GMAT Club
US News Rankings progression - last 10 years in a snapshot - New!
Just starting out with GMAT? Start here...
Need GMAT Book Recommendations? Best GMAT Books
Co-author of the GMAT Club tests
|
|
|
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1296
Concentration: Strategy, General Management
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
14 Nov 2010, 01:27
1
This post received
KUDOS
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!!! 
_________________
[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]
I Can, I Will
GMAT Club Premium Membership - big benefits and savings
|
|
|
|
|
|
Manager
Joined: 26 Aug 2010
Posts: 71
Location: India
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
14 Nov 2010, 09:34
This is terrific! Outstanding work... +5 to you!
_________________
Spread some happiness..Press Kudos!
|
|
|
|
|
|
Manager
Joined: 20 Apr 2010
Posts: 210
Schools: ISB, HEC, Said
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
15 Nov 2010, 03:38
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
|
|
|
|
|
|
Retired Moderator
Status: The last round
Joined: 18 Jun 2009
Posts: 1296
Concentration: Strategy, General Management
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
15 Nov 2010, 03:45
1
This post received
KUDOS
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.
_________________
[ From 470 to 680-My Story ] [ My Last Month Before Test ]
[ GMAT Prep Analysis Tool ] [ US. Business School Dashboard ] [ Int. Business School Dashboard ]
I Can, I Will
GMAT Club Premium Membership - big benefits and savings
|
|
|
|
|
|
Manager
Status: Dream on, till your dream comes true!
Joined: 11 Sep 2010
Posts: 99
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
15 Nov 2010, 13:38
Fantastic
|
|
|
|
|
|
Manager
Status: Will Retake GMAT
Joined: 30 Jul 2010
Posts: 130
Location: India
Concentration: General Management, Entrepreneurship
GPA: 3.11
WE: Information Technology (Computer Software)
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
16 Nov 2010, 14:56
You really rock man....really great work.. +1
_________________
Re-taking GMAT. Hope the charm works this time..
|
|
|
|
|
|
Manager
Joined: 16 Jul 2010
Posts: 148
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
17 Nov 2010, 01:14
thanks! great job!!
|
|
|
|
|
|
Manager
Joined: 07 Jan 2010
Posts: 143
Location: So. CA
WE 1: 2 IT
WE 2: 4 Software Analyst
|
Re: Business School Dashboard 2010-US [#permalink]
Show Tags
20 Nov 2010, 13:11
+1 too bad its not web based but its still awesome!
|
|
|
|
|
|
|
Re: Business School Dashboard 2010-US
[#permalink]
20 Nov 2010, 13:11
|
|
|
|
|
Go to page
1 2 3
Next
[ 41 posts ]
|
|
|
|
|
|
|
|
23
