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

3 months to
20 Jan 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
West Sussex / Crawley
Rank 51 62 -
Rank change year-on-year
+11 -
Permanent jobs citing OLAP 2 1 0
As % of all permanent IT jobs located in Crawley 0.50% 0.29% -
As % of the Database & Business Intelligence category 2.02% 0.62% -
Number of salaries quoted 2 1 0
Median salary £44,500 £40,000 -
Median salary % change year-on-year
+11.25% -
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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

Database & Business Intelligence Category
Crawley
Permanent IT job ads with a match in the
Database & Business Intelligence category
99 161 137
As % of all permanent IT jobs located in Crawley 24.94% 46.13% 34.60%
Number of salaries quoted 91 159 120
Median salary £50,000 £50,000 £40,500
Median salary % change year-on-year
- +23.45%
90% offered a salary of more than £40,000 £27,500 £26,500
10% offered a salary of more than £65,000 £62,500 £55,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

OLAP
Jobs Demand Trend in Crawley

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

OLAP Jobs Demand Trend in Crawley

OLAP
Salary Trend in Crawley

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

OLAP Salary Trend in Crawley

OLAP
Salary Histogram in Crawley

This chart provides a salary histogram for IT jobs citing OLAP across the Crawley region over the 3 months to 20 January 2017.

OLAP Salary Histogram in Crawley

OLAP
Top 30 Related IT Skills in Crawley

For the 6 months to 20 January 2017, 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 Crawley region with a requirement for OLAP.

1 4 (100.00%) SQL
1 4 (100.00%) OLTP
2 3 (75.00%) SQL Server
2 3 (75.00%) Business Intelligence
3 2 (50.00%) Kimball Methodology
3 2 (50.00%) NoSQL
3 2 (50.00%) Big Data
3 2 (50.00%) Power BI
3 2 (50.00%) MySQL
3 2 (50.00%) Oracle
3 2 (50.00%) CRM
3 2 (50.00%) Cognos
3 2 (50.00%) ETL
3 2 (50.00%) Microsoft
3 2 (50.00%) Advertising
3 2 (50.00%) Scrum
3 2 (50.00%) Agile Software Development
3 2 (50.00%) SQL Server Reporting Services
3 2 (50.00%) SQL Server Integration Services
3 2 (50.00%) Oracle OLAP
3 2 (50.00%) SQL Server Analysis Services
3 2 (50.00%) Kanban
4 1 (25.00%) Talend Open Studio
4 1 (25.00%) FastStats
4 1 (25.00%) Hadoop
4 1 (25.00%) Time Management
4 1 (25.00%) BusinessObjects XI
4 1 (25.00%) JIRA
4 1 (25.00%) Dynamics NAV
4 1 (25.00%) Dynamics CRM

OLAP
Top Related IT Skills in Crawley 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:

Business Applications
1 1 (25.00%) Dynamics CRM
1 1 (25.00%) Dynamics NAV
1 1 (25.00%) FastStats
Database & Business Intelligence
1 4 (100.00%) OLTP
2 3 (75.00%) SQL Server
3 2 (50.00%) Big Data
3 2 (50.00%) MySQL
3 2 (50.00%) NoSQL
3 2 (50.00%) Oracle OLAP
3 2 (50.00%) Power BI
3 2 (50.00%) SQL Server Analysis Services
3 2 (50.00%) SQL Server Integration Services
3 2 (50.00%) SQL Server Reporting Services
4 1 (25.00%) BusinessObjects
4 1 (25.00%) BusinessObjects XI
4 1 (25.00%) Data Warehouse
4 1 (25.00%) Hadoop
4 1 (25.00%) Oracle Reports
4 1 (25.00%) RDBMS
4 1 (25.00%) Relational Database
4 1 (25.00%) SQL Server 2012
Development Applications
1 1 (25.00%) JIRA
1 1 (25.00%) Talend Open Studio
General
1 2 (50.00%) Advertising
Job Titles
1 2 (50.00%) Analyst
2 1 (25.00%) Business Intelligence Analyst
2 1 (25.00%) Business Intelligence Lead
2 1 (25.00%) Project Leader
2 1 (25.00%) Report Analyst
2 1 (25.00%) SQL Analyst
2 1 (25.00%) SSIS Analyst
2 1 (25.00%) SSRS Analyst
Processes & Methodologies
1 3 (75.00%) Business Intelligence
2 2 (50.00%) Agile Software Development
2 2 (50.00%) CRM
2 2 (50.00%) ETL
2 2 (50.00%) Kanban
2 2 (50.00%) Kimball Methodology
2 2 (50.00%) Scrum
3 1 (25.00%) Decision Quality
3 1 (25.00%) Performance Tuning
3 1 (25.00%) Stakeholder Management
3 1 (25.00%) Time Management
Programming Languages
1 4 (100.00%) SQL
2 1 (25.00%) PL/SQL
Quality Assurance & Compliance
1 1 (25.00%) Data Quality
Vendors
1 2 (50.00%) Cognos
1 2 (50.00%) Microsoft
1 2 (50.00%) Oracle
2 1 (25.00%) Informatica
2 1 (25.00%) Talend