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

3 months to
26 Feb 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
UK / England
Rank 754 803 727
Rank change year-on-year
+49 -76
Permanent jobs citing PowerPivot 78 125 203
As % of all permanent IT jobs located in England 0.100% 0.13% 0.20%
As % of the Database & Business Intelligence category 0.33% 0.41% 0.65%
Number of salaries quoted 71 97 183
Median salary £50,000 £48,750 £45,000
Median salary % change year-on-year
+2.56% +8.33%
90% offered a salary of more than £30,000 £28,350 £35,000
10% offered a salary of more than £70,000 £75,000 £65,000
UK excluding London median salary £45,000 £45,250 £42,000
% change year-on-year
-0.55% +7.73%

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
23613 30311 31100
As % of all permanent IT jobs located in England 30.26% 31.59% 31.20%
Number of salaries quoted 20274 26006 26804
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year
- +11.11%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +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 26 February 2017.

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 26 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
London +52 41 £55,000 +2.32% 3
South East +55 21 £45,000 -1.09%
South West +18 4 £28,000 -1.75%
North West -14 4 £33,750 +10.80% 1
Yorkshire +33 3 £37,500 +19.04%
East of England +30 2 £50,000 -6.97% 3
West Midlands - 2 £33,250 - 1
East Midlands +5 1 £60,000 +14.28%
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

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

