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 3 months to 29 March 2017 with a comparison to the same period in the previous 2 years.

Microsoft Power Pivot
UK / England
3 months to
29 Mar 2017
Same period 2016 Same period 2015
Rank 796 779 785
Rank change year-on-year -17 +6  
Permanent jobs citing PowerPivot 48 139 162
As % of all permanent IT jobs advertised in England 0.060% 0.14% 0.16%
As % of the Database & Business Intelligence category 0.20% 0.46% 0.52%
Number of salaries quoted 45 118 153
Median salary £50,000 £51,250 £45,000
Median salary % change year-on-year -2.43% +13.88%  
90% offered a salary of more than £28,500 £30,000 £39,720
10% offered a salary of more than £78,500 £72,500 £65,000
UK excluding London median salary £35,000 £45,000 £42,500
% change year-on-year -22.22% +5.88%  

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

Database & Business Intelligence Skills
England
Permanent job vacancies with a requirement for database and business intelligence skills 24462 30231 31353
As % of all permanent IT job vacancies advertised in England 30.50% 30.88% 31.27%
Number of salaries quoted 21017 26056 26826
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year - +11.11%  
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

PowerPivot
Job Vacancy Trend in England

The job posting trend of jobs advertised in England citing PowerPivot as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 29 March 2017.

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 3 months to 29 March 2017. 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 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
London +3 27 £62,500 +13.63% 2
South East +47 9 £40,000 -12.08% 2
North West -13 5 £30,000 -0.75%
South West +30 4 £28,000 +27.27%
East of England +19 1 £40,000 -5.20%
East Midlands -2 1 £47,500 +18.75% 2
PowerPivot
UK

