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 21 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
21 Feb 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
England / London
Rank 540 586 562
Rank change year-on-year
+46 -24
Permanent jobs citing PowerPivot 43 63 92
As % of all permanent IT jobs located in London 0.13% 0.15% 0.22%
As % of the Database & Business Intelligence category 0.43% 0.49% 0.73%
Number of salaries quoted 39 43 85
Median salary £55,000 £52,500 £57,500
Median salary % change year-on-year
+4.76% -8.69%
90% offered a salary of more than £36,000 £25,000 £42,500
10% offered a salary of more than £70,000 £81,000 £80,000
UK excluding London median salary £45,000 £40,500 £42,000
% change year-on-year
+11.11% -3.57%

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
10054 12765 12549
As % of all permanent IT jobs located in London 30.09% 31.40% 30.43%
Number of salaries quoted 8783 11066 10801
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
90% offered a salary of more than £39,000 £40,000 £37,500
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
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 21 February 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 21 February 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 +34 9 £55,000 +25.71%
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in London

For the 6 months to 21 February 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 64 (86.49%) Business Intelligence
2 59 (79.73%) SQL
3 56 (75.68%) SQL Server Reporting Services
4 45 (60.81%) Microsoft
5 44 (59.46%) SQL Server Analysis Services
6 42 (56.76%) SQL Server
7 38 (51.35%) Data Warehouse
8 37 (50.00%) Power BI
9 35 (47.30%) SQL Server Integration Services
10 33 (44.59%) MS Excel
11 27 (36.49%) ETL
12 25 (33.78%) Analytics
13 24 (32.43%) Data Analysis Expressions (DAX)
13 24 (32.43%) T-SQL
14 23 (31.08%) Microsoft Analysis Services
15 20 (27.03%) MDX
15 20 (27.03%) Data Modelling
16 19 (25.68%) C#
16 19 (25.68%) Finance
17 15 (20.27%) QA
17 15 (20.27%) QlikView
18 14 (18.92%) Data Mart
18 14 (18.92%) .NET
18 14 (18.92%) SharePoint
18 14 (18.92%) Oracle
18 14 (18.92%) SQL Server 2012
18 14 (18.92%) Microsoft Power View
18 14 (18.92%) ETL Development
18 14 (18.92%) PowerShell
18 14 (18.92%) Performance Optimisation

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 14 (18.92%) SharePoint
2 10 (13.51%) WebSphere
3 8 (10.81%) OpenStack
4 2 (2.70%) Apache Pig
5 1 (1.35%) Apache Spark
5 1 (1.35%) IIS
5 1 (1.35%) SAS
5 1 (1.35%) SharePoint 2010
5 1 (1.35%) SharePoint 2013
5 1 (1.35%) SharePoint Server
Applications
1 33 (44.59%) MS Excel
2 10 (13.51%) 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 8 (10.81%) Amazon AWS
1 8 (10.81%) GitHub
2 6 (8.11%) PaaS
3 5 (6.76%) SaaS
4 3 (4.05%) Microsoft Azure
5 1 (1.35%) Akamai
5 1 (1.35%) IaaS
5 1 (1.35%) Office 365
Communications & Networking
1 1 (1.35%) LDAP
Database & Business Intelligence
1 56 (75.68%) SQL Server Reporting Services
2 44 (59.46%) SQL Server Analysis Services
3 42 (56.76%) SQL Server
4 38 (51.35%) Data Warehouse
5 37 (50.00%) Power BI
6 35 (47.30%) SQL Server Integration Services
7 23 (31.08%) Microsoft Analysis Services
8 15 (20.27%) QlikView
9 14 (18.92%) Data Mart
9 14 (18.92%) Microsoft Power View
9 14 (18.92%) SQL Server 2012
10 13 (17.57%) CouchDB
10 13 (17.57%) MySQL
10 13 (17.57%) Relational Database
11 10 (13.51%) BusinessObjects
11 10 (13.51%) PerformancePoint
11 10 (13.51%) SAP Data Services
12 8 (10.81%) Big Data
12 8 (10.81%) Hadoop
12 8 (10.81%) SQL Server 2014
Development Applications
1 8 (10.81%) Git (software)
1 8 (10.81%) Jenkins
2 1 (1.35%) SQL Server Management Studio (SSMS)
2 1 (1.35%) Visual Studio
General
1 19 (25.68%) Finance
2 10 (13.51%) Legal
3 7 (9.46%) Law
4 4 (5.41%) Billing
4 4 (5.41%) Games
5 3 (4.05%) Banking
6 2 (2.70%) Advertising
7 1 (1.35%) Manufacturing
Job Titles
1 26 (35.14%) Analyst
2 23 (31.08%) Developer
3 19 (25.68%) Business Intelligence Analyst
4 15 (20.27%) Report Developer
5 14 (18.92%) Architect
6 10 (13.51%) Senior Analyst
6 10 (13.51%) Senior Business Intelligence Analyst
6 10 (13.51%) Solutions Architect
7 8 (10.81%) Business Intelligence Developer
7 8 (10.81%) SQL Developer
7 8 (10.81%) SSRS Developer
8 6 (8.11%) Senior NHS Analyst
9 5 (6.76%) Consultant
9 5 (6.76%) Data Analyst
9 5 (6.76%) Database Developer
9 5 (6.76%) SSIS Analyst
10 4 (5.41%) Business Intelligence Consultant
10 4 (5.41%) SQL BI Developer
10 4 (5.41%) SSIS Developer
10 4 (5.41%) Team Leader
Libraries, Frameworks & Software Standards
1 20 (27.03%) MDX
2 14 (18.92%) .NET
3 13 (17.57%) .NET Framework
4 3 (4.05%) Kafka
5 1 (1.35%) Ajax
5 1 (1.35%) ASP.NET
5 1 (1.35%) HTML
5 1 (1.35%) jQuery
5 1 (1.35%) KnockoutJS
5 1 (1.35%) Web Services
5 1 (1.35%) XML
5 1 (1.35%) XSL
Miscellaneous
1 10 (13.51%) Management Information System
1 10 (13.51%) Wiki
2 9 (12.16%) NHS
3 6 (8.11%) Analytical Skills
4 1 (1.35%) Algorithms
4 1 (1.35%) Blog
4 1 (1.35%) Fintech
4 1 (1.35%) User Experience
Operating Systems
1 13 (17.57%) Windows
1 13 (17.57%) Windows Server
1 13 (17.57%) Windows Server 2012
2 2 (2.70%) Unix
Processes & Methodologies
1 64 (86.49%) Business Intelligence
2 27 (36.49%) ETL
3 25 (33.78%) Analytics
4 20 (27.03%) Data Modelling
5 14 (18.92%) ETL Development
5 14 (18.92%) Performance Optimisation
6 13 (17.57%) Use Case
7 10 (13.51%) Test Scripting
7 10 (13.51%) TOGAF
7 10 (13.51%) Translating Business Requirements
7 10 (13.51%) Workflow
8 9 (12.16%) Agile Software Development
8 9 (12.16%) Data Analysis
9 8 (10.81%) Continuous Integration
9 8 (10.81%) Visualisation
10 6 (8.11%) Business Analysis
10 6 (8.11%) Enterprise Architecture
10 6 (8.11%) Presales
10 6 (8.11%) Stakeholder Engagement
10 6 (8.11%) UML
Programming Languages
1 59 (79.73%) SQL
2 24 (32.43%) Data Analysis Expressions (DAX)
2 24 (32.43%) T-SQL
3 19 (25.68%) C#
4 14 (18.92%) PowerShell
5 11 (14.86%) VBA
6 10 (13.51%) JavaScript
7 8 (10.81%) Java
8 2 (2.70%) Python
8 2 (2.70%) R
9 1 (1.35%) Ruby
Qualifications
1 10 (13.51%) Degree
2 1 (1.35%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 15 (20.27%) QA
2 12 (16.22%) Data Quality
3 5 (6.76%) ISO/IEC 27001
4 2 (2.70%) PCI DSS
4 2 (2.70%) SLA
System Software
1 3 (4.05%) Apache Flume
Systems Management
1 1 (1.35%) CA Single Sign-On
Vendors
1 45 (60.81%) Microsoft
2 14 (18.92%) Oracle
3 13 (17.57%) Tableau
4 10 (13.51%) IBM
4 10 (13.51%) Nintex
4 10 (13.51%) SAP
5 8 (10.81%) RedGate
6 3 (4.05%) Ab Initio
6 3 (4.05%) Hortonworks
6 3 (4.05%) Informatica
6 3 (4.05%) Teradata
7 2 (2.70%) Cloudera
8 1 (1.35%) Cognos
8 1 (1.35%) F5
8 1 (1.35%) Google
8 1 (1.35%) Riverbed
London
Networkers
Salary: £65000 - £70000 per annum + Excellent benefits
Posted: 5 days ago
London
Arrows Group Ltd
Salary: £45000 per annum + benefits
Posted: 10 days ago