Human Capital Systems, Analytics and Data Mining Paperback Edition Now Available

Human Capital Systems, Analytics and Data Mining includes Relational and Dimensional Modeling Tutorials with Data Modeling of Human Capital Information Database Systems that include special emphasis on Compensation Data Structures and Analytics.

Detailed Tutorials cover Human Capital Databases from Relational to Dimensional which are then exposed to in depth Online Analytical Processing (OLAP) and Data Mining Projects.  Coverage of Compensation Systems include Extensive Original Research in Gender Based Pay Equity Issues through the lens of Comparable Worth.  Replication of the Pay Equity research with New Findings is included in Tutorials throughout the text.

Development of OLAP Databases and Human Capital Data Mining Projects further exploring contemporary Human Capital Research are the main focus of the book.  Also included are development of Human Capital Information System Interactive Dashboards that effectively visualize recommended internal research methods along with detailed Tutorials on how to create and maintain the Dashboards.  Dashboard development are mainly concentrated on Compensation Metrics and Analytics.

Oracle Data Modeling and Power BI Human Capital Interactive Dashboard Tutorials In New Data Mining Book

Human Capital Systems, Analytics and Data Mining, ISBN 9781498764780 - CAT# K29042, is now available in Paperback and includes extensive Tutorials for Oracle SQl Developer Data Modeling,SQL Server Data Mining and Power BI along with downloadable templates.

Human Capital Systems, Analytics and Data Mining is a Practical Guide for Human Capital Practitioners with Pay Equity and Job Mobility Research Based on Jobs of Comparable Worth. Extensive Tutorials throughout on Database Design, Analytics, Data Mining and Dashboards. New Pay Gap Research Findings included in the book reveal discovery of Gender Pay Gap Truths and Fictions.

WorldatWork Journal Article - Data Mining Pay Equity Issues

My latest book - Human Capital Management Systems, Analytics and Data Mining includes In-Depth HCM Analytics and Data Mining covering Gender Related Pay Equity and Occupational Mobility Research based on Comparable Worth Analysis.

Book Updates are included in - WorldatWork Journal Q3 2019 Article: Gender-Based Pay Equity Differences and Upward Occupational Mobility Through the Lens of Comparable Worth The Journal Article can be downloaded in PDF format here.

Relational and Dimensional Modeling Tutorials with Oracle SQL Developer Data Modeling

Chapters 3 and 4 of My new book Human Capital Systems, Analytics and Data Mining includes Relational and Dimensional Modeling Tutorials with Oracle SQL Developer Data Modeling.

 Human Capital Databases are migrated from Relational to Dimensional.  Export of DDL Scripts to migrate the Relational and Dimensional Designs to SQL Server are included along with extensive Tutorials.  The current release of Oracle SQL Developer Data Modeling v8.14 includes export dialects for SQL Server 2012 which are compatible with SQL Server 2014 and 2016.  Later chapters of the book include development of OLAP databases with Microsoft Analysis Services Multidimensional Model Databases (SSAS) and  Data Mining Projects.  Original Research in Pay Equity Issues through the lens of Comparable Worth is included.

Microsoft Power BI vs Tableau vs Qlik

In the Gartner Report of February 2018 Microsoft Power BI, Tableau and Qlik are considered the dominant BI Platforms for Business Intelligence and Analytics.

Each has Desktop versions, however Microsoft Power BI Desktop does not require any account setup, is free and is the quickest and easiest to deploy. Tableau Desktop has a limited trial version of desktop and limited licenses for students and faculty. Qlik Desktop requires registration, account setup and offers a limited trial period.

Power BI Desktop provides stand alone Desktop appications and very quick deveopment of powerful interactive Dashboards with Analytic options which are very intuitive. Connections to SQL Server Analytical Services Multidimensional and Tabular Databases is seamless.

The Author of this blog has a new book

Human Capital Systems, Analytics and Data Mining Scheduled for publication Spring/Summer 2018 which includes extensive Tutorials and Exercises in HCM Analytics and Data Mining along with development of HCM Interactive Dashboards with Power BI Desktop.

Visual Studio 2017 / SQL Server 2016 Analytical Services

The SQL Server 2016 Analytical Services is now completely up-to-date with the release of Visual Studio 2017. Visual Studio 2017 needs to have the Microsoft Analysis Services Modeling Projects Extension for building Analysis Services Multidimensional and Tabular Projects. Only the Multidimensional install option in SQL Server 2016 Analytical Services allows the development of Data Mining Models.

For students and developers the Visual Studio 2017 Community Edition is free along with the Developer Edition of SQL Sever 2016.

Oracle Database 11.2.0.4 Support Extended to 2020

A number of Internal and Vendor Applications still run solely on Oracle 11g with no near term plans to upgrade to Oracle 12c.which was first released in 2013.  With the extension of support of 11.2.0.4 to 2020 current applications running on 11.2.0.4 have considerable breathing room to prepare for the eventual upgrade to Oracle 12c.

Moving the support date out to 2020 for Oracle 11g - 11.2.0.4 was a smart decision by Oracle leaving room for current applications running 11g to take a more natural and paced evolution to 12c.