Muutke küpsiste eelistusi

E-raamat: Human Capital Systems, Analytics, and Data Mining

(Golden Gate University, California, USA)
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 58,49 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Human Capital Systems, Analytics, and Data MiningSuurem pilt
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Human Capital Systems, Analytics, and Data Mining provides human capital professionals, researchers, and students with a comprehensive and portable guide to human capital systems, analytics and data mining. The main purpose of this book is to provide a rich tool set of methods and tutorials for Human Capital Management Systems (HCMS) database modeling, analytics, interactive dashboards, and data mining that is independent of any human capital software vendor offerings and is equally usable and portable among both commercial and internally developed HCMS.

The book begins with an overview of HCMS, including coverage of human resource systems history and current HCMS Computing Environments. It next explores relational and dimensional database management concepts and principles. HCMS Instructional databases developed by the Author for use in Graduate Level HCMS and Compensation Courses are used for database modeling and dashboard design exercises.

Exciting knowledge discovery and research Tutorials and Exercises using Online Analytical Processing (OLAP) and data mining tools through replication of actual original pay equity research by the author are included. New findings concerning Gender Based Pay Equity Research through the lens Comparable Worth and Occupational Mobility are covered extensively in Human Capital Metrics, Analytics and Data Mining Chapters.

Arvustused

Use the data, or ignore it at your peril. In the times we now live in, no company is without relevant, useful, actionable data on how we are performing, our staff, our suppliers, and many many more aspects of our businesses. If you dont effectively monitor, analyse and interpret this data, then you are leaving yourself open to being overtaken by your rivals, who, you can be sure, are doing exactly this.

This book thoroughly and methodically takes you through a series of ways in which you can, and should be using this data to your advantage. Weve heard all the cliches and truisms about data being the new oil, but unless you know how to use it, then it could just be a meaningless pool of ones and zeroes to you. With a series of comprehensive and informative screenshots this book takes you through many areas in which the data can provide invaluable insights. It will be interesting to see if they decide to release video tutorials to accompany this book and the various chapters that they cover.

This book seems to be a clear example that data analysts are becoming more and more important as so much of our working lives becomes digitised and leaving a digital footprint. A useful tool for those working at the coalface in this sector.

-Simon Cocking, Irish Tech News

