The table below looks at the statistics for PowerPivot skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited PowerPivot over the 3 months to 3 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
3 Dec 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 771 818 768
Rank change year-on-year
+47 -50
Permanent jobs citing PowerPivot 94 151 218
As % of all permanent IT jobs located in the UK 0.11% 0.14% 0.19%
As % of the Database & Business Intelligence category 0.35% 0.44% 0.62%
Number of salaries quoted 84 122 181
Median salary £50,750 £40,500 £43,500
Median salary % change year-on-year
+25.30% -6.89%
90% offered a salary of more than £31,800 £30,459 £30,000
10% offered a salary of more than £67,500 £60,000 £65,000
UK excluding London median salary £50,000 £40,500 £42,000
% change year-on-year
+23.45% -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 across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
26700 34195 35140
As % of all permanent IT jobs located in the UK 29.88% 31.86% 30.57%
Number of salaries quoted 22878 28793 29983
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

PowerPivot
Jobs Demand Trend

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

PowerPivot Jobs Demand Trend in the UK

PowerPivot
Salary Trend

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

PowerPivot Salary Trend in the UK

PowerPivot
Salary Histogram

This chart provides a salary histogram for IT jobs citing PowerPivot over the 3 months to 3 December 2016 within the UK.

PowerPivot Salary Histogram in the UK

PowerPivot
Top 30 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the UK over the 3 months to 3 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
England +18 92 £50,750 +25.30% 13
London +51 36 £53,750 +34.37% 4
South East +54 18 £52,500 +29.62%
City of London +37 11 £55,000 -
East Midlands +23 10 £37,000 -32.72%
Yorkshire +19 7 £55,000 +80.32% 2
South West +12 7 £27,500 -14.06% 2
East of England +11 6 £51,250 -10.86% 1
Northamptonshire +10 6 £45,000 -18.18%
Somerset - 6 £27,500 - 1
Bath - 6 £27,500 - 1
West Yorkshire +25 5 £42,500 +39.34% 1
North West -41 5 £57,500 +53.33% 3
Manchester -19 4 £57,500 +43.75% 2
Leeds - 4 £46,250 - 1
Northampton - 4 - -
Cambridgeshire - 3 £52,500 - 1
West Sussex +23 2 £47,000 +25.33%
Hampshire +8 2 £37,500 -19.35%
North Yorkshire +6 2 £70,000 +115.38%
Hertfordshire -1 2 £52,500 -8.69%
Basingstoke -13 2 £37,500 -31.81%
Leicester - 2 £33,750 -
York - 2 £70,000 -
Leicestershire - 2 £33,750 -
Buckinghamshire +15 1 £40,000 -5.88%
Wiltshire +13 1 - - 1
Chorley +1 1 £30,000 -7.69% 1
Brackley -1 1 £30,000 -45.45%
Lancashire -8 1 £30,000 -1.50% 1

PowerPivot
Top 30 Related IT Skills

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

1 147 (81.67%) SQL
1 147 (81.67%) Business Intelligence
2 141 (78.33%) SQL Server Reporting Services
3 125 (69.44%) Microsoft
4 123 (68.33%) SQL Server
5 117 (65.00%) SQL Server Integration Services
5 117 (65.00%) SQL Server Analysis Services
6 104 (57.78%) Power BI
7 83 (46.11%) Data Warehouse
8 78 (43.33%) T-SQL
9 71 (39.44%) ETL
10 69 (38.33%) MS Excel
11 51 (28.33%) Analytics
12 50 (27.78%) Data Modelling
13 48 (26.67%) Agile Software Development
13 48 (26.67%) MDX
14 47 (26.11%) Finance
15 41 (22.78%) Microsoft Power View
16 40 (22.22%) Tableau
17 39 (21.67%) MySQL
18 38 (21.11%) Analytical Skills
18 38 (21.11%) SQL Server 2012
19 37 (20.56%) Data Analysis Expressions (DAX)
20 36 (20.00%) Management Information System
21 35 (19.44%) Relational Database
21 35 (19.44%) Kimball Methodology
22 30 (16.67%) SharePoint
23 29 (16.11%) Visualisation
24 28 (15.56%) Microsoft Analysis Services
25 27 (15.00%) C#

