The following table provides summary statistics for permanent job vacancies advertised in London 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 25 June 2017 with a comparison to the same period in the previous 2 years.

Microsoft Power Pivot
England / London
3 months to
25 Jun 2017
Same period 2016 Same period 2015
Rank 598 585 597
Rank change year-on-year -13 +12  
Permanent jobs citing PowerPivot 14 51 84
As % of all permanent IT jobs advertised in London 0.039% 0.13% 0.19%
As % of the Database & Business Intelligence category 0.13% 0.44% 0.58%
Number of salaries quoted 9 41 73
Median salary £65,000 £60,000 £57,500
Median salary % change year-on-year +8.33% +4.34%  
90% offered a salary of more than £51,000 £46,000 £44,200
10% offered a salary of more than £73,000 £70,000 £84,000
UK excluding London median salary £37,500 £41,250 £50,000
% change year-on-year -9.09% -17.50%  

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 London with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
London
Permanent job vacancies with a requirement for database and business intelligence skills 10916 11625 14412
As % of all permanent IT job vacancies advertised in London 30.06% 29.45% 32.19%
Number of salaries quoted 9084 10113 12237
Median salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.34% -  
90% offered a salary of more than £40,000 £40,000 £39,000
10% offered a salary of more than £82,500 £80,000 £80,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

PowerPivot
Job Vacancy Trend in London

The job posting trend of jobs advertised in London 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 London

PowerPivot
Salary Trend in London

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

Salary trend for PowerPivot in London

PowerPivot
Salary Histogram in London

The salary distribution of IT jobs citing PowerPivot in London over the 3 months to 25 June 2017.

Salary histogram for PowerPivot in London

PowerPivot
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the London region over the 3 months to 25 June 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
City of London +8 1 £60,000 +4.34%
Canary Wharf - 1 £67,500 -
PowerPivot
England

For the 6 months to 25 June 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 London region with a requirement for PowerPivot.

1 36 (85.71%) Business Intelligence
2 34 (80.95%) SQL Server Reporting Services
3 31 (73.81%) SQL Server Analysis Services
3 31 (73.81%) SQL Server
4 29 (69.05%) SQL Server Integration Services
5 28 (66.67%) Power BI
6 23 (54.76%) SQL
7 22 (52.38%) ETL
8 21 (50.00%) Data Warehouse
8 21 (50.00%) Microsoft Excel
9 19 (45.24%) Microsoft
10 16 (38.10%) Tableau
11 15 (35.71%) MDX
12 12 (28.57%) Data Analysis Expressions (DAX)
13 10 (23.81%) Analytics
13 10 (23.81%) Microsoft Power View
13 10 (23.81%) Microsoft Analysis Services
13 10 (23.81%) BusinessObjects
13 10 (23.81%) Finance
13 10 (23.81%) T-SQL
14 9 (21.43%) Data Modelling
14 9 (21.43%) Informatica
15 8 (19.05%) SharePoint
15 8 (19.05%) SAP
15 8 (19.05%) QlikView
15 8 (19.05%) Degree
16 7 (16.67%) Use Case
16 7 (16.67%) Agile Software Development
16 7 (16.67%) Relational Database
17 6 (14.29%) Big Data