Preface xvii
Author xix
Trademarks and Copyrights xxi
Chapter 1 Human Capital Management Systems
1(14)
State of Affairs
1(1)
Policies, Systems, and Culture
2(2)
Purpose and Design of Human Capital Management Systems
4(1)
Computing Environments
5(1)
On Premises, Software as a Service, Platform as a Service, Infrastructure as a Service, Hybrid
5(1)
Advantages and Disadvantages of Cloud Computing
6(1)
On Premises
7(1)
Software as a Service
7(1)
Platform as a Service
7(1)
Infrastructure as a Service
8(1)
Hybrid
9(1)
Development, Test, and Production Environments
9(1)
Cloud/Hosted Solution Challenges
9(1)
Support
9(1)
Performance
9(1)
Customization
9(1)
Security
10(1)
Systems Acquisition and Development
10(1)
Needs and Gap Analysis
10(1)
System Specifications and Requirements
10(1)
Vendor/Solution Team Search Process
11(1)
Departmental Computing
12(1)
HCM Professional System Skills
12(1)
Chapter Summary
12(1)
Review Questions
13(1)
Case Study
14(1)
References
14(1)
Chapter 2 Human Capital Management System Components
15(26)
Relational Database Management System Organization
15(1)
Employee Base Information
15(1)
Employee Profile
16(1)
Rating
16(1)
Management Level
16(1)
Department
16(1)
Location
16(1)
Performance Management
16(23)
Eeo Audit and Compliance
18(1)
Position and Job Classification
18(3)
Compensation and Benefits
21(1)
Job-Related Database Tables
21(1)
Job Level Table
21(1)
Job Family
22(1)
Occupation
23(1)
Salary Grade/Band Related Tables
24(1)
Structure Table
24(1)
Region
24(1)
Salary Grade/Band Table
25(1)
Salary Range Table Built-In Calculation Options
26(1)
Annual Range Data Elements
26(1)
Salary Grade Range Data
26(1)
Job Classification Table
27(1)
Data Elements
27(1)
Internal Compensation Target Table
27(1)
Data Elements
28(1)
Internal Staff Compensation Data Table
28(1)
Salary Survey Data Related Tables
28(1)
Source
29(1)
Data Elements
29(1)
Data Status
29(1)
Source Job Code
29(1)
Adjustment Factors
29(1)
Region
30(1)
Sector
30(1)
Variable Compensation Plan
31(1)
SIC
31(1)
Job Level
31(1)
Geographic Responsibility Table
31(1)
Competitive Survey Data Table
31(1)
Survey Statistic Table
31(1)
Salary Survey Statistical Analysis Components
32(1)
Compensation Component Allocation Key Performance Indicators
32(1)
Salary Survey Analysis Related Table Reports and Charts
32(1)
Internal Salary Analysis Related Table Reports and Charts
33(2)
Position Control
35(1)
Talent Acquisition/Recruitment
36(1)
Payroll
37(1)
Benefit Plans
38(1)
Departmental Computing
39(1)
HCM Professional System Skills
39(1)
Chapter Summary
39(1)
Review Questions
39(1)
Case Study
40(1)
References
40(1)
Chapter 3 Database Systems, Concepts, and Design
41(22)
Database Systems
41(1)
Relational Database Management Systems
41(1)
Relational Database Management System Table Structures
42(1)
Database Normalization
42(1)
Relational Database Management System Physical Schemas With Related TABLES
43(8)
Third Normal Form
43(1)
Data Modeling Notation
44(1)
Table Relationships
45(4)
Referential Integrity
49(2)
Data Types
51(4)
Sql
52(1)
Ddl
52(3)
Deploying Data Models in Relational Database Management Systems
55(1)
Sql Server 2016/2017 Installation---Free Developer Edition With Tutorial
56(4)
Feature Selection
57(1)
Database Engine Configuration
57(2)
Analysis Services Mode Option
59(1)
Chapter Summary
60(1)
Review Questions
60(1)
Case Study---Relational Database Design
61(1)
References
62(1)
Chapter 4 Dimensional Modeling
63(18)
Relational Database Design Review
63(1)
Installation of Oracle Sql Developer Data Modeler With Tutorial
64(1)
Data Modeler Preferences
64(2)
Loading a Data Model
66(1)
Data Model Design Modification
66(1)
Relational Design Exercise With Data Modeler Tutorial
66(4)
New Table
67(1)
Table Properties
67(1)
Foreign Key Definition
68(2)
Dimensional Modeling
70(1)
Dimensional Databases
71(1)
Star Schemas
72(1)
Dimensional Design With Tutorial
72(2)
Online Transaction Processing Third Normal Form to Star Schema Design Conversion Steps---Employee Review Schema
74(3)
Loading of Data into Data Warehouse and Online Analytical Processing Databases
77(1)
Data Warehouses and Data Marts
77(1)
Chapter Summary
78(1)
Review Questions
78(1)
Case Study---Multidimensional Olap Database Star Schema Design
79(1)
Dimensions
79(1)
Measures
79(1)
References
79(2)
Chapter 5 Reporting and Analytics with Multidimensional and Relational Databases
81(22)
Reporting and Analytics Using Star Schema Structured Query Language Server Database With Tutorial
81(2)
Loading the hcmsadm Employee Review Star Schema Database
82(1)
Power Bl Desktop With Tutorial
83(2)
Installation
83(1)
Connecting to Employee Review Star Schema Database
83(1)
Table Selections
84(1)
Analytics and Charts in Power Bi Desktop With Tutorial
85(1)
Slicer Objects
85(1)
Copying Charts
85(3)
Gender Average and Median Wage Comparisons by Department
88(1)
Dashboards With Tutorial
88(13)
Compensation Analytics Dashboard Development
89(1)
Dashboard Exercise---Salaries by Gender and Job Family
89(3)
Interactive Dashboards with Analytics
92(1)
Employee Merit Increase Interactive Dashboard
92(1)
Salary Range Distribution and Compa-Ratio Analysis
92(2)
Pay Policies and Market Competitiveness
94(1)
Quartile Distribution Chart
94(2)
A Closer Look at Compa-Ratios
96(1)
Salary Range Distribution and Compa-Ratio Analysis Interactive Dashboard
97(1)
Diversity Analysis
97(2)
Salary Range and Compa-Ratio Diversity Dashboard
99(2)
Chapter Summary
101(1)
Case Study---Interactive Dashboard Exercise With Bi Desktop
101(1)
Review Questions
102(1)
References
102(1)
Chapter 6 Online Analytical Processing and the OLAP Cube Multidimensional Database
103(24)
Multidimensional Olap Cubes
103(2)
OLAP Drill Down
104(1)
Dimensional Reporting
104(1)
Accessing OLAP Cubes
104(1)
Fedscope Olap Database Overview With Tutorial
105(2)
Pay Equity Research Part I---Gender Wage Gap and Comparable Worth Analysis With Tutorial
107(18)
FedScope Pay Equity Research Tutorial
109(1)
Measures and Dimensions
110(1)
Gender-Based Comparisons of Average Salaries
110(3)
Adding Calculated Columns in FedScope OLAP Database Viewer
113(5)
Early Observations---Gender-Based Pay Differences
118(1)
Gender-Based Pay Comparisons for Jobs of Equal Value or Comparable Worth with Tutorial
118(1)
Averages Distort Actual Differences
119(1)
OLAP Database Analysis with Excel with Tutorial
119(4)
Gender Pay Comparison Conclusions for Jobs of Comparable Worth
123(1)
Bureau of Labor Statistics Current Population Survey Pay Equity Studies versus FedScope OLAP Database Analytics
123(2)
Chapter Summary
125(1)
Review Questions
125(1)
Case Study---Fedscope Online Olap Employment Database---Time Dimension Comparisons
125(1)
References
126(1)
Chapter 7 Multidimensional OLAP Database Project with SQL Server Analysis Services
127(38)
Multidimensional Project Overview
127(1)
Fedscope Modified Employment Star Schema
127(2)
Restoring Modified Fedscope Database From Author's Website With Tutorial
129(2)
Multidimensional Modeling of Fedscope Employment Data
131(1)
Installation of Visual Studio 2017 Community Edition
131(1)
Visual Studio Microsoft Analysis Services Extension Installation With Tutorial
131(1)
Visual Studio 2017 New Multidimensional Project Fedscope Olap With Tutorial
132(1)
Data Source Definition
133(2)
Data Source View Definition
135(2)
Data Source View---Exploring Data
137(1)
New Multidimensional Olap Cube
138(1)
Cube Measures Selection
139(1)
Cube Dimensions Selection
140(1)
Building and Deploying the Multidimensional Database Solution
141(1)
Olap Cube Processing
142(2)
Working With Analysis Services Multidimensional Database and Olap Cube After Project Solution Build and Deployment With Tutorial
144(1)
Dimension Attribute Usage
144(1)
Adding Dimension Non-Key Attributes to Cube Structure
145(2)
Size Comparisons: Analytical Services Multidimensional Olap Database Versus Data Source Sql Server Database
147(1)
Named Calculations in Data Source View
148(7)
Cube Fact Measure Aggregation Options
155(4)
Browsing the Cube With Tutorial
159(1)
Basic Visual Studio Cube Browser
159(3)
Chapter Summary
162(1)
Review Questions
162(1)
Case Study---Olap Calculated Fields
163(1)
References
163(2)
Chapter 8 Multidimensional Cube Analysis with Microsoft Excel and SQL Server Analysis Services
165(18)
Analyze in Excel With Tutorial
165(1)
Pivot Table Tools
166(1)
Pay Equity Research Part II: Gender Wage Gap, Comparable Worth and Length of Service With Tutorial
167(1)
Multidimensional Cube Analysis With Excel Pivot Tables
167(5)
Federal Classification and Evaluation Systems
172(1)
Job Analysis and Job Evaluation
173(1)
Female Upward Job Mobility
174(1)
Gender-Based Mobility Gap Analysis With Tutorial
174(1)
Length of Service Considerations
175(2)
Length of Service Quotients
177(1)
Pivot Table Charting With Tutorial
177(2)
Filtering Dimension Value Choices in Pivot Charts
179(2)
Chapter Summary
181(1)
Review Questions
181(1)
Case Study---Pivot Table Added Calculations
182(1)
References
182(1)
Chapter 9 Data Mining
183(32)
Origins of Data Mining
183(1)
Olap Versus Data Mining
183(1)
Supervised Versus Unsupervised Learning
184(1)
Decision Trees
184(1)
Data Mining Projects With Sql Server Analysis Services
184(1)
Pay Equity Research Part III With Tutorial
184(12)
Opening the SQL Server Analysis Services Database
185(1)
Building a Decision Tree Data Mining Model
185(1)
Data Mining Wizard
185(3)
Mining Structure Processing
188(3)
Continuous versus Discrete Variables
191(1)
Data Mining Legend
192(1)
Adding Variables to Mining Structures
193(2)
Viewing the Decision Tree
195(1)
Mining Model Content Viewer
195(1)
Gender Mobility Issues---Upper Pay Grades
196(2)
Dependency Network View
196(2)
Gender Mobility Issues---Occupation Categories
198(3)
Clustering With Tutorial
201(9)
Association Rules With Tutorial
210(3)
Chapter Summary
213(1)
Case Study
213(1)
Review Questions
213(1)
References
214(1)
Chapter 10 Project Management
215(12)
Project Management Overview
215(1)
Systems Development Life Cycle
216(4)
Project Definition
216(1)
Project Charter
216(1)
Project Scope
217(1)
User Requirements Definition
217(1)
Functional Requirements
217(1)
Data Requirements Definition
218(1)
Analysis and Design
218(1)
System Build
219(1)
Implementation and Training
219(1)
Sustainment/Maintenance
219(1)
Hcms Project Team
220(1)
Project Plan
221(1)
Work Breakdown Structure
221(1)
Wbs History
221(1)
Chapter Summary
222(1)
Review Questions
223(1)
Case Study---Project Management
223(2)
Individual Case Study Deliverables
224(1)
References
225(2)
Appendix A Sql Data Types 227(2)
Appendix B Sql Database and Analysis Server Database Scripts 229(2)
Appendix C Microsoft Sql Server Analysis Services Aggregation Options 231(2)
Appendix D U.S. Cdc Project Charter Template 233(10)
Appendix E Sample Human Management Capital System Request For Information 243(8)
Appendix F Human Capital Management System Request For Proposal 251(10)
Appendix G Sample Human Capital Management System Project Plan 261(4)
Index 265
Robert C. Hughes, MS, has over 40 years of experience in Human Capital Management

and Information Systems that includes internal and external consulting engagements

in Compensation Planning and Human Capital Management Information Systems.

Mr. Hughes is currently an Adjunct Professor in the Ageno School of Business at Golden

Gate University in San Francisco.

Mr. Hughes has taught courses in Compensation, Management Information Systems,

Data Warehousing, Business Intelligence and Predictive Analytics, and Human Resource

Management Information Systems at colleges and universities around the San Francisco

Bay Area, including Golden Gate University; University of San Francisco; Sonoma State

University; Chapman University; University of California Berkeley Extension; and

California State University, East Bay.

Mr. Hughes has developed innovative and cost-effective Compensation and Human

Capital Management Systems internally and commercially and has been instrumental in

consulting with management in charting Corporate Level Human Capital Compensation

and Management System strategies and large HCMS projects. Commercial Compensation

Systems developed by Mr. Hughes have been marketed successfully in the United States,

Europe, and the Middle East.

Mr. Hughes was awarded the Lifetime Achievement Award in Compensation in May

2000 from World at Work (formerly American Compensation Association). Previous published

works include Evaluation of Salary Survey Sources: A Comparative Approach, Fall

1986, Compensation and Benefits Management Journal.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814987647972e.html
Märksõnad: