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

3 months to
25 Sep 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 800 740 793
Rank change year-on-year
-60 +53
Permanent jobs citing PowerPivot 82 197 173
As % of all permanent IT jobs located in England 0.092% 0.19% 0.16%
As % of the Database & Business Intelligence category 0.31% 0.62% 0.52%
Number of salaries quoted 76 169 152
Median salary £50,000 £42,500 £45,000
Median salary % change year-on-year
+17.64% -5.55%
90% offered a salary of more than £37,500 £30,459 £30,000
10% offered a salary of more than £65,000 £62,500 £77,500
UK excluding London median salary £45,000 £40,500 £35,000
% change year-on-year
+11.11% +15.71%
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
26205 31710 33587
As % of all permanent IT jobs located in England 29.53% 30.95% 31.48%
Number of salaries quoted 22521 27046 28468
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 £67,500 £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 25 September 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 25 September 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 +13 37 £57,500 +21.05% 1
South East -1 18 £40,000 -8.04%
Yorkshire +28 8 £37,500 -25.00% 1
North West -11 5 £62,500 +105.19% 4
East of England +12 4 £53,750 +0.46% 1
South West -1 3 £40,000 +25.00%
West Midlands -14 3 £47,500 +55.94%
East Midlands - 2 £45,000 -
North East - 2 £48,000 -
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

