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

3 months to
3 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 66 76 50
Rank change year-on-year
+10 -26
Permanent jobs citing OLAP 3 3 12
As % of all permanent IT jobs located in Cardiff 0.46% 0.42% 1.99%
As % of the Database & Business Intelligence category 1.44% 1.39% 7.10%
Number of salaries quoted 3 3 12
Median salary £35,000 £36,500 £36,000
Median salary % change year-on-year
-4.10% +1.38%
90% offered a salary of more than £27,000 £31,300 £33,500
10% offered a salary of more than £39,000 £36,500 £40,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%
OLAP
South Wales

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

Database & Business Intelligence Category
Cardiff
Permanent IT job ads with a match in the
Database & Business Intelligence category
209 216 169
As % of all permanent IT jobs located in Cardiff 32.15% 30.47% 28.07%
Number of salaries quoted 197 188 156
Median salary £40,000 £35,000 £35,000
Median salary % change year-on-year
+14.28% -
90% offered a salary of more than £25,500 £25,500 £28,500
10% offered a salary of more than £60,000 £42,500 £45,300
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

OLAP
Jobs Demand Trend in Cardiff

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

OLAP Jobs Demand Trend in Cardiff

OLAP
Salary Trend in Cardiff

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

OLAP Salary Trend in Cardiff

OLAP
Salary Histogram in Cardiff

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

OLAP Salary Histogram in Cardiff

OLAP
Top 30 Related IT Skills in Cardiff

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

1 10 (100.00%) SQL
1 10 (100.00%) SQL Server
2 9 (90.00%) T-SQL
3 8 (80.00%) Microsoft
3 8 (80.00%) ETL
3 8 (80.00%) SQL Server Integration Services
4 7 (70.00%) Business Intelligence
4 7 (70.00%) SQL Server Analysis Services
4 7 (70.00%) Data Warehouse
5 6 (60.00%) MDX
5 6 (60.00%) Agile Software Development
5 6 (60.00%) OLAP Cube
6 4 (40.00%) MS Excel
7 3 (30.00%) CRM
7 3 (30.00%) Finance
7 3 (30.00%) .NET
7 3 (30.00%) Visual Studio
7 3 (30.00%) Microsoft Analysis Services
7 3 (30.00%) SQL Server Reporting Services
7 3 (30.00%) Computer Science
7 3 (30.00%) ETL Development
7 3 (30.00%) Analytical Skills
7 3 (30.00%) SQL Server 2012
8 2 (20.00%) Kimball Methodology
8 2 (20.00%) Oracle Database
8 2 (20.00%) Prototyping
8 2 (20.00%) Oracle OLAP
8 2 (20.00%) jQuery
8 2 (20.00%) RESTful
8 2 (20.00%) Microsoft Azure

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