ABSTRACT
Excel Pivot Tables connected to Microsoft Analytical Services Online Analytical Processing (OLAP) Multidimensional Databases were used to further perform Analytics in regard to Gender-Based Pay Equity and Occupational Mobility analysis. Excel Pivot Tables can provide a capable platform for OLAP Analytics. There is no direct connection between the OLAP Cube Database as found with Excel when launched directly in Visual Studio with an open connection to an Structured Query Language (SQL) Server Analysis Services Database with Multidimensional Cube(s) present. The Process of Job Evaluation in the Federal Evaluation System follows the process of Job Classification. A Modern Job Analysis and Competency Analysis System are in use in both the Private and Public Sectors and supports compliance with the Uniform Guidelines on Employee Selection Procedures. Both the Salary Totals and Relative Employment Quotients further indicate a weakness in Female Gender Employment Upward Mobility, which may be due in part to discrimination based on sex.
