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

3 months to
4 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 57 61 -
Rank change year-on-year
+4 -
Permanent jobs citing OLAP 3 1 0
As % of all permanent IT jobs located in Lancashire 0.73% 0.23% -
As % of the Database & Business Intelligence category 2.14% 0.58% -
Number of salaries quoted 3 1 0
Median salary £47,500 £27,500 -
Median salary % change year-on-year
+72.72% -
UK excluding London median salary £46,750 £40,000 £41,500
% change year-on-year
+16.87% -3.61%
OLAP
North West

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

Database & Business Intelligence Category
Lancashire
Permanent IT job ads with a match in the
Database & Business Intelligence category
140 171 164
As % of all permanent IT jobs located in Lancashire 33.90% 38.60% 37.61%
Number of salaries quoted 119 144 148
Median salary £35,000 £35,000 £34,000
Median salary % change year-on-year
- +2.94%
90% offered a salary of more than £26,000 £25,000 £27,000
10% offered a salary of more than £44,500 £42,500 £42,500
UK excluding London median salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

OLAP
Jobs Demand Trend in Lancashire

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

OLAP Jobs Demand Trend in Lancashire

OLAP
Salary Trend in Lancashire

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

OLAP Salary Trend in Lancashire

OLAP
Salary Histogram in Lancashire

This chart provides a salary histogram for IT jobs citing OLAP across the Lancashire region over the 3 months to 4 May 2016.

OLAP Salary Histogram in Lancashire

OLAP
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Lancashire region over the 3 months to 4 May 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
Preston +2 2 £47,500 +72.72%
OLAP
North West

OLAP
Top 27 Related IT Skills in Lancashire

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

1 4 (100.00%) SQL
1 4 (100.00%) SQL Server
2 3 (75.00%) Data Warehouse
2 3 (75.00%) Business Intelligence
2 3 (75.00%) Microsoft
2 3 (75.00%) SQL Server Reporting Services
2 3 (75.00%) SQL Server Integration Services
2 3 (75.00%) SQL Server Analysis Services
3 2 (50.00%) Relational Database
3 2 (50.00%) OLAP Cube
3 2 (50.00%) Enterprise Data Warehouse
3 2 (50.00%) Data Modelling
3 2 (50.00%) ETL
3 2 (50.00%) MS Excel
3 2 (50.00%) T-SQL
4 1 (25.00%) Disaster Recovery
4 1 (25.00%) Finance
4 1 (25.00%) Microsoft Analysis Services
4 1 (25.00%) OLTP
4 1 (25.00%) Power BI
4 1 (25.00%) Microsoft Power View
4 1 (25.00%) SQL Server 2000
4 1 (25.00%) SQL Server 2008
4 1 (25.00%) Pentaho
4 1 (25.00%) PowerPivot
4 1 (25.00%) Data Analytics
4 1 (25.00%) Analytics

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

Applications
1 2 (50.00%) MS Excel
Database & Business Intelligence
1 4 (100.00%) SQL Server
2 3 (75.00%) Data Warehouse
2 3 (75.00%) SQL Server Analysis Services
2 3 (75.00%) SQL Server Integration Services
2 3 (75.00%) SQL Server Reporting Services
3 2 (50.00%) Enterprise Data Warehouse
3 2 (50.00%) OLAP Cube
3 2 (50.00%) Relational Database
4 1 (25.00%) Microsoft Analysis Services
4 1 (25.00%) Microsoft Power View
4 1 (25.00%) OLTP
4 1 (25.00%) Pentaho
4 1 (25.00%) Power BI
4 1 (25.00%) PowerPivot
4 1 (25.00%) SQL Server 2000
4 1 (25.00%) SQL Server 2008
General
1 1 (25.00%) Finance
Job Titles
1 2 (50.00%) Business Intelligence Developer
1 2 (50.00%) Developer
1 2 (50.00%) Microsoft BI Developer
1 2 (50.00%) Microsoft Developer
2 1 (25.00%) Administrator
2 1 (25.00%) Analyst
2 1 (25.00%) DBA
2 1 (25.00%) SQL DBA
2 1 (25.00%) SQL Server DBA
Processes & Methodologies
1 3 (75.00%) Business Intelligence
2 2 (50.00%) Data Modelling
2 2 (50.00%) ETL
3 1 (25.00%) Analytics
3 1 (25.00%) Data Analytics
3 1 (25.00%) Disaster Recovery
Programming Languages
1 4 (100.00%) SQL
2 2 (50.00%) T-SQL
Vendors
1 3 (75.00%) Microsoft
Lancashire
Capita plc
Posted: 13 days ago