Events & Promotions
|
|
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
Track
Your Progress
Practice
Pays
Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.
Jul 0811:30 AM EDT
-01:30 PM EDT
An interactive 2-hour class by Aditya Kumar to Establish clear structures & guidelines to enhance your decision-making and improve your speed and accuracy in Algebra.
Hussain15
Retired Moderator
Joined: 18 Jun 2009
Last visit: 07 Jul 2021
Posts: 1,076
Given Kudos: 157
Status:The last round
Concentration: Strategy, General Management
Schools: Stanford '14 (D) Booth '14 (D) Johnson '14 (D)
GMAT 1: 680 Q48 V34
10 Nov 2010, 05:22
Kudos
Bookmarks
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.
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.
https://www.microsoft.com/downloads/en/d ... laylang=en
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.
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.
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.
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.
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.
https://www.microsoft.com/downloads/en/d ... laylang=en
Attachments
Business School Dashboard-2010.xlsx [66.52 KiB]
Downloaded 1838 times
10 Nov 2010, 06:30
Kudos
Bookmarks
This looks absolutely fantastic!
Thank you for your work on this and putting your soul and mind into it.
Thank you for your work on this and putting your soul and mind into it.
10 Nov 2010, 06:51
Kudos
Bookmarks
I don't have the latest version to open the xlsx, is there a xls version? 
