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

3 months to
26 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 195 203 199
Rank change year-on-year
+8 -4
Permanent jobs citing OLAP 15 20 33
As % of all permanent IT jobs located in Berkshire 0.35% 0.38% 0.56%
As % of the Database & Business Intelligence category 1.42% 1.41% 2.57%
Number of salaries quoted 15 13 22
Median salary £50,000 £40,000 £55,000
Median salary % change year-on-year
+25.00% -27.27%
90% offered a salary of more than £48,500 £35,000 £40,500
10% offered a salary of more than £58,000 £53,700 £60,000
UK excluding London median salary £48,750 £42,500 £42,500
% change year-on-year
+14.70% -
OLAP
South East

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

Database & Business Intelligence Category
Berkshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1058 1421 1284
As % of all permanent IT jobs located in Berkshire 24.56% 27.32% 21.70%
Number of salaries quoted 892 1177 995
Median salary £48,000 £47,500 £45,000
Median salary % change year-on-year
+1.05% +5.55%
90% offered a salary of more than £32,500 £35,000 £30,000
10% offered a salary of more than £60,000 £65,000 £65,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLAP
Jobs Demand Trend in Berkshire

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

OLAP Jobs Demand Trend in Berkshire

OLAP
Salary Trend in Berkshire

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

OLAP Salary Trend in Berkshire

OLAP
Salary Histogram in Berkshire

This chart provides a salary histogram for IT jobs citing OLAP across the Berkshire region over the 3 months to 26 September 2016.

OLAP Salary Histogram in Berkshire

OLAP
Job Locations in Berkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Berkshire region over the 3 months to 26 September 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
Slough +29 9 £55,000 +1.85%
Reading +11 2 £47,500 -9.52% 1
OLAP
South East

OLAP
Top 30 Related IT Skills in Berkshire

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

1 19 (82.61%) SQL Server
2 18 (78.26%) Business Intelligence
3 15 (65.22%) SQL
3 15 (65.22%) SQL Server 2012
4 12 (52.17%) MDX
4 12 (52.17%) SQL Server Integration Services
5 11 (47.83%) T-SQL
5 11 (47.83%) ETL
5 11 (47.83%) Data Warehouse
5 11 (47.83%) SQL Server 2014
6 9 (39.13%) Data Analysis Expressions (DAX)
6 9 (39.13%) Performance Tuning
6 9 (39.13%) SQL Server Reporting Services
7 8 (34.78%) Data Modelling
7 8 (34.78%) OLTP
7 8 (34.78%) MS Excel
8 7 (30.43%) Kimball Methodology
9 6 (26.09%) PL/SQL
10 5 (21.74%) Microsoft
10 5 (21.74%) Cognos
10 5 (21.74%) Cognos Powerplay
10 5 (21.74%) Visual Studio
10 5 (21.74%) MySQL
10 5 (21.74%) Statistics
10 5 (21.74%) JIRA
10 5 (21.74%) SQL Server Management Studio (SSMS)
10 5 (21.74%) Release Management
10 5 (21.74%) Business Intelligence Development Studio
10 5 (21.74%) Logical Data Model
10 5 (21.74%) Physical Data Model