PowerPivot
Co-occurring IT Skills in London 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 8 (19.05%) SharePoint
2 4 (9.52%) Apache Pig
2 4 (9.52%) WebSphere
3 2 (4.76%) OpenStack
4 1 (2.38%) Apache Spark
4 1 (2.38%) IIS
Applications
1 21 (50.00%) Microsoft Excel
2 4 (9.52%) MS Visio
2 4 (9.52%) SPSS
3 1 (2.38%) Microsoft Office
Cloud Services
1 5 (11.90%) Microsoft Azure
2 3 (7.14%) PaaS
2 3 (7.14%) SaaS
3 2 (4.76%) Amazon AWS
3 2 (4.76%) GitHub
Database & Business Intelligence
1 34 (80.95%) SQL Server Reporting Services
2 31 (73.81%) SQL Server
2 31 (73.81%) SQL Server Analysis Services
3 29 (69.05%) SQL Server Integration Services
4 28 (66.67%) Power BI
5 21 (50.00%) Data Warehouse
6 10 (23.81%) BusinessObjects
6 10 (23.81%) Microsoft Analysis Services
6 10 (23.81%) Microsoft Power View
7 8 (19.05%) QlikView
8 7 (16.67%) Relational Database
9 6 (14.29%) Apache Hive
9 6 (14.29%) Big Data
9 6 (14.29%) Hadoop
10 5 (11.90%) Sqoop
11 4 (9.52%) PerformancePoint
11 4 (9.52%) PowerCenter
11 4 (9.52%) SAP Data Services
11 4 (9.52%) SQL Server 2008
11 4 (9.52%) SQL Server 2016
Development Applications
1 3 (7.14%) Git (software)
2 2 (4.76%) Jenkins
2 2 (4.76%) Team Foundation Server
3 1 (2.38%) Octopus Deploy
3 1 (2.38%) Visual Studio Team System
General
1 10 (23.81%) Finance
2 4 (9.52%) Games
3 3 (7.14%) Advertising
3 3 (7.14%) Banking
3 3 (7.14%) Law
3 3 (7.14%) Legal
4 2 (4.76%) Publishing
4 2 (4.76%) Retail
4 2 (4.76%) Retail Banking
5 1 (2.38%) Back Office
5 1 (2.38%) Billing
5 1 (2.38%) Front Office
Job Titles
1 17 (40.48%) Developer
2 14 (33.33%) Analyst
3 12 (28.57%) Business Intelligence Developer
4 9 (21.43%) Architect
5 7 (16.67%) Business Intelligence Analyst
6 6 (14.29%) Power BI Developer
7 5 (11.90%) Data Analyst
7 5 (11.90%) Principal Architect
7 5 (11.90%) Principal Technical Architect
7 5 (11.90%) Senior Architect
7 5 (11.90%) Senior Technical Architect
7 5 (11.90%) SQL Developer
7 5 (11.90%) Technical Architect
8 4 (9.52%) Business Developer
8 4 (9.52%) Solutions Architect
8 4 (9.52%) SSIS Analyst
8 4 (9.52%) SSRS Developer
9 3 (7.14%) Senior Business Intelligence Analyst
9 3 (7.14%) SQL BI Developer
9 3 (7.14%) SSIS Developer
Libraries, Frameworks & Software Standards
1 15 (35.71%) MDX
2 5 (11.90%) .NET
2 5 (11.90%) Kafka
3 2 (4.76%) .NET Framework
4 1 (2.38%) Ajax
4 1 (2.38%) ASP.NET
4 1 (2.38%) CSS
4 1 (2.38%) D3.js
4 1 (2.38%) HTML
4 1 (2.38%) jQuery
4 1 (2.38%) XML
Miscellaneous
1 3 (7.14%) Analytical Skills
1 3 (7.14%) Management Information System
1 3 (7.14%) NHS
2 2 (4.76%) Wiki
3 1 (2.38%) Blog
3 1 (2.38%) Hedge funds
3 1 (2.38%) User Experience
Operating Systems
1 4 (9.52%) Unix
2 3 (7.14%) Windows
2 3 (7.14%) Windows Server 2012
3 2 (4.76%) Windows Server
4 1 (2.38%) Windows Server 2008
Processes & Methodologies
1 36 (85.71%) Business Intelligence
2 22 (52.38%) ETL
3 10 (23.81%) Analytics
4 9 (21.43%) Data Modelling
5 7 (16.67%) Agile Software Development
5 7 (16.67%) Use Case
6 6 (14.29%) Visualisation
7 5 (11.90%) Kimball Methodology
7 5 (11.90%) Requirements Analysis
7 5 (11.90%) Technical Architecture
8 4 (9.52%) Capacity Planning
8 4 (9.52%) Continuous Integration
8 4 (9.52%) Open Source
8 4 (9.52%) Stakeholder Management
8 4 (9.52%) TOGAF
8 4 (9.52%) Translating Business Requirements
8 4 (9.52%) Workflow
9 3 (7.14%) Customer Requirements
9 3 (7.14%) Dimensional Modelling
9 3 (7.14%) Presales
Programming Languages
1 23 (54.76%) SQL
2 12 (28.57%) Data Analysis Expressions (DAX)
3 10 (23.81%) T-SQL
4 6 (14.29%) C#
5 5 (11.90%) JavaScript
5 5 (11.90%) VBA
6 4 (9.52%) PowerShell
7 3 (7.14%) Java
8 1 (2.38%) R
Qualifications
1 8 (19.05%) Degree
2 2 (4.76%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 5 (11.90%) QA
2 4 (9.52%) Data Quality
3 3 (7.14%) Cyber Essentials
3 3 (7.14%) ISO/IEC 27001
4 1 (2.38%) PCI DSS
System Software
1 5 (11.90%) Apache Flume
Systems Management
1 1 (2.38%) Control-M
1 1 (2.38%) Opscode Chef
1 1 (2.38%) Puppet
Vendors
1 19 (45.24%) Microsoft
2 16 (38.10%) Tableau
3 9 (21.43%) Informatica
4 8 (19.05%) SAP
5 5 (11.90%) Ab Initio
5 5 (11.90%) Hortonworks
5 5 (11.90%) IBM
5 5 (11.90%) Teradata
6 4 (9.52%) Nintex
6 4 (9.52%) Oracle
7 2 (4.76%) RedGate
8 1 (2.38%) Alteryx
8 1 (2.38%) Cloudera
London
Woodrow Mercer Recruitment
Salary: £45000 - £55000 per annum
Posted: 5 days ago
London
CodeSource Recruitment Limited
Salary: From £50,000 to £65,000 per annum £50,000 to £65,000 per annum + Bonus
Posted: 5 days ago
South East London
Citywire
Salary: Competitive
Posted: 5 days ago
London
Michael Page Technology
Salary: £40000 - £45000 per annum + Great Benefits
Posted: 17 days ago