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

3 months to
29 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 90 113 113
Rank change year-on-year
+23 0
Permanent jobs citing OLAP 2 12 14
As % of all permanent IT jobs located in Cheshire 0.19% 0.72% 0.79%
As % of the Database & Business Intelligence category 0.64% 2.20% 2.06%
Number of salaries quoted 2 10 13
Median salary £47,500 £41,500 £42,500
Median salary % change year-on-year
+14.45% -2.35%
UK excluding London median salary £45,500 £40,000 £42,500
% change year-on-year
+13.75% -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 Cheshire region.

Database & Business Intelligence Category
Cheshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
311 546 680
As % of all permanent IT jobs located in Cheshire 29.40% 32.85% 38.59%
Number of salaries quoted 271 453 541
Median salary £40,000 £40,000 £37,500
Median salary % change year-on-year
- +6.66%
90% offered a salary of more than £27,500 £30,000 £28,000
10% offered a salary of more than £55,000 £47,500 £47,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 Cheshire

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

OLAP Jobs Demand Trend in Cheshire

OLAP
Salary Trend in Cheshire

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

OLAP Salary Trend in Cheshire

OLAP
Salary Histogram in Cheshire

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

OLAP Salary Histogram in Cheshire

OLAP
Job Locations in Cheshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the Cheshire region over the 3 months to 29 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
Macclesfield +5 1 £35,000 -12.50%
OLAP
North West

OLAP
Top 30 Related IT Skills in Cheshire

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

1 5 (100.00%) Business Intelligence
2 4 (80.00%) SQL
2 4 (80.00%) OLAP Cube
3 3 (60.00%) SQL Server Reporting Services
3 3 (60.00%) SQL Server Analysis Services
3 3 (60.00%) SQL Server Integration Services
3 3 (60.00%) Finance
3 3 (60.00%) T-SQL
3 3 (60.00%) Data Warehouse
3 3 (60.00%) ETL
4 2 (40.00%) Microsoft
4 2 (40.00%) SQL Server
4 2 (40.00%) MS Excel
4 2 (40.00%) Cognos
4 2 (40.00%) Agile Software Development
5 1 (20.00%) Cognos TM1
5 1 (20.00%) Cognos Controller
5 1 (20.00%) MDX
5 1 (20.00%) Cognos Business Intelligence
5 1 (20.00%) Oracle OLAP
5 1 (20.00%) Scrum
5 1 (20.00%) Essbase
5 1 (20.00%) SharePoint
5 1 (20.00%) XML
5 1 (20.00%) Oracle Reports
5 1 (20.00%) .NET
5 1 (20.00%) Oracle
5 1 (20.00%) Project Management
5 1 (20.00%) IBM
5 1 (20.00%) PL/SQL

OLAP
Top Related IT Skills in Cheshire 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 1 (20.00%) SharePoint
Applications
1 2 (40.00%) MS Excel
Business Applications
1 1 (20.00%) Cognos Business Intelligence
1 1 (20.00%) Cognos Controller
1 1 (20.00%) Cognos TM1
Database & Business Intelligence
1 4 (80.00%) OLAP Cube
2 3 (60.00%) Data Warehouse
2 3 (60.00%) SQL Server Analysis Services
2 3 (60.00%) SQL Server Integration Services
2 3 (60.00%) SQL Server Reporting Services
3 2 (40.00%) SQL Server
4 1 (20.00%) Essbase
4 1 (20.00%) Oracle BI EE
4 1 (20.00%) Oracle ODI
4 1 (20.00%) Oracle OLAP
4 1 (20.00%) Oracle Reports
4 1 (20.00%) Relational Database
General
1 3 (60.00%) Finance
Job Titles
1 4 (80.00%) Business Intelligence Developer
1 4 (80.00%) Developer
2 1 (20.00%) Analyst
2 1 (20.00%) Business Developer
2 1 (20.00%) Business Intelligence Lead
2 1 (20.00%) Business Intelligence Manager
2 1 (20.00%) Business Manager
2 1 (20.00%) Lead Developer
2 1 (20.00%) OBIEE Developer
2 1 (20.00%) Oracle BI Developer
2 1 (20.00%) Oracle Developer
2 1 (20.00%) Senior Business Intelligence Developer
2 1 (20.00%) Senior Developer
2 1 (20.00%) Senior SQL Developer
2 1 (20.00%) SQL BI Developer
2 1 (20.00%) SQL Developer
2 1 (20.00%) SSAS Developer
2 1 (20.00%) SSIS Developer
2 1 (20.00%) SSRS Developer
2 1 (20.00%) TM1 Analyst
Libraries, Frameworks & Software Standards
1 1 (20.00%) .NET
1 1 (20.00%) MDX
1 1 (20.00%) XML
Miscellaneous
1 1 (20.00%) Analytical Skills
Processes & Methodologies
1 5 (100.00%) Business Intelligence
2 3 (60.00%) ETL
3 2 (40.00%) Agile Software Development
4 1 (20.00%) E-Commerce
4 1 (20.00%) Investment Management
4 1 (20.00%) Kimball Methodology
4 1 (20.00%) Project Management
4 1 (20.00%) Scrum
4 1 (20.00%) Translating Business Requirements
Programming Languages
1 4 (80.00%) SQL
2 3 (60.00%) T-SQL
3 1 (20.00%) PL/SQL
Vendors
1 2 (40.00%) Cognos
1 2 (40.00%) Microsoft
2 1 (20.00%) IBM
2 1 (20.00%) Oracle