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

3 months to
10 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 110 94 86
Rank change year-on-year
-16 -8
Permanent jobs citing OLAP 2 4 14
As % of all permanent IT jobs located in Wales 0.16% 0.32% 1.10%
As % of the Database & Business Intelligence category 0.47% 1.13% 3.14%
Number of salaries quoted 2 4 14
Median salary £32,500 £35,000 £35,750
Median salary % change year-on-year
-7.14% -2.09%
90% offered a salary of more than £26,500 £31,050 £30,350
10% offered a salary of more than £38,500 £36,500 £40,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +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
423 353 446
As % of all permanent IT jobs located in Wales 32.89% 28.61% 35.04%
Number of salaries quoted 370 301 401
Median salary £40,541 £35,000 £35,000
Median salary % change year-on-year
+15.83% -
90% offered a salary of more than £27,500 £25,500 £29,000
10% offered a salary of more than £76,250 £42,500 £46,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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 10 December 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 10 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
South Wales -6 2 £32,500 -7.14%
OLAP
UK

OLAP
Top 30 Related IT Skills in Wales

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

1 11 (100.00%) SQL Server
2 10 (90.91%) SQL
3 9 (81.82%) T-SQL
3 9 (81.82%) Microsoft
3 9 (81.82%) ETL
3 9 (81.82%) SQL Server Integration Services
4 8 (72.73%) Business Intelligence
4 8 (72.73%) SQL Server Analysis Services
4 8 (72.73%) Data Warehouse
5 7 (63.64%) OLAP Cube
6 6 (54.55%) MDX
6 6 (54.55%) Agile Software Development
7 4 (36.36%) SQL Server Reporting Services
7 4 (36.36%) Finance
7 4 (36.36%) MS Excel
8 3 (27.27%) CRM
8 3 (27.27%) .NET
8 3 (27.27%) Visual Studio
8 3 (27.27%) Microsoft Analysis Services
8 3 (27.27%) Computer Science
8 3 (27.27%) ETL Development
8 3 (27.27%) Analytical Skills
8 3 (27.27%) SQL Server 2012
9 2 (18.18%) Kimball Methodology
9 2 (18.18%) Oracle Database
9 2 (18.18%) Prototyping
9 2 (18.18%) Oracle OLAP
9 2 (18.18%) jQuery
9 2 (18.18%) RESTful
9 2 (18.18%) Microsoft Azure

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 (18.18%) Apache
1 2 (18.18%) Oracle 10gAS
1 2 (18.18%) Oracle Application Server
1 2 (18.18%) SharePoint
Applications
1 4 (36.36%) MS Excel
Business Applications
1 2 (18.18%) Dynamics AX
Cloud Services
1 2 (18.18%) Amazon AWS
1 2 (18.18%) Microsoft Azure
Communications & Networking
1 2 (18.18%) Intranet
Database & Business Intelligence
1 11 (100.00%) SQL Server
2 9 (81.82%) SQL Server Integration Services
3 8 (72.73%) Data Warehouse
3 8 (72.73%) SQL Server Analysis Services
4 7 (63.64%) OLAP Cube
5 4 (36.36%) SQL Server Reporting Services
6 3 (27.27%) Microsoft Analysis Services
6 3 (27.27%) SQL Server 2012
7 2 (18.18%) DTS
7 2 (18.18%) GIS
7 2 (18.18%) Oracle Database
7 2 (18.18%) Oracle Database 10g
7 2 (18.18%) Oracle OLAP
7 2 (18.18%) Oracle Reports
8 1 (9.09%) Hadoop
8 1 (9.09%) OLTP
8 1 (9.09%) Relational Database
8 1 (9.09%) SQL Server 2014
Development Applications
1 3 (27.27%) Visual Studio
2 2 (18.18%) MorphX
2 2 (18.18%) Oracle Forms
2 2 (18.18%) PVCS
2 2 (18.18%) Visual Studio Team System
3 1 (9.09%) Team Foundation Server
General
1 4 (36.36%) Finance
2 1 (9.09%) Banking
Job Titles
1 11 (100.00%) Developer
2 8 (72.73%) Senior Developer
3 6 (54.55%) Database Developer
4 4 (36.36%) Senior Database Developer
5 3 (27.27%) Business Intelligence Developer
6 2 (18.18%) Senior Business Intelligence Developer
6 2 (18.18%) Senior Systems Developer
6 2 (18.18%) Systems Developer
7 1 (9.09%) Microsoft Developer
7 1 (9.09%) Senior Microsoft Developer
Libraries, Frameworks & Software Standards
1 6 (54.55%) MDX
2 3 (27.27%) .NET
3 2 (18.18%) Ajax
3 2 (18.18%) CSS
3 2 (18.18%) CSS3
3 2 (18.18%) HTML
3 2 (18.18%) HTML5
3 2 (18.18%) jQuery
3 2 (18.18%) JSON
3 2 (18.18%) RESTful
3 2 (18.18%) SOAP
3 2 (18.18%) Web Services
3 2 (18.18%) XML
Miscellaneous
1 3 (27.27%) Analytical Skills
1 3 (27.27%) Computer Science
Operating Systems
1 2 (18.18%) Windows
Processes & Methodologies
1 9 (81.82%) ETL
2 8 (72.73%) Business Intelligence
3 6 (54.55%) Agile Software Development
4 3 (27.27%) CRM
4 3 (27.27%) ETL Development
5 2 (18.18%) ERP
5 2 (18.18%) Kimball Methodology
5 2 (18.18%) MVC
5 2 (18.18%) OO
5 2 (18.18%) OOP
5 2 (18.18%) Project Management
5 2 (18.18%) Prototyping
5 2 (18.18%) Responsive Web Design
5 2 (18.18%) TDD
5 2 (18.18%) Waterfall
5 2 (18.18%) Web Design
6 1 (9.09%) Mentoring
Programming Languages
1 10 (90.91%) SQL
2 9 (81.82%) T-SQL
3 2 (18.18%) JavaScript
3 2 (18.18%) PHP
3 2 (18.18%) PL/SQL
3 2 (18.18%) X++
4 1 (9.09%) C#
4 1 (9.09%) PowerShell
Qualifications
1 2 (18.18%) Degree
Vendors
1 9 (81.82%) Microsoft
2 2 (18.18%) Oracle
2 2 (18.18%) Serena