1 144 (84.71%) Business Intelligence
2 139 (81.76%) SQL
3 133 (78.24%) SQL Server Reporting Services
4 115 (67.65%) SQL Server Integration Services
5 112 (65.88%) SQL Server
6 107 (62.94%) SQL Server Analysis Services
7 106 (62.35%) Power BI
8 94 (55.29%) Microsoft
9 80 (47.06%) Data Warehouse
9 80 (47.06%) T-SQL
10 66 (38.82%) Analytics
11 56 (32.94%) MS Excel
12 55 (32.35%) ETL
13 53 (31.18%) Data Modelling
14 51 (30.00%) Agile Software Development
15 44 (25.88%) Microsoft Power View
16 43 (25.29%) MySQL
17 37 (21.76%) Finance
18 36 (21.18%) Hadoop
19 35 (20.59%) Relational Database
20 34 (20.00%) Data Analysis Expressions (DAX)
21 33 (19.41%) Tableau
22 32 (18.82%) Big Data
22 32 (18.82%) SQL Server 2012
22 32 (18.82%) MDX
22 32 (18.82%) Management Information System
23 31 (18.24%) Analytical Skills
24 30 (17.65%) Microsoft Analysis Services
25 29 (17.06%) BusinessObjects
26 26 (15.29%) SharePoint

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 26 (15.29%) SharePoint
2 11 (6.47%) WebSphere
3 9 (5.29%) Apache Pig
4 8 (4.71%) OpenStack
5 4 (2.35%) SAS
6 3 (1.76%) Apache Spark
7 1 (0.59%) IIS
7 1 (0.59%) SharePoint 2010
7 1 (0.59%) SharePoint 2013
7 1 (0.59%) SharePoint Server
Applications
1 56 (32.94%) MS Excel
2 11 (6.47%) MS Visio
3 7 (4.12%) MS Office
4 4 (2.35%) SPSS
5 3 (1.76%) MS PowerPoint
6 1 (0.59%) InfoPath
6 1 (0.59%) Spreadsheet
Business Applications
1 2 (1.18%) Dynamics CRM
2 1 (0.59%) Dynamics AX
2 1 (0.59%) NetSuite
2 1 (0.59%) OPENHousing
2 1 (0.59%) Oracle Financials
2 1 (0.59%) StreamServe
Cloud Services
1 17 (10.00%) GitHub
2 13 (7.65%) Amazon AWS
3 10 (5.88%) Microsoft Azure
4 7 (4.12%) PaaS
5 6 (3.53%) SaaS
6 4 (2.35%) Google Analytics
7 1 (0.59%) Akamai
7 1 (0.59%) IaaS
7 1 (0.59%) Office 365
Communications & Networking
1 4 (2.35%) MVNO
2 1 (0.59%) LDAP
Database & Business Intelligence
1 133 (78.24%) SQL Server Reporting Services
2 115 (67.65%) SQL Server Integration Services
3 112 (65.88%) SQL Server
4 107 (62.94%) SQL Server Analysis Services
5 106 (62.35%) Power BI
6 80 (47.06%) Data Warehouse
7 44 (25.88%) Microsoft Power View
8 43 (25.29%) MySQL
9 36 (21.18%) Hadoop
10 35 (20.59%) Relational Database
11 32 (18.82%) Big Data
11 32 (18.82%) SQL Server 2012
12 30 (17.65%) Microsoft Analysis Services
13 29 (17.06%) BusinessObjects
14 22 (12.94%) Apache Hive
15 20 (11.76%) QlikView
16 18 (10.59%) OLAP
16 18 (10.59%) SQL Server 2014
17 16 (9.41%) NoSQL
18 15 (8.82%) Data Mart
Development Applications
1 19 (11.18%) JIRA
2 9 (5.29%) Git (software)
2 9 (5.29%) Visual Studio
3 8 (4.71%) Jenkins
4 6 (3.53%) Talend Open Studio
5 3 (1.76%) Team Foundation Server
6 1 (0.59%) SQL Server Management Studio (SSMS)
General
1 37 (21.76%) Finance
2 16 (9.41%) Legal
3 11 (6.47%) Law
4 4 (2.35%) Billing
4 4 (2.35%) Games
4 4 (2.35%) Marketing
4 4 (2.35%) Retail
4 4 (2.35%) Telecoms
5 3 (1.76%) Advertising
5 3 (1.76%) Banking
5 3 (1.76%) Manufacturing
5 3 (1.76%) Publishing
6 2 (1.18%) Pharmaceutical
7 1 (0.59%) Financial Institution
Job Titles
1 74 (43.53%) Developer
2 63 (37.06%) Analyst
3 37 (21.76%) Business Intelligence Developer
4 32 (18.82%) SQL Developer
5 29 (17.06%) Business Intelligence Analyst
6 17 (10.00%) Architect
7 15 (8.82%) Report Developer
8 14 (8.24%) Report Analyst
8 14 (8.24%) SQL Server Developer
9 13 (7.65%) SQL BI Developer
10 12 (7.06%) Insight Analyst
10 12 (7.06%) Senior Analyst
10 12 (7.06%) SSRS Developer
11 11 (6.47%) Senior Business Intelligence Analyst
11 11 (6.47%) Senior Business Intelligence Developer
11 11 (6.47%) Senior Developer
11 11 (6.47%) Solutions Architect
12 10 (5.88%) Data Analyst
12 10 (5.88%) SQL Analyst
13 9 (5.29%) NoSQL Developer
Libraries, Frameworks & Software Standards
1 32 (18.82%) MDX
2 24 (14.12%) .NET
3 13 (7.65%) .NET Framework
4 6 (3.53%) ASP.NET
5 4 (2.35%) Kafka
6 3 (1.76%) HTML
7 2 (1.18%) CSS
7 2 (1.18%) XML
8 1 (0.59%) Ajax
8 1 (0.59%) jQuery
8 1 (0.59%) KnockoutJS
8 1 (0.59%) Web Services
8 1 (0.59%) XSL
Miscellaneous
1 32 (18.82%) Management Information System
2 31 (18.24%) Analytical Skills
3 10 (5.88%) Wiki
4 9 (5.29%) NHS
5 5 (2.94%) Algorithms
6 3 (1.76%) Driving Licence
7 2 (1.18%) Fintech
7 2 (1.18%) Life Science
8 1 (0.59%) Blog
8 1 (0.59%) Computer Science
8 1 (0.59%) Credit Risk
8 1 (0.59%) User Experience
Operating Systems
1 13 (7.65%) Windows
1 13 (7.65%) Windows Server
1 13 (7.65%) Windows Server 2012
2 3 (1.76%) Unix
Processes & Methodologies
1 144 (84.71%) Business Intelligence
2 66 (38.82%) Analytics
3 55 (32.35%) ETL
4 53 (31.18%) Data Modelling
5 51 (30.00%) Agile Software Development
6 22 (12.94%) Scrum
7 18 (10.59%) Data Analysis
8 16 (9.41%) ETL Development
8 16 (9.41%) Mentoring
9 15 (8.82%) Kimball Methodology
9 15 (8.82%) Time Management
10 14 (8.24%) Performance Optimisation
10 14 (8.24%) Use Case
10 14 (8.24%) Visualisation
11 13 (7.65%) Customer Requirements
12 12 (7.06%) Translating Business Requirements
13 11 (6.47%) Coaching
13 11 (6.47%) Dashboard Development
13 11 (6.47%) TOGAF
13 11 (6.47%) Workflow
Programming Languages
1 139 (81.76%) SQL
2 80 (47.06%) T-SQL
3 34 (20.00%) Data Analysis Expressions (DAX)
4 25 (14.71%) C#
5 22 (12.94%) VBA
6 19 (11.18%) Python
7 17 (10.00%) JavaScript
8 15 (8.82%) PowerShell
9 9 (5.29%) PL/SQL
10 8 (4.71%) Java
11 7 (4.12%) R
12 5 (2.94%) Ruby
13 3 (1.76%) VBScript
14 1 (0.59%) C
14 1 (0.59%) C++
14 1 (0.59%) Pascal
14 1 (0.59%) VB
Qualifications
1 18 (10.59%) Degree
2 3 (1.76%) DBS Check
3 2 (1.18%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 21 (12.35%) Data Quality
2 17 (10.00%) QA
3 7 (4.12%) ISO/IEC 27001
4 6 (3.53%) Cyber Essentials
5 2 (1.18%) PCI DSS
5 2 (1.18%) SLA
System Software
1 4 (2.35%) Apache Flume
Systems Management
1 9 (5.29%) Puppet
2 1 (0.59%) CA Single Sign-On
Vendors
1 94 (55.29%) Microsoft
2 33 (19.41%) Tableau
3 25 (14.71%) Cognos
4 20 (11.76%) Oracle
5 13 (7.65%) SAP
6 12 (7.06%) IBM
7 11 (6.47%) Nintex
8 10 (5.88%) RedGate
9 8 (4.71%) Teradata
10 6 (3.53%) Talend
11 5 (2.94%) Google
12 4 (2.35%) Ab Initio
12 4 (2.35%) Hortonworks
12 4 (2.35%) Informatica
13 2 (1.18%) Cloudera
13 2 (1.18%) IDERA
14 1 (0.59%) Capita
14 1 (0.59%) F5
14 1 (0.59%) MicroStrategy
14 1 (0.59%) Riverbed
Borehamwood, Hertfordshire
Capital IT Resourcing LTD
Salary: £35000 - £45000 per annum + Benefits
Posted: Yesterday
North London
Bluetownonline
Salary: £24000 - £32000 per annum
Posted: 2 days ago
Cannock, Staffordshire
Bluetownonline
Salary: £28000 per annum
Posted: 3 days ago
Hertfordshire
Lawrence Harvey
Salary: £35000.00 - £45000.00 per annum + pension, health care
Posted: 10 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 13 days ago
London
Arrows Group Ltd
Salary: £45000 per annum + benefits
Posted: 16 days ago
Cambridge
Bluetown Online LTD
Posted: 17 days ago