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

3 months to
26 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 62 71 66
Rank change year-on-year
+9 -5
Permanent jobs citing OLAP 11 5 10
As % of all permanent IT jobs located in Cardiff 1.61% 0.65% 1.44%
As % of the Database & Business Intelligence category 6.83% 2.24% 5.68%
Number of salaries quoted 7 4 10
Median salary £32,500 £35,750 £41,980
Median salary % change year-on-year
-9.09% -14.84%
90% offered a salary of more than £22,100 £34,000 £37,250
10% offered a salary of more than £38,500 £40,125 £45,000
UK excluding London median salary £46,750 £40,000 £42,500
% change year-on-year
+16.87% -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
161 223 176
As % of all permanent IT jobs located in Cardiff 23.54% 29.19% 25.32%
Number of salaries quoted 150 173 160
Median salary £36,000 £38,000 £38,783
Median salary % change year-on-year
-5.26% -2.01%
90% offered a salary of more than £22,500 £28,500 £29,500
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 26 June 2016.

OLAP Salary Histogram in Cardiff

OLAP
Top 30 Related IT Skills in Cardiff

For the 6 months to 26 June 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%) Business Intelligence
2 17 (89.47%) SQL
2 17 (89.47%) SQL Server
3 16 (84.21%) SQL Server Analysis Services
4 15 (78.95%) SQL Server Reporting Services
5 14 (73.68%) Data Warehouse
5 14 (73.68%) SQL Server Integration Services
6 12 (63.16%) SQL Server 2012
6 12 (63.16%) OLAP Cube
7 11 (57.89%) MDX
7 11 (57.89%) ETL
7 11 (57.89%) MS Excel
7 11 (57.89%) Microsoft
8 6 (31.58%) T-SQL
8 6 (31.58%) Agile Software Development
9 5 (26.32%) SQL Server 2008
10 4 (21.05%) Analytical Skills
10 4 (21.05%) BusinessObjects
10 4 (21.05%) Visual Studio
10 4 (21.05%) OLTP
10 4 (21.05%) Team Foundation Server
10 4 (21.05%) Relational Database
11 3 (15.79%) Data Integration
11 3 (15.79%) Tableau
11 3 (15.79%) Kimball Methodology
11 3 (15.79%) Inmon Methodology
11 3 (15.79%) QA
11 3 (15.79%) Oracle OLAP
11 3 (15.79%) QlikView
11 3 (15.79%) SharePoint

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 3 (15.79%) SharePoint
2 1 (5.26%) SharePoint 2013
Applications
1 11 (57.89%) MS Excel
2 1 (5.26%) MS Office
Cloud Services
1 2 (10.53%) Microsoft Azure
Database & Business Intelligence
1 17 (89.47%) SQL Server
2 16 (84.21%) SQL Server Analysis Services
3 15 (78.95%) SQL Server Reporting Services
4 14 (73.68%) Data Warehouse
4 14 (73.68%) SQL Server Integration Services
5 12 (63.16%) OLAP Cube
5 12 (63.16%) SQL Server 2012
6 5 (26.32%) SQL Server 2008
7 4 (21.05%) BusinessObjects
7 4 (21.05%) OLTP
7 4 (21.05%) Relational Database
8 3 (15.79%) Oracle OLAP
8 3 (15.79%) QlikView
9 2 (10.53%) Microsoft Analysis Services
10 1 (5.26%) DataStage
10 1 (5.26%) Microsoft Power View
10 1 (5.26%) SQL Server 2014
10 1 (5.26%) Star Schema
Development Applications
1 4 (21.05%) Team Foundation Server
1 4 (21.05%) Visual Studio
2 3 (15.79%) SQL Server Management Studio (SSMS)
General
1 3 (15.79%) Advertising
2 1 (5.26%) Finance
Job Titles
1 15 (78.95%) Developer
2 9 (47.37%) Database Developer
3 8 (42.11%) SQL Developer
4 7 (36.84%) Analyst
4 7 (36.84%) Business Intelligence Analyst
4 7 (36.84%) Business Intelligence Developer
4 7 (36.84%) SSAS Developer
4 7 (36.84%) SSIS Developer
4 7 (36.84%) SSRS Developer
5 5 (26.32%) Senior Database Developer
5 5 (26.32%) Senior Developer
5 5 (26.32%) SQL BI Developer
6 4 (21.05%) SQL Database Developer
6 4 (21.05%) SQL Server Developer
7 3 (15.79%) Analyst Developer
7 3 (15.79%) T-SQL Developer
8 2 (10.53%) Business Developer
8 2 (10.53%) SQL Analyst
9 1 (5.26%) Developer Analyst
9 1 (5.26%) Systems Support Analyst
Libraries, Frameworks & Software Standards
1 11 (57.89%) MDX
2 1 (5.26%) Oracle Streams
Miscellaneous
1 4 (21.05%) Analytical Skills
2 3 (15.79%) Data Integration
3 2 (10.53%) Management Information System
Operating Systems
1 1 (5.26%) Windows
Processes & Methodologies
1 19 (100.00%) Business Intelligence
2 11 (57.89%) ETL
3 6 (31.58%) Agile Software Development
4 3 (15.79%) Inmon Methodology
4 3 (15.79%) ITIL
4 3 (15.79%) Kimball Methodology
4 3 (15.79%) PRINCE2
4 3 (15.79%) Scrum
5 2 (10.53%) TDD
6 1 (5.26%) Coaching
6 1 (5.26%) Content Management
6 1 (5.26%) Data Analysis
6 1 (5.26%) Data Migration
6 1 (5.26%) Data Transformation
6 1 (5.26%) Knowledge Management
6 1 (5.26%) Mentoring
6 1 (5.26%) Migration
6 1 (5.26%) Project Management
6 1 (5.26%) Service Delivery
Programming Languages
1 17 (89.47%) SQL
2 6 (31.58%) T-SQL
Qualifications
1 2 (10.53%) Degree
Quality Assurance & Compliance
1 3 (15.79%) QA
Vendors
1 11 (57.89%) Microsoft
2 3 (15.79%) Oracle
2 3 (15.79%) Tableau
3 1 (5.26%) IBM