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

3 months to
4 May 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 767 786 886
Rank change year-on-year
+19 +100
Permanent jobs citing PowerPivot 156 156 82
As % of all permanent IT jobs located in England 0.16% 0.15% 0.074%
As % of the Database & Business Intelligence category 0.53% 0.47% 0.23%
Number of salaries quoted 124 145 73
Median salary £50,000 £52,500 £47,500
Median salary % change year-on-year
-4.76% +10.52%
90% offered a salary of more than £32,150 £40,000 £30,500
10% offered a salary of more than £70,000 £75,000 £65,000
UK excluding London median salary £43,597 £45,000 £40,000
% change year-on-year
-3.11% +12.50%
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
29424 32950 36181
As % of all permanent IT jobs located in England 30.63% 32.04% 32.52%
Number of salaries quoted 25421 28071 30982
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 £31,500 £30,000
10% offered a salary of more than £72,500 £67,500 £70,000
UK excluding London median salary £42,500 £40,000 £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 4 May 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 4 May 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 -8 89 £57,500 +4.54% 7
South East +3 27 £45,500 +1.11% 6
North West +34 13 £30,459 -23.85% 2
Yorkshire +13 11 £47,500 +5.55% 1
South West +2 5 £38,500 -30.00% 1
East Midlands - 4 £40,000 - 1
North East - 3 £38,500 - 1
East of England - 2 £47,597 - 1
West Midlands -22 1 £40,000 +6.66%
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

