The table below looks at the statistics for PowerPivot skills in IT jobs advertised for the England 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 768 784 750
Rank change year-on-year
+16 -34
Permanent jobs citing PowerPivot 96 150 217
As % of all permanent IT jobs located in England 0.11% 0.15% 0.20%
As % of the Database & Business Intelligence category 0.38% 0.47% 0.66%
Number of salaries quoted 86 118 178
Median salary £50,000 £40,500 £43,500
Median salary % change year-on-year
+23.45% -6.89%
90% offered a salary of more than £30,750 £30,000 £30,000
10% offered a salary of more than £67,500 £60,000 £65,000
UK excluding London median salary £47,500 £40,500 £42,000
% change year-on-year
+17.28% -3.57%
PowerPivot
UK

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 England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
25176 31880 32688
As % of all permanent IT jobs located in England 29.95% 32.05% 30.69%
Number of salaries quoted 21748 27102 28128
Median salary £50,000 £48,500 £45,000
Median salary % change year-on-year
+3.09% +7.77%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

PowerPivot
Jobs Demand Trend in England

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

PowerPivot Jobs Demand Trend in England

PowerPivot
Salary Trend in England

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

PowerPivot Salary Trend in England

PowerPivot
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing PowerPivot across the England region over the 3 months to 9 December 2016.

PowerPivot Salary Histogram in England

PowerPivot
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the England 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
London +53 40 £55,000 +37.50% 5
South East +57 18 £52,500 +29.62% 5
East Midlands +14 10 £37,000 -32.72%
Yorkshire +24 8 £48,750 +59.83% 1
South West +16 6 £27,500 -14.06% 2
East of England +4 5 £50,000 -13.04% 1
North West -50 5 £43,750 +19.01% 3
West Midlands -6 2 £33,250 -21.76% 1
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

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 England region with a requirement for PowerPivot.

1 148 (82.68%) SQL
2 145 (81.01%) Business Intelligence
3 140 (78.21%) SQL Server Reporting Services
4 122 (68.16%) SQL Server
5 121 (67.60%) Microsoft
6 116 (64.80%) SQL Server Analysis Services
7 115 (64.25%) SQL Server Integration Services
8 106 (59.22%) Power BI
9 82 (45.81%) Data Warehouse
10 80 (44.69%) T-SQL
11 68 (37.99%) ETL
12 65 (36.31%) MS Excel
13 53 (29.61%) Analytics
14 50 (27.93%) Data Modelling
15 46 (25.70%) Agile Software Development
15 46 (25.70%) MDX
16 45 (25.14%) Finance
17 40 (22.35%) MySQL
17 40 (22.35%) Microsoft Power View
18 38 (21.23%) Data Analysis Expressions (DAX)
18 38 (21.23%) Tableau
19 37 (20.67%) SQL Server 2012
19 37 (20.67%) Analytical Skills
20 36 (20.11%) Relational Database
20 36 (20.11%) Management Information System
21 34 (18.99%) Kimball Methodology
22 31 (17.32%) Microsoft Analysis Services
23 29 (16.20%) SharePoint
24 28 (15.64%) Data Quality
25 27 (15.08%) Data Analysis

