UC Berkeley Data Sciences
Robert C. Hughes, M.S., Assistant Professor, Retired  

Publications

Human Capital Systems, Analytics and Data Mining
ISBN 9781498764780 - CAT# K29042
Paperback Edition Now Available

New Pay Gap Research Findings: Discover Gender Pay Gap Truths and Fictions

[order now...]Human Capital Systems, Analytics and Data Mining : A Technical Guide for Human Capital Practitioners and Analysts with Pay Equity and Job Mobility Research Based on Jobs of Comparable Worth In-Depth HCM Analytics and Data Mining that includes Ground Breaking Gender Based Pay Equity and Occupational Mobility Research based on Comparable Worth Analysis.

This book effectively bridges the gap between the Human Capital Management Professional and the Data Scientist. It fills a large void with respect to Human Capital Systems, Analytics and Data Mining.

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 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.

To order click here..

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.

Now Available.. CRC Taylor and Francis. ISBN-978-1-4987-6478-0

To order click here..

Book Resources for Instructors, HCM Professionals and Students

For Faculty Only Resources visit the CRC Taylor and Francis Publisher site.

HCM Professional and Student Download Resources

File Download Instructions

Installation of files available for download should be done only after first reviewing carefully the download instructions for each file in the Book.

Current backups should be made for any existing databases, data models and other files before attempting installation of any new databases or data models or other files available for download from the book resource site(s).

All files are Copyright (c) 2018-2022 Robert C. Hughes M.S. All Rights Reserved World Wide


Chapter 4
hcmsadm_employee_review_star_schema_chapter3_v2_dmd.zip
hcmsadm_employee_review01_chapter3.zip
hcmsadm_employee_review01_chapter3_v1_dmd.zip
hcmsadm_employee_review01_chapter3_v2_dmd.zip
hcmsadm_sample_star_schema DDL Script.ddl
hcmsadm_sample_star_schema v4_dmd.zip
Chapter 5
avgmeritincreasedash02interactive_dataimported.pbix
quartileandcomparatiodash01.pbix
fedscope_empl_03_2015_DatabaseDDLScript_Schema.sql
hcmsadm_employee_review_star_ddl_with data.sql
Chapter 7
fedscope_empl_03_2015.bak (65MB)
fedscope_empl_03_2015_Database_DDL_Script.sql
Chapter 8
fedscope_employment_OLAPandMining_analysis_svcs_db.abf (177MB)
genderwagegap01.xlsx
genderwagegap02.xlsx

Past Course Offerings at UC Berkeley Extension

X426.1 (3 semester units in EECS) Data Warehouse Design and Dimensional Modeling with OLAP
July 11 - August 15, 2017
UC Berkeley Extension, San Francisco Campus, 160 Spear Street, Room 605, San Francisco, CA 94105.

Course is Predominately Cloud Based using SQL Server Database and SQL Server Analytical Services OLAP platforms. Learn the fundamental principles guiding data warehouse design, dimensional data modeling, and online analytical processing (OLAP) and data including a review of SQL relational database fundamentals. Design data warehouses and data marts to further explore these principles. Build dimensional data models using SQL Server 2012 Enterprise Analytical Services, which supports online analytical processing and data. Course project work uses both workstation-based and Cloud tools for both data warehouse and dimensional modeling exercises. Free Student Access to Cloud SQL Server 2012 Enterprise and Virtual Windows Desktop with Visual Studio Business Intelligence Tools.

X426.1 (3 semester units in EECS) Data Warehouse Design and Dimensional Modeling
July 12 - August 16, 2016
UC Berkeley Extension, Golden Bear Center, 1995 University Avenue, Room 210, Berkeley, California

Learn the fundamental principles guiding data warehouse design, dimensional data modeling, and online analytical processing (OLAP) and data including a review of SQL relational database fundamentals. Design data warehouses and data marts to further explore these principles. Build dimensional data models using SQL Server 2012 Enterprise Analytical Services, which supports online analytical processing and data. Course project work uses both workstation-based and Cloud tools for both data warehouse and dimensional modeling exercises. Free Student Access to Cloud SQL Server 2012 Enterprise and Virtual Windows Desktop with Visual Studio Business Intelligence Tools

X426.1 (3 semester units in EECS) Data Warehouse Design and Dimensional Modeling
July 6 - August 10, 2015
UC Berkeley Extension, Golden Bear Center, 1995 University Avenue, Berkeley, California

Learn the fundamental principles guiding data warehouse design, dimensional data modeling, and online analytical processing (OLAP) and data including a review of SQL relational database fundamentals. Design data warehouses and data marts to further explore these principles. Build dimensional data models using SQL Server Enterprise Analytical Services, which supports online analytical processing and data. Course project work uses both workstation-based and Cloud tools for both data warehouse and dimensional modeling exercises.

X411.4 Fall 2013 - Predictive Data Analysis, Warehousing and Mining
Meeting Dates TBD, 6 meetings, Saturdays, 9 am-4:45pm
UC Berkeley Extension, Golden Bear Center, 1995 University Avenue, Berkeley, California

Discover professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through data mining tools so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. After a brief review of SQL relational databases, learn the fundamental principles guiding data warehousing, Cloud-based online analytical processing (OLAP) and business intelligence. Develop your practical skills by turning raw data into useful information. Learn professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. Course project work uses both workstation-based and Cloud tools for data warehouse, OLAP, data mining and predictive analytics exercises.

EDP 154625 X411.4 (3 semester units in EECS) Summer 2012 - Predictive Data Analysis, Warehousing and Mining
July 7 to August 11, 2012, 6 meetings, Saturdays, 9 am-4:45pm
1995 University Avenue, Berkeley, Room 210, 2nd Floor

Learn professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through data mining tools so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. After a brief review of SQL relational databases, learn the fundamental principles guiding data warehousing, Cloud-based online analytical processing (OLAP) and business intelligence. Develop your practical skills by turning raw data into useful information. Learn professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. Course project work uses both workstation-based and Cloud tools for data warehouse, OLAP, data mining and predictive analytics exercises. You must install or have access to Microsoft SQL Server Enterprise Database Engine or similar software to succeed in this course.

 

Blog

Resources:
Human Capital Job and Competency Descriptions
Information Technology Salaries
Information Technology Job and Competency Descriptions

Last updated: 04.02.2022

© Robert C. Hughes, M.S., 2010-2022 All rights reserved.