The table below looks at the statistics for PowerPivot skills in IT jobs advertised for the London region. Included is a guide to the salaries offered in IT jobs that have cited PowerPivot over the 3 months to 17 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
17 Jan 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
England / London
Rank 523 583 570
Rank change year-on-year
+60 -13
Permanent jobs citing PowerPivot 48 56 71
As % of all permanent IT jobs located in London 0.14% 0.14% 0.18%
As % of the Database & Business Intelligence category 0.48% 0.44% 0.58%
Number of salaries quoted 44 34 62
Median salary £55,000 £48,750 £58,125
Median salary % change year-on-year
+12.82% -16.12%
90% offered a salary of more than £37,500 £25,000 £40,000
10% offered a salary of more than £69,250 £80,000 £80,000
UK excluding London median salary £45,000 £41,500 £42,000
% change year-on-year
+8.43% -1.19%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the London region.

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
9990 12644 12213
As % of all permanent IT jobs located in London 29.89% 31.63% 30.19%
Number of salaries quoted 8797 10909 10515
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

PowerPivot
Jobs Demand Trend in London

The demand trend of job ads across the London region citing PowerPivot as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

PowerPivot Jobs Demand Trend in London

PowerPivot
Salary Trend in London

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

PowerPivot Salary Trend in London

PowerPivot
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing PowerPivot across the London region over the 3 months to 17 January 2017.

PowerPivot Salary Histogram 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 17 January 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 +39 13 £55,000 - 1
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in London

For the 6 months to 17 January 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 63 (85.14%) SQL
1 63 (85.14%) Business Intelligence
2 55 (74.32%) SQL Server Reporting Services
3 49 (66.22%) Microsoft
4 41 (55.41%) SQL Server
4 41 (55.41%) SQL Server Analysis Services
5 35 (47.30%) SQL Server Integration Services
5 35 (47.30%) Data Warehouse
5 35 (47.30%) Power BI
6 31 (41.89%) MS Excel
7 27 (36.49%) T-SQL
8 26 (35.14%) MDX
9 25 (33.78%) Microsoft Analysis Services
9 25 (33.78%) Data Analysis Expressions (DAX)
10 24 (32.43%) Analytics
11 23 (31.08%) ETL
12 21 (28.38%) Finance
13 20 (27.03%) C#
14 19 (25.68%) Data Modelling
15 18 (24.32%) Tableau
16 16 (21.62%) SharePoint
17 15 (20.27%) QlikView
18 14 (18.92%) Data Quality
19 13 (17.57%) QA
19 13 (17.57%) Data Analysis
19 13 (17.57%) Oracle
19 13 (17.57%) .NET
19 13 (17.57%) Management Information System
20 12 (16.22%) Legal
20 12 (16.22%) BusinessObjects