PowerPivot
Top Related IT Skills 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 30 (16.67%) SharePoint
2 9 (5.00%) WebSphere
3 5 (2.78%) OpenStack
4 4 (2.22%) Apache Pig
4 4 (2.22%) SAS
5 2 (1.11%) Apache Spark
6 1 (0.56%) IIS
6 1 (0.56%) MS Exchange
6 1 (0.56%) SharePoint 2010
6 1 (0.56%) SharePoint 2013
6 1 (0.56%) SharePoint Server
Applications
1 69 (38.33%) MS Excel
2 9 (5.00%) MS Visio
3 5 (2.78%) MS PowerPoint
4 4 (2.22%) MS Office
5 1 (0.56%) InfoPath
Business Applications
1 3 (1.67%) Dynamics CRM
2 2 (1.11%) Dynamics AX
3 1 (0.56%) OPENHousing
3 1 (0.56%) Oracle Financials
3 1 (0.56%) StreamServe
Cloud Services
1 21 (11.67%) Microsoft Azure
2 12 (6.67%) GitHub
3 10 (5.56%) Amazon AWS
4 7 (3.89%) PaaS
4 7 (3.89%) SaaS
5 5 (2.78%) Google Analytics
6 2 (1.11%) Office 365
7 1 (0.56%) AdWords
7 1 (0.56%) Azure Machine Learning
7 1 (0.56%) IaaS
Communications & Networking
1 1 (0.56%) DHCP
1 1 (0.56%) LDAP
Database & Business Intelligence
1 141 (78.33%) SQL Server Reporting Services
2 123 (68.33%) SQL Server
3 117 (65.00%) SQL Server Analysis Services
3 117 (65.00%) SQL Server Integration Services
4 104 (57.78%) Power BI
5 83 (46.11%) Data Warehouse
6 41 (22.78%) Microsoft Power View
7 39 (21.67%) MySQL
8 38 (21.11%) SQL Server 2012
9 35 (19.44%) Relational Database
10 28 (15.56%) Microsoft Analysis Services
11 26 (14.44%) Big Data
12 25 (13.89%) SQL Server 2014
13 24 (13.33%) BusinessObjects
14 21 (11.67%) OLAP
15 20 (11.11%) Hadoop
16 18 (10.00%) MS Access
17 15 (8.33%) Data Mining
18 14 (7.78%) NoSQL
18 14 (7.78%) SQL Server 2016
Development Applications
1 11 (6.11%) JIRA
2 9 (5.00%) Visual Studio
3 7 (3.89%) Team Foundation Server
4 6 (3.33%) Git (software)
5 5 (2.78%) Jenkins
6 4 (2.22%) Talend Open Studio
General
1 47 (26.11%) Finance
2 23 (12.78%) Legal
3 12 (6.67%) Advertising
3 12 (6.67%) Billing
4 8 (4.44%) Law
5 5 (2.78%) Marketing
6 2 (1.11%) Banking
6 2 (1.11%) Manufacturing
7 1 (0.56%) Pharmaceutical
Job Titles
1 83 (46.11%) Developer
2 50 (27.78%) Analyst
3 46 (25.56%) Business Intelligence Developer
4 35 (19.44%) SQL Developer
5 26 (14.44%) Business Intelligence Analyst
6 16 (8.89%) Senior Business Intelligence Developer
6 16 (8.89%) Senior Developer
7 15 (8.33%) Business Intelligence Lead
8 14 (7.78%) SQL BI Developer
9 13 (7.22%) Consultant
9 13 (7.22%) SQL Analyst
9 13 (7.22%) SSIS Developer
10 12 (6.67%) Data Analyst
10 12 (6.67%) Excel Analyst
10 12 (6.67%) Report Developer
11 11 (6.11%) Architect
11 11 (6.11%) DBA
11 11 (6.11%) SQL Server Developer
11 11 (6.11%) SSRS Developer
12 10 (5.56%) Business Intelligence Consultant
Libraries, Frameworks & Software Standards
1 48 (26.67%) MDX
2 22 (12.22%) .NET
3 10 (5.56%) .NET Framework
4 9 (5.00%) XML
5 6 (3.33%) ASP.NET
5 6 (3.33%) Web Services
6 4 (2.22%) JSON
7 3 (1.67%) HTML
7 3 (1.67%) REST
7 3 (1.67%) SOAP
8 1 (0.56%) Ajax
8 1 (0.56%) COM
8 1 (0.56%) CSS
8 1 (0.56%) D3.js
8 1 (0.56%) HTML5
8 1 (0.56%) jQuery
8 1 (0.56%) KnockoutJS
8 1 (0.56%) Leaflet
8 1 (0.56%) XSL
Miscellaneous
1 38 (21.11%) Analytical Skills
2 36 (20.00%) Management Information System
3 29 (16.11%) Visualisation
4 7 (3.89%) Replication
4 7 (3.89%) Wiki
5 6 (3.33%) Algorithms
6 4 (2.22%) NHS
7 3 (1.67%) Driving Licence
8 2 (1.11%) Data Integration
8 2 (1.11%) Ergonomics
8 2 (1.11%) Mathematics
8 2 (1.11%) Performance Metrics
8 2 (1.11%) Statistics
9 1 (0.56%) Computer Science
9 1 (0.56%) Credit Risk
9 1 (0.56%) Data Extraction
9 1 (0.56%) Data Protection Act
9 1 (0.56%) Enterprise Software
9 1 (0.56%) Life Science
9 1 (0.56%) User Experience
Operating Systems
1 10 (5.56%) Windows
1 10 (5.56%) Windows Server
1 10 (5.56%) Windows Server 2012
Processes & Methodologies
1 147 (81.67%) Business Intelligence
2 71 (39.44%) ETL
3 51 (28.33%) Analytics
4 50 (27.78%) Data Modelling
5 48 (26.67%) Agile Software Development
6 35 (19.44%) Kimball Methodology
7 27 (15.00%) Data Analysis
8 22 (12.22%) Data Cleansing
9 20 (11.11%) Data Management
9 20 (11.11%) Scrum
10 13 (7.22%) Translating Business Requirements
11 12 (6.67%) ETL Development
11 12 (6.67%) Presales
11 12 (6.67%) TOGAF
12 11 (6.11%) Mentoring
12 11 (6.11%) Performance Optimisation
12 11 (6.11%) Time Management
13 10 (5.56%) Business Analysis
13 10 (5.56%) Project Management
14 9 (5.00%) Workflow
Programming Languages
1 147 (81.67%) SQL
2 78 (43.33%) T-SQL
3 37 (20.56%) Data Analysis Expressions (DAX)
4 27 (15.00%) C#
5 20 (11.11%) VBA
6 15 (8.33%) JavaScript
7 12 (6.67%) PowerShell
8 11 (6.11%) Python
9 9 (5.00%) PL/SQL
10 6 (3.33%) Ruby
11 5 (2.78%) Java
12 3 (1.67%) VB
13 2 (1.11%) R
13 2 (1.11%) VB.NET
13 2 (1.11%) VBScript
14 1 (0.56%) C
14 1 (0.56%) C++
14 1 (0.56%) Pascal
Qualifications
1 12 (6.67%) Degree
2 8 (4.44%) DBS Check
3 1 (0.56%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 27 (15.00%) Data Quality
2 11 (6.11%) QA
3 7 (3.89%) ISO/IEC 27001
4 6 (3.33%) PCI DSS
5 5 (2.78%) SLA
System Software
1 2 (1.11%) Active Directory
2 1 (0.56%) Virtual Desktop
2 1 (0.56%) Virtual Machines
2 1 (0.56%) VMware Infrastructure
Systems Management
1 7 (3.89%) Puppet
2 1 (0.56%) CA Single Sign-On
Vendors
1 125 (69.44%) Microsoft
2 40 (22.22%) Tableau
3 18 (10.00%) Oracle
4 17 (9.44%) Cognos
5 15 (8.33%) SAP
6 11 (6.11%) IBM
7 9 (5.00%) Nintex
8 5 (2.78%) Google
8 5 (2.78%) RedGate
9 4 (2.22%) NetSuite
9 4 (2.22%) Salesforce.com
9 4 (2.22%) Talend
10 2 (1.11%) JD Edwards
10 2 (1.11%) VMware
11 1 (0.56%) Akamai
11 1 (0.56%) Capita
11 1 (0.56%) F5
11 1 (0.56%) MicroStrategy
11 1 (0.56%) Riverbed
11 1 (0.56%) Sony
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: Yesterday
Worcestershire
Spring Technology
Salary: £30000.00 - £40000.00 per annum
Posted: 2 days ago
London
Arrows Group
Salary: £55000 - £65000 per annum + benefits
Posted: 22 hours ago
London
Nigel Frank International
Salary: £40000 - £65000 per annum + Benefits
Posted: 3 days ago
Leeds, West Yorkshire
The Bridge Ltd
Salary: From £30,000 to £45,000 per annum
Posted: 4 days ago
Chorley, Lancashire
Verticality Ltd
Salary: to £35k DOE
Posted: 3 days ago
London
Networkers
Salary: £70000 per annum + Benefits
Posted: 2 days ago
Greater Manchester
Rutherford Grant
Salary: £40000.00 - £45000.00 per annum + bonus and benefits
Posted: 9 days ago
London
Hays London City Cheapside
Salary: £37000.00 - £45000.00 per annum
Posted: 19 days ago
Swindon, Wiltshire
Sanderson
Posted: 18 days ago
Bath, Avon
myBench Ltd
Salary: From £30,000 to £47,000 per annum
Posted: 16 days ago