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

Saturday, July 26, 2014

Oracle SQL Developer Data Modeling 4.0.2.840

The latest version of Oracle SQL Developer Data Modeling v4 - 4.0.2.840 is actually distinct in several ways from the immediate predecessor - v4.0.2.15.21 and earlier releases including a more intuitive navigation system.  For example to open a Data Model in  earlier releases one had to navigate several levels to File > DataModeler > Open.  Now it's just File > Open (as it was in much earlier releases)
Work still needed in certain areas as noted below -

DDL Generation (SQL Server 2012 still not supported. SQL Server 2008 is last listed DDL RDMS Target listed for Exporting DDL from Data Model.

SQL Server 2008 Target RDMS Exported DDL  issues -
  • Generated DDL contains errors eg DATETIME includes (8) Length option which should be dropped.
  • In DDL, Schema Names not showing up in Table Name Prefix for Create or Alter TAble commands
  • Schema Names do appear in generated DDL Constraint Names but with period (.) that SQL Server does not accept.

Other issues -
  • Cannot copy objects from one design to another, even with the same Model
  • Scratchpad SQL Syntax converter still only works from other RDMS to Oracle only, not from Oracle to other RDMS

 A big plus and improvement in the v4 series is the Navigation pane which makes it very easy to move around on the the design pallete across larger Data Models without the need for zoom out or slider use.