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

3 months to
31 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank - 52 -
Permanent jobs citing OLAP 0 9 0
As % of all permanent IT jobs located in Portsmouth - 2.36% -
As % of the Database & Business Intelligence category - 5.92% -
Number of salaries quoted 0 9 0
Median salary - £32,500 -
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%
OLAP
Hampshire

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 Portsmouth region.

Database & Business Intelligence Category
Portsmouth
Permanent IT job ads with a match in the
Database & Business Intelligence category
129 152 214
As % of all permanent IT jobs located in Portsmouth 40.57% 39.90% 51.69%
Number of salaries quoted 125 137 140
Median salary £45,000 £41,500 £43,000
Median salary % change year-on-year
+8.43% -3.48%
90% offered a salary of more than £35,000 £29,000 £23,500
10% offered a salary of more than £70,000 £53,500 £57,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLAP
Jobs Demand Trend in Portsmouth

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

OLAP Jobs Demand Trend in Portsmouth

OLAP
Salary Trend in Portsmouth

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

OLAP Salary Trend in Portsmouth

OLAP
Top 9 Related IT Skills in Portsmouth

For the 6 months to 31 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 Portsmouth region with a requirement for OLAP.

1 1 (100.00%) SQL
1 1 (100.00%) T-SQL
1 1 (100.00%) SQL Server
1 1 (100.00%) Business Intelligence
1 1 (100.00%) Advertising
1 1 (100.00%) SQL Server Reporting Services
1 1 (100.00%) SQL Server Integration Services
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) SQL Server 2012

OLAP
Top Related IT Skills in Portsmouth 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:

Database & Business Intelligence
1 1 (100.00%) SQL Server
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) SQL Server 2012
1 1 (100.00%) SQL Server Integration Services
1 1 (100.00%) SQL Server Reporting Services
General
1 1 (100.00%) Advertising
Job Titles
1 1 (100.00%) Business Intelligence Developer
1 1 (100.00%) Developer
1 1 (100.00%) SQL BI Developer
1 1 (100.00%) SQL Developer
1 1 (100.00%) SSRS Developer
1 1 (100.00%) T-SQL Developer
Processes & Methodologies
1 1 (100.00%) Business Intelligence
Programming Languages
1 1 (100.00%) SQL
1 1 (100.00%) T-SQL