Period
to 19 June 2018

The following table provides summary statistics for permanent job vacancies advertised in England with a requirement for PowerPivot skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited PowerPivot over the 6 months to 19 June 2018 with a comparison to the same period in the previous 2 years.

Microsoft Power Pivot
UK > England
6 months to
19 Jun 2018
Same period 2017 Same period 2016
Rank 1016 1054 990
Rank change year-on-year +38 -64 -55
Permanent jobs citing PowerPivot 145 106 256
As % of all permanent IT jobs advertised in England 0.090% 0.065% 0.14%
As % of the Database & Business Intelligence category 0.29% 0.21% 0.45%
Number of salaries quoted 105 94 209
England median annual salary £51,000 £46,250 £50,000
Median salary % change year-on-year +10.27% -7.50% -
10th Percentile £26,250 £26,750 £27,500
90th Percentile £71,500 £70,000 £74,000
UK median annual salary £51,000 £45,000 £50,000
% change year-on-year +13.33% -10.00% -

PowerPivot is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 49,399 49,546 57,465
As % of all permanent IT jobs advertised in England 30.66% 30.58% 30.59%
Number of salaries quoted 40,693 42,329 49,565
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £29,750 £28,750
90th Percentile £81,250 £77,500 £75,000
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

PowerPivot
Job Vacancy Trend in England

Job postings citing PowerPivot as a percentage of all IT jobs advertised in England.

Job vacancy trend for PowerPivot in England

PowerPivot
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing PowerPivot in England.

Salary trend for PowerPivot in England

PowerPivot
Salary Histogram in England

The salary distribution of IT jobs citing PowerPivot in England over the 6 months to 19 June 2018.

Salary histogram for PowerPivot in England

PowerPivot
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the England region over the 6 months to 19 June 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London +42 80 £61,250 -5.77% 12
East of England +42 33 £34,000 -35.24% 3
North of England -13 11 £32,500 -7.89% 1
South West +6 10 £40,000 +42.86% 2
South East -14 7 £47,500 +5.56% 2
Yorkshire +19 6 £62,500 +56.25% 1
North West -15 5 £31,500 +5.00%
Midlands +2 4 £35,000 -28.57%
East Midlands -7 4 £35,000 -31.03%
PowerPivot
UK

For the 6 months to 19 June 2018, IT jobs citing PowerPivot also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the England region with a requirement for PowerPivot.

1 137 (94.48%) Business Intelligence
2 117 (80.69%) Power BI
3 100 (68.97%) SQL
4 99 (68.28%) SQL Server Integration Services
5 95 (65.52%) Microsoft
6 91 (62.76%) SQL Server Reporting Services
7 86 (59.31%) Microsoft Excel
8 83 (57.24%) SQL Server Analysis Services
9 82 (56.55%) SQL Server
10 77 (53.10%) ETL
11 74 (51.03%) Data Warehouse
12 65 (44.83%) Data Modelling
13 56 (38.62%) Analytics
14 45 (31.03%) Microsoft Power View
15 38 (26.21%) Finance
15 38 (26.21%) Data Analysis Expressions (DAX)
16 34 (23.45%) T-SQL
17 29 (20.00%) Visualisation
18 28 (19.31%) Microsoft Azure
19 27 (18.62%) Analytical Skills
20 25 (17.24%) Advertising
21 24 (16.55%) Problem-Solving
22 23 (15.86%) Data Analysis
23 21 (14.48%) .NET
24 20 (13.79%) Tableau
25 19 (13.10%) Data Integration
25 19 (13.10%) Degree
25 19 (13.10%) Agile Software Development
26 18 (12.41%) C#
26 18 (12.41%) MDX