For the 6 months to 4 May 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 246 (86.62%) Business Intelligence
2 224 (78.87%) SQL
3 213 (75.00%) SQL Server
4 196 (69.01%) Microsoft
5 191 (67.25%) SQL Server Reporting Services
6 169 (59.51%) SQL Server Integration Services
7 167 (58.80%) SQL Server Analysis Services
8 155 (54.58%) Data Warehouse
9 143 (50.35%) MS Excel
10 114 (40.14%) T-SQL
11 107 (37.68%) Microsoft Power View
12 104 (36.62%) Power BI
13 102 (35.92%) MDX
14 94 (33.10%) ETL
15 84 (29.58%) SharePoint
15 84 (29.58%) Finance
16 70 (24.65%) Analytics
17 65 (22.89%) Data Analysis Expressions (DAX)
17 65 (22.89%) VBA
18 62 (21.83%) SQL Server 2008
19 60 (21.13%) Agile Software Development
19 60 (21.13%) OLAP
19 60 (21.13%) Kimball Methodology
20 54 (19.01%) Analytical Skills
21 50 (17.61%) Tableau
21 50 (17.61%) SQL Server 2012
22 45 (15.85%) Management Information System
23 42 (14.79%) Data Modelling
23 42 (14.79%) Degree
24 41 (14.44%) C#

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 84 (29.58%) SharePoint
2 20 (7.04%) SAS
3 3 (1.06%) IIS
3 3 (1.06%) SharePoint 2010
3 3 (1.06%) SharePoint 2013
4 2 (0.70%) NServiceBus
5 1 (0.35%) SharePoint Server
5 1 (0.35%) WebSphere
Applications
1 143 (50.35%) MS Excel
2 25 (8.80%) MS Office
3 14 (4.93%) MS PowerPoint
4 6 (2.11%) SPSS
5 4 (1.41%) Spreadsheet
6 2 (0.70%) MS Visio
7 1 (0.35%) GNU Octave
7 1 (0.35%) MS Project
Business Applications
1 9 (3.17%) Cognos Business Intelligence
2 8 (2.82%) Dynamics CRM
3 5 (1.76%) Cognos TM1
3 5 (1.76%) SAP Business One
4 3 (1.06%) Oracle Financials
5 2 (0.70%) Sage 1000
5 2 (0.70%) Tesseract
6 1 (0.35%) Dynamics AX
Cloud Services
1 28 (9.86%) Microsoft Azure
2 6 (2.11%) Adobe Analytics
3 5 (1.76%) Google Analytics
3 5 (1.76%) PaaS
4 4 (1.41%) Azure Machine Learning
4 4 (1.41%) IaaS
5 2 (0.70%) SaaS
6 1 (0.35%) Office 365
Communications & Networking
1 10 (3.52%) DNS
2 3 (1.06%) DHCP
3 2 (0.70%) Internet
Database & Business Intelligence
1 213 (75.00%) SQL Server
2 191 (67.25%) SQL Server Reporting Services
3 169 (59.51%) SQL Server Integration Services
4 167 (58.80%) SQL Server Analysis Services
5 155 (54.58%) Data Warehouse
6 107 (37.68%) Microsoft Power View
7 104 (36.62%) Power BI
8 62 (21.83%) SQL Server 2008
9 60 (21.13%) OLAP
10 50 (17.61%) SQL Server 2012
11 41 (14.44%) Relational Database
12 37 (13.03%) SQL Server 2014
13 33 (11.62%) Microsoft Analysis Services
14 29 (10.21%) SQL Server 2005
15 27 (9.51%) RDBMS
16 24 (8.45%) PerformancePoint
17 20 (7.04%) SQL Server 2016
18 18 (6.34%) Data Mining
19 17 (5.99%) NoSQL
20 16 (5.63%) QlikView
Development Applications
1 21 (7.39%) Team Foundation Server
2 11 (3.87%) SQL Server Management Studio (SSMS)
3 9 (3.17%) JIRA
3 9 (3.17%) Visual Studio
4 5 (1.76%) Toad
5 3 (1.06%) Talend Open Studio
5 3 (1.06%) Visual Studio Tools for Office
6 2 (0.70%) ERwin
6 2 (0.70%) Git (software)
6 2 (0.70%) Subversion
General
1 84 (29.58%) Finance
2 21 (7.39%) Marketing
3 15 (5.28%) Banking
4 11 (3.87%) Legal
5 8 (2.82%) Manufacturing
6 7 (2.46%) Billing
6 7 (2.46%) Retail
7 6 (2.11%) Advertising
7 6 (2.11%) Private Banking
7 6 (2.11%) Telecoms
8 5 (1.76%) iGaming
9 2 (0.70%) Financial Institution
9 2 (0.70%) Investment Banking
10 1 (0.35%) Publishing
Job Titles
1 119 (41.90%) Developer
2 103 (36.27%) Analyst
3 88 (30.99%) Business Intelligence Developer
4 46 (16.20%) SQL Developer
5 45 (15.85%) Business Intelligence Analyst
6 30 (10.56%) Architect
7 29 (10.21%) SQL BI Developer
7 29 (10.21%) SSIS Developer
8 28 (9.86%) SQL Analyst
9 27 (9.51%) Report Analyst
10 24 (8.45%) SQL Server Developer
11 21 (7.39%) SSRS Analyst
12 19 (6.69%) SSAS Developer
13 18 (6.34%) Business Developer
13 18 (6.34%) Data Analyst
13 18 (6.34%) SSRS Developer
14 16 (5.63%) Consultant
14 16 (5.63%) Microsoft BI Developer
15 15 (5.28%) Business Intelligence Consultant
15 15 (5.28%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 102 (35.92%) MDX
2 30 (10.56%) HTML
3 26 (9.15%) .NET
3 26 (9.15%) CSS
4 19 (6.69%) XML
5 9 (3.17%) Web Services
6 8 (2.82%) ASP.NET
7 6 (2.11%) Ajax
7 6 (2.11%) jQuery
8 5 (1.76%) HTML5
9 4 (1.41%) D3.js
9 4 (1.41%) Leaflet
10 2 (0.70%) CSS3
10 2 (0.70%) RabbitMQ
11 1 (0.35%) EDI
11 1 (0.35%) Google Maps API
11 1 (0.35%) JSON
Miscellaneous
1 54 (19.01%) Analytical Skills
2 45 (15.85%) Management Information System
3 30 (10.56%) Visualisation
4 25 (8.80%) Mathematics
5 21 (7.39%) Data Integration
6 17 (5.99%) Computer Science
7 16 (5.63%) Mobile App
8 13 (4.58%) Statistics
9 8 (2.82%) User Experience
10 6 (2.11%) Neural Network
11 5 (1.76%) Data Structures
11 5 (1.76%) Economics
11 5 (1.76%) iPad
12 4 (1.41%) Data Extraction
12 4 (1.41%) Hybrid Cloud
13 3 (1.06%) NHS
13 3 (1.06%) Replication
14 2 (0.70%) Clustering
14 2 (0.70%) Credit Risk
14 2 (0.70%) Fintech
Operating Systems
1 10 (3.52%) Windows
1 10 (3.52%) Windows Server
1 10 (3.52%) Windows Server 2012
2 7 (2.46%) Windows Server 2003
3 3 (1.06%) Windows Server 2008
Processes & Methodologies
1 246 (86.62%) Business Intelligence
2 94 (33.10%) ETL
3 70 (24.65%) Analytics
4 60 (21.13%) Agile Software Development
4 60 (21.13%) Kimball Methodology
5 42 (14.79%) Data Modelling
6 37 (13.03%) Data Analysis
7 30 (10.56%) Data Management
8 28 (9.86%) Dashboard Development
9 27 (9.51%) Data Analytics
10 24 (8.45%) Performance Tuning
10 24 (8.45%) Presales
11 19 (6.69%) Business Analysis
11 19 (6.69%) SDLC
12 18 (6.34%) E-Commerce
12 18 (6.34%) Information Management
12 18 (6.34%) Validation
13 17 (5.99%) Data Visualisation
14 15 (5.28%) Scrum
14 15 (5.28%) Test Scripting
Programming Languages
1 224 (78.87%) SQL
2 114 (40.14%) T-SQL
3 65 (22.89%) Data Analysis Expressions (DAX)
3 65 (22.89%) VBA
4 41 (14.44%) C#
5 14 (4.93%) R
6 9 (3.17%) VBScript
7 7 (2.46%) PowerShell
7 7 (2.46%) Python
8 6 (2.11%) JavaScript
9 2 (0.70%) COBOL
9 2 (0.70%) VB.NET
Qualifications
1 42 (14.79%) Degree
2 18 (6.34%) Microsoft Certification
3 15 (5.28%) MCSE
4 2 (0.70%) CCAB
5 1 (0.35%) ACCA
5 1 (0.35%) CIMA
5 1 (0.35%) ITIL Certification
5 1 (0.35%) MBA
5 1 (0.35%) MCP
5 1 (0.35%) PMI Certification
5 1 (0.35%) PMP
Quality Assurance & Compliance
1 32 (11.27%) Data Quality
2 12 (4.23%) Solvency II
3 11 (3.87%) QA
4 6 (2.11%) PCI DSS
5 4 (1.41%) Basel II
6 1 (0.35%) ISO/IEC 27001
6 1 (0.35%) SLA
System Software
1 10 (3.52%) Active Directory
2 7 (2.46%) VMware ESX
3 5 (1.76%) VMware Infrastructure
Vendors
1 196 (69.01%) Microsoft
2 50 (17.61%) Tableau
3 26 (9.15%) Cognos
4 16 (5.63%) IBM
5 13 (4.58%) Oracle
6 12 (4.23%) Hitachi
7 7 (2.46%) Dell
7 7 (2.46%) HP
7 7 (2.46%) SAP
7 7 (2.46%) VMware
8 6 (2.11%) Adobe
8 6 (2.11%) Google
9 5 (1.76%) ESRI
10 4 (1.41%) Ab Initio
11 3 (1.06%) Talend
11 3 (1.06%) Vertica
12 2 (0.70%) Sage
13 1 (0.35%) IDERA
13 1 (0.35%) Informatica
13 1 (0.35%) Nintex
City, London
Streamline Connections
Salary: £45000 - £55000 per annum + Benefits
Posted: 17 hours ago
City, London
Streamline Connections
Salary: £55000 - £70000 per annum + Benefits
Posted: 17 hours ago
Kent
Salt
Salary: £40000 - £50000 per annum + Great Benefits
Posted: 20 hours ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £45,000 per annum
Posted: 23 hours ago
Kent
Intech 7
Salary: From £55,000 to £55,000 per annum excellent benefits
Posted: 4 days ago
Durham, County Durham
Experis Ltd
Salary: £38000.00 - £45000.00 per annum
Posted: 4 days ago
Bristol, Avon
Novate IT Ltd
Salary: £50000.00 - £60000.00 per annum + benefits
Posted: 5 days ago
Lancashire
Capita plc
Posted: 13 days ago
Corby
Nigel Frank International Ltd
Salary: £45000 - £55000 per annum + Pension, Negotiable
Posted: 19 days ago
Southampton
Deerfoot IT Resources Ltd
Salary: £20000 - £50000 per annum + benefits
Posted: 19 days ago
London
Ampersand Consulting
Salary: £55000 - £65000 per annum
Posted: 20 days ago
Peterborough
Nigel Frank International Ltd
Salary: £40000 - £52000 per annum + Pension, Negotiable
Posted: 21 days ago
London
Bluetown Online LTD
Posted: 22 days ago