PowerPivot
Top Related IT Skills in England 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 29 (16.20%) SharePoint
2 10 (5.59%) WebSphere
3 6 (3.35%) OpenStack
4 4 (2.23%) Apache Pig
4 4 (2.23%) SAS
5 2 (1.12%) 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 65 (36.31%) MS Excel
2 10 (5.59%) MS Visio
3 5 (2.79%) MS PowerPoint
4 4 (2.23%) MS Office
5 1 (0.56%) InfoPath
Business Applications
1 3 (1.68%) Dynamics CRM
2 2 (1.12%) Oracle Financials
3 1 (0.56%) Dynamics AX
3 1 (0.56%) OPENHousing
3 1 (0.56%) StreamServe
Cloud Services
1 19 (10.61%) Microsoft Azure
2 13 (7.26%) GitHub
3 11 (6.15%) Amazon AWS
4 7 (3.91%) PaaS
4 7 (3.91%) SaaS
5 5 (2.79%) Google Analytics
6 2 (1.12%) 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 140 (78.21%) SQL Server Reporting Services
2 122 (68.16%) SQL Server
3 116 (64.80%) SQL Server Analysis Services
4 115 (64.25%) SQL Server Integration Services
5 106 (59.22%) Power BI
6 82 (45.81%) Data Warehouse
7 40 (22.35%) Microsoft Power View
7 40 (22.35%) MySQL
8 37 (20.67%) SQL Server 2012
9 36 (20.11%) Relational Database
10 31 (17.32%) Microsoft Analysis Services
11 26 (14.53%) Big Data
12 25 (13.97%) BusinessObjects
12 25 (13.97%) SQL Server 2014
13 20 (11.17%) Hadoop
13 20 (11.17%) OLAP
14 17 (9.50%) MS Access
15 15 (8.38%) Data Mining
15 15 (8.38%) QlikView
16 14 (7.82%) NoSQL
Development Applications
1 11 (6.15%) JIRA
2 10 (5.59%) Visual Studio
3 7 (3.91%) Git (software)
4 6 (3.35%) Jenkins
4 6 (3.35%) Team Foundation Server
5 4 (2.23%) Talend Open Studio
General
1 45 (25.14%) Finance
2 23 (12.85%) Legal
3 12 (6.70%) Advertising
4 11 (6.15%) Billing
5 8 (4.47%) Law
6 5 (2.79%) Marketing
7 3 (1.68%) Banking
8 2 (1.12%) Manufacturing
9 1 (0.56%) Pharmaceutical
Job Titles
1 82 (45.81%) Developer
2 50 (27.93%) Analyst
3 43 (24.02%) Business Intelligence Developer
4 35 (19.55%) SQL Developer
5 26 (14.53%) Business Intelligence Analyst
6 15 (8.38%) Senior Business Intelligence Developer
6 15 (8.38%) Senior Developer
7 14 (7.82%) Business Intelligence Lead
8 13 (7.26%) Consultant
8 13 (7.26%) Report Developer
8 13 (7.26%) SQL Analyst
8 13 (7.26%) SQL BI Developer
9 12 (6.70%) Architect
9 12 (6.70%) Data Analyst
9 12 (6.70%) Excel Analyst
9 12 (6.70%) SSIS Developer
10 10 (5.59%) Business Intelligence Consultant
10 10 (5.59%) DBA
10 10 (5.59%) SQL Server Developer
10 10 (5.59%) SSRS Developer
Libraries, Frameworks & Software Standards
1 46 (25.70%) MDX
2 24 (13.41%) .NET
3 11 (6.15%) .NET Framework
4 8 (4.47%) XML
5 6 (3.35%) ASP.NET
6 5 (2.79%) Web Services
7 4 (2.23%) JSON
8 3 (1.68%) HTML
8 3 (1.68%) REST
8 3 (1.68%) SOAP
9 1 (0.56%) Ajax
9 1 (0.56%) COM
9 1 (0.56%) CSS
9 1 (0.56%) D3.js
9 1 (0.56%) HTML5
9 1 (0.56%) jQuery
9 1 (0.56%) KnockoutJS
9 1 (0.56%) Leaflet
9 1 (0.56%) XSL
Miscellaneous
1 37 (20.67%) Analytical Skills
2 36 (20.11%) Management Information System
3 26 (14.53%) Visualisation
4 8 (4.47%) Wiki
5 6 (3.35%) Algorithms
5 6 (3.35%) NHS
5 6 (3.35%) Replication
6 3 (1.68%) Driving Licence
7 2 (1.12%) Ergonomics
7 2 (1.12%) Mathematics
7 2 (1.12%) Performance Metrics
7 2 (1.12%) Statistics
8 1 (0.56%) Computer Science
8 1 (0.56%) Credit Risk
8 1 (0.56%) Data Extraction
8 1 (0.56%) Data Integration
8 1 (0.56%) Data Protection Act
8 1 (0.56%) Fintech
8 1 (0.56%) Life Science
8 1 (0.56%) User Experience
Operating Systems
1 11 (6.15%) Windows
1 11 (6.15%) Windows Server
1 11 (6.15%) Windows Server 2012
Processes & Methodologies
1 145 (81.01%) Business Intelligence
2 68 (37.99%) ETL
3 53 (29.61%) Analytics
4 50 (27.93%) Data Modelling
5 46 (25.70%) Agile Software Development
6 34 (18.99%) Kimball Methodology
7 27 (15.08%) Data Analysis
8 21 (11.73%) Data Cleansing
9 20 (11.17%) Data Management
10 18 (10.06%) Scrum
11 13 (7.26%) ETL Development
11 13 (7.26%) TOGAF
11 13 (7.26%) Translating Business Requirements
12 12 (6.70%) Performance Optimisation
12 12 (6.70%) Presales
13 11 (6.15%) Mentoring
13 11 (6.15%) Project Management
13 11 (6.15%) Time Management
14 10 (5.59%) Business Analysis
14 10 (5.59%) Workflow
Programming Languages
1 148 (82.68%) SQL
2 80 (44.69%) T-SQL
3 38 (21.23%) Data Analysis Expressions (DAX)
4 27 (15.08%) C#
5 20 (11.17%) VBA
6 16 (8.94%) JavaScript
7 13 (7.26%) PowerShell
8 11 (6.15%) Python
9 9 (5.03%) PL/SQL
10 6 (3.35%) Java
10 6 (3.35%) Ruby
11 3 (1.68%) VB
12 2 (1.12%) R
12 2 (1.12%) VB.NET
12 2 (1.12%) VBScript
13 1 (0.56%) C
13 1 (0.56%) C++
13 1 (0.56%) Pascal
Qualifications
1 13 (7.26%) Degree
2 8 (4.47%) DBS Check
3 2 (1.12%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 28 (15.64%) Data Quality
2 14 (7.82%) QA
3 7 (3.91%) ISO/IEC 27001
4 5 (2.79%) PCI DSS
4 5 (2.79%) SLA
System Software
1 2 (1.12%) 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.91%) Puppet
2 1 (0.56%) CA Single Sign-On
Vendors
1 121 (67.60%) Microsoft
2 38 (21.23%) Tableau
3 20 (11.17%) Oracle
4 18 (10.06%) Cognos
5 16 (8.94%) SAP
6 12 (6.70%) IBM
7 10 (5.59%) Nintex
8 6 (3.35%) RedGate
9 5 (2.79%) Google
10 4 (2.23%) Salesforce.com
10 4 (2.23%) Talend
11 3 (1.68%) NetSuite
12 2 (1.12%) VMware
13 1 (0.56%) Akamai
13 1 (0.56%) Capita
13 1 (0.56%) F5
13 1 (0.56%) JD Edwards
13 1 (0.56%) MicroStrategy
13 1 (0.56%) Riverbed
13 1 (0.56%) Sony
City, London
Comtecs
Salary: £65000 - £75000 Per Annum + Bonus + Excellent Benefits
Posted: 6 hours ago
Worcestershire
Spring Technology
Salary: £30000.00 - £46000.00 per annum
Posted: 23 hours ago
City, London
Harvey Nash plc
Salary: £25000 - £28000 per annum
Posted: Yesterday
South East
Austin Fraser
Salary: £45000.00 per annum + Benefits
Posted: Yesterday
London
ISL
Salary: £38000 - £42000 per annum + + benfiits
Posted: Yesterday
South East
Austin Fraser
Salary: £55000 - £65000 per annum + Bonus + Benefits
Posted: Yesterday
Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + Benefits
Posted: 3 days ago
Reigate, Surrey
Henderson Drake
Salary: From £42,000 to £45,000 per annum Bonus + Pension + Healthcare + Holid
Posted: 2 days ago
Slough, Berkshire
Telefonica
Posted: 3 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 7 days ago
Greater Manchester
Rutherford Grant
Salary: £40000.00 - £45000.00 per annum + bonus and benefits
Posted: 15 days ago
London
Hays London City Cheapside
Salary: £37000.00 - £45000.00 per annum
Posted: 25 days ago
Swindon, Wiltshire
Sanderson
Posted: 25 days ago
Bath, Avon
myBench Ltd
Salary: From £30,000 to £47,000 per annum
Posted: 23 days ago
London
Arrows Group Ltd
Salary: £55000 - £65000 per annum + benefits
Posted: 24 days ago