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

3 months to
28 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 59 61 71
Rank change year-on-year
+2 +10
Permanent jobs citing OLAP 10 6 3
As % of all permanent IT jobs located in Cardiff 1.56% 0.88% 0.45%
As % of the Database & Business Intelligence category 6.02% 2.70% 1.69%
Number of salaries quoted 6 3 3
Median salary £28,750 £37,500 £37,500
Median salary % change year-on-year
-23.33% -
90% offered a salary of more than £22,000 £34,700 £35,500
10% offered a salary of more than £38,750 £40,500 £41,084
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -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
166 222 178
As % of all permanent IT jobs located in Cardiff 25.86% 32.41% 26.65%
Number of salaries quoted 147 176 150
Median salary £37,500 £37,500 £38,783
Median salary % change year-on-year
- -3.30%
90% offered a salary of more than £22,500 £27,500 £30,000
10% offered a salary of more than £45,000 £52,500 £45,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 28 May 2016.

OLAP Salary Histogram in Cardiff

OLAP
Top 30 Related IT Skills in Cardiff

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

1 22 (100.00%) Business Intelligence
2 20 (90.91%) SQL
3 19 (86.36%) SQL Server Reporting Services
3 19 (86.36%) SQL Server Analysis Services
4 17 (77.27%) Data Warehouse
4 17 (77.27%) SQL Server Integration Services
5 16 (72.73%) SQL Server
6 14 (63.64%) MDX
7 12 (54.55%) SQL Server 2012
8 11 (50.00%) MS Excel
8 11 (50.00%) OLAP Cube
9 10 (45.45%) ETL
9 10 (45.45%) Microsoft
9 10 (45.45%) Agile Software Development
10 7 (31.82%) Scrum
10 7 (31.82%) Kimball Methodology
10 7 (31.82%) Inmon Methodology
10 7 (31.82%) Oracle OLAP
10 7 (31.82%) QlikView
10 7 (31.82%) SharePoint
10 7 (31.82%) Oracle
10 7 (31.82%) ITIL
10 7 (31.82%) PRINCE2
10 7 (31.82%) Tableau
11 5 (22.73%) T-SQL
11 5 (22.73%) SQL Server 2008
12 4 (18.18%) Team Foundation Server
12 4 (18.18%) Visual Studio
12 4 (18.18%) OLTP
12 4 (18.18%) BusinessObjects

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 7 (31.82%) SharePoint
2 1 (4.55%) SharePoint 2013
Applications
1 11 (50.00%) MS Excel
2 1 (4.55%) MS Office
Cloud Services
1 2 (9.09%) Microsoft Azure
Database & Business Intelligence
1 19 (86.36%) SQL Server Analysis Services
1 19 (86.36%) SQL Server Reporting Services
2 17 (77.27%) Data Warehouse
2 17 (77.27%) SQL Server Integration Services
3 16 (72.73%) SQL Server
4 12 (54.55%) SQL Server 2012
5 11 (50.00%) OLAP Cube
6 7 (31.82%) Oracle OLAP
6 7 (31.82%) QlikView
7 5 (22.73%) SQL Server 2008
8 4 (18.18%) BusinessObjects
8 4 (18.18%) OLTP
8 4 (18.18%) Relational Database
9 2 (9.09%) Microsoft Analysis Services
10 1 (4.55%) DataStage
10 1 (4.55%) Microsoft Power View
10 1 (4.55%) SQL Server 2014
10 1 (4.55%) Star Schema
Development Applications
1 4 (18.18%) Team Foundation Server
1 4 (18.18%) Visual Studio
2 3 (13.64%) SQL Server Management Studio (SSMS)
General
1 3 (13.64%) Advertising
2 1 (4.55%) Finance
Job Titles
1 18 (81.82%) Developer
2 12 (54.55%) SQL Developer
3 11 (50.00%) Business Intelligence Developer
4 9 (40.91%) SQL BI Developer
4 9 (40.91%) SSAS Developer
4 9 (40.91%) SSIS Developer
4 9 (40.91%) SSRS Developer
5 8 (36.36%) Database Developer
6 7 (31.82%) Analyst
6 7 (31.82%) Business Intelligence Analyst
7 6 (27.27%) Business Developer
7 6 (27.27%) Senior Developer
8 4 (18.18%) Senior Database Developer
8 4 (18.18%) SQL Database Developer
8 4 (18.18%) SQL Server Developer
9 3 (13.64%) Analyst Developer
9 3 (13.64%) T-SQL Developer
10 2 (9.09%) Senior Business Intelligence Developer
10 2 (9.09%) Senior SQL Developer
10 2 (9.09%) SQL Analyst
Libraries, Frameworks & Software Standards
1 14 (63.64%) MDX
2 1 (4.55%) Oracle Streams
Miscellaneous
1 3 (13.64%) Analytical Skills
1 3 (13.64%) Data Integration
2 2 (9.09%) Management Information System
Operating Systems
1 1 (4.55%) Windows
Processes & Methodologies
1 22 (100.00%) Business Intelligence
2 10 (45.45%) Agile Software Development
2 10 (45.45%) ETL
3 7 (31.82%) Inmon Methodology
3 7 (31.82%) ITIL
3 7 (31.82%) Kimball Methodology
3 7 (31.82%) PRINCE2
3 7 (31.82%) Scrum
4 2 (9.09%) Service Management
4 2 (9.09%) TDD
5 1 (4.55%) Coaching
5 1 (4.55%) Content Management
5 1 (4.55%) Data Analysis
5 1 (4.55%) Data Migration
5 1 (4.55%) Data Transformation
5 1 (4.55%) Knowledge Management
5 1 (4.55%) Mentoring
5 1 (4.55%) Migration
5 1 (4.55%) Project Management
5 1 (4.55%) Service Delivery
Programming Languages
1 20 (90.91%) SQL
2 5 (22.73%) T-SQL
Qualifications
1 2 (9.09%) Degree
Quality Assurance & Compliance
1 3 (13.64%) QA
Vendors
1 10 (45.45%) Microsoft
2 7 (31.82%) Oracle
2 7 (31.82%) Tableau
3 1 (4.55%) IBM