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

3 months to
1 Oct 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 71 80 -
Rank change year-on-year
+9 -
Permanent jobs citing OLAP 4 4 0
As % of all permanent IT jobs located in the North East 0.58% 0.53% -
As % of the Database & Business Intelligence category 1.91% 1.55% -
Number of salaries quoted 4 2 0
Median salary £38,750 £32,500 -
Median salary % change year-on-year
+19.23% -
UK excluding London median salary £50,000 £42,500 £42,500
% change year-on-year
+17.64% -
OLAP
England

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 North East region.

Database & Business Intelligence Category
North East
Permanent IT job ads with a match in the
Database & Business Intelligence category
209 258 260
As % of all permanent IT jobs located in the North East 30.47% 34.08% 31.75%
Number of salaries quoted 180 229 191
Median salary £40,000 £37,500 £34,000
Median salary % change year-on-year
+6.66% +10.29%
90% offered a salary of more than £31,250 £30,000 £23,800
10% offered a salary of more than £50,000 £45,000 £51,459
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

OLAP
Jobs Demand Trend in the North East

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

OLAP Jobs Demand Trend in the North East

OLAP
Salary Trend in the North East

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

OLAP Salary Trend in the North East

OLAP
Salary Histogram in the North East

This chart provides a salary histogram for IT jobs citing OLAP across the North East region over the 3 months to 1 October 2016.

OLAP Salary Histogram in the North East

OLAP
Job Locations in the North East

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the North East region over the 3 months to 1 October 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
Tyne and Wear 0 4 £38,750 +19.23%
OLAP
England

OLAP
Top 30 Related IT Skills in the North East

For the 6 months to 1 October 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 North East region with a requirement for OLAP.

1 11 (100.00%) SQL
1 11 (100.00%) Business Intelligence
2 9 (81.82%) SQL Server Integration Services
3 7 (63.64%) SQL Server Reporting Services
4 6 (54.55%) Microsoft
4 6 (54.55%) SQL Server
4 6 (54.55%) ETL
4 6 (54.55%) SQL Server Analysis Services
5 5 (45.45%) Finance
6 4 (36.36%) Information Security
6 4 (36.36%) Oracle Discoverer
6 4 (36.36%) Project Management
6 4 (36.36%) Oracle
6 4 (36.36%) Data Modelling
6 4 (36.36%) Data Warehouse
6 4 (36.36%) ITIL
6 4 (36.36%) Oracle Financials
6 4 (36.36%) Oracle OLAP
6 4 (36.36%) Freedom of Information
6 4 (36.36%) Data Protection
6 4 (36.36%) Data Extraction
6 4 (36.36%) Big Data
6 4 (36.36%) SQL Server 2014
6 4 (36.36%) SQL Server Management Studio (SSMS)
6 4 (36.36%) Mentoring
6 4 (36.36%) Translating Business Requirements
7 3 (27.27%) Data Quality
7 3 (27.27%) Business Analysis
7 3 (27.27%) Data Analysis
7 3 (27.27%) Dimensional Modelling

OLAP
Top Related IT Skills in the North East 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 (18.18%) SharePoint
Applications
1 2 (18.18%) MS Excel
Business Applications
1 4 (36.36%) Oracle Financials
Database & Business Intelligence
1 9 (81.82%) SQL Server Integration Services
2 7 (63.64%) SQL Server Reporting Services
3 6 (54.55%) SQL Server
3 6 (54.55%) SQL Server Analysis Services
4 4 (36.36%) Big Data
4 4 (36.36%) Data Warehouse
4 4 (36.36%) Oracle Discoverer
4 4 (36.36%) Oracle OLAP
4 4 (36.36%) SQL Server 2014
5 2 (18.18%) Microsoft Power View
5 2 (18.18%) OLAP Cube
5 2 (18.18%) Oracle Reports
5 2 (18.18%) PerformancePoint
5 2 (18.18%) Power BI
5 2 (18.18%) PowerPivot
6 1 (9.09%) OLTP
Development Applications
1 4 (36.36%) SQL Server Management Studio (SSMS)
General
1 5 (45.45%) Finance
2 2 (18.18%) Retail
Job Titles
1 7 (63.64%) Business Intelligence Developer
1 7 (63.64%) Developer
2 6 (54.55%) SQL BI Developer
2 6 (54.55%) SQL Developer
3 5 (45.45%) Business Developer
4 4 (36.36%) Analyst
4 4 (36.36%) Microsoft BI Developer
5 3 (27.27%) Business Intelligence Analyst
6 2 (18.18%) Data Analyst
6 2 (18.18%) Senior Business Intelligence Developer
6 2 (18.18%) Senior Developer
6 2 (18.18%) Senior SQL Developer
6 2 (18.18%) SSAS Developer
6 2 (18.18%) SSIS Developer
7 1 (9.09%) Business Intelligence Data Analyst
7 1 (9.09%) Data Integration Developer
7 1 (9.09%) Designer
7 1 (9.09%) Integration Developer
7 1 (9.09%) Senior Analyst
7 1 (9.09%) Senior Data Analyst
Libraries, Frameworks & Software Standards
1 2 (18.18%) MDX
2 1 (9.09%) JSON
2 1 (9.09%) REST
2 1 (9.09%) XML
Miscellaneous
1 4 (36.36%) Data Extraction
1 4 (36.36%) Freedom of Information
2 3 (27.27%) Computer Science
2 3 (27.27%) Mathematics
3 2 (18.18%) Data Integration
3 2 (18.18%) User Experience
4 1 (9.09%) Analytical Skills
Processes & Methodologies
1 11 (100.00%) Business Intelligence
2 6 (54.55%) ETL
3 4 (36.36%) Data Modelling
3 4 (36.36%) Data Protection
3 4 (36.36%) Information Security
3 4 (36.36%) ITIL
3 4 (36.36%) Mentoring
3 4 (36.36%) Project Management
3 4 (36.36%) Translating Business Requirements
4 3 (27.27%) Business Analysis
4 3 (27.27%) Data Analysis
4 3 (27.27%) Dimensional Modelling
5 2 (18.18%) Change Management
5 2 (18.18%) Critical Success Factor
5 2 (18.18%) Data Architecture
5 2 (18.18%) Stakeholder Engagement
5 2 (18.18%) UX Design
6 1 (9.09%) Data Analytics
6 1 (9.09%) ERP
6 1 (9.09%) SOA
Programming Languages
1 11 (100.00%) SQL
2 2 (18.18%) Data Analysis Expressions (DAX)
3 1 (9.09%) Python
3 1 (9.09%) R
3 1 (9.09%) T-SQL
3 1 (9.09%) VB
Qualifications
1 3 (27.27%) Degree
1 3 (27.27%) ISEB
Quality Assurance & Compliance
1 3 (27.27%) Data Quality
1 3 (27.27%) QA
Vendors
1 6 (54.55%) Microsoft
2 4 (36.36%) Oracle
3 1 (9.09%) ION Trading