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

3 months to
25 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 89 100 86
Rank change year-on-year
+11 -14
Permanent jobs citing OLAP 17 4 18
As % of all permanent IT jobs located in Wales 1.27% 0.29% 1.36%
As % of the Database & Business Intelligence category 4.50% 0.98% 5.08%
Number of salaries quoted 13 4 17
Median salary £36,250 £35,750 £37,500
Median salary % change year-on-year
+1.39% -4.66%
90% offered a salary of more than £22,500 £34,000 £27,500
10% offered a salary of more than £40,000 £40,125 £45,000
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
378 409 354
As % of all permanent IT jobs located in Wales 28.29% 29.53% 26.72%
Number of salaries quoted 324 336 327
Median salary £39,500 £37,000 £35,000
Median salary % change year-on-year
+6.75% +5.71%
90% offered a salary of more than £25,100 £27,500 £26,805
10% offered a salary of more than £47,500 £45,000 £45,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 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 25 July 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 25 July 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 +21 17 £36,250 +1.39%
OLAP
UK

OLAP
Top 30 Related IT Skills in Wales

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

1 23 (92.00%) SQL
1 23 (92.00%) Business Intelligence
2 21 (84.00%) SQL Server Integration Services
3 20 (80.00%) SQL Server Analysis Services
3 20 (80.00%) SQL Server
4 19 (76.00%) ETL
5 17 (68.00%) OLAP Cube
6 14 (56.00%) SQL Server Reporting Services
6 14 (56.00%) MDX
6 14 (56.00%) Data Warehouse
7 13 (52.00%) Microsoft
7 13 (52.00%) SQL Server 2012
8 11 (44.00%) MS Excel
8 11 (44.00%) T-SQL
8 11 (44.00%) Agile Software Development
9 8 (32.00%) TDD
10 7 (28.00%) Visual Studio
11 5 (20.00%) Analytical Skills
11 5 (20.00%) Hadoop
12 4 (16.00%) SQL Server 2008
12 4 (16.00%) Team Foundation Server
12 4 (16.00%) Big Data
12 4 (16.00%) Relational Database
12 4 (16.00%) OLTP
12 4 (16.00%) BusinessObjects
12 4 (16.00%) Microsoft Analysis Services
13 3 (12.00%) Computer Science
13 3 (12.00%) QA
13 3 (12.00%) Finance
13 3 (12.00%) Advertising

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 2 (8.00%) Apache
1 2 (8.00%) Oracle 10gAS
1 2 (8.00%) Oracle Application Server
1 2 (8.00%) SharePoint
Applications
1 11 (44.00%) MS Excel
2 1 (4.00%) MS Office
Business Applications
1 2 (8.00%) Dynamics AX
Cloud Services
1 3 (12.00%) Microsoft Azure
2 1 (4.00%) Amazon AWS
Communications & Networking
1 2 (8.00%) Intranet
Database & Business Intelligence
1 21 (84.00%) SQL Server Integration Services
2 20 (80.00%) SQL Server
2 20 (80.00%) SQL Server Analysis Services
3 17 (68.00%) OLAP Cube
4 14 (56.00%) Data Warehouse
4 14 (56.00%) SQL Server Reporting Services
5 13 (52.00%) SQL Server 2012
6 5 (20.00%) Hadoop
7 4 (16.00%) Big Data
7 4 (16.00%) BusinessObjects
7 4 (16.00%) Microsoft Analysis Services
7 4 (16.00%) OLTP
7 4 (16.00%) Relational Database
7 4 (16.00%) SQL Server 2008
8 2 (8.00%) DTS
8 2 (8.00%) GIS
8 2 (8.00%) Oracle Database
8 2 (8.00%) Oracle Database 10g
8 2 (8.00%) Oracle OLAP
8 2 (8.00%) Oracle Reports
Development Applications
1 7 (28.00%) Visual Studio
2 4 (16.00%) Team Foundation Server
3 3 (12.00%) SQL Server Management Studio (SSMS)
4 2 (8.00%) MorphX
4 2 (8.00%) Oracle Forms
4 2 (8.00%) PVCS
4 2 (8.00%) Visual Studio Team System
General
1 3 (12.00%) Advertising
1 3 (12.00%) Finance
Job Titles
1 21 (84.00%) Developer
2 16 (64.00%) Database Developer
3 14 (56.00%) Senior Developer
4 11 (44.00%) Senior Database Developer
5 9 (36.00%) SSAS Developer
6 8 (32.00%) SQL Database Developer
6 8 (32.00%) SQL Developer
7 5 (20.00%) SSIS Developer
7 5 (20.00%) SSRS Developer
8 4 (16.00%) Analyst
8 4 (16.00%) Business Intelligence Analyst
8 4 (16.00%) Business Intelligence Developer
8 4 (16.00%) ETL Developer
8 4 (16.00%) Senior ETL Developer
8 4 (16.00%) Senior SQL Developer
8 4 (16.00%) SQL Server Developer
9 3 (12.00%) T-SQL Developer
10 2 (8.00%) Senior Systems Developer
10 2 (8.00%) Systems Developer
11 1 (4.00%) Senior Microsoft Developer
Libraries, Frameworks & Software Standards
1 14 (56.00%) MDX
2 2 (8.00%) .NET
2 2 (8.00%) Ajax
2 2 (8.00%) CSS
2 2 (8.00%) CSS3
2 2 (8.00%) HTML
2 2 (8.00%) HTML5
2 2 (8.00%) jQuery
2 2 (8.00%) JSON
2 2 (8.00%) RESTful
2 2 (8.00%) SOAP
2 2 (8.00%) Web Services
2 2 (8.00%) XML
Miscellaneous
1 5 (20.00%) Analytical Skills
2 3 (12.00%) Computer Science
2 3 (12.00%) Data Integration
3 1 (4.00%) Management Information System
Operating Systems
1 3 (12.00%) Windows
Processes & Methodologies
1 23 (92.00%) Business Intelligence
2 19 (76.00%) ETL
3 11 (44.00%) Agile Software Development
4 8 (32.00%) TDD
5 2 (8.00%) CRM
5 2 (8.00%) ERP
5 2 (8.00%) MVC
5 2 (8.00%) OO
5 2 (8.00%) OOP
5 2 (8.00%) Project Management
5 2 (8.00%) Prototyping
5 2 (8.00%) Responsive Web Design
5 2 (8.00%) Waterfall
5 2 (8.00%) Web Design
6 1 (4.00%) Data Migration
6 1 (4.00%) Data Transformation
6 1 (4.00%) Database Optimisation
6 1 (4.00%) ETL Development
6 1 (4.00%) Mentoring
6 1 (4.00%) Migration
Programming Languages
1 23 (92.00%) SQL
2 11 (44.00%) T-SQL
3 2 (8.00%) JavaScript
3 2 (8.00%) PHP
3 2 (8.00%) PL/SQL
3 2 (8.00%) X++
Qualifications
1 3 (12.00%) Degree
Quality Assurance & Compliance
1 3 (12.00%) QA
Vendors
1 13 (52.00%) Microsoft
2 2 (8.00%) Oracle
2 2 (8.00%) Serena