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

3 months to
29 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 20 - 44
Rank change year-on-year
- 0
Permanent jobs citing OLAP 27 0 3
As % of all permanent IT jobs located in Worcestershire 8.44% - 1.10%
As % of the Database & Business Intelligence category 18.24% - 2.46%
Number of salaries quoted 24 0 3
Median salary £47,500 - £40,000
UK excluding London median salary £47,500 £40,000 £42,562
% change year-on-year
+18.75% -6.01%
OLAP
West Midlands

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

Database & Business Intelligence Category
Worcestershire
Permanent IT job ads with a match in the
Database & Business Intelligence category
148 137 122
As % of all permanent IT jobs located in Worcestershire 46.25% 45.51% 44.69%
Number of salaries quoted 137 132 109
Median salary £42,500 £36,500 £37,500
Median salary % change year-on-year
+16.43% -2.66%
90% offered a salary of more than £27,500 £30,500 £30,000
10% offered a salary of more than £52,500 £45,000 £43,596
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLAP
Jobs Demand Trend in Worcestershire

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

OLAP Jobs Demand Trend in Worcestershire

OLAP
Salary Trend in Worcestershire

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

OLAP Salary Trend in Worcestershire

OLAP
Salary Histogram in Worcestershire

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

OLAP Salary Histogram in Worcestershire

OLAP
Job Locations in Worcestershire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Worcestershire region over the 3 months to 29 June 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
Worcester - 27 £47,500 -
OLAP
West Midlands

OLAP
Top 27 Related IT Skills in Worcestershire

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

1 27 (100.00%) SQL Server
1 27 (100.00%) Business Intelligence
2 26 (96.30%) SQL Server 2012
3 24 (88.89%) SQL Server Reporting Services
4 23 (85.19%) SQL
4 23 (85.19%) OLAP Cube
5 22 (81.48%) Analytical Skills
6 21 (77.78%) Tableau
7 18 (66.67%) Visualisation
8 17 (62.96%) SQL Server Integration Services
9 16 (59.26%) ETL
10 15 (55.56%) Agile Software Development
11 13 (48.15%) SAP
12 10 (37.04%) SAP Business One
13 7 (25.93%) Data Extraction
13 7 (25.93%) Data Analysis
14 5 (18.52%) Finance
15 4 (14.81%) Continuous Improvement
16 3 (11.11%) Digital Marketing
16 3 (11.11%) Marketing
16 3 (11.11%) SAP Oil and Gas
16 3 (11.11%) Manufacturing
16 3 (11.11%) Programme Management
16 3 (11.11%) Electronics
16 3 (11.11%) Telecoms
17 1 (3.70%) Management Information System
17 1 (3.70%) MS Excel

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

Applications
1 1 (3.70%) MS Excel
Business Applications
1 10 (37.04%) SAP Business One
2 3 (11.11%) SAP Oil and Gas
Database & Business Intelligence
1 27 (100.00%) SQL Server
2 26 (96.30%) SQL Server 2012
3 24 (88.89%) SQL Server Reporting Services
4 23 (85.19%) OLAP Cube
5 17 (62.96%) SQL Server Integration Services
General
1 5 (18.52%) Finance
2 3 (11.11%) Electronics
2 3 (11.11%) Manufacturing
2 3 (11.11%) Marketing
2 3 (11.11%) Telecoms
Job Titles
1 23 (85.19%) Business Intelligence Developer
1 23 (85.19%) Developer
2 7 (25.93%) Report Developer
3 5 (18.52%) Business Developer
3 5 (18.52%) SQL BI Developer
3 5 (18.52%) SQL Developer
4 4 (14.81%) SSRS Developer
5 3 (11.11%) Consultant
6 2 (7.41%) SSRS Consultant
7 1 (3.70%) Analyst
7 1 (3.70%) Business Consultant
7 1 (3.70%) Business Intelligence Consultant
7 1 (3.70%) Data Analyst
7 1 (3.70%) SQL Server BI Developer
7 1 (3.70%) SQL Server Consultant
7 1 (3.70%) SQL Server Developer
7 1 (3.70%) SSIS Consultant
Miscellaneous
1 22 (81.48%) Analytical Skills
2 18 (66.67%) Visualisation
3 7 (25.93%) Data Extraction
4 1 (3.70%) Management Information System
Processes & Methodologies
1 27 (100.00%) Business Intelligence
2 16 (59.26%) ETL
3 15 (55.56%) Agile Software Development
4 7 (25.93%) Data Analysis
5 4 (14.81%) Continuous Improvement
6 3 (11.11%) Digital Marketing
6 3 (11.11%) Programme Management
Programming Languages
1 23 (85.19%) SQL
Vendors
1 21 (77.78%) Tableau
2 13 (48.15%) SAP