NEW HERE? LEARN MORE
closeclose
Last visit was: 24 Apr 2024, 05:41 It is currently 24 Apr 2024, 05:41
Decision Tracker
My Rewards
New posts
New comers' posts

Close
GMAT Club Daily Prep
Thank you for using the timer - this advanced tool can estimate your performance and suggest more practice questions. We have subscribed you to Daily Prep Questions via email.

Customized
for You

we will pick new questions that match your level based on your Timer History

Track
Your Progress

every week, we’ll send you an estimated GMAT score based on your performance

Practice
Pays

we will pick new questions that match your level based on your Timer History
Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.
Go to My Error Log Learn more
Close
Request Expert Reply
Confirm Cancel

International Business School Dashboard 2011

SORT BY:
Date
Kudos
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [28]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
International Business School Dashboard 2011 [#permalink] New post   23 Jan 2011, 11:37
24
Kudos
4
Bookmarks
Hi team, here we go for the MS Excel based dashboard of Int. business schools. After a great response on US schools dashboard, I was asked and was thinking myself too to work on the same data for non-US schools. Though the required info was a challanging task, as non-US schools dont share as much info as US schools do, I am able to finalize and present the required dashboard after googling various websites and contacting some current students.

Attached dashboard file is the first version and based on your suggestions, I will be plugging in some more info in the near future. Summarized info is shown below for your reference

Dashboard 1



1.I have gathered the data of these 17 schools only & will add new schools if required
Cranfield, ESADE, HEC-Paris, IE, IESE,
IMD, Insead, Ivey, Judge, LBS, Mancheser,
McGill, Queens, Rotman, Said, Schulich, SDA Bacconi.

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.


Business School Rankings



1.Forbes global mba rankings of this decade have been presented in the last sheet.
2.Two options are there, a single school ranking or ranking comparison between two schools can be viewed.
3. I was considering FT's and other rankings as well, but there was no uniformity in their data for the last 10 years.





Quote:
I was unable to find the "under graduate majors" of most recent classes of Judge, LBS and Manchester business schools. The "post graduate job functions" of recent graduated class of LBS and Said were also unavailable. If anyone can provide this info, that will be a great help.


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 (2003 version).
https://www.microsoft.com/downloads/en/d ... laylang=en
Attachments

Int. Business School Dashboard-Version 1.xlsx [44.85 KiB]
Downloaded 1287 times

User avatar
gurpreetsingh
SVP
SVP
Joined: 12 Oct 2009
Status:<strong>Nothing comes easy: neither do I want.</strong>
Posts: 2279
Own Kudos [?]: 3593 [0]
Given Kudos: 235
Location: Malaysia
Concentration: Technology, Entrepreneurship
Schools: ISB '15 (M)
GMAT 1: 670 Q49 V31
GMAT 2: 710 Q50 V35
Send PM
Reviews Badge
Re: International Business School Dashboard 2011 [#permalink] New post   23 Jan 2011, 11:45
I call it - Smart work !!

Thanks for the efforts and time spent for the community...
avatar
ssstan
Intern
Intern
Joined: 21 Jan 2011
Posts: 5
Own Kudos [?]: [0]
Given Kudos: 0
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   23 Jan 2011, 11:51
Really great work!

Thumbs up!!!
avatar
thfc
Manager
Manager
Joined: 07 Jan 2011
Posts: 57
Own Kudos [?]: 6 [0]
Given Kudos: 4
Schools:London Business School (Admitted), INSEAD (ding w/ interview), Cambridge (Admitted), HEC (Admitted)
GPA: 3.5
WE 1: 9 yrs in supply chain with experience in 4 countries
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   23 Jan 2011, 11:55
Thanks for all the effort put in! This is very useful.

Just noticed something small though - LBS is showing as having an enrolment of 802; I think the number is closer to 380-400. Also HEC Paris shows an enrolment of 451. I think the actual number is closer to 200.
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [1]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
Re: International Business School Dashboard 2011 [#permalink] New post   23 Jan 2011, 12:34
1
Kudos
Thanks for the comments.

@thfc:Thanks for the pointing the issue. The class size of both LBS & HEC Paris is shown in "Dashboard 2". The numbers you have mentioned are appearing in that second sheet. Yes the school enrollment seems awkward but it was that number that was appearing at business week website. To avoid any mis understanding I have uploaded the new file. Thanks again.
avatar
bozman
Intern
Intern
Joined: 05 Jul 2010
Posts: 17
Own Kudos [?]: [0]
Given Kudos: 1
Location: Seattle, WA
Schools:Cambridge (R2 Admit- will matriculate), Oxford (R2 invite- declined)
 Q45  V40
GPA: 3.48
WE 1: Supply Chain Manager- start-up biotechnology company
WE 2: Supply Chain Planner- Starbucks Coffee Company
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   15 Feb 2011, 10:35
This is great! Thanks so much for putting this together.

-Craig
User avatar
sdas
Senior Manager
Senior Manager
Joined: 23 Mar 2011
Posts: 365
Own Kudos [?]: 637 [0]
Given Kudos: 59
Location: India
Schools: Rotman '16 Ivey '15 Queens'16 INSEAD Jan '16
GPA: 2.5
WE:Operations (Hospitality and Tourism)
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   18 Apr 2011, 05:07
hi,might sound stupid. bt i am tryin to access the data, but i am unable to see comparisons of different schools.all i can see are the data already showing only (eg schullich). pls guide
User avatar
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Status:The last round
Posts: 1078
Own Kudos [?]: 3046 [1]
Given Kudos: 157
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
Send PM
GMAT ToolKit User
Re: International Business School Dashboard 2011 [#permalink] New post   22 Apr 2011, 22:26
1
Kudos
sdas wrote:
hi,might sound stupid. bt i am tryin to access the data, but i am unable to see comparisons of different schools.all i can see are the data already showing only (eg schullich). pls guide


Hi sdas.

I think you are on dashboard 2. Just click the drop arrow to see the other schools' info. To have comparison of different schools, you must go to dashboard 1 (the first sheet in the file). There you can use the drop down list and have your desired comparison.

Let us know, in case of any issue.
User avatar
S
MBACrystalBall
Director
Director
Joined: 06 Feb 2010
Posts: 545
Own Kudos [?]: 134 [0]
Given Kudos: 36
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   21 Jul 2011, 00:54
I liked the way you've used basic Excel features to give it a professional look. Packaged in a simple, elegant and useful manner.

Good work, buddy.

Kudos count going up.
User avatar
vgr
Manager
Manager
Joined: 06 Jun 2010
Status:Applying to schools
Posts: 58
Own Kudos [?]: 14 [0]
Given Kudos: 2
Location: India
Concentration: General Management, Strategy
Schools: NUS (D) Erasmus (WL) ISB (S) ESADE HKUST (II) NTU IE IIMA (A)
GMAT 1: 660 Q50 V29
GPA: 2.9
WE:Operations (Other)
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   19 Oct 2011, 13:53
awesome stuff. Thanks for the post.
avatar
miweekend
Intern
Intern
Joined: 29 Jun 2011
Posts: 12
Own Kudos [?]: 23 [0]
Given Kudos: 0
 Q33  V19
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   19 Oct 2011, 23:43
Hussain15 wrote:
Hi team, here we go for the MS Excel based dashboard of Int. business schools. After a great response on US schools dashboard, I was asked and was thinking myself too to work on the same data for non-US schools. Though the required info was a challanging task, as non-US schools dont share as much info as US schools do, I am able to finalize and present the required dashboard after googling various websites and contacting some current students.

Attached dashboard file is the first version and based on your suggestions, I will be plugging in some more info in the near future. Summarized info is shown below for your reference

Dashboard 1



1.I have gathered the data of these 17 schools only & will add new schools if required
Cranfield, ESADE, HEC-Paris, IE, IESE,
IMD, Insead, Ivey, Judge, LBS, Mancheser,
McGill, Queens, Rotman, Said, Schulich, SDA Bacconi.

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.


Business School Rankings



1.Forbes global mba rankings of this decade have been presented in the last sheet.
2.Two options are there, a single school ranking or ranking comparison between two schools can be viewed.
3. I was considering FT's and other rankings as well, but there was no uniformity in their data for the last 10 years.





Quote:
I was unable to find the "under graduate majors" of most recent classes of Judge, LBS and Manchester business schools. The "post graduate job functions" of recent graduated class of LBS and Said were also unavailable. If anyone can provide this info, that will be a great help.


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 (2003 version).
https://www.microsoft.com/downloads/en/d ... laylang=en


Thanks for putting these together. I wonder if we could add Warwick onto the list? However, not too sure if Warwick is in the same category in terms of B-School standard...pls advise. thanks!
avatar
avenkatesh007
Manager
Manager
Joined: 24 Oct 2011
Posts: 78
Own Kudos [?]: 25 [0]
Given Kudos: 27
Location: India
Concentration: General Management, International Business
Schools: Anderson FEMBA '16
GMAT Date: 11-29-2011
GPA: 3.5
WE:Web Development (Computer Software)
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   08 Dec 2011, 12:31
Thanks for the effort. was helful
User avatar
devansh_god
Manager
Manager
Joined: 24 Jan 2006
Posts: 194
Own Kudos [?]: 527 [0]
Given Kudos: 15
Location: India
Concentration: Finance, Entrepreneurship
Schools: Kenan-Flagler '14 (S) Olin (S) Owen '14 (S) Tippie (S)
WE:General Management (Manufacturing)
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   13 Dec 2011, 01:22
Kudos!!!! +1
avatar
bashu
Intern
Intern
Joined: 20 Sep 2010
Posts: 2
Own Kudos [?]: [0]
Given Kudos: 2
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   21 Dec 2011, 01:30
thank you! it was very helpful :)
avatar
haree
Intern
Intern
Joined: 09 Mar 2012
Posts: 10
Own Kudos [?]: [0]
Given Kudos: 0
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   09 Mar 2012, 09:28
Hmm thanks for sharing this wonderful post, I really like to your thread.It is quite helpful discussion according to me, thank you so much for the impressive post......
avatar
hola123
Intern
Intern
Joined: 05 Mar 2012
Posts: 12
Own Kudos [?]: 1 [0]
Given Kudos: 0
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   17 Apr 2012, 00:44
hi,

can you add St. gallen to it ?
avatar
terry0603
Intern
Intern
Joined: 05 Nov 2011
Posts: 1
Own Kudos [?]: [0]
Given Kudos: 0
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   22 Apr 2012, 04:37
excellent board
User avatar
MBAbot
Non-Human User
Joined: 01 Oct 2013
Posts: 910
Own Kudos [?]: 40 [0]
Given Kudos: 0
Send PM
Re: International Business School Dashboard 2011 [#permalink] New post   19 Jul 2019, 13:16
Hello from the GMAT Club MBAbot!

Thanks to another GMAT Club member, I have just discovered this valuable topic, yet it had no discussion for over a year. I am now bumping it up - doing my job. I think you may find it valuable (esp those replies with Kudos).

Want to see all other topics I dig out? Follow me (click follow button on profile). You will receive a summary of all topics I bump in your profile area as well as via email.
GMAT Club Bot
gmatclubot
Re: International Business School Dashboard 2011 [#permalink]
19 Jul 2019, 13:16

Powered by phpBB © phpBB Group | Emoji artwork provided by EmojiOne
Main navigation
GMAT Resources
Partners
MBA Resources
www.gmac.com|www.mba.com | | GMAT Club Rules | Terms and Conditions