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

Microsoft Power Pivot
UK > England
6 months to
19 Sep 2018
Same period 2017 Same period 2016
Rank 982 1037 1021
Rank change year-on-year +55 -16 -119
Permanent jobs citing PowerPivot 153 123 209
As % of all permanent IT jobs advertised in England 0.098% 0.074% 0.11%
As % of the Database & Business Intelligence category 0.33% 0.24% 0.38%
Number of salaries quoted 115 106 176
England median annual salary £50,000 £48,250 £50,000
Median salary % change year-on-year +3.63% -3.50% -
10th Percentile £26,250 £28,000 £32,250
90th Percentile £71,500 £70,000 £67,500
UK median annual salary £50,000 £47,500 £50,000
% change year-on-year +5.26% -5.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 46,406 50,693 54,548
As % of all permanent IT jobs advertised in England 29.71% 30.43% 29.81%
Number of salaries quoted 37,990 42,185 47,074
England median annual salary £50,000 £48,500 £47,500
Median salary % change year-on-year +3.09% +2.11% +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £83,750 £77,500 £76,250
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 September 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 September 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 +96 103 £52,500 -12.50% 5
East of England +28 22 £51,000 -5.12% 3
North of England +19 11 £48,250 +35.64%
South West +7 8 £40,000 -28.89% 4
Yorkshire +11 7 £62,500 +56.25%
South East +5 7 £60,000 +93.55%
Midlands +15 5 £37,500 -18.03% 1
North West +1 4 £32,500 +8.33%
East Midlands 0 3 £37,500 -23.47%
West Midlands +26 2 £36,250 +11.54% 1
PowerPivot
UK

