What salaries executives get?
(Taken from Annual Reports)
Once we build up a large database (say 100,000
executives/ 1000 companies), several interesting
ANAYLYSIS / PRESENTATIONS are possible
(1) Scattergram
Each as "salary" data is being added
daily/ continuously, it should be possible to plot Salary Vs. Age On the fly (On Internet or Extranet). Thereafter
a facility can be provided (to a surfer) to go along x axis and click on.
any desired "Age" value.
(of course the scattergram and the line of best fit
are already visible to him on the screen).
As soon as he clicks on "Age = 35" the
scattergram disappears.
over a
period of few years, with accumulation of salary - data of thousands of
executives, year after year, it would be possible to carry - out (and display
on screen) many types of
TREND ANALYSIS
Such "trend - analysis" could be repeated
for
. Any
given "Age"
. Any given
"Edu. Qualification"
. Any
given "Function"
. Any
given "Industry"
. Any
given "Designation - Level"
. Any
given "Company"
Also, we have to show
. Salary
Vs. Edu. Qualification
. Salary
Vs. Function
. Salary
Vs. Industry
. Salary
Vs. Designation Leave etc. etc.
(2) SPECIFIC COMPANY SALARY ANALYSIS
Any number of executives (especially personnel
Manager) would want to analyse, "Salaries of Executives of a Given
Company" Such a "given
Company" could be a competitor
or
The Industry - Leader (so that you can bench -
mark)
e.g. Videocon International (Ltd. Might wish to
Analyse salary details/ distribution of
. BPL
.
Godreg GE
.
Amtrex
.
Voltas
.
Philips etc
Personnel Manager of Videocon Might like to shoot a
query on our database as follows :
Pl. show me. salary details of Companies.
XYZ
ABC
LMN
PQR
A Minimum of
3 companies must be mentioned.
a. All
executive
b. Executives
belonging to function
c. Executives
with “designation- Level” of CMD/ MD/V.P etc.
d. Executives
in the age-group of 25-29/ 30-34/ 35-39/40-44 etc.
The result be displayed as a TABULATION or A GRAPH
( without revealing the actual names of the executives)
h.c.parekh
No comments:
Post a Comment