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

3 months to
27 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 61 78 56
Rank change year-on-year
+17 -22
Permanent jobs citing OLAP 13 4 15
As % of all permanent IT jobs located in Cardiff 1.80% 0.49% 2.24%
As % of the Database & Business Intelligence category 6.91% 1.69% 8.02%
Number of salaries quoted 10 4 14
Median salary £33,750 £35,750 £39,740
Median salary % change year-on-year
-5.59% -10.04%
90% offered a salary of more than £22,400 £34,000 £35,750
10% offered a salary of more than £39,550 £40,125 £45,000
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
188 237 187
As % of all permanent IT jobs located in Cardiff 26.04% 29.08% 27.91%
Number of salaries quoted 177 185 170
Median salary £37,500 £37,500 £37,500
90% offered a salary of more than £22,500 £27,400 £27,500
10% offered a salary of more than £45,000 £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 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 27 July 2016.

OLAP Salary Histogram in Cardiff

OLAP
Top 30 Related IT Skills in Cardiff

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

1 19 (100.00%) SQL Server
2 18 (94.74%) SQL
3 17 (89.47%) Business Intelligence
4 16 (84.21%) SQL Server Integration Services
5 15 (78.95%) SQL Server Analysis Services
6 13 (68.42%) SQL Server 2012
6 13 (68.42%) ETL
7 12 (63.16%) OLAP Cube
7 12 (63.16%) Microsoft
7 12 (63.16%) Data Warehouse
7 12 (63.16%) SQL Server Reporting Services
8 11 (57.89%) MS Excel
8 11 (57.89%) T-SQL
9 10 (52.63%) MDX
10 7 (36.84%) Visual Studio
10 7 (36.84%) Agile Software Development
11 5 (26.32%) Analytical Skills
12 4 (21.05%) Relational Database
12 4 (21.05%) SQL Server 2008
12 4 (21.05%) Team Foundation Server
12 4 (21.05%) TDD
12 4 (21.05%) Microsoft Analysis Services
12 4 (21.05%) BusinessObjects
12 4 (21.05%) OLTP
13 3 (15.79%) Windows
13 3 (15.79%) Advertising
13 3 (15.79%) Degree
13 3 (15.79%) Computer Science
13 3 (15.79%) QA
13 3 (15.79%) Data Integration

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 (10.53%) Apache
1 2 (10.53%) Oracle 10gAS
1 2 (10.53%) Oracle Application Server
1 2 (10.53%) SharePoint
Applications
1 11 (57.89%) MS Excel
2 1 (5.26%) MS Office
Business Applications
1 2 (10.53%) Dynamics AX
Cloud Services
1 3 (15.79%) Microsoft Azure
2 1 (5.26%) Amazon AWS
Communications & Networking
1 2 (10.53%) Intranet
Database & Business Intelligence
1 19 (100.00%) SQL Server
2 16 (84.21%) SQL Server Integration Services
3 15 (78.95%) SQL Server Analysis Services
4 13 (68.42%) SQL Server 2012
5 12 (63.16%) Data Warehouse
5 12 (63.16%) OLAP Cube
5 12 (63.16%) SQL Server Reporting Services
6 4 (21.05%) BusinessObjects
6 4 (21.05%) Microsoft Analysis Services
6 4 (21.05%) OLTP
6 4 (21.05%) Relational Database
6 4 (21.05%) SQL Server 2008
7 2 (10.53%) DTS
7 2 (10.53%) GIS
7 2 (10.53%) Oracle Database
7 2 (10.53%) Oracle Database 10g
7 2 (10.53%) Oracle OLAP
7 2 (10.53%) Oracle Reports
8 1 (5.26%) Hadoop
Development Applications
1 7 (36.84%) Visual Studio
2 4 (21.05%) Team Foundation Server
3 3 (15.79%) SQL Server Management Studio (SSMS)
4 2 (10.53%) MorphX
4 2 (10.53%) Oracle Forms
4 2 (10.53%) PVCS
4 2 (10.53%) Visual Studio Team System
General
1 3 (15.79%) Advertising
2 2 (10.53%) Finance
Job Titles
1 15 (78.95%) Developer
2 12 (63.16%) Database Developer
3 9 (47.37%) Senior Developer
4 7 (36.84%) Senior Database Developer
5 5 (26.32%) SSAS Developer
5 5 (26.32%) SSIS Developer
5 5 (26.32%) SSRS Developer
6 4 (21.05%) Analyst
6 4 (21.05%) Business Intelligence Analyst
6 4 (21.05%) SQL Database Developer
6 4 (21.05%) SQL Developer
6 4 (21.05%) SQL Server Developer
7 3 (15.79%) T-SQL Developer
8 2 (10.53%) Business Intelligence Developer
8 2 (10.53%) Senior Systems Developer
8 2 (10.53%) Systems Developer
9 1 (5.26%) Microsoft Developer
9 1 (5.26%) Senior Microsoft Developer
9 1 (5.26%) SQL BI Developer
9 1 (5.26%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 10 (52.63%) MDX
2 2 (10.53%) .NET
2 2 (10.53%) Ajax
2 2 (10.53%) CSS
2 2 (10.53%) CSS3
2 2 (10.53%) HTML
2 2 (10.53%) HTML5
2 2 (10.53%) jQuery
2 2 (10.53%) JSON
2 2 (10.53%) RESTful
2 2 (10.53%) SOAP
2 2 (10.53%) Web Services
2 2 (10.53%) XML
Miscellaneous
1 5 (26.32%) Analytical Skills
2 3 (15.79%) Computer Science
2 3 (15.79%) Data Integration
3 1 (5.26%) Management Information System
Operating Systems
1 3 (15.79%) Windows
Processes & Methodologies
1 17 (89.47%) Business Intelligence
2 13 (68.42%) ETL
3 7 (36.84%) Agile Software Development
4 4 (21.05%) TDD
5 2 (10.53%) CRM
5 2 (10.53%) ERP
5 2 (10.53%) MVC
5 2 (10.53%) OO
5 2 (10.53%) OOP
5 2 (10.53%) Project Management
5 2 (10.53%) Prototyping
5 2 (10.53%) Responsive Web Design
5 2 (10.53%) Waterfall
5 2 (10.53%) Web Design
6 1 (5.26%) Data Analysis
6 1 (5.26%) Data Migration
6 1 (5.26%) Data Transformation
6 1 (5.26%) ETL Development
6 1 (5.26%) Mentoring
6 1 (5.26%) Migration
Programming Languages
1 18 (94.74%) SQL
2 11 (57.89%) T-SQL
3 2 (10.53%) JavaScript
3 2 (10.53%) PHP
3 2 (10.53%) PL/SQL
3 2 (10.53%) X++
Qualifications
1 3 (15.79%) Degree
Quality Assurance & Compliance
1 3 (15.79%) QA
Vendors
1 12 (63.16%) Microsoft
2 2 (10.53%) Oracle
2 2 (10.53%) Serena