For the 6 months to 19 September 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 143 (93.46%) Business Intelligence
2 117 (76.47%) SQL Server Integration Services
3 116 (75.82%) Microsoft
4 114 (74.51%) SQL
5 106 (69.28%) Power BI
6 104 (67.97%) SQL Server
7 103 (67.32%) Microsoft Excel
8 102 (66.67%) SQL Server Reporting Services
9 86 (56.21%) Data Warehouse
10 80 (52.29%) ETL
10 80 (52.29%) SQL Server Analysis Services
11 70 (45.75%) Data Modelling
12 62 (40.52%) Microsoft Power View
13 58 (37.91%) Analytics
14 56 (36.60%) T-SQL
15 52 (33.99%) Finance
16 40 (26.14%) Data Analysis Expressions (DAX)
17 39 (25.49%) Agile Software Development
18 33 (21.57%) Data Analysis
19 32 (20.92%) Microsoft Azure
20 27 (17.65%) SharePoint
21 26 (16.99%) Data Integration
22 25 (16.34%) Analytical Skills
23 23 (15.03%) Visualisation
23 23 (15.03%) Kimball Methodology
24 22 (14.38%) Degree
25 21 (13.73%) QA
25 21 (13.73%) Scrum
26 20 (13.07%) VBA
27 18 (11.76%) C#

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 27 (17.65%) SharePoint
2 11 (7.19%) BizTalk Server
3 9 (5.88%) Oracle SOA Suite
4 4 (2.61%) WebSphere
Applications
1 103 (67.32%) Microsoft Excel
2 18 (11.76%) Microsoft Office
3 10 (6.54%) Spreadsheet
4 5 (3.27%) MS Visio
5 2 (1.31%) Microsoft PowerPoint
6 1 (0.65%) Microsoft Project
6 1 (0.65%) SPSS
6 1 (0.65%) SPSS Modeler
Business Applications
1 13 (8.50%) Cognos Business Intelligence
2 9 (5.88%) Cognos TM1
3 7 (4.58%) Dynamics AX
4 4 (2.61%) Dynamics CRM
4 4 (2.61%) Dynamics NAV
5 1 (0.65%) NetSuite
5 1 (0.65%) Oracle ERP
Cloud Services
1 32 (20.92%) Microsoft Azure
2 11 (7.19%) Azure Data Factory
3 9 (5.88%) Office 365
4 8 (5.23%) Data Lake Analytics
5 4 (2.61%) PaaS
5 4 (2.61%) SaaS
6 3 (1.96%) Dynamics 365
7 2 (1.31%) Azure Machine Learning
8 1 (0.65%) Cortana Intelligence Suite
Communications & Networking
1 3 (1.96%) Modbus
1 3 (1.96%) VPN
2 1 (0.65%) Internet
Database & Business Intelligence
1 117 (76.47%) SQL Server Integration Services
2 106 (69.28%) Power BI
3 104 (67.97%) SQL Server
4 102 (66.67%) SQL Server Reporting Services
5 86 (56.21%) Data Warehouse
6 80 (52.29%) SQL Server Analysis Services
7 62 (40.52%) Microsoft Power View
8 14 (9.15%) Data Lake
8 14 (9.15%) QlikView
8 14 (9.15%) Relational Database
9 12 (7.84%) SQL Server 2016
10 11 (7.19%) Data Mining
10 11 (7.19%) Microsoft Analysis Services
11 10 (6.54%) Azure SQL Database
11 10 (6.54%) SQL Server 2008
12 8 (5.23%) Big Data
12 8 (5.23%) SQL Server 2012
13 6 (3.92%) HDInsight
13 6 (3.92%) Spotfire
13 6 (3.92%) SQL Server 2014
Development Applications
1 13 (8.50%) SQL Server Management Studio (SSMS)
2 6 (3.92%) Visual Studio
3 5 (3.27%) JIRA
4 2 (1.31%) Toad
5 1 (0.65%) Git (software)
General
1 52 (33.99%) Finance
2 16 (10.46%) Advertising
3 7 (4.58%) Banking
4 5 (3.27%) Retail
5 4 (2.61%) Investment Banking
5 4 (2.61%) Local Government
6 3 (1.96%) Manufacturing
7 2 (1.31%) Law
7 2 (1.31%) Legal
7 2 (1.31%) Marketing
8 1 (0.65%) Billing
8 1 (0.65%) Electronics
8 1 (0.65%) Games
8 1 (0.65%) Telecoms
Job Titles
1 68 (44.44%) Developer
2 56 (36.60%) Business Intelligence Developer
3 42 (27.45%) Analyst
4 25 (16.34%) Power BI Developer
5 19 (12.42%) Architect
6 18 (11.76%) Business Intelligence Analyst
6 18 (11.76%) SSAS Developer
6 18 (11.76%) SSIS Developer
7 17 (11.11%) Senior Developer
8 16 (10.46%) Senior Business Intelligence Developer
9 15 (9.80%) Business Intelligence Architect
10 14 (9.15%) SQL Developer
11 13 (8.50%) Consultant
12 12 (7.84%) Business Developer
13 11 (7.19%) SQL BI Developer
13 11 (7.19%) SSRS Developer
14 10 (6.54%) Junior
14 10 (6.54%) Junior Analyst
15 9 (5.88%) Analyst Developer
15 9 (5.88%) Business Intelligence Consultant
Libraries, Frameworks & Software Standards
1 18 (11.76%) MDX
2 17 (11.11%) .NET
3 11 (7.19%) Middleware
4 8 (5.23%) JSON
5 6 (3.92%) XML
6 4 (2.61%) Web Services
7 2 (1.31%) Ajax
7 2 (1.31%) ASP.NET
7 2 (1.31%) CSS
7 2 (1.31%) HTML
7 2 (1.31%) jQuery
8 1 (0.65%) COM
8 1 (0.65%) EDI
Miscellaneous
1 25 (16.34%) Analytical Skills
2 10 (6.54%) Computer Science
3 9 (5.88%) Self-Motivation
4 7 (4.58%) Management Information System
5 6 (3.92%) Enterprise Software
5 6 (3.92%) Greenfield Project
5 6 (3.92%) Reinsurance
6 4 (2.61%) Replication
7 2 (1.31%) FMCG
7 2 (1.31%) Life Science
8 1 (0.65%) Algorithms
8 1 (0.65%) Credit Risk
8 1 (0.65%) Fintech
8 1 (0.65%) Social Media
Operating Systems
1 4 (2.61%) Windows
1 4 (2.61%) Windows Server
1 4 (2.61%) Windows Server 2012
Processes & Methodologies
1 143 (93.46%) Business Intelligence
2 80 (52.29%) ETL
3 70 (45.75%) Data Modelling
4 58 (37.91%) Analytics
5 39 (25.49%) Agile Software Development
6 33 (21.57%) Data Analysis
7 26 (16.99%) Data Integration
8 23 (15.03%) Kimball Methodology
8 23 (15.03%) Visualisation
9 21 (13.73%) Scrum
10 16 (10.46%) Problem-Solving
11 12 (7.84%) Business Analysis
11 12 (7.84%) Information Management
11 12 (7.84%) Machine Learning
12 11 (7.19%) Dimensional Modelling
12 11 (7.19%) Performance Tuning
13 10 (6.54%) Data Science
13 10 (6.54%) Stakeholder Management
14 9 (5.88%) Business Analytics
14 9 (5.88%) Validation
Programming Languages
1 114 (74.51%) SQL
2 56 (36.60%) T-SQL
3 40 (26.14%) Data Analysis Expressions (DAX)
4 20 (13.07%) VBA
5 18 (11.76%) C#
6 7 (4.58%) Python
7 5 (3.27%) PowerShell
7 5 (3.27%) R
7 5 (3.27%) VB
8 3 (1.96%) VB.NET
8 3 (1.96%) VBScript
9 2 (1.31%) JavaScript
9 2 (1.31%) U-SQL
10 1 (0.65%) C
10 1 (0.65%) PL/SQL
Qualifications
1 22 (14.38%) Degree
2 7 (4.58%) Computer Science Degree
3 2 (1.31%) Master's Degree
4 1 (0.65%) DBS Check
4 1 (0.65%) Numerate Degree
4 1 (0.65%) Postgraduate
Quality Assurance & Compliance
1 21 (13.73%) QA
2 5 (3.27%) Data Quality
3 4 (2.61%) Cyber Essentials
3 4 (2.61%) ISO/IEC 27001
3 4 (2.61%) SLA
4 2 (1.31%) GDPR
Vendors
1 116 (75.82%) Microsoft
2 17 (11.11%) Oracle
2 17 (11.11%) Tableau
3 15 (9.80%) Informatica
4 14 (9.15%) Cognos
5 11 (7.19%) Talend
6 9 (5.88%) Hyperion
7 5 (3.27%) Capita
8 4 (2.61%) Cloudera
8 4 (2.61%) Google
8 4 (2.61%) IBM
8 4 (2.61%) Nintex
8 4 (2.61%) SAP
8 4 (2.61%) TOWER Software
9 2 (1.31%) Cognizant
9 2 (1.31%) JD Edwards
10 1 (0.65%) iManage