The table below looks at the statistics for OLAP skills in IT jobs advertised for the Cambridge region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 29 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
29 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 99 94 120
Rank change year-on-year
-5 +26
Permanent jobs citing OLAP 6 7 4
As % of all permanent IT jobs located in Cambridge 0.52% 0.50% 0.22%
As % of the Database & Business Intelligence category 1.92% 1.67% 0.77%
Number of salaries quoted 6 7 4
Median salary £29,000 £27,500 £30,000
Median salary % change year-on-year
+5.45% -8.33%
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
OLAP
Cambridgeshire

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the Cambridge region.

Database & Business Intelligence Category
Cambridge
Permanent IT job ads with a match in the
Database & Business Intelligence category
312 420 521
As % of all permanent IT jobs located in Cambridge 26.78% 29.89% 29.25%
Number of salaries quoted 251 388 446
Median salary £45,000 £42,500 £42,500
Median salary % change year-on-year
+5.88% -
90% offered a salary of more than £30,000 £30,000 £31,500
10% offered a salary of more than £57,500 £55,000 £55,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

OLAP
Jobs Demand Trend in Cambridge

The demand trend of job ads across the Cambridge region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in Cambridge

OLAP
Salary Trend in Cambridge

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the Cambridge region.

OLAP Salary Trend in Cambridge

OLAP
Salary Histogram in Cambridge

This chart provides a salary histogram for IT jobs citing OLAP across the Cambridge region over the 3 months to 29 July 2016.

OLAP Salary Histogram in Cambridge

OLAP
Top 30 Related IT Skills in Cambridge

For the 6 months to 29 July 2016, IT jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Cambridge region with a requirement for OLAP.

1 5 (71.43%) SQL
1 5 (71.43%) T-SQL
1 5 (71.43%) SQL Server
1 5 (71.43%) Crystal Reports
1 5 (71.43%) Microsoft
1 5 (71.43%) Analytical Skills
2 4 (57.14%) iPad
2 4 (57.14%) ITIL
3 2 (28.57%) Degree
3 2 (28.57%) HTTP
3 2 (28.57%) Business Intelligence
3 2 (28.57%) Data Warehouse
3 2 (28.57%) COM
3 2 (28.57%) Mentoring
4 1 (14.29%) Data Structures
4 1 (14.29%) OLAP Cube
4 1 (14.29%) Business Analytics
4 1 (14.29%) Analytics
4 1 (14.29%) ERP
4 1 (14.29%) Data Modelling
4 1 (14.29%) ETL
4 1 (14.29%) JDE OneWorld
4 1 (14.29%) Oracle
4 1 (14.29%) CRM
4 1 (14.29%) Cognos
4 1 (14.29%) Oracle Certification
4 1 (14.29%) JD Edwards
4 1 (14.29%) Computer Science
4 1 (14.29%) Oracle OLAP
4 1 (14.29%) Data Integration

OLAP
Top Related IT Skills in Cambridge by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Business Applications
1 1 (14.29%) Cognos TM1
1 1 (14.29%) JDE OneWorld
Communications & Networking
1 2 (28.57%) HTTP
Database & Business Intelligence
1 5 (71.43%) Crystal Reports
1 5 (71.43%) SQL Server
2 2 (28.57%) Data Warehouse
3 1 (14.29%) OLAP Cube
3 1 (14.29%) Oracle OLAP
3 1 (14.29%) SQL Server Integration Services
3 1 (14.29%) SQL Server Reporting Services
Job Titles
1 5 (71.43%) Applications Support
2 4 (57.14%) Analyst
2 4 (57.14%) Applications Support Analyst
2 4 (57.14%) SQL Analyst
2 4 (57.14%) SQL Support Analyst
2 4 (57.14%) Support Analyst
3 1 (14.29%) Applications Engineer
3 1 (14.29%) Applications Support Engineer
3 1 (14.29%) Architect
3 1 (14.29%) Business Architect
3 1 (14.29%) ERP Manager
3 1 (14.29%) IT Manager
3 1 (14.29%) MIS Architect
3 1 (14.29%) Support Engineer
3 1 (14.29%) Systems Manager
Libraries, Frameworks & Software Standards
1 2 (28.57%) COM
Miscellaneous
1 5 (71.43%) Analytical Skills
2 4 (57.14%) iPad
3 1 (14.29%) Computer Science
3 1 (14.29%) Data Integration
3 1 (14.29%) Data Structures
Processes & Methodologies
1 4 (57.14%) ITIL
2 2 (28.57%) Business Intelligence
2 2 (28.57%) Mentoring
3 1 (14.29%) Agile Software Development
3 1 (14.29%) Analytics
3 1 (14.29%) Business Analytics
3 1 (14.29%) CRM
3 1 (14.29%) Data Modelling
3 1 (14.29%) ERP
3 1 (14.29%) ETL
3 1 (14.29%) Statistical Analysis
Programming Languages
1 5 (71.43%) SQL
1 5 (71.43%) T-SQL
Qualifications
1 2 (28.57%) Degree
2 1 (14.29%) Oracle Certification
Vendors
1 5 (71.43%) Microsoft
2 1 (14.29%) Cognos
2 1 (14.29%) JD Edwards
2 1 (14.29%) Oracle