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 27 August 2016 with a comparison to the same period over the previous 2 years.

3 months to
27 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 99 109 115
Rank change year-on-year
+10 +6
Permanent jobs citing OLAP 6 1 7
As % of all permanent IT jobs located in Cambridge 0.51% 0.073% 0.39%
As % of the Database & Business Intelligence category 1.82% 0.26% 1.39%
Number of salaries quoted 6 1 7
Median salary £29,000 £37,500 £32,500
Median salary % change year-on-year
-22.66% +15.38%
90% offered a salary of more than £27,250 £37,500 £30,000
10% offered a salary of more than £48,750 £37,500 £39,500
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%
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
329 392 504
As % of all permanent IT jobs located in Cambridge 27.69% 28.53% 27.78%
Number of salaries quoted 266 371 417
Median salary £45,000 £42,500 £42,000
Median salary % change year-on-year
+5.88% +1.19%
90% offered a salary of more than £30,000 £30,000 £32,500
10% offered a salary of more than £60,000 £52,500 £55,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

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 27 August 2016.

OLAP Salary Histogram in Cambridge

OLAP
Top 30 Related IT Skills in Cambridge

For the 6 months to 27 August 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