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

3 months to
7 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 172 166 195
Rank change year-on-year
-6 +29
Permanent jobs citing OLAP 6 22 1
As % of all permanent IT jobs located in Hampshire 0.19% 0.64% 0.026%
As % of the Database & Business Intelligence category 0.63% 1.78% 0.077%
Number of salaries quoted 5 17 1
Median salary £45,000 £46,500 £35,000
Median salary % change year-on-year
-3.22% +32.85%
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%
OLAP
South East

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

Database & Business Intelligence Category
Hampshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
959 1235 1294
As % of all permanent IT jobs located in Hampshire 30.07% 36.19% 34.02%
Number of salaries quoted 875 1098 1095
Median salary £40,000 £42,500 £42,500
Median salary % change year-on-year
-5.88% -
90% offered a salary of more than £30,000 £32,000 £27,500
10% offered a salary of more than £57,500 £55,000 £60,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

OLAP
Jobs Demand Trend in Hampshire

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

OLAP Jobs Demand Trend in Hampshire

OLAP
Salary Trend in Hampshire

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

OLAP Salary Trend in Hampshire

OLAP
Salary Histogram in Hampshire

This chart provides a salary histogram for IT jobs citing OLAP across the Hampshire region over the 3 months to 7 December 2016.

OLAP Salary Histogram in Hampshire

OLAP
Job Locations in Hampshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Hampshire region over the 3 months to 7 December 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Portsmouth - 3 £43,125 -
Southampton +3 1 £45,000 -
Basingstoke - 1 £55,000 -
OLAP
South East

OLAP
Top 30 Related IT Skills in Hampshire

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

1 30 (85.71%) SQL
1 30 (85.71%) SQL Server
2 28 (80.00%) T-SQL
3 25 (71.43%) OLTP
4 22 (62.86%) Microsoft
5 20 (57.14%) Data Warehouse
6 18 (51.43%) MS Excel
7 14 (40.00%) Degree
8 13 (37.14%) Computer Science
9 12 (34.29%) Enterprise Software
9 12 (34.29%) Business Intelligence
10 11 (31.43%) Disaster Recovery
10 11 (31.43%) Windows
10 11 (31.43%) Replication
10 11 (31.43%) VMware
10 11 (31.43%) Clustering
10 11 (31.43%) Performance Tuning
10 11 (31.43%) Capacity Planning
10 11 (31.43%) High Availability
10 11 (31.43%) Microsoft Clustering
11 10 (28.57%) Finance
12 9 (25.71%) Data Management
12 9 (25.71%) Reverse Engineering
12 9 (25.71%) Database Security
12 9 (25.71%) Data Analysis
13 8 (22.86%) SQL Server Integration Services
13 8 (22.86%) SQL Server Analysis Services
13 8 (22.86%) SQL Server Reporting Services
14 6 (17.14%) Retail
14 6 (17.14%) MS Access

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

Application Platforms
1 2 (5.71%) SAS
Applications
1 18 (51.43%) MS Excel
Business Applications
1 3 (8.57%) Cognos Business Intelligence
1 3 (8.57%) Cognos Controller
1 3 (8.57%) Cognos TM1
1 3 (8.57%) Oracle EBS
Database & Business Intelligence
1 30 (85.71%) SQL Server
2 25 (71.43%) OLTP
3 20 (57.14%) Data Warehouse
4 8 (22.86%) SQL Server Analysis Services
4 8 (22.86%) SQL Server Integration Services
4 8 (22.86%) SQL Server Reporting Services
5 6 (17.14%) MS Access
5 6 (17.14%) OLAP Cube
6 3 (8.57%) Oracle OLAP
7 2 (5.71%) Crystal Reports
7 2 (5.71%) Power BI
7 2 (5.71%) Relational Database
8 1 (2.86%) Business Intelligence Development Studio
8 1 (2.86%) BusinessObjects
8 1 (2.86%) Enterprise Data Warehouse
8 1 (2.86%) Microsoft Analysis Services
8 1 (2.86%) Pentaho
8 1 (2.86%) QlikView
8 1 (2.86%) SQL Server 2012
8 1 (2.86%) SQL Server 2016
Development Applications
1 2 (5.71%) Visual Studio
General
1 10 (28.57%) Finance
2 6 (17.14%) Retail
3 2 (5.71%) Advertising
Job Titles
1 15 (42.86%) Developer
2 11 (31.43%) DBA
2 11 (31.43%) Senior DBA
2 11 (31.43%) Senior SQL DBA
2 11 (31.43%) Senior SQL Server DBA
2 11 (31.43%) SQL DBA
2 11 (31.43%) SQL Developer
2 11 (31.43%) SQL Server DBA
3 9 (25.71%) Analyst
4 5 (14.29%) Business Intelligence Developer
4 5 (14.29%) SQL Analyst
5 4 (11.43%) SQL Server Developer
6 3 (8.57%) Business Intelligence Analyst
6 3 (8.57%) Data Analyst
6 3 (8.57%) Data Warehouse Analyst
6 3 (8.57%) Junior
6 3 (8.57%) Senior Analyst
6 3 (8.57%) Senior Data Analyst
6 3 (8.57%) Senior Data Warehouse Analyst
6 3 (8.57%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 5 (14.29%) MDX
2 2 (5.71%) CSS
2 2 (5.71%) HTML
Miscellaneous
1 13 (37.14%) Computer Science
2 12 (34.29%) Enterprise Software
3 11 (31.43%) Clustering
3 11 (31.43%) Replication
4 1 (2.86%) Algorithms
4 1 (2.86%) Fintech
4 1 (2.86%) FMCG
4 1 (2.86%) Statistics
Operating Systems
1 11 (31.43%) Windows
Processes & Methodologies
1 12 (34.29%) Business Intelligence
2 11 (31.43%) Capacity Planning
2 11 (31.43%) Disaster Recovery
2 11 (31.43%) High Availability
2 11 (31.43%) Performance Tuning
3 9 (25.71%) Data Analysis
3 9 (25.71%) Data Management
3 9 (25.71%) Database Security
3 9 (25.71%) Reverse Engineering
4 6 (17.14%) Analytics
4 6 (17.14%) Software Engineering
5 4 (11.43%) ETL
6 3 (8.57%) Agile Software Development
6 3 (8.57%) CRM
6 3 (8.57%) Data Analytics
7 2 (5.71%) Dimensional Modelling
7 2 (5.71%) Process Improvement
7 2 (5.71%) Refactoring
8 1 (2.86%) Data Migration
8 1 (2.86%) Predictive Analytics
Programming Languages
1 30 (85.71%) SQL
2 28 (80.00%) T-SQL
3 3 (8.57%) C#
3 3 (8.57%) Java
4 2 (5.71%) JavaScript
5 1 (2.86%) VB
5 1 (2.86%) VB6
5 1 (2.86%) VBA
Qualifications
1 14 (40.00%) Degree
Quality Assurance & Compliance
1 4 (11.43%) QA
Systems Management
1 11 (31.43%) Microsoft Clustering
Vendors
1 22 (62.86%) Microsoft
2 11 (31.43%) VMware
3 4 (11.43%) Cognos
3 4 (11.43%) IBM
4 3 (8.57%) Oracle
5 1 (2.86%) SAP