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

3 months to
24 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank - 41 74
Permanent jobs citing OLAP 0 11 1
As % of all permanent IT jobs located in Portsmouth - 3.41% 0.22%
As % of the Database & Business Intelligence category - 9.57% 0.42%
Number of salaries quoted 0 11 1
Median salary - £35,000 £32,500
Median salary % change year-on-year
- +7.69%
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
98 115 236
As % of all permanent IT jobs located in Portsmouth 36.30% 35.60% 50.75%
Number of salaries quoted 93 97 173
Median salary £40,000 £42,500 £45,000
Median salary % change year-on-year
-5.88% -5.55%
90% offered a salary of more than £30,000 £29,000 £22,500
10% offered a salary of more than £70,000 £54,000 £50,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 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 24 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 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