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 9 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
9 Dec 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 559 612 589
Rank change year-on-year
+53 -23
Permanent jobs citing PowerPivot 40 52 78
As % of all permanent IT jobs located in London 0.11% 0.12% 0.17%
As % of the Database & Business Intelligence category 0.38% 0.38% 0.58%
Number of salaries quoted 35 36 58
Median salary £55,000 £40,000 £55,000
Median salary % change year-on-year
+37.50% -27.27%
90% offered a salary of more than £41,000 £30,000 £39,250
10% offered a salary of more than £67,500 £80,000 £80,000
UK excluding London median salary £47,500 £40,500 £42,000
% change year-on-year
+17.28% -3.57%
PowerPivot
England

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
10434 13591 13529
As % of all permanent IT jobs located in London 29.62% 31.37% 30.13%
Number of salaries quoted 9083 11596 11683
Median salary £60,000 £56,000 £55,000
Median salary % change year-on-year
+7.14% +1.81%
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 £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 9 December 2016.

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 9 December 2016. 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
(Click see detailed
statistics and trends)
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 +33 11 £55,000 - 2
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in London

For the 6 months to 9 December 2016, 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 70 (88.61%) Business Intelligence
2 67 (84.81%) SQL
3 63 (79.75%) Microsoft
3 63 (79.75%) SQL Server Reporting Services
4 50 (63.29%) SQL Server Analysis Services
5 48 (60.76%) SQL Server
6 41 (51.90%) Power BI
7 37 (46.84%) MS Excel
7 37 (46.84%) Data Warehouse
7 37 (46.84%) SQL Server Integration Services
8 34 (43.04%) T-SQL
8 34 (43.04%) ETL
9 29 (36.71%) Data Analysis Expressions (DAX)
10 28 (35.44%) Finance
11 26 (32.91%) Microsoft Analysis Services
11 26 (32.91%) MDX
12 23 (29.11%) Data Modelling
12 23 (29.11%) Analytics
12 23 (29.11%) Tableau
13 21 (26.58%) Data Quality
13 21 (26.58%) C#
14 20 (25.32%) Data Analysis
14 20 (25.32%) Data Cleansing
14 20 (25.32%) Visualisation
15 19 (24.05%) SharePoint
16 18 (22.78%) SQL Server 2012
17 17 (21.52%) Analytical Skills
17 17 (21.52%) Management Information System
18 16 (20.25%) Legal
18 16 (20.25%) Oracle

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 19 (24.05%) SharePoint
2 9 (11.39%) WebSphere
3 6 (7.59%) OpenStack
4 1 (1.27%) IIS
4 1 (1.27%) SAS
4 1 (1.27%) SharePoint 2010
4 1 (1.27%) SharePoint 2013
4 1 (1.27%) SharePoint Server
Applications
1 37 (46.84%) MS Excel
2 9 (11.39%) MS Visio
3 2 (2.53%) MS Office
3 2 (2.53%) MS PowerPoint
4 1 (1.27%) InfoPath
Business Applications
1 2 (2.53%) Oracle Financials
Cloud Services
1 7 (8.86%) Microsoft Azure
2 6 (7.59%) Amazon AWS
2 6 (7.59%) GitHub
2 6 (7.59%) PaaS
2 6 (7.59%) SaaS
3 2 (2.53%) Office 365
4 1 (1.27%) Azure Machine Learning
4 1 (1.27%) IaaS
Communications & Networking
1 1 (1.27%) LDAP
Database & Business Intelligence
1 63 (79.75%) SQL Server Reporting Services
2 50 (63.29%) SQL Server Analysis Services
3 48 (60.76%) SQL Server
4 41 (51.90%) Power BI
5 37 (46.84%) Data Warehouse
5 37 (46.84%) SQL Server Integration Services
6 26 (32.91%) Microsoft Analysis Services
7 18 (22.78%) SQL Server 2012
8 14 (17.72%) MySQL
9 13 (16.46%) Relational Database
10 12 (15.19%) Data Mart
10 12 (15.19%) QlikView
10 12 (15.19%) SQL Server 2014
10 12 (15.19%) SQL Server 2016
11 11 (13.92%) CouchDB
12 10 (12.66%) BusinessObjects
12 10 (12.66%) Microsoft Power View
13 9 (11.39%) PerformancePoint
13 9 (11.39%) SAP Data Services
14 6 (7.59%) Oracle Reports
Development Applications
1 6 (7.59%) Git (software)
1 6 (7.59%) Jenkins
2 1 (1.27%) Team Foundation Server
General
1 28 (35.44%) Finance
2 16 (20.25%) Legal
3 11 (13.92%) Billing
4 5 (6.33%) Advertising
5 3 (3.80%) Banking
5 3 (3.80%) Law
5 3 (3.80%) Marketing
6 1 (1.27%) Manufacturing
Job Titles
1 27 (34.18%) Developer
2 18 (22.78%) Analyst
3 15 (18.99%) Business Intelligence Analyst
4 13 (16.46%) Business Intelligence Developer
4 13 (16.46%) Report Developer
5 10 (12.66%) Architect
5 10 (12.66%) Business Intelligence Lead
6 9 (11.39%) Solutions Architect
7 8 (10.13%) Consultant
7 8 (10.13%) SQL Developer
8 7 (8.86%) Business Intelligence Consultant
8 7 (8.86%) Senior Analyst
8 7 (8.86%) Senior Business Intelligence Analyst
8 7 (8.86%) Team Leader
9 6 (7.59%) DBA
9 6 (7.59%) Microsoft BI Developer
9 6 (7.59%) Senior Business Intelligence Developer
9 6 (7.59%) Senior Developer
9 6 (7.59%) SSIS Developer
9 6 (7.59%) SSRS Developer
Libraries, Frameworks & Software Standards
1 26 (32.91%) MDX
2 14 (17.72%) .NET
3 11 (13.92%) .NET Framework
4 5 (6.33%) XML
5 3 (3.80%) REST
5 3 (3.80%) SOAP
5 3 (3.80%) Web Services
6 2 (2.53%) HTML
6 2 (2.53%) JSON
7 1 (1.27%) Ajax
7 1 (1.27%) ASP.NET
7 1 (1.27%) COM
7 1 (1.27%) D3.js
7 1 (1.27%) HTML5
7 1 (1.27%) jQuery
7 1 (1.27%) KnockoutJS
7 1 (1.27%) Leaflet
7 1 (1.27%) XSL
Miscellaneous
1 20 (25.32%) Visualisation
2 17 (21.52%) Analytical Skills
2 17 (21.52%) Management Information System
3 8 (10.13%) Wiki
4 6 (7.59%) NHS
4 6 (7.59%) Replication
5 1 (1.27%) Algorithms
5 1 (1.27%) Data Extraction
5 1 (1.27%) Fintech
5 1 (1.27%) Mathematics
5 1 (1.27%) User Experience
Operating Systems
1 11 (13.92%) Windows
1 11 (13.92%) Windows Server
1 11 (13.92%) Windows Server 2012
Processes & Methodologies
1 70 (88.61%) Business Intelligence
2 34 (43.04%) ETL
3 23 (29.11%) Analytics
3 23 (29.11%) Data Modelling
4 20 (25.32%) Data Analysis
4 20 (25.32%) Data Cleansing
5 15 (18.99%) Data Management
5 15 (18.99%) Kimball Methodology
6 12 (15.19%) ETL Development
6 12 (15.19%) Performance Optimisation
6 12 (15.19%) TOGAF
7 11 (13.92%) Presales
8 9 (11.39%) Translating Business Requirements
8 9 (11.39%) Use Case
8 9 (11.39%) Workflow
9 8 (10.13%) Test Scripting
10 7 (8.86%) Agile Software Development
10 7 (8.86%) Business Analysis
10 7 (8.86%) Master Data Management
11 6 (7.59%) Enterprise Architecture
Programming Languages
1 67 (84.81%) SQL
2 34 (43.04%) T-SQL
3 29 (36.71%) Data Analysis Expressions (DAX)
4 21 (26.58%) C#
5 14 (17.72%) VBA
6 12 (15.19%) PowerShell
7 8 (10.13%) JavaScript
8 6 (7.59%) Java
9 2 (2.53%) Python
9 2 (2.53%) R
10 1 (1.27%) Ruby
Qualifications
1 7 (8.86%) Degree
2 2 (2.53%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 21 (26.58%) Data Quality
2 13 (16.46%) QA
3 5 (6.33%) ISO/IEC 27001
3 5 (6.33%) PCI DSS
4 3 (3.80%) SLA
Systems Management
1 1 (1.27%) CA Single Sign-On
Vendors
1 63 (79.75%) Microsoft
2 23 (29.11%) Tableau
3 16 (20.25%) Oracle
4 10 (12.66%) SAP
5 9 (11.39%) IBM
5 9 (11.39%) Nintex
6 6 (7.59%) RedGate
7 3 (3.80%) Salesforce.com
8 2 (2.53%) Cognos
9 1 (1.27%) Akamai
9 1 (1.27%) Alteryx
9 1 (1.27%) F5
9 1 (1.27%) MuleSoft
9 1 (1.27%) Riverbed
City, London
Comtecs
Salary: £65000 - £75000 Per Annum + Bonus + Excellent Benefits
Posted: 5 hours ago
City, London
Harvey Nash plc
Salary: £25000 - £28000 per annum
Posted: Yesterday
London
ISL
Salary: £38000 - £42000 per annum + + benfiits
Posted: Yesterday
London
Hays London City Cheapside
Salary: £37000.00 - £45000.00 per annum
Posted: 25 days ago
London
Arrows Group Ltd
Salary: £55000 - £65000 per annum + benefits
Posted: 24 days ago