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

3 months to
23 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 50 62 59
Rank change year-on-year
+12 -3
Permanent jobs citing OLAP 3 9 1
As % of all permanent IT jobs located in Derbyshire 0.80% 1.56% 0.20%
As % of the Database & Business Intelligence category 2.40% 4.64% 0.74%
Number of salaries quoted 3 7 1
Median salary £65,000 £42,500 £55,000
Median salary % change year-on-year
+52.94% -22.72%
UK excluding London median salary £47,500 £40,000 £44,500
% change year-on-year
+18.75% -10.11%
OLAP
East Midlands

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

Database & Business Intelligence Category
Derbyshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
125 194 135
As % of all permanent IT jobs located in Derbyshire 33.42% 33.62% 27.61%
Number of salaries quoted 98 163 117
Median salary £37,500 £40,000 £37,500
Median salary % change year-on-year
-6.25% +6.66%
90% offered a salary of more than £30,000 £25,000 £25,000
10% offered a salary of more than £50,000 £50,000 £50,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 Derbyshire

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

OLAP Jobs Demand Trend in Derbyshire

OLAP
Salary Trend in Derbyshire

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

OLAP Salary Trend in Derbyshire

OLAP
Salary Histogram in Derbyshire

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

OLAP Salary Histogram in Derbyshire

OLAP
Job Locations in Derbyshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Derbyshire region over the 3 months to 23 July 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Derby +10 1 £52,500 +5.00%
OLAP
East Midlands

OLAP
Top 27 Related IT Skills in Derbyshire

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

1 3 (100.00%) Business Intelligence
2 2 (66.67%) Scrum
2 2 (66.67%) Agile Software Development
2 2 (66.67%) C#
2 2 (66.67%) Java
2 2 (66.67%) SQL
2 2 (66.67%) Python
2 2 (66.67%) PowerShell
2 2 (66.67%) Scala
2 2 (66.67%) Hadoop
2 2 (66.67%) Visualisation
2 2 (66.67%) Microsoft Azure
2 2 (66.67%) Machine Learning
2 2 (66.67%) Big Data
2 2 (66.67%) Data Analytics
2 2 (66.67%) Analytics
2 2 (66.67%) Mentoring
2 2 (66.67%) Apache Spark
2 2 (66.67%) HDInsight
2 2 (66.67%) Power BI
3 1 (33.33%) Analytical Skills
3 1 (33.33%) SQL Server Integration Services
3 1 (33.33%) SQL Server Analysis Services
3 1 (33.33%) Data Modelling
3 1 (33.33%) SQL Server
3 1 (33.33%) SQL Server Reporting Services
3 1 (33.33%) Data Analysis

OLAP
Top Related IT Skills in Derbyshire 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 (66.67%) Apache Spark
Cloud Services
1 2 (66.67%) Microsoft Azure
Database & Business Intelligence
1 2 (66.67%) Big Data
1 2 (66.67%) Hadoop
1 2 (66.67%) HDInsight
1 2 (66.67%) Power BI
2 1 (33.33%) SQL Server
2 1 (33.33%) SQL Server Analysis Services
2 1 (33.33%) SQL Server Integration Services
2 1 (33.33%) SQL Server Reporting Services
Job Titles
1 2 (66.67%) Azure Developer
1 2 (66.67%) C# Developer
1 2 (66.67%) Developer
1 2 (66.67%) Lead C# Developer
1 2 (66.67%) Lead Developer
2 1 (33.33%) Business Intelligence Lead
Miscellaneous
1 2 (66.67%) Visualisation
2 1 (33.33%) Analytical Skills
Processes & Methodologies
1 3 (100.00%) Business Intelligence
2 2 (66.67%) Agile Software Development
2 2 (66.67%) Analytics
2 2 (66.67%) Data Analytics
2 2 (66.67%) Machine Learning
2 2 (66.67%) Mentoring
2 2 (66.67%) Scrum
3 1 (33.33%) Data Analysis
3 1 (33.33%) Data Modelling
Programming Languages
1 2 (66.67%) C#
1 2 (66.67%) Java
1 2 (66.67%) PowerShell
1 2 (66.67%) Python
1 2 (66.67%) Scala
1 2 (66.67%) SQL