Period
to 17 January 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 17 January 2018 with a comparison to the same period in the previous 2 years.

Microsoft Power Pivot
UK > England
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 1014 975 928
Rank change year-on-year -39 -47 -62
Permanent jobs citing PowerPivot 131 179 326
As % of all permanent IT jobs advertised in England 0.081% 0.11% 0.17%
As % of the Database & Business Intelligence category 0.26% 0.36% 0.53%
Number of salaries quoted 109 163 265
England median annual salary £54,979 £50,000 £42,000
Median salary % change year-on-year +9.96% +19.05% -6.67%
10th Percentile £30,950 £31,350 £28,250
90th Percentile £67,500 £68,750 £68,750
UK median annual salary £54,979 £50,000 £41,250
% change year-on-year +9.96% +21.21% -8.33%

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,492 49,980 61,296
As % of all permanent IT jobs advertised in England 30.52% 29.76% 31.72%
Number of salaries quoted 41,367 43,114 52,301
England median annual salary £50,000 £47,500 £46,000
Median salary % change year-on-year +5.26% +3.26% +2.22%
10th Percentile £30,500 £29,750 £28,750
90th Percentile £77,500 £77,500 £75,000
UK median annual salary £48,000 £47,500 £45,000
% change year-on-year +1.05% +5.56% +1.69%

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 17 January 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 17 January 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 +30 83 £60,000 +9.09% 11
South East -7 18 £30,000 -36.84% 2
North of England -2 15 £38,000 -10.59% 1
North West -2 10 £38,000 -36.67% 1
Midlands +10 8 £35,000 -6.67% 1
South West +5 6 £53,750 +91.96%
Yorkshire +15 5 £40,000 +6.67%
East Midlands +18 4 £31,500 -21.25%
West Midlands +8 4 £35,000 - 1
East of England +11 1 £57,500 +4.55% 1
PowerPivot
UK

For the 6 months to 17 January 2018, IT jobs citing PowerPivot 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 England region with a requirement for PowerPivot.