For the 6 months to 25 September 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 174 (87.00%) SQL
2 169 (84.50%) Business Intelligence
3 154 (77.00%) Microsoft
4 152 (76.00%) SQL Server Reporting Services
5 147 (73.50%) SQL Server
6 139 (69.50%) SQL Server Analysis Services
7 127 (63.50%) SQL Server Integration Services
8 113 (56.50%) Power BI
9 106 (53.00%) MS Excel
10 99 (49.50%) T-SQL
11 81 (40.50%) ETL
12 80 (40.00%) Data Warehouse
13 72 (36.00%) MDX
14 69 (34.50%) Finance
15 55 (27.50%) Tableau
15 55 (27.50%) Data Analysis Expressions (DAX)
16 53 (26.50%) Agile Software Development
17 50 (25.00%) SQL Server 2012
18 46 (23.00%) Kimball Methodology
19 42 (21.00%) Visualisation
20 40 (20.00%) SharePoint
20 40 (20.00%) Microsoft Power View
21 39 (19.50%) SQL Server 2014
22 38 (19.00%) Analytical Skills
22 38 (19.00%) VBA
22 38 (19.00%) Management Information System
23 36 (18.00%) OLAP
24 33 (16.50%) Data Modelling
25 32 (16.00%) Data Cleansing
25 32 (16.00%) Analytics

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 40 (20.00%) SharePoint
2 4 (2.00%) WebSphere
3 2 (1.00%) SAS
4 1 (0.50%) Apache
4 1 (0.50%) Apache Pig
4 1 (0.50%) MS Exchange
4 1 (0.50%) Tomcat
Applications
1 106 (53.00%) MS Excel
2 6 (3.00%) MS PowerPoint
3 4 (2.00%) MS Visio
4 1 (0.50%) MS Office
Business Applications
1 5 (2.50%) Oracle Financials
2 4 (2.00%) Dynamics CRM
3 1 (0.50%) Cognos TM1
3 1 (0.50%) Dynamics AX
Cloud Services
1 28 (14.00%) Microsoft Azure
2 6 (3.00%) SaaS
3 4 (2.00%) PaaS
4 3 (1.50%) Amazon AWS
5 2 (1.00%) Google Analytics
6 1 (0.50%) AdWords
6 1 (0.50%) Azure Machine Learning
6 1 (0.50%) Office 365
Communications & Networking
1 1 (0.50%) DHCP
Database & Business Intelligence
1 152 (76.00%) SQL Server Reporting Services
2 147 (73.50%) SQL Server
3 139 (69.50%) SQL Server Analysis Services
4 127 (63.50%) SQL Server Integration Services
5 113 (56.50%) Power BI
6 80 (40.00%) Data Warehouse
7 50 (25.00%) SQL Server 2012
8 40 (20.00%) Microsoft Power View
9 39 (19.50%) SQL Server 2014
10 36 (18.00%) OLAP
11 31 (15.50%) Relational Database
12 28 (14.00%) SQL Server 2008
13 26 (13.00%) Microsoft Analysis Services
13 26 (13.00%) MS Access
14 23 (11.50%) Big Data
15 20 (10.00%) MySQL
15 20 (10.00%) SQL Server 2016
16 18 (9.00%) Hadoop
17 17 (8.50%) SQL Server 2005
18 14 (7.00%) PerformancePoint
Development Applications
1 11 (5.50%) Team Foundation Server
2 8 (4.00%) Visual Studio
3 4 (2.00%) SQL Server Management Studio (SSMS)
4 1 (0.50%) JIRA
4 1 (0.50%) Talend Open Studio
4 1 (0.50%) Toad
General
1 69 (34.50%) Finance
2 30 (15.00%) Legal
3 20 (10.00%) Billing
4 13 (6.50%) Advertising
5 7 (3.50%) Marketing
6 6 (3.00%) Telecoms
7 5 (2.50%) Law
8 2 (1.00%) Arabic Language
8 2 (1.00%) Banking
8 2 (1.00%) French Language
8 2 (1.00%) German Language
8 2 (1.00%) Hindi Language
8 2 (1.00%) Russian Language
8 2 (1.00%) Spanish Language
9 1 (0.50%) Financial Institution
9 1 (0.50%) Investment Banking
9 1 (0.50%) Manufacturing
9 1 (0.50%) Private Banking
Job Titles
1 92 (46.00%) Developer
2 74 (37.00%) Business Intelligence Developer
3 61 (30.50%) Analyst
4 38 (19.00%) SQL Developer
5 36 (18.00%) Business Intelligence Analyst
6 29 (14.50%) SSIS Developer
7 26 (13.00%) SQL Analyst
8 22 (11.00%) SQL BI Developer
9 19 (9.50%) Microsoft BI Developer
9 19 (9.50%) SSAS Developer
10 18 (9.00%) Report Analyst
11 17 (8.50%) Microsoft Developer
11 17 (8.50%) SSRS Developer
12 16 (8.00%) Business Intelligence Lead
12 16 (8.00%) Senior Business Intelligence Developer
12 16 (8.00%) Senior Developer
13 14 (7.00%) Data Analyst
13 14 (7.00%) SQL Server Developer
14 13 (6.50%) SSRS Analyst
15 12 (6.00%) Excel Analyst
Libraries, Frameworks & Software Standards
1 72 (36.00%) MDX
2 12 (6.00%) XML
3 10 (5.00%) .NET
3 10 (5.00%) Web Services
4 9 (4.50%) HTML
5 4 (2.00%) CSS
5 4 (2.00%) JSON
6 3 (1.50%) REST
6 3 (1.50%) SOAP
7 2 (1.00%) .NET Framework
7 2 (1.00%) ASP.NET
7 2 (1.00%) HTML5
8 1 (0.50%) COM
8 1 (0.50%) D3.js
8 1 (0.50%) Leaflet
8 1 (0.50%) Middleware
Miscellaneous
1 42 (21.00%) Visualisation
2 38 (19.00%) Analytical Skills
2 38 (19.00%) Management Information System
3 10 (5.00%) Data Integration
3 10 (5.00%) Replication
4 9 (4.50%) Mathematics
5 5 (2.50%) Data Extraction
6 4 (2.00%) Algorithms
6 4 (2.00%) Digital Media
6 4 (2.00%) User Experience
7 3 (1.50%) Computer Science
7 3 (1.50%) Enterprise Software
7 3 (1.50%) Mobile App
7 3 (1.50%) Statistics
8 2 (1.00%) Ergonomics
8 2 (1.00%) Fintech
8 2 (1.00%) Freedom of Information
8 2 (1.00%) Wiki
9 1 (0.50%) Data Protection Act
9 1 (0.50%) Driving Licence
Operating Systems
1 2 (1.00%) Windows
1 2 (1.00%) Windows Server
1 2 (1.00%) Windows Server 2012
Processes & Methodologies
1 169 (84.50%) Business Intelligence
2 81 (40.50%) ETL
3 53 (26.50%) Agile Software Development
4 46 (23.00%) Kimball Methodology
5 33 (16.50%) Data Modelling
6 32 (16.00%) Analytics
6 32 (16.00%) Data Cleansing
7 31 (15.50%) Data Analysis
8 30 (15.00%) Data Management
9 16 (8.00%) Reverse Engineering
10 15 (7.50%) Dimensional Modelling
11 14 (7.00%) Dashboard Development
11 14 (7.00%) Scrum
12 13 (6.50%) Data Visualisation
12 13 (6.50%) E-Commerce
13 12 (6.00%) Presales
14 11 (5.50%) Master Data Management
14 11 (5.50%) SDLC
14 11 (5.50%) Translating Business Requirements
15 10 (5.00%) Data Analytics
Programming Languages
1 174 (87.00%) SQL
2 99 (49.50%) T-SQL
3 55 (27.50%) Data Analysis Expressions (DAX)
4 38 (19.00%) VBA
5 23 (11.50%) C#
6 5 (2.50%) JavaScript
6 5 (2.50%) Python
6 5 (2.50%) VB.NET
7 4 (2.00%) PL/SQL
7 4 (2.00%) Ruby
7 4 (2.00%) VBScript
8 3 (1.50%) R
9 2 (1.00%) Java
9 2 (1.00%) PowerShell
9 2 (1.00%) VB
Qualifications
1 15 (7.50%) Degree
2 7 (3.50%) DBS Check
3 1 (0.50%) ACCA
3 1 (0.50%) CIMA
3 1 (0.50%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 30 (15.00%) Data Quality
2 13 (6.50%) PCI DSS
3 7 (3.50%) QA
3 7 (3.50%) SLA
4 4 (2.00%) ISO/IEC 27001
5 3 (1.50%) Solvency II
System Software
1 2 (1.00%) Active Directory
2 1 (0.50%) Virtual Desktop
2 1 (0.50%) Virtual Machines
2 1 (0.50%) VMware Infrastructure
Systems Management
1 1 (0.50%) Jitterbit
Vendors
1 154 (77.00%) Microsoft
2 55 (27.50%) Tableau
3 11 (5.50%) Oracle
4 10 (5.00%) SAP
5 7 (3.50%) Cognos
6 5 (2.50%) IBM
6 5 (2.50%) Salesforce.com
7 4 (2.00%) Nintex
8 3 (1.50%) NetSuite
9 2 (1.00%) Google
9 2 (1.00%) VMware
10 1 (0.50%) Alteryx
10 1 (0.50%) IDERA
10 1 (0.50%) JD Edwards
10 1 (0.50%) MuleSoft
10 1 (0.50%) RedGate
10 1 (0.50%) Sony
10 1 (0.50%) Talend
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 3 days ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £35,000 per annum
Posted: 5 days ago
Manchester, Lancashire
Venturi
Salary: £50000 - £65000 per annum + Bonus + Benefits
Posted: 5 days ago
Cambridge, Cambridgeshire
Vantage Recruitment Solutions Ltd
Salary: From £40,000 to £50,000 per annum + Benefits
Posted: 5 days ago
London
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + pension, healthcare, dental
Posted: 11 days ago
Manchester
Venturi
Posted: 18 days ago