PowerPivot
Co-occurring IT Skills in England 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 17 (11.72%) SharePoint
2 11 (7.59%) BizTalk Server
3 9 (6.21%) Oracle SOA Suite
4 6 (4.14%) Apache Spark
5 3 (2.07%) WebSphere
Applications
1 86 (59.31%) Microsoft Excel
2 10 (6.90%) Spreadsheet
3 7 (4.83%) Microsoft Office
4 3 (2.07%) MS Visio
5 1 (0.69%) SPSS
5 1 (0.69%) SPSS Modeler
Business Applications
1 15 (10.34%) Cognos Business Intelligence
2 9 (6.21%) Cognos TM1
3 1 (0.69%) Oracle ERP
Cloud Services
1 28 (19.31%) Microsoft Azure
2 9 (6.21%) Office 365
3 6 (4.14%) Azure Data Factory
3 6 (4.14%) Data Lake Analytics
4 3 (2.07%) Azure Machine Learning
4 3 (2.07%) PaaS
4 3 (2.07%) SaaS
5 2 (1.38%) Cloud Computing
5 2 (1.38%) Dynamics 365
Communications & Networking
1 3 (2.07%) Modbus
1 3 (2.07%) VPN
Database & Business Intelligence
1 117 (80.69%) Power BI
2 99 (68.28%) SQL Server Integration Services
3 91 (62.76%) SQL Server Reporting Services
4 83 (57.24%) SQL Server Analysis Services
5 82 (56.55%) SQL Server
6 74 (51.03%) Data Warehouse
7 45 (31.03%) Microsoft Power View
8 17 (11.72%) QlikView
9 14 (9.66%) SQL Server 2008
10 11 (7.59%) Relational Database
11 10 (6.90%) Data Lake
11 10 (6.90%) Microsoft Analysis Services
11 10 (6.90%) OLAP
12 9 (6.21%) SQL Server 2016
13 7 (4.83%) Big Data
14 6 (4.14%) Azure SQL Database
14 6 (4.14%) Data Mining
14 6 (4.14%) HDInsight
15 5 (3.45%) GIS
15 5 (3.45%) Spotfire
Development Applications
1 7 (4.83%) JIRA
1 7 (4.83%) SQL Server Management Studio (SSMS)
2 4 (2.76%) Toad
2 4 (2.76%) Visual Studio Team System
3 2 (1.38%) Git (software)
3 2 (1.38%) Visual Studio
4 1 (0.69%) Octopus Deploy
4 1 (0.69%) Team Foundation Server
General
1 38 (26.21%) Finance
2 25 (17.24%) Advertising
3 11 (7.59%) Retail
4 5 (3.45%) Law
4 5 (3.45%) Legal
4 5 (3.45%) Marketing
5 4 (2.76%) Banking
5 4 (2.76%) Investment Banking
5 4 (2.76%) Local Government
6 2 (1.38%) Manufacturing
7 1 (0.69%) Billing
7 1 (0.69%) Electronics
7 1 (0.69%) Front Office
7 1 (0.69%) Games
7 1 (0.69%) Telecoms
Job Titles
1 71 (48.97%) Developer
2 59 (40.69%) Business Intelligence Developer
3 40 (27.59%) Analyst
4 27 (18.62%) Business Intelligence Analyst
5 24 (16.55%) Power BI Developer
6 18 (12.41%) Architect
6 18 (12.41%) SSAS Developer
7 17 (11.72%) Senior Developer
7 17 (11.72%) SSIS Developer
8 16 (11.03%) Consultant
8 16 (11.03%) SSRS Developer
9 15 (10.34%) Business Intelligence Architect
9 15 (10.34%) Senior Business Intelligence Developer
10 12 (8.28%) Business Developer
10 12 (8.28%) Business Intelligence Consultant
11 10 (6.90%) Business Intelligence Lead
11 10 (6.90%) Power BI Consultant
11 10 (6.90%) SQL Developer
12 9 (6.21%) Analyst Developer
12 9 (6.21%) Report Developer
Libraries, Frameworks & Software Standards
1 21 (14.48%) .NET
2 18 (12.41%) MDX
3 12 (8.28%) Middleware
4 4 (2.76%) ASP.NET
4 4 (2.76%) Kafka
5 1 (0.69%) COM
5 1 (0.69%) D3.js
5 1 (0.69%) EDI
5 1 (0.69%) Web Services
5 1 (0.69%) XML
Miscellaneous
1 27 (18.62%) Analytical Skills
2 10 (6.90%) Computer Science
3 8 (5.52%) Greenfield Project
3 8 (5.52%) Self-Motivation
4 6 (4.14%) Management Information System
5 4 (2.76%) Enterprise Software
5 4 (2.76%) Fintech
6 3 (2.07%) Credit Risk
7 2 (1.38%) FMCG
7 2 (1.38%) Hedge funds
7 2 (1.38%) Life Science
7 2 (1.38%) NHS
7 2 (1.38%) Reinsurance
8 1 (0.69%) Data Structures
8 1 (0.69%) Replication
8 1 (0.69%) Social Media
8 1 (0.69%) User Experience
Operating Systems
1 1 (0.69%) Windows
1 1 (0.69%) Windows Server
1 1 (0.69%) Windows Server 2012
Processes & Methodologies
1 137 (94.48%) Business Intelligence
2 77 (53.10%) ETL
3 65 (44.83%) Data Modelling
4 56 (38.62%) Analytics
5 29 (20.00%) Visualisation
6 24 (16.55%) Problem-Solving
7 23 (15.86%) Data Analysis
8 19 (13.10%) Agile Software Development
8 19 (13.10%) Data Integration
9 14 (9.66%) Kimball Methodology
10 13 (8.97%) Machine Learning
10 13 (8.97%) Stakeholder Management
11 11 (7.59%) Business Analysis
12 9 (6.21%) Data Science
12 9 (6.21%) Data Visualisation
12 9 (6.21%) Information Management
12 9 (6.21%) SOA
13 8 (5.52%) Data Management
13 8 (5.52%) Decision-Making
13 8 (5.52%) Performance Optimisation
Programming Languages
1 100 (68.97%) SQL
2 38 (26.21%) Data Analysis Expressions (DAX)
3 34 (23.45%) T-SQL
4 18 (12.41%) C#
5 16 (11.03%) VBA
6 10 (6.90%) Python
7 7 (4.83%) VB
7 7 (4.83%) VB.NET
8 6 (4.14%) R
9 4 (2.76%) MATLAB
10 3 (2.07%) VBScript
11 1 (0.69%) C
11 1 (0.69%) JavaScript
11 1 (0.69%) PL/SQL
11 1 (0.69%) PowerShell
Qualifications
1 19 (13.10%) Degree
2 6 (4.14%) Computer Science Degree
3 3 (2.07%) Postgraduate
4 2 (1.38%) ACCA
4 2 (1.38%) Master's Degree
5 1 (0.69%) CIMA
5 1 (0.69%) DBS Check
5 1 (0.69%) Numerate Degree
Quality Assurance & Compliance
1 9 (6.21%) QA
2 4 (2.76%) SLA
3 3 (2.07%) Cyber Essentials
3 3 (2.07%) ISO/IEC 27001
4 2 (1.38%) Data Quality
5 1 (0.69%) GAAP
5 1 (0.69%) GDPR
5 1 (0.69%) Solvency II
Systems Management
1 1 (0.69%) Control-M
1 1 (0.69%) Opscode Chef
1 1 (0.69%) Puppet
1 1 (0.69%) Systems Management Server (SMS)
Vendors
1 95 (65.52%) Microsoft
2 20 (13.79%) Tableau
3 17 (11.72%) Cognos
4 14 (9.66%) Oracle
5 11 (7.59%) Informatica
5 11 (7.59%) Talend
6 9 (6.21%) Hyperion
7 4 (2.76%) Alteryx
7 4 (2.76%) SAP
8 3 (2.07%) Capita
8 3 (2.07%) IBM
8 3 (2.07%) Nintex
9 2 (1.38%) Cognizant
9 2 (1.38%) TOWER Software
10 1 (0.69%) MicroStrategy