Human Capital Systems, Analytics, and Data Mining

Robert C. Hughes, MS, has over 40 years of experience in Human Capital Managementand Information Systems that includes internal and external consulting engagementsin Compensation Planning and Human Capital Management Information Systems.Mr. Hughes is currently an Adjunct Professor in the Ageno School of Business at GoldenGate University in San Francisco.Mr. Hughes has taught courses in Compensation, Management Information Systems,Data Warehousing, Business Intelligence and Predictive Analytics, and Human ResourceManagement Information Systems at colleges and universities around the San FranciscoBay Area, including Golden Gate University; University of San Francisco; Sonoma StateUniversity; Chapman University; University of California Berkeley Extension; andCalifornia State University, East Bay.Mr. Hughes has developed innovative and cost-effective Compensation and HumanCapital Management Systems internally and commercially and has been instrumental inconsulting with management in charting Corporate Level Human Capital Compensationand Management System strategies and large HCMS projects. Commercial CompensationSystems 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 May2000 from World at Work (formerly American Compensation Association). Previous publishedworks include Evaluation of Salary Survey Sources: A Comparative Approach, Fall1986, Compensation and Benefits Management Journal.

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 don’t 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. We’ve 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

• 1. Human Capital Management Systems 2. Human Capital Management System Components 3. Database Systems, Concepts and Design 4. Dimensional Modeling 5. Reporting and Analytics with Multidimensional and Relational Databases 6. Online Analytical Processing and the OLAP Cube Multidimensional Database 7. Multidimensional OLAP Database Project with SQL Server Analytical Services 8. Multidimensional Cube Analysis with Microsoft Excel and SQL Server Analysis Services 9. Data Mining 10. Project Management 11. Appendix A SQL Data Types 12. Appendix B SQL Database and Analysis Server Database Scripts 13. Appendix C Microsoft SQL Server Analytics Services Aggregation Options 14. Appendix D U. S. CDC Project Charter Template 15. Appendix E Sample HCMS Request for Information 16. Appendix F Human Capital Management System Request for Proposal (RFP) 17. Appendix G Sample HCMS Project Plan