PowerPivot
Top Related 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 16 (21.62%) SharePoint
2 11 (14.86%) WebSphere
3 6 (8.11%) OpenStack
4 1 (1.35%) IIS
4 1 (1.35%) SAS
4 1 (1.35%) SharePoint 2010
4 1 (1.35%) SharePoint 2013
4 1 (1.35%) SharePoint Server
Applications
1 31 (41.89%) MS Excel
2 11 (14.86%) MS Visio
3 4 (5.41%) MS Office
3 4 (5.41%) SPSS
4 2 (2.70%) MS PowerPoint
5 1 (1.35%) InfoPath
Business Applications
1 1 (1.35%) Oracle Financials
Cloud Services
1 7 (9.46%) PaaS
2 6 (8.11%) Amazon AWS
2 6 (8.11%) GitHub
2 6 (8.11%) SaaS
3 3 (4.05%) Microsoft Azure
4 2 (2.70%) Office 365
5 1 (1.35%) Akamai
5 1 (1.35%) IaaS
Communications & Networking
1 1 (1.35%) LDAP
Database & Business Intelligence
1 55 (74.32%) SQL Server Reporting Services
2 41 (55.41%) SQL Server
2 41 (55.41%) SQL Server Analysis Services
3 35 (47.30%) Data Warehouse
3 35 (47.30%) Power BI
3 35 (47.30%) SQL Server Integration Services
4 25 (33.78%) Microsoft Analysis Services
5 15 (20.27%) QlikView
6 12 (16.22%) BusinessObjects
6 12 (16.22%) Data Mart
6 12 (16.22%) MySQL
6 12 (16.22%) SQL Server 2012
7 11 (14.86%) CouchDB
7 11 (14.86%) Microsoft Power View
7 11 (14.86%) PerformancePoint
7 11 (14.86%) SAP Data Services
8 8 (10.81%) Relational Database
9 6 (8.11%) Big Data
9 6 (8.11%) SQL Server 2014
9 6 (8.11%) SQL Server 2016
Development Applications
1 6 (8.11%) Git (software)
1 6 (8.11%) Jenkins
2 1 (1.35%) SQL Server Management Studio (SSMS)
2 1 (1.35%) Visual Studio
General
1 21 (28.38%) Finance
2 12 (16.22%) Legal
3 7 (9.46%) Billing
4 5 (6.76%) Law
5 4 (5.41%) Games
6 3 (4.05%) Advertising
6 3 (4.05%) Banking
7 1 (1.35%) Manufacturing
7 1 (1.35%) Marketing
Job Titles
1 23 (31.08%) Analyst
2 21 (28.38%) Developer
3 15 (20.27%) Business Intelligence Analyst
4 13 (17.57%) Report Developer
5 12 (16.22%) Architect
6 11 (14.86%) Solutions Architect
7 8 (10.81%) Senior Analyst
7 8 (10.81%) Senior Business Intelligence Analyst
7 8 (10.81%) SSRS Developer
8 7 (9.46%) Business Intelligence Developer
8 7 (9.46%) Consultant
8 7 (9.46%) SQL Developer
8 7 (9.46%) Team Leader
9 6 (8.11%) Business Intelligence Consultant
9 6 (8.11%) Business Intelligence Lead
9 6 (8.11%) Data Analyst
10 5 (6.76%) Database Developer
10 5 (6.76%) SSIS Developer
11 4 (5.41%) Business Developer
11 4 (5.41%) Senior NHS Analyst
Libraries, Frameworks & Software Standards
1 26 (35.14%) MDX
2 13 (17.57%) .NET
3 11 (14.86%) .NET Framework
4 3 (4.05%) Web Services
4 3 (4.05%) XML
5 1 (1.35%) Ajax
5 1 (1.35%) ASP.NET
5 1 (1.35%) COM
5 1 (1.35%) D3.js
5 1 (1.35%) HTML
5 1 (1.35%) jQuery
5 1 (1.35%) JSON
5 1 (1.35%) KnockoutJS
5 1 (1.35%) Leaflet
5 1 (1.35%) REST
5 1 (1.35%) SOAP
5 1 (1.35%) XSL
Miscellaneous
1 13 (17.57%) Management Information System
2 11 (14.86%) Visualisation
3 8 (10.81%) Analytical Skills
3 8 (10.81%) Wiki
4 7 (9.46%) NHS
5 1 (1.35%) Algorithms
5 1 (1.35%) Data Extraction
5 1 (1.35%) Fintech
5 1 (1.35%) Mathematics
5 1 (1.35%) User Experience
Operating Systems
1 11 (14.86%) Windows
1 11 (14.86%) Windows Server
1 11 (14.86%) Windows Server 2012
Processes & Methodologies
1 63 (85.14%) Business Intelligence
2 24 (32.43%) Analytics
3 23 (31.08%) ETL
4 19 (25.68%) Data Modelling
5 13 (17.57%) Data Analysis
6 12 (16.22%) ETL Development
6 12 (16.22%) Performance Optimisation
7 11 (14.86%) TOGAF
7 11 (14.86%) Translating Business Requirements
7 11 (14.86%) Workflow
8 9 (12.16%) Kimball Methodology
9 8 (10.81%) Agile Software Development
9 8 (10.81%) Presales
9 8 (10.81%) Test Scripting
9 8 (10.81%) Use Case
10 7 (9.46%) Data Cleansing
10 7 (9.46%) SSADM
10 7 (9.46%) UML
11 6 (8.11%) Continuous Integration
11 6 (8.11%) Stakeholder Engagement
Programming Languages
1 63 (85.14%) SQL
2 27 (36.49%) T-SQL
3 25 (33.78%) Data Analysis Expressions (DAX)
4 20 (27.03%) C#
5 12 (16.22%) PowerShell
5 12 (16.22%) VBA
6 8 (10.81%) JavaScript
7 6 (8.11%) Java
8 2 (2.70%) Python
8 2 (2.70%) R
9 1 (1.35%) Ruby
Qualifications
1 8 (10.81%) Degree
2 1 (1.35%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 14 (18.92%) Data Quality
2 13 (17.57%) QA
3 6 (8.11%) ISO/IEC 27001
4 3 (4.05%) SLA
5 2 (2.70%) PCI DSS
Systems Management
1 1 (1.35%) CA Single Sign-On
Vendors
1 49 (66.22%) Microsoft
2 18 (24.32%) Tableau
3 13 (17.57%) Oracle
4 12 (16.22%) SAP
5 11 (14.86%) IBM
5 11 (14.86%) Nintex
6 6 (8.11%) RedGate
7 1 (1.35%) Cloudera
7 1 (1.35%) Cognos
7 1 (1.35%) F5
7 1 (1.35%) Google
7 1 (1.35%) Riverbed
7 1 (1.35%) Salesforce.com
City, London
Comtecs
Salary: £65000 - £70000 Per Annum + Bonus + Excellent Benefits
Posted: Yesterday
London
Networkers
Salary: £65000 - £70000 per annum + Excellent benefits
Posted: 4 days ago
South West London
Bluetown Online LTD
Salary: £24000 - £32000 per annum
Posted: 13 days ago