For the 6 months to 29 March 2017, 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 125 (83.89%) Business Intelligence
2 122 (81.88%) SQL
3 115 (77.18%) SQL Server Reporting Services
4 101 (67.79%) SQL Server Integration Services
5 97 (65.10%) Power BI
6 96 (64.43%) SQL Server
7 90 (60.40%) SQL Server Analysis Services
8 79 (53.02%) Microsoft
9 71 (47.65%) T-SQL
10 70 (46.98%) Data Warehouse
11 62 (41.61%) Analytics
12 50 (33.56%) ETL
13 48 (32.21%) MS Excel
14 46 (30.87%) Data Modelling
15 40 (26.85%) Microsoft Power View
16 39 (26.17%) Agile Software Development
17 31 (20.81%) MySQL
17 31 (20.81%) Hadoop
18 30 (20.13%) Data Analysis Expressions (DAX)
19 28 (18.79%) Management Information System
19 28 (18.79%) Finance
19 28 (18.79%) Relational Database
20 26 (17.45%) Analytical Skills
20 26 (17.45%) SQL Server 2012
20 26 (17.45%) Big Data
21 25 (16.78%) Microsoft Analysis Services
21 25 (16.78%) BusinessObjects
22 24 (16.11%) .NET
23 23 (15.44%) Cognos
23 23 (15.44%) SharePoint

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 23 (15.44%) SharePoint
2 10 (6.71%) WebSphere
3 9 (6.04%) Apache Pig
4 8 (5.37%) OpenStack
5 3 (2.01%) SAS
6 2 (1.34%) Apache Spark
7 1 (0.67%) IIS
7 1 (0.67%) SharePoint 2010
7 1 (0.67%) SharePoint 2013
7 1 (0.67%) SharePoint Server
Applications
1 48 (32.21%) MS Excel
2 10 (6.71%) MS Visio
3 7 (4.70%) MS Office
4 4 (2.68%) SPSS
5 2 (1.34%) MS PowerPoint
5 2 (1.34%) Spreadsheet
6 1 (0.67%) InfoPath
Business Applications
1 3 (2.01%) Dynamics NAV
2 1 (0.67%) Dynamics AX
2 1 (0.67%) OPENHousing
2 1 (0.67%) Oracle Financials
2 1 (0.67%) StreamServe
Cloud Services
1 17 (11.41%) GitHub
2 11 (7.38%) Amazon AWS
3 7 (4.70%) Microsoft Azure
4 6 (4.03%) PaaS
5 5 (3.36%) SaaS
6 3 (2.01%) Google Analytics
7 1 (0.67%) Akamai
7 1 (0.67%) IaaS
7 1 (0.67%) Office 365
Communications & Networking
1 4 (2.68%) MVNO
2 3 (2.01%) LAN
2 3 (2.01%) WAN
3 1 (0.67%) LDAP
Database & Business Intelligence
1 115 (77.18%) SQL Server Reporting Services
2 101 (67.79%) SQL Server Integration Services
3 97 (65.10%) Power BI
4 96 (64.43%) SQL Server
5 90 (60.40%) SQL Server Analysis Services
6 70 (46.98%) Data Warehouse
7 40 (26.85%) Microsoft Power View
8 31 (20.81%) Hadoop
8 31 (20.81%) MySQL
9 28 (18.79%) Relational Database
10 26 (17.45%) Big Data
10 26 (17.45%) SQL Server 2012
11 25 (16.78%) BusinessObjects
11 25 (16.78%) Microsoft Analysis Services
12 23 (15.44%) QlikView
13 22 (14.77%) Apache Hive
14 15 (10.07%) OLAP
15 14 (9.40%) NoSQL
16 12 (8.05%) Data Mart
16 12 (8.05%) SQL Server 2014
Development Applications
1 18 (12.08%) JIRA
2 9 (6.04%) Git (software)
3 8 (5.37%) Jenkins
4 7 (4.70%) Visual Studio
5 5 (3.36%) Talend Open Studio
6 2 (1.34%) Team Foundation Server
7 1 (0.67%) MSTest
7 1 (0.67%) SpecFlow
7 1 (0.67%) SQL Server Management Studio (SSMS)
General
1 28 (18.79%) Finance
2 9 (6.04%) Legal
3 8 (5.37%) Law
4 4 (2.68%) Games
4 4 (2.68%) Marketing
4 4 (2.68%) Retail
4 4 (2.68%) Telecoms
5 3 (2.01%) Banking
5 3 (2.01%) Pharmaceutical
5 3 (2.01%) Publishing
6 2 (1.34%) Advertising
6 2 (1.34%) Manufacturing
7 1 (0.67%) Billing
7 1 (0.67%) Financial Institution
Job Titles
1 64 (42.95%) Developer
2 59 (39.60%) Analyst
3 28 (18.79%) Business Intelligence Developer
3 28 (18.79%) SQL Developer
4 24 (16.11%) Business Intelligence Analyst
5 16 (10.74%) Architect
6 14 (9.40%) Report Developer
6 14 (9.40%) SQL Server Developer
7 12 (8.05%) Insight Analyst
7 12 (8.05%) Report Analyst
7 12 (8.05%) Senior Analyst
8 11 (7.38%) Senior Business Intelligence Analyst
8 11 (7.38%) SQL BI Developer
9 10 (6.71%) Solutions Architect
9 10 (6.71%) SSRS Developer
10 9 (6.04%) Data Analyst
10 9 (6.04%) NoSQL Developer
11 8 (5.37%) SQL Server BI Developer
12 7 (4.70%) SSIS Analyst
12 7 (4.70%) SSIS Developer
Libraries, Frameworks & Software Standards
1 24 (16.11%) .NET
2 22 (14.77%) MDX
3 11 (7.38%) .NET Framework
4 7 (4.70%) ASP.NET
5 6 (4.03%) XML
6 5 (3.36%) Kafka
7 4 (2.68%) HTML
8 3 (2.01%) CSS
8 3 (2.01%) EDI
9 2 (1.34%) Ajax
9 2 (1.34%) jQuery
10 1 (0.67%) KnockoutJS
10 1 (0.67%) Web Services
10 1 (0.67%) XSL
Miscellaneous
1 28 (18.79%) Management Information System
2 26 (17.45%) Analytical Skills
3 9 (6.04%) NHS
4 8 (5.37%) Wiki
5 3 (2.01%) Driving Licence
6 2 (1.34%) Fintech
6 2 (1.34%) Life Science
6 2 (1.34%) User Experience
7 1 (0.67%) Algorithms
7 1 (0.67%) Blog
7 1 (0.67%) Computer Science
7 1 (0.67%) Credit Risk
Operating Systems
1 11 (7.38%) Windows
1 11 (7.38%) Windows Server
1 11 (7.38%) Windows Server 2012
2 4 (2.68%) Unix
Processes & Methodologies
1 125 (83.89%) Business Intelligence
2 62 (41.61%) Analytics
3 50 (33.56%) ETL
4 46 (30.87%) Data Modelling
5 39 (26.17%) Agile Software Development
6 22 (14.77%) Scrum
7 15 (10.07%) Data Analysis
7 15 (10.07%) Time Management
8 14 (9.40%) Mentoring
9 13 (8.72%) Customer Requirements
9 13 (8.72%) ETL Development
9 13 (8.72%) Use Case
10 11 (7.38%) Dashboard Development
10 11 (7.38%) Kimball Methodology
10 11 (7.38%) Performance Optimisation
11 10 (6.71%) Coaching
11 10 (6.71%) TOGAF
11 10 (6.71%) Translating Business Requirements
11 10 (6.71%) Visualisation
11 10 (6.71%) Workflow
Programming Languages
1 122 (81.88%) SQL
2 71 (47.65%) T-SQL
3 30 (20.13%) Data Analysis Expressions (DAX)
4 22 (14.77%) C#
5 20 (13.42%) VBA
6 15 (10.07%) Python
7 14 (9.40%) JavaScript
8 13 (8.72%) PowerShell
9 8 (5.37%) Java
9 8 (5.37%) PL/SQL
10 7 (4.70%) R
11 3 (2.01%) VBScript
12 2 (1.34%) VB
13 1 (0.67%) C
13 1 (0.67%) C++
13 1 (0.67%) Pascal
13 1 (0.67%) Ruby
Qualifications
1 20 (13.42%) Degree
2 2 (1.34%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 19 (12.75%) Data Quality
2 17 (11.41%) QA
3 6 (4.03%) ISO/IEC 27001
4 5 (3.36%) Cyber Essentials
5 3 (2.01%) SLA
6 1 (0.67%) PCI DSS
System Software
1 5 (3.36%) Apache Flume
Systems Management
1 9 (6.04%) Puppet
2 1 (0.67%) CA Single Sign-On
Vendors
1 79 (53.02%) Microsoft
2 23 (15.44%) Cognos
3 21 (14.09%) Tableau
4 18 (12.08%) Oracle
5 13 (8.72%) SAP
6 11 (7.38%) IBM
7 10 (6.71%) Nintex
7 10 (6.71%) RedGate
8 9 (6.04%) Teradata
9 5 (3.36%) Ab Initio
9 5 (3.36%) Hortonworks
9 5 (3.36%) Informatica
9 5 (3.36%) Talend
10 4 (2.68%) Google
11 2 (1.34%) Cloudera
11 2 (1.34%) F5
11 2 (1.34%) IDERA
12 1 (0.67%) Capita
12 1 (0.67%) MicroStrategy
12 1 (0.67%) Riverbed
Northampton, Northamptonshire
onezeero.
Salary: £40000 - £45000 per annum + Great Benefits
Posted: 2 hours ago
England
Lawrence Harvey
Salary: £4000.00 - £50000 per annum
Posted: 21 days ago
Newbury
Spectrum IT
Salary: £30000 per annum
Posted: 22 days ago
Northamptonshire
Lawrence Harvey
Salary: £45000 - £50000 per annum
Posted: 21 days ago
Sevenoaks
Mint
Salary: £30000 - £40000 per annum + Excellent
Posted: 27 days ago
City of London
Bluetown Online LTD
Salary: £24000 - £32000 per annum
Posted: 23 days ago
London
TRG
Salary: 55000 Per Annum Plus excellent benefits
Posted: 24 days ago