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

3 months to
31 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 90 99 102
Rank change year-on-year
+9 +3
Permanent jobs citing OLAP 11 6 8
As % of all permanent IT jobs located in Wales 0.85% 0.44% 0.60%
As % of the Database & Business Intelligence category 2.94% 1.49% 2.32%
Number of salaries quoted 7 3 8
Median salary £35,000 £37,500 £36,250
Median salary % change year-on-year
-6.66% +3.44%
90% offered a salary of more than £22,100 £34,700 £26,450
10% offered a salary of more than £38,500 £40,500 £43,250
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -5.88%
OLAP
UK

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

Database & Business Intelligence Category
Wales
Permanent IT job ads with a match in the
Database & Business Intelligence category
374 403 345
As % of all permanent IT jobs located in Wales 28.75% 29.35% 25.86%
Number of salaries quoted 321 342 310
Median salary £38,500 £37,500 £35,000
Median salary % change year-on-year
+2.66% +7.14%
90% offered a salary of more than £25,000 £27,500 £25,000
10% offered a salary of more than £47,500 £52,500 £47,500
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLAP
Jobs Demand Trend in Wales

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

OLAP Jobs Demand Trend in Wales

OLAP
Salary Trend in Wales

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

OLAP Salary Trend in Wales

OLAP
Salary Histogram in Wales

This chart provides a salary histogram for IT jobs citing OLAP across the Wales region over the 3 months to 31 May 2016.

OLAP Salary Histogram in Wales

OLAP
Job Locations in Wales

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Wales region over the 3 months to 31 May 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
South Wales +8 11 £35,000 -6.66%
OLAP
UK

OLAP
Top 30 Related IT Skills in Wales

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

1 28 (100.00%) Business Intelligence
2 26 (92.86%) SQL
3 24 (85.71%) SQL Server Analysis Services
4 22 (78.57%) SQL Server Integration Services
5 20 (71.43%) SQL Server Reporting Services
6 19 (67.86%) MDX
7 18 (64.29%) Data Warehouse
8 16 (57.14%) ETL
8 16 (57.14%) SQL Server
8 16 (57.14%) OLAP Cube
9 15 (53.57%) Agile Software Development
10 12 (42.86%) SQL Server 2012
11 11 (39.29%) MS Excel
12 10 (35.71%) Microsoft
13 7 (25.00%) Tableau
13 7 (25.00%) TDD
13 7 (25.00%) Kimball Methodology
13 7 (25.00%) Inmon Methodology
13 7 (25.00%) Oracle OLAP
13 7 (25.00%) QlikView
13 7 (25.00%) Scrum
13 7 (25.00%) SharePoint
13 7 (25.00%) Oracle
13 7 (25.00%) ITIL
13 7 (25.00%) PRINCE2
14 5 (17.86%) SQL Server 2008
14 5 (17.86%) Hadoop
14 5 (17.86%) T-SQL
14 5 (17.86%) Big Data
15 4 (14.29%) Relational Database

OLAP
Top Related IT Skills in Wales 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 7 (25.00%) SharePoint
2 1 (3.57%) SharePoint 2013
Applications
1 11 (39.29%) MS Excel
2 1 (3.57%) MS Office
Cloud Services
1 2 (7.14%) Microsoft Azure
Database & Business Intelligence
1 24 (85.71%) SQL Server Analysis Services
2 22 (78.57%) SQL Server Integration Services
3 20 (71.43%) SQL Server Reporting Services
4 18 (64.29%) Data Warehouse
5 16 (57.14%) OLAP Cube
5 16 (57.14%) SQL Server
6 12 (42.86%) SQL Server 2012
7 7 (25.00%) Oracle OLAP
7 7 (25.00%) QlikView
8 5 (17.86%) Big Data
8 5 (17.86%) Hadoop
8 5 (17.86%) SQL Server 2008
9 4 (14.29%) BusinessObjects
9 4 (14.29%) OLTP
9 4 (14.29%) Relational Database
10 2 (7.14%) Microsoft Analysis Services
11 1 (3.57%) DataStage
11 1 (3.57%) Microsoft Power View
11 1 (3.57%) SQL Server 2014
11 1 (3.57%) Star Schema
Development Applications
1 4 (14.29%) Team Foundation Server
1 4 (14.29%) Visual Studio
2 3 (10.71%) SQL Server Management Studio (SSMS)
General
1 3 (10.71%) Advertising
2 1 (3.57%) Finance
Job Titles
1 24 (85.71%) Developer
2 17 (60.71%) SQL Developer
3 14 (50.00%) SSAS Developer
4 13 (46.43%) Database Developer
5 12 (42.86%) Business Intelligence Developer
6 11 (39.29%) Senior Developer
7 9 (32.14%) Senior Database Developer
7 9 (32.14%) SQL BI Developer
7 9 (32.14%) SQL Database Developer
7 9 (32.14%) SSIS Developer
7 9 (32.14%) SSRS Developer
8 7 (25.00%) Analyst
8 7 (25.00%) Business Intelligence Analyst
8 7 (25.00%) Senior SQL Developer
9 6 (21.43%) Business Developer
10 5 (17.86%) ETL Developer
10 5 (17.86%) Senior ETL Developer
11 4 (14.29%) SQL Server Developer
12 3 (10.71%) Analyst Developer
12 3 (10.71%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 19 (67.86%) MDX
2 1 (3.57%) Oracle Streams
Miscellaneous
1 3 (10.71%) Analytical Skills
1 3 (10.71%) Data Integration
2 2 (7.14%) Management Information System
Operating Systems
1 1 (3.57%) Windows
Processes & Methodologies
1 28 (100.00%) Business Intelligence
2 16 (57.14%) ETL
3 15 (53.57%) Agile Software Development
4 7 (25.00%) Inmon Methodology
4 7 (25.00%) ITIL
4 7 (25.00%) Kimball Methodology
4 7 (25.00%) PRINCE2
4 7 (25.00%) Scrum
4 7 (25.00%) TDD
5 2 (7.14%) Service Management
6 1 (3.57%) Content Management
6 1 (3.57%) Data Analysis
6 1 (3.57%) Data Migration
6 1 (3.57%) Data Transformation
6 1 (3.57%) Database Optimisation
6 1 (3.57%) Knowledge Management
6 1 (3.57%) Mentoring
6 1 (3.57%) Migration
6 1 (3.57%) Project Management
6 1 (3.57%) Service Delivery
Programming Languages
1 26 (92.86%) SQL
2 5 (17.86%) T-SQL
Qualifications
1 2 (7.14%) Degree
Quality Assurance & Compliance
1 3 (10.71%) QA
Vendors
1 10 (35.71%) Microsoft
2 7 (25.00%) Oracle
2 7 (25.00%) Tableau
3 1 (3.57%) IBM