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

Microsoft Power Pivot
England / London
3 months to
28 Mar 2017
Same period 2016 Same period 2015
Rank 549 567 569
Rank change year-on-year +18 +2  
Permanent jobs citing PowerPivot 28 88 94
As % of all permanent IT jobs advertised in London 0.083% 0.21% 0.22%
As % of the Database & Business Intelligence category 0.27% 0.67% 0.72%
Number of salaries quoted 27 73 87
Median salary £60,000 £55,000 £52,500
Median salary % change year-on-year +9.09% +4.76%  
90% offered a salary of more than £38,600 £35,500 £42,500
10% offered a salary of more than £82,500 £74,500 £75,000
UK excluding London median salary £37,500 £45,000 £42,500
% change year-on-year -16.66% +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 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 10238 13169 13047
As % of all permanent IT job vacancies advertised in London 30.35% 31.23% 30.41%
Number of salaries quoted 8889 11491 11206
Median salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.34% +4.54%  
90% offered a salary of more than £40,000 £40,000 £38,000
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

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 28 March 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 28 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
City of London +26 6 £67,500 +54.28% 1
PowerPivot
England

PowerPivot
Top 30 Co-occurring IT Skills in London

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

1 61 (87.14%) Business Intelligence
2 53 (75.71%) SQL Server Reporting Services
3 52 (74.29%) SQL
4 43 (61.43%) SQL Server Analysis Services
5 42 (60.00%) SQL Server
6 40 (57.14%) Microsoft
7 38 (54.29%) SQL Server Integration Services
7 38 (54.29%) Power BI
8 36 (51.43%) Data Warehouse
9 31 (44.29%) MS Excel
10 27 (38.57%) ETL
11 24 (34.29%) Analytics
12 22 (31.43%) T-SQL
12 22 (31.43%) Data Analysis Expressions (DAX)
13 20 (28.57%) Data Modelling
14 19 (27.14%) Microsoft Analysis Services
15 17 (24.29%) Finance
15 17 (24.29%) C#
15 17 (24.29%) Microsoft Power View
16 16 (22.86%) MDX
16 16 (22.86%) QA
17 15 (21.43%) QlikView
18 14 (20.00%) .NET
18 14 (20.00%) SharePoint
18 14 (20.00%) Relational Database
19 13 (18.57%) Use Case
20 12 (17.14%) Degree
20 12 (17.14%) Data Mart
20 12 (17.14%) Oracle
20 12 (17.14%) PowerShell

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 14 (20.00%) SharePoint
2 9 (12.86%) WebSphere
3 8 (11.43%) OpenStack
4 4 (5.71%) Apache Pig
5 1 (1.43%) Apache Spark
5 1 (1.43%) IIS
5 1 (1.43%) SAS
5 1 (1.43%) SharePoint 2010
5 1 (1.43%) SharePoint 2013
5 1 (1.43%) SharePoint Server
Applications
1 31 (44.29%) MS Excel
2 9 (12.86%) MS Visio
3 4 (5.71%) MS Office
3 4 (5.71%) SPSS
4 1 (1.43%) InfoPath
4 1 (1.43%) MS PowerPoint
Business Applications
1 1 (1.43%) Oracle Financials
Cloud Services
1 8 (11.43%) Amazon AWS
1 8 (11.43%) GitHub
2 5 (7.14%) PaaS
3 4 (5.71%) SaaS
4 3 (4.29%) Microsoft Azure
5 1 (1.43%) Akamai
5 1 (1.43%) IaaS
5 1 (1.43%) Office 365
Communications & Networking
1 1 (1.43%) LDAP
Database & Business Intelligence
1 53 (75.71%) SQL Server Reporting Services
2 43 (61.43%) SQL Server Analysis Services
3 42 (60.00%) SQL Server
4 38 (54.29%) Power BI
4 38 (54.29%) SQL Server Integration Services
5 36 (51.43%) Data Warehouse
6 19 (27.14%) Microsoft Analysis Services
7 17 (24.29%) Microsoft Power View
8 15 (21.43%) QlikView
9 14 (20.00%) Relational Database
10 12 (17.14%) Data Mart
11 11 (15.71%) CouchDB
11 11 (15.71%) MySQL
11 11 (15.71%) SQL Server 2012
12 10 (14.29%) Big Data
12 10 (14.29%) Hadoop
13 9 (12.86%) BusinessObjects
13 9 (12.86%) PerformancePoint
13 9 (12.86%) SAP Data Services
13 9 (12.86%) SQL Server 2016
Development Applications
1 8 (11.43%) Git (software)
1 8 (11.43%) Jenkins
2 1 (1.43%) SQL Server Management Studio (SSMS)
2 1 (1.43%) Visual Studio
General
1 17 (24.29%) Finance
2 8 (11.43%) Law
2 8 (11.43%) Legal
3 4 (5.71%) Games
4 3 (4.29%) Banking
5 2 (2.86%) Advertising
6 1 (1.43%) Billing
Job Titles
1 27 (38.57%) Analyst
2 23 (32.86%) Developer
3 19 (27.14%) Business Intelligence Analyst
4 15 (21.43%) Architect
5 14 (20.00%) Report Developer
6 10 (14.29%) Senior Analyst
6 10 (14.29%) Senior Business Intelligence Analyst
7 9 (12.86%) Solutions Architect
8 8 (11.43%) SSRS Developer
9 7 (10.00%) Business Intelligence Developer
9 7 (10.00%) SQL Developer
9 7 (10.00%) SSIS Analyst
10 6 (8.57%) Senior NHS Analyst
11 5 (7.14%) Data Analyst
11 5 (7.14%) Database Developer
11 5 (7.14%) Principal Architect
11 5 (7.14%) Principal Technical Architect
11 5 (7.14%) Senior Architect
11 5 (7.14%) Senior Technical Architect
11 5 (7.14%) Technical Architect
Libraries, Frameworks & Software Standards
1 16 (22.86%) MDX
2 14 (20.00%) .NET
3 11 (15.71%) .NET Framework
4 5 (7.14%) Kafka
5 2 (2.86%) Ajax
5 2 (2.86%) ASP.NET
5 2 (2.86%) HTML
5 2 (2.86%) jQuery
5 2 (2.86%) XML
6 1 (1.43%) CSS
6 1 (1.43%) KnockoutJS
6 1 (1.43%) Web Services
6 1 (1.43%) XSL
Miscellaneous
1 9 (12.86%) NHS
2 8 (11.43%) Management Information System
2 8 (11.43%) Wiki
3 6 (8.57%) Analytical Skills
4 1 (1.43%) Algorithms
4 1 (1.43%) Blog
4 1 (1.43%) User Experience
Operating Systems
1 11 (15.71%) Windows
1 11 (15.71%) Windows Server
1 11 (15.71%) Windows Server 2012
2 4 (5.71%) Unix
Processes & Methodologies
1 61 (87.14%) Business Intelligence
2 27 (38.57%) ETL
3 24 (34.29%) Analytics
4 20 (28.57%) Data Modelling
5 13 (18.57%) Use Case
6 11 (15.71%) ETL Development
6 11 (15.71%) Performance Optimisation
7 9 (12.86%) Continuous Integration
7 9 (12.86%) Customer Requirements
7 9 (12.86%) TOGAF
7 9 (12.86%) Translating Business Requirements
7 9 (12.86%) Workflow
8 8 (11.43%) Agile Software Development
8 8 (11.43%) Test Scripting
9 7 (10.00%) Enterprise Architecture
9 7 (10.00%) Stakeholder Engagement
9 7 (10.00%) Visualisation
10 6 (8.57%) Business Analysis
10 6 (8.57%) Stakeholder Management
10 6 (8.57%) Technical Architecture
Programming Languages
1 52 (74.29%) SQL
2 22 (31.43%) Data Analysis Expressions (DAX)
2 22 (31.43%) T-SQL
3 17 (24.29%) C#
4 12 (17.14%) PowerShell
5 11 (15.71%) JavaScript
6 8 (11.43%) Java
7 7 (10.00%) VBA
8 3 (4.29%) R
9 2 (2.86%) Python
10 1 (1.43%) Ruby
Qualifications
1 12 (17.14%) Degree
2 2 (2.86%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 16 (22.86%) QA
2 10 (14.29%) Data Quality
3 4 (5.71%) Cyber Essentials
3 4 (5.71%) ISO/IEC 27001
4 1 (1.43%) PCI DSS
System Software
1 5 (7.14%) Apache Flume
Systems Management
1 1 (1.43%) CA Single Sign-On
Vendors
1 40 (57.14%) Microsoft
2 12 (17.14%) Oracle
3 11 (15.71%) Tableau
4 9 (12.86%) IBM
4 9 (12.86%) Nintex
4 9 (12.86%) SAP
5 8 (11.43%) RedGate
6 5 (7.14%) Ab Initio
6 5 (7.14%) Hortonworks
6 5 (7.14%) Informatica
6 5 (7.14%) Teradata
7 2 (2.86%) Cloudera
8 1 (1.43%) Cognos
8 1 (1.43%) F5
8 1 (1.43%) Google
8 1 (1.43%) Riverbed
City of London
Bluetown Online LTD
Salary: £24000 - £32000 per annum
Posted: 22 days ago
London
TRG
Salary: 55000 Per Annum Plus excellent benefits
Posted: 23 days ago