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

3 months to
27 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 56 - -
Rank change year-on-year
- 0
Permanent jobs citing OLAP 3 0 0
As % of all permanent IT jobs located in Lancashire 0.69% - -
As % of the Database & Business Intelligence category 1.97% - -
Number of salaries quoted 3 0 0
Median salary £32,500 - -
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -5.88%
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
152 189 150
As % of all permanent IT jobs located in Lancashire 35.10% 37.57% 36.67%
Number of salaries quoted 118 165 131
Median salary £35,000 £35,700 £32,500
Median salary % change year-on-year
-1.96% +9.84%
90% offered a salary of more than £27,500 £25,500 £27,000
10% offered a salary of more than £42,500 £42,500 £42,500
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 27 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 27 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
Chorley - 1 £32,500 -
Preston - 1 £47,500 -
OLAP
North West

OLAP
Top 30 Related IT Skills in Lancashire

For the 6 months to 27 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 5 (100.00%) SQL
1 5 (100.00%) SQL Server
2 4 (80.00%) Data Warehouse
2 4 (80.00%) Business Intelligence
2 4 (80.00%) Microsoft
2 4 (80.00%) SQL Server Reporting Services
2 4 (80.00%) SQL Server Integration Services
2 4 (80.00%) SQL Server Analysis Services
3 3 (60.00%) Data Modelling
3 3 (60.00%) ETL
3 3 (60.00%) MS Excel
3 3 (60.00%) T-SQL
4 2 (40.00%) PowerPivot
4 2 (40.00%) OLAP Cube
4 2 (40.00%) Enterprise Data Warehouse
4 2 (40.00%) Power BI
4 2 (40.00%) Relational Database
5 1 (20.00%) Microsoft Power View
5 1 (20.00%) Data Analytics
5 1 (20.00%) SQL Server 2012
5 1 (20.00%) Analytics
5 1 (20.00%) Data Analysis Expressions (DAX)
5 1 (20.00%) SQL Server 2000
5 1 (20.00%) SQL Server 2008
5 1 (20.00%) Pentaho
5 1 (20.00%) MDX
5 1 (20.00%) Disaster Recovery
5 1 (20.00%) Finance
5 1 (20.00%) Microsoft Analysis Services
5 1 (20.00%) OLTP

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 3 (60.00%) MS Excel
Database & Business Intelligence
1 5 (100.00%) SQL Server
2 4 (80.00%) Data Warehouse
2 4 (80.00%) SQL Server Analysis Services
2 4 (80.00%) SQL Server Integration Services
2 4 (80.00%) SQL Server Reporting Services
3 2 (40.00%) Enterprise Data Warehouse
3 2 (40.00%) OLAP Cube
3 2 (40.00%) Power BI
3 2 (40.00%) PowerPivot
3 2 (40.00%) Relational Database
4 1 (20.00%) Microsoft Analysis Services
4 1 (20.00%) Microsoft Power View
4 1 (20.00%) OLTP
4 1 (20.00%) Pentaho
4 1 (20.00%) SQL Server 2000
4 1 (20.00%) SQL Server 2008
4 1 (20.00%) SQL Server 2012
General
1 1 (20.00%) Finance
Job Titles
1 3 (60.00%) Business Intelligence Developer
1 3 (60.00%) Developer
2 2 (40.00%) Analyst
2 2 (40.00%) Microsoft BI Developer
2 2 (40.00%) Microsoft Developer
3 1 (20.00%) Administrator
3 1 (20.00%) Analyst Developer
3 1 (20.00%) Business Intelligence Analyst
3 1 (20.00%) Business Intelligence Data Analyst
3 1 (20.00%) Data Analyst
3 1 (20.00%) DBA
3 1 (20.00%) Developer Analyst
3 1 (20.00%) SQL DBA
3 1 (20.00%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 1 (20.00%) MDX
Processes & Methodologies
1 4 (80.00%) Business Intelligence
2 3 (60.00%) Data Modelling
2 3 (60.00%) ETL
3 1 (20.00%) Analytics
3 1 (20.00%) Data Analytics
3 1 (20.00%) Disaster Recovery
Programming Languages
1 5 (100.00%) SQL
2 3 (60.00%) T-SQL
3 1 (20.00%) Data Analysis Expressions (DAX)
Vendors
1 4 (80.00%) Microsoft