 |
Locate the Top Companies in X Industry?
TOPIC: For this search you will locate top consulting companies in the human resources industry using Standard Industrial Classification Codes (SIC codes). The SIC code (SC=) locates both Primary and Secondary lines of business. You can also narrow the search to just the primary line of business as we will do in this search, using the Primary Classification code (PC=). Alternatively, SELECT the SIC (Standard Industrial Classification) code directly, if known.
D&B—Dun's Market Identifiers™ (File 516) is a good database for locating U.S. companies in a specific industry and then identifying the top 10 by sales.
Note: You can use other criteria to limit your search:
By State: S ST=WA (2-letter state postal code)
By Region: S RG=MIDWEST
By the headquarters: S SF=HEADQUARTERS
By the ultimate company location: S SF=ULTIMATE
By Employee size: S EM>=1000 (EM total employees)
By Employee location: S EH>=50 (EH location employees)
By Executives: S S1/NAMES limits records that contain at least 1 executive name
See the Bluesheet for other criteria.
COMMAND SUMMARY
BEGIN 516
EXPAND PC=8742
SELECT E number(s)
SELECT S1/SALES
SORT S2/ALL/SA,D
REPORT S2/CO,SA/1-10
HOW TO...
1. BEGIN 516, Dun's Market Identifiers.
2. EXPAND using
the 4-digit SIC code (Standard Industrial Classification
code) to identify the appropriate code. Note that
the more general category is Management Consulting
Services.
The "2+2" extensions to the 4-digit code are only applicable in the U.S. D&B files.
|
?b 516
File 516:D & B - DUNS MARKET IDENTIFIERS 2007/Sep
(c) 2007 D&B)
Set Items Description
--- ----- -----------
?e pc=8742
Ref Items Index-term
E1 892 PC=87419906
E2 712 PC=87419907
E3 135741 *PC=8742 (MANAGEMENT CONSULTING SERVICES)
E4 37984 PC=874200
E5 37984 PC=87420000 (MANAGEMENT CONSULTING SERVICES)
E6 4876 PC=874201 (INDUSTRIAL AND LABOR CONSULTING SERVICES)
E7 593 PC=87420100 (INDUSTRIAL AND LABOR CONSULTING
E8 577 PC=87420101 (AUTOMATION AND ROBOTICS CONSULTANT)
E9 828 PC=87420102 (INDUSTRIAL CONSULTANT)
E10 151 PC=87420103 (INDUSTRIAL HYGIENE CONSULTANT)
E11 426 PC=87420104 (MAINTENANCE MANAGEMENT CONSULTANT)
E12 244 PC=87420105 (MANAGEMENT ENGINEERING)
E13 1549 PC=87420106 (MANUFACTURING MANAGEMENT CONSULTANT)
E14 541 PC=87420107 (QUALITY ASSURANCE CONSULTANT)
E15 9995 PC=874202 (HUMAN RESOURCE CONSULTING SERVICES)
E16 3351 PC=87420200 (HUMAN RESOURCE CONSULTING SERVICES)
E17 1171 PC=87420201 (COMPENSATION AND BENEFITS PLANNING
E18 336 PC=87420202 (INCENTIVE OR AWARD PROGRAM CONSULTANT)
. . . . |
3. SELECT the appropriate E number(s).
4. Restrict your set to those companies that have SALES data available.
If you are looking for just the top 10 or 50 companies, you may want to limit your set even further before you sort, for example, companies with sales greater than $20 million
(S S2 AND SA>20M).
The smaller the set, the faster the results will be sorted. |
?s e15
S1 9995 PC='874202' (HUMAN RESOURCE CONSULTING SERVICES)
?s s1/sales
S2 9925 S1/SALES |
5. SORT the final set by sales in descending order.
|
?sort s2/all/sa,d
S3 9925 Sort S2/ALL/SA,D |
6. TYPE the first 10 records in Format 9 or use the REPORT command, choosing the fields you want to view.
|
?report s3/co,sa/1-10
DIALOG(R)File 516 :D & B - DUNS MARKET IDENTIFIERS
(c) 2007 D&B) All rts. reserv.
Company Sales
Name Dollars
------------------------------ -------------
Hewitt Associates, Inc. 2,857,161,000
Agl Resources Service Company 2,718,000,000
Watson Wyatt Worldwide, Inc. 1,271,811,000
Mercer Human Resource Consulti 852,300,000
Mercer Human Resource Consulti 850,000,000
Mpri, Inc. 545,562,528
New York State Environmental F 528,725,291
The Corporate Executive Board 460,623,000
Hewitt Associates, Inc. 438,900,000
B I 400,000,000 |
RELATED HOW DO I...? SOLUTIONS
NEED HELP?
Contact the Dialog Knowledge Center
Within North America +1 800 3 DIALOG (334
2564)
Outside North America 00 800 33 DIALOG (33
34 2564)
Web Form www.dialog.com/contacts/webform
|
You are viewing the
Click below to view the
 |