OLAP
Top Related IT Skills in Berkshire 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 (8.70%) SharePoint
2 1 (4.35%) SAS
Applications
1 8 (34.78%) MS Excel
Business Applications
1 2 (8.70%) Cognos Business Intelligence
2 1 (4.35%) Oracle Financial Analyzer
Database & Business Intelligence
1 19 (82.61%) SQL Server
2 15 (65.22%) SQL Server 2012
3 12 (52.17%) SQL Server Integration Services
4 11 (47.83%) Data Warehouse
4 11 (47.83%) SQL Server 2014
5 9 (39.13%) SQL Server Reporting Services
6 8 (34.78%) OLTP
7 5 (21.74%) Business Intelligence Development Studio
7 5 (21.74%) Cognos Powerplay
7 5 (21.74%) MySQL
8 4 (17.39%) Data Mart
8 4 (17.39%) OLAP Cube
8 4 (17.39%) Oracle OLAP
8 4 (17.39%) SQL Server 2000
8 4 (17.39%) SQL Server Analysis Services
9 3 (13.04%) BusinessObjects
9 3 (13.04%) CorVu
9 3 (13.04%) QlikView
10 2 (8.70%) Cognos Framework Manager
10 2 (8.70%) Cognos Report Studio
Development Applications
1 5 (21.74%) JIRA
1 5 (21.74%) SQL Server Management Studio (SSMS)
1 5 (21.74%) Visual Studio
2 1 (4.35%) Team Foundation Server
General
1 4 (17.39%) Retail
2 3 (13.04%) Finance
3 2 (8.70%) Banking
4 1 (4.35%) Legal
Job Titles
1 15 (65.22%) Developer
2 12 (52.17%) Business Intelligence Developer
3 5 (21.74%) SQL BI Developer
3 5 (21.74%) SQL Developer
4 4 (17.39%) DBA
4 4 (17.39%) SQL DBA
4 4 (17.39%) SQL Server DBA
4 4 (17.39%) SSIS Developer
5 3 (13.04%) Consultant
5 3 (13.04%) Dashboard Consultant
5 3 (13.04%) Microsoft BI Developer
5 3 (13.04%) Microsoft Developer
5 3 (13.04%) Senior Business Intelligence Developer
5 3 (13.04%) Senior Developer
6 2 (8.70%) Business Developer
6 2 (8.70%) Business Intelligence Consultant
6 2 (8.70%) Cognos Developer
6 2 (8.70%) MySQL Developer
6 2 (8.70%) T-SQL Developer
7 1 (4.35%) Junior Cognos Developer
Libraries, Frameworks & Software Standards
1 12 (52.17%) MDX
2 2 (8.70%) .NET
Miscellaneous
1 5 (21.74%) Statistics
2 4 (17.39%) Clustering
2 4 (17.39%) Replication
3 3 (13.04%) Analytical Skills
3 3 (13.04%) Visualisation
Operating Systems
1 1 (4.35%) Linux
1 1 (4.35%) Windows
Processes & Methodologies
1 18 (78.26%) Business Intelligence
2 11 (47.83%) ETL
3 9 (39.13%) Performance Tuning
4 8 (34.78%) Data Modelling
5 7 (30.43%) Kimball Methodology
6 5 (21.74%) Logical Data Model
6 5 (21.74%) Physical Data Model
6 5 (21.74%) Release Management
7 4 (17.39%) Database Mirroring
7 4 (17.39%) E-Commerce
7 4 (17.39%) High Availability
7 4 (17.39%) Load Balancing
7 4 (17.39%) Performance Monitoring
8 3 (13.04%) Data Visualisation
9 2 (8.70%) Configuration Management
9 2 (8.70%) Dashboard Development
9 2 (8.70%) Dimensional Modelling
9 2 (8.70%) Translating Business Requirements
10 1 (4.35%) Line Management
10 1 (4.35%) Unit Testing
Programming Languages
1 15 (65.22%) SQL
2 11 (47.83%) T-SQL
3 9 (39.13%) Data Analysis Expressions (DAX)
4 6 (26.09%) PL/SQL
5 2 (8.70%) C#
5 2 (8.70%) VB.NET
6 1 (4.35%) Java
Vendors
1 5 (21.74%) Cognos
1 5 (21.74%) Microsoft
2 4 (17.39%) Oracle
3 3 (13.04%) Actuate
3 3 (13.04%) MicroStrategy
3 3 (13.04%) SAP
3 3 (13.04%) Tableau
4 1 (4.35%) Cloudera
4 1 (4.35%) MapR
Reading, Berkshire
Lawrence Harvey Enterprise
Salary: £60000 - £65000 per annum + Benefits
Posted: 5 days ago