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

3 months to
24 Jul 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 793 745 838
Rank change year-on-year
-48 +93
Permanent jobs citing PowerPivot 103 201 122
As % of all permanent IT jobs located in England 0.11% 0.20% 0.11%
As % of the Database & Business Intelligence category 0.38% 0.61% 0.35%
Number of salaries quoted 89 167 109
Median salary £52,500 £50,000 £50,000
Median salary % change year-on-year
+5.00% -
90% offered a salary of more than £32,200 £36,000 £29,000
10% offered a salary of more than £65,000 £70,000 £80,000
UK excluding London median salary £45,000 £50,000 £35,000
% change year-on-year
-10.00% +42.85%
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
27247 32903 34720
As % of all permanent IT jobs located in England 29.68% 31.97% 32.22%
Number of salaries quoted 23518 27985 29919
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,000 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 24 July 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 24 July 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 +21 46 £60,000 +4.34% 7
South East -25 17 £52,500 +5.00% 1
Yorkshire +21 12 £40,000 -20.00% 3
North West +15 11 £30,000 -20.00% 3
West Midlands -2 6 £43,750 - 1
East of England +37 5 £53,000 +11.57%
South West +21 4 £55,000 +77.41% 1
North East - 2 £41,250 - 1
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

For the 6 months to 24 July 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 217 (84.77%) Business Intelligence
2 211 (82.42%) SQL
3 192 (75.00%) Microsoft
4 187 (73.05%) SQL Server
5 183 (71.48%) SQL Server Reporting Services
6 162 (63.28%) SQL Server Analysis Services
7 147 (57.42%) SQL Server Integration Services
8 139 (54.30%) MS Excel
9 121 (47.27%) Data Warehouse
10 116 (45.31%) T-SQL
10 116 (45.31%) Power BI
11 106 (41.41%) ETL
12 96 (37.50%) Finance
13 92 (35.94%) MDX
14 81 (31.64%) Microsoft Power View
15 73 (28.52%) Data Analysis Expressions (DAX)
16 63 (24.61%) SharePoint
17 59 (23.05%) SQL Server 2012
18 57 (22.27%) Agile Software Development
19 55 (21.48%) VBA
20 54 (21.09%) OLAP
20 54 (21.09%) Kimball Methodology
21 53 (20.70%) Tableau
21 53 (20.70%) Management Information System
22 48 (18.75%) SQL Server 2008
22 48 (18.75%) Analytical Skills
23 47 (18.36%) Analytics
24 46 (17.97%) Data Quality
25 44 (17.19%) Data Management
26 41 (16.02%) 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 63 (24.61%) SharePoint
2 13 (5.08%) SAS
3 3 (1.17%) IIS
4 2 (0.78%) NServiceBus
4 2 (0.78%) WebSphere
5 1 (0.39%) Apache
5 1 (0.39%) Tomcat
Applications
1 139 (54.30%) MS Excel
2 8 (3.13%) MS Office
3 7 (2.73%) MS PowerPoint
4 5 (1.95%) SPSS
5 4 (1.56%) Spreadsheet
6 3 (1.17%) MS Visio
Business Applications
1 10 (3.91%) Dynamics CRM
2 5 (1.95%) Oracle Financials
3 4 (1.56%) SAP Business One
4 2 (0.78%) Tesseract
5 1 (0.39%) Cognos TM1
5 1 (0.39%) Dynamics AX
Cloud Services
1 29 (11.33%) Microsoft Azure
2 6 (2.34%) Google Analytics
3 5 (1.95%) Adobe Analytics
4 4 (1.56%) SaaS
5 2 (0.78%) PaaS
6 1 (0.39%) AdWords
6 1 (0.39%) Amazon AWS
6 1 (0.39%) Azure Machine Learning
6 1 (0.39%) Office 365
Communications & Networking
1 3 (1.17%) DHCP
1 3 (1.17%) DNS
Database & Business Intelligence
1 187 (73.05%) SQL Server
2 183 (71.48%) SQL Server Reporting Services
3 162 (63.28%) SQL Server Analysis Services
4 147 (57.42%) SQL Server Integration Services
5 121 (47.27%) Data Warehouse
6 116 (45.31%) Power BI
7 81 (31.64%) Microsoft Power View
8 59 (23.05%) SQL Server 2012
9 54 (21.09%) OLAP
10 48 (18.75%) SQL Server 2008
11 41 (16.02%) SQL Server 2014
12 39 (15.23%) Relational Database
13 29 (11.33%) SQL Server 2005
14 24 (9.38%) SQL Server 2016
15 21 (8.20%) MS Access
16 20 (7.81%) Microsoft Analysis Services
16 20 (7.81%) RDBMS
17 18 (7.03%) Big Data
17 18 (7.03%) PerformancePoint
18 17 (6.64%) Pentaho
Development Applications
1 14 (5.47%) Team Foundation Server
2 7 (2.73%) SQL Server Management Studio (SSMS)
2 7 (2.73%) Visual Studio
3 3 (1.17%) JIRA
3 3 (1.17%) Visual Studio Tools for Office
4 1 (0.39%) Git (software)
4 1 (0.39%) Subversion
4 1 (0.39%) Toad
General
1 96 (37.50%) Finance
2 22 (8.59%) Legal
3 21 (8.20%) Marketing
4 18 (7.03%) Billing
5 15 (5.86%) Advertising
6 11 (4.30%) Banking
7 9 (3.52%) Telecoms
8 6 (2.34%) Private Banking
9 5 (1.95%) Retail
10 4 (1.56%) Manufacturing
11 2 (0.78%) Arabic Language
11 2 (0.78%) Financial Institution
11 2 (0.78%) French Language
11 2 (0.78%) German Language
11 2 (0.78%) Hindi Language
11 2 (0.78%) Investment Banking
11 2 (0.78%) Russian Language
11 2 (0.78%) Spanish Language
Job Titles
1 122 (47.66%) Developer
2 100 (39.06%) Business Intelligence Developer
3 90 (35.16%) Analyst
4 51 (19.92%) SQL Developer
5 42 (16.41%) Business Intelligence Analyst
6 34 (13.28%) SSIS Developer
7 33 (12.89%) SQL BI Developer
8 31 (12.11%) Report Analyst
8 31 (12.11%) SQL Analyst
9 25 (9.77%) Microsoft BI Developer
9 25 (9.77%) SSRS Analyst
10 23 (8.98%) Microsoft Developer
11 22 (8.59%) SQL Server Developer
12 21 (8.20%) SSAS Developer
13 18 (7.03%) SSRS Developer
14 17 (6.64%) Senior Business Intelligence Developer
14 17 (6.64%) Senior Developer
15 16 (6.25%) Business Developer
15 16 (6.25%) Data Analyst
15 16 (6.25%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 92 (35.94%) MDX
2 23 (8.98%) HTML
3 19 (7.42%) XML
4 18 (7.03%) CSS
5 14 (5.47%) .NET
6 10 (3.91%) Web Services
7 4 (1.56%) HTML5
7 4 (1.56%) JSON
8 3 (1.17%) Ajax
8 3 (1.17%) ASP.NET
8 3 (1.17%) jQuery
9 2 (0.78%) RabbitMQ
9 2 (0.78%) REST
9 2 (0.78%) SOAP
10 1 (0.39%) Google Maps API
10 1 (0.39%) Middleware
Miscellaneous
1 53 (20.70%) Management Information System
2 48 (18.75%) Analytical Skills
3 41 (16.02%) Visualisation
4 24 (9.38%) Mathematics
5 16 (6.25%) Data Integration
6 14 (5.47%) Computer Science
7 12 (4.69%) Mobile App
8 11 (4.30%) Statistics
9 10 (3.91%) Replication
10 9 (3.52%) User Experience
11 5 (1.95%) Data Extraction
11 5 (1.95%) iPad
12 4 (1.56%) Digital Media
13 3 (1.17%) Enterprise Software
14 2 (0.78%) Data Structures
14 2 (0.78%) Economics
14 2 (0.78%) Fintech
14 2 (0.78%) Freedom of Information
14 2 (0.78%) NHS
15 1 (0.39%) Data Conversion
Operating Systems
1 3 (1.17%) Windows
1 3 (1.17%) Windows Server
1 3 (1.17%) Windows Server 2008
1 3 (1.17%) Windows Server 2012
Processes & Methodologies
1 217 (84.77%) Business Intelligence
2 106 (41.41%) ETL
3 57 (22.27%) Agile Software Development
4 54 (21.09%) Kimball Methodology
5 47 (18.36%) Analytics
6 44 (17.19%) Data Management
7 41 (16.02%) Data Analysis
8 38 (14.84%) Data Modelling
9 28 (10.94%) Data Cleansing
10 27 (10.55%) Data Analytics
11 24 (9.38%) Dashboard Development
12 19 (7.42%) Data Visualisation
12 19 (7.42%) SDLC
13 18 (7.03%) Dimensional Modelling
13 18 (7.03%) Reverse Engineering
14 17 (6.64%) E-Commerce
14 17 (6.64%) Presales
14 17 (6.64%) Validation
15 16 (6.25%) CRM
15 16 (6.25%) Performance Tuning
Programming Languages
1 211 (82.42%) SQL
2 116 (45.31%) T-SQL
3 73 (28.52%) Data Analysis Expressions (DAX)
4 55 (21.48%) VBA
5 30 (11.72%) C#
6 4 (1.56%) JavaScript
6 4 (1.56%) R
6 4 (1.56%) VBScript
7 3 (1.17%) VB.NET
8 2 (0.78%) Java
8 2 (0.78%) PL/SQL
9 1 (0.39%) Python
Qualifications
1 36 (14.06%) Degree
2 3 (1.17%) MCSE
2 3 (1.17%) Microsoft Certification
3 2 (0.78%) ACCA
3 2 (0.78%) CIMA
4 1 (0.39%) MBA
4 1 (0.39%) PMI Certification
4 1 (0.39%) PMP
4 1 (0.39%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 46 (17.97%) Data Quality
2 15 (5.86%) PCI DSS
3 12 (4.69%) Solvency II
4 8 (3.13%) QA
5 4 (1.56%) Basel II
6 3 (1.17%) SLA
7 2 (0.78%) ISO/IEC 27001
System Software
1 3 (1.17%) Active Directory
Systems Management
1 1 (0.39%) Jitterbit
Vendors
1 192 (75.00%) Microsoft
2 53 (20.70%) Tableau
3 17 (6.64%) Oracle
4 16 (6.25%) Cognos
5 10 (3.91%) IBM
6 9 (3.52%) SAP
7 7 (2.73%) Google
8 5 (1.95%) Adobe
9 4 (1.56%) Ab Initio
9 4 (1.56%) Hitachi
9 4 (1.56%) Salesforce.com
10 2 (0.78%) Nintex
11 1 (0.39%) Alteryx
11 1 (0.39%) IDERA
11 1 (0.39%) JD Edwards
11 1 (0.39%) MicroStrategy
11 1 (0.39%) MuleSoft
11 1 (0.39%) RedGate
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 2 days ago
Leeds, West Yorkshire
The Bridge Ltd
Salary: From £30,000 to £45,000 per annum
Posted: 5 days ago
London
Nigel Frank International Ltd
Salary: £35000 - £45000 per annum + Company Bonus + Benefits
Posted: 4 days ago
Newcastle Upon Tyne, Tyne and Wear
HAYS INFORMATION TECHNOLOGY
Salary: £40000.00 - £46000.00 per annum
Posted: 3 days ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £35,000 per annum
Posted: 5 days ago
South East
Lawrence Harvey Enterprise
Salary: £62000.00 - £70000.00 per annum + flexible
Posted: 5 days ago
City, London
Next Ventures Ltd
Salary: From £60,000 to £70,000 per annum
Posted: 2 days ago
London
Next Ventures Limited
Salary: £60,000 - £75,000 per year
Posted: 3 days ago
Central London / West End
Venturi
Salary: £55000 - £60000 per annum + Bonus and Benefits
Posted: 4 days ago
Manchester, Lancashire
HAYS INFORMATION TECHNOLOGY
Salary: £20000.00 - £23000.00 per annum + Benefits
Posted: 4 days ago
York
Computer Futures
Salary: competitive
Posted: 10 days ago
Manchester
Arrow Global
Salary: Competitive
Posted: 13 days ago
City of London
Hays London City Cheapside
Salary: £40000.00 - £55000.00 per annum
Posted: 25 days ago
Malmesbury, Wiltshire
Dyson
Posted: 16 days ago
London
Bluetown Online LTD
Salary: £28000 - £35000 per annum
Posted: 26 days ago