Sunday, April 3, 2022

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.

Friday, August 23, 2019

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.

Thursday, March 21, 2019

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.

Thursday, May 10, 2018

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.

Tuesday, May 16, 2017

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.

Tuesday, September 13, 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.

Monday, February 16, 2015

Analytical SQL Promises Portability

Oracle Analytical SQL continues to develop beyond the built-in statistical routines it has had embedded in the Database Product since 8i with many new advances in the 12c release series including several algorithms supporting Predictive Analytics and Data/Text Mining.

Built-in SQL Analytics, that is using extensions of the SQL language to handle descriptive statistics, hypothesis testing and predictive analytical algorithms and more provides an avenue in which there is less need for expensive separate analytical servers, special language coding and multiple BI source code management.

Oracle SQL Analytics that are developed are submitted continually for ANSI SQL Standards inclusion.  Since most SQL Database vendors strive to support ANSI Standard SQL portability of code becomes more possible.  Most Business Intelligence (BI) Apps and servers support proprietary coding structures and interfaces.

ANSI Analytical SQL when more available across DBMS vendors will help to make Analytical Processes and Procedures more highly portable, code efficient and cost effective.

For more information on the ANSI SQL 99 Standard that supports Analytical SQL visit references below -

IBM
https://www-01.ibm.com/support/knowledgecenter/SSULQD_7.1.0/com.ibm.nz.dbu.doc/c_dbuser_ntz_sql_analytic_funcs.html
HP
http://my.vertica.com/docs/6.0.x/HTML/index.htm#11092.htm
Book -Joe Celko's Analytics and OLAP in SQL
https://books.google.com/books?id=fvE2We_ehL8C&dq=celko+oracle+ansi+sql+99+standard+analytics&source=gbs_navlinks_s
Oracle
http://ss64.com/ora/syntax-analytic.html