1 117 (89.31%) Business Intelligence
2 101 (77.10%) SQL
3 99 (75.57%) Power BI
4 96 (73.28%) SQL Server
5 82 (62.60%) SQL Server Integration Services
6 81 (61.83%) SQL Server Reporting Services
6 81 (61.83%) Data Warehouse
7 76 (58.02%) Microsoft Excel
8 71 (54.20%) Microsoft
9 63 (48.09%) SQL Server Analysis Services
10 53 (40.46%) ETL
11 48 (36.64%) Analytical Skills
12 42 (32.06%) Analytics
13 40 (30.53%) T-SQL
14 38 (29.01%) Data Modelling
15 31 (23.66%) Finance
15 31 (23.66%) Agile Software Development
16 29 (22.14%) OLAP
17 28 (21.37%) Data Analysis
17 28 (21.37%) Data Analysis Expressions (DAX)
18 27 (20.61%) MDX
19 24 (18.32%) Microsoft Analysis Services
19 24 (18.32%) Tableau
20 23 (17.56%) Relational Database
21 22 (16.79%) Degree
21 22 (16.79%) Kimball Methodology
22 21 (16.03%) Big Data
22 21 (16.03%) Visualisation
23 20 (15.27%) Microsoft Power View
24 19 (14.50%) Performance Tuning

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 16 (12.21%) SharePoint
2 12 (9.16%) Apache Spark
3 2 (1.53%) IIS
4 1 (0.76%) WebSphere
Applications
1 76 (58.02%) Microsoft Excel
2 5 (3.82%) Microsoft PowerPoint
3 3 (2.29%) Spreadsheet
4 2 (1.53%) Microsoft Office
5 1 (0.76%) MS Visio
5 1 (0.76%) SPSS
Business Applications
1 2 (1.53%) Dynamics AX
2 1 (0.76%) NetSuite
Cloud Services
1 19 (14.50%) Microsoft Azure
2 12 (9.16%) Azure Machine Learning
2 12 (9.16%) Cloud Computing
3 2 (1.53%) Azure Data Factory
4 1 (0.76%) Cortana Intelligence Suite
4 1 (0.76%) Data Lake Analytics
4 1 (0.76%) Dynamics 365
4 1 (0.76%) PaaS
4 1 (0.76%) SaaS
Communications & Networking
1 16 (12.21%) Internet
Database & Business Intelligence
1 99 (75.57%) Power BI
2 96 (73.28%) SQL Server
3 82 (62.60%) SQL Server Integration Services
4 81 (61.83%) Data Warehouse
4 81 (61.83%) SQL Server Reporting Services
5 63 (48.09%) SQL Server Analysis Services
6 29 (22.14%) OLAP
7 24 (18.32%) Microsoft Analysis Services
8 23 (17.56%) Relational Database
9 21 (16.03%) Big Data
10 20 (15.27%) Microsoft Power View
11 19 (14.50%) SQL Server 2008
12 17 (12.98%) OLAP Cube
13 16 (12.21%) Hadoop
14 14 (10.69%) BusinessObjects
15 11 (8.40%) QlikView
15 11 (8.40%) SQL Server 2014
16 9 (6.87%) SQL Server 2016
17 8 (6.11%) Enterprise Data Warehouse
17 8 (6.11%) GIS
Development Applications
1 17 (12.98%) Team Foundation Server
2 9 (6.87%) JIRA
3 7 (5.34%) SQL Server Management Studio (SSMS)
4 5 (3.82%) Visual Studio
5 4 (3.05%) Octopus Deploy
General
1 31 (23.66%) Finance
2 15 (11.45%) Retail
3 12 (9.16%) Banking
4 10 (7.63%) Retail Banking
5 7 (5.34%) Publishing
6 6 (4.58%) Back Office
6 6 (4.58%) Marketing
7 5 (3.82%) Advertising
8 1 (0.76%) Automotive
8 1 (0.76%) Manufacturing
8 1 (0.76%) Pharmaceutical
Job Titles
1 63 (48.09%) Developer
2 48 (36.64%) Business Intelligence Developer
3 39 (29.77%) Analyst
4 23 (17.56%) SQL Developer
5 18 (13.74%) Data Analyst
6 17 (12.98%) Power BI Developer
7 16 (12.21%) SQL BI Developer
8 15 (11.45%) Business Intelligence Consultant
8 15 (11.45%) Consultant
9 14 (10.69%) Business Intelligence Lead
10 12 (9.16%) Business Intelligence Analyst
10 12 (9.16%) SSAS Developer
10 12 (9.16%) SSIS Developer
11 11 (8.40%) Business Developer
12 10 (7.63%) SSRS Developer
13 9 (6.87%) Agile Developer
13 9 (6.87%) T-SQL Developer
14 8 (6.11%) DBA
14 8 (6.11%) SQL DBA
15 7 (5.34%) SQL Analyst
Libraries, Frameworks & Software Standards
1 27 (20.61%) MDX
2 13 (9.92%) .NET
3 1 (0.76%) COM
3 1 (0.76%) CSS
3 1 (0.76%) HTML
3 1 (0.76%) Web Services
3 1 (0.76%) XML
Miscellaneous
1 48 (36.64%) Analytical Skills
2 16 (12.21%) NHS
3 8 (6.11%) Management Information System
4 7 (5.34%) iPhone
5 5 (3.82%) Driving Licence
6 3 (2.29%) Fintech
7 2 (1.53%) Credit Risk
8 1 (0.76%) Algorithms
8 1 (0.76%) Data Structures
8 1 (0.76%) Enterprise Software
8 1 (0.76%) Greenfield Project
Operating Systems
1 2 (1.53%) Windows
1 2 (1.53%) Windows Server 2008
1 2 (1.53%) Windows Server 2012
2 1 (0.76%) Linux
Processes & Methodologies
1 117 (89.31%) Business Intelligence
2 53 (40.46%) ETL
3 42 (32.06%) Analytics
4 38 (29.01%) Data Modelling
5 31 (23.66%) Agile Software Development
6 28 (21.37%) Data Analysis
7 22 (16.79%) Kimball Methodology
8 21 (16.03%) Visualisation
9 19 (14.50%) Performance Tuning
10 16 (12.21%) Dimensional Modelling
11 15 (11.45%) Machine Learning
12 14 (10.69%) Scrum
13 11 (8.40%) Migration
14 10 (7.63%) Mathematics
14 10 (7.63%) Performance Monitoring
15 8 (6.11%) Kanban
16 7 (5.34%) Data Analytics
16 7 (5.34%) Data Integration
16 7 (5.34%) Data Management
16 7 (5.34%) Data Visualisation
Programming Languages
1 101 (77.10%) SQL
2 40 (30.53%) T-SQL
3 28 (21.37%) Data Analysis Expressions (DAX)
4 18 (13.74%) VBA
5 6 (4.58%) PowerShell
6 5 (3.82%) C#
7 4 (3.05%) JavaScript
8 3 (2.29%) R
9 2 (1.53%) Java
10 1 (0.76%) Python
10 1 (0.76%) X++
Qualifications
1 22 (16.79%) Degree
2 5 (3.82%) MCSA
2 5 (3.82%) MCSE
2 5 (3.82%) Microsoft Certification
3 4 (3.05%) MBA
4 3 (2.29%) ACCA
5 2 (1.53%) Postgraduate
6 1 (0.76%) APMP
6 1 (0.76%) CIMA
6 1 (0.76%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 9 (6.87%) Data Quality
2 5 (3.82%) NEBOSH
3 2 (1.53%) GAAP
3 2 (1.53%) QA
3 2 (1.53%) Solvency II
4 1 (0.76%) Cyber Essentials
4 1 (0.76%) ISO/IEC 27001
Systems Management
1 1 (0.76%) Systems Management Server (SMS)
Vendors
1 71 (54.20%) Microsoft
2 24 (18.32%) Tableau
3 15 (11.45%) Oracle
4 9 (6.87%) MicroStrategy
5 6 (4.58%) RedGate
5 6 (4.58%) SAP
6 4 (3.05%) Informatica
7 2 (1.53%) Cloudera
7 2 (1.53%) Hortonworks
7 2 (1.53%) IDERA
7 2 (1.53%) Talend
8 1 (0.76%) Birst
8 1 (0.76%) Cognos
8 1 (0.76%) IBM
8 1 (0.76%) JD Edwards
8 1 (0.76%) Logi
8 1 (0.76%) Logi Analytics
8 1 (0.76%) Nintex