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

3 months to
30 Aug 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 815 713 820
Rank change year-on-year
-102 +107
Permanent jobs citing PowerPivot 81 218 140
As % of all permanent IT jobs located in England 0.088% 0.22% 0.13%
As % of the Database & Business Intelligence category 0.30% 0.70% 0.41%
Number of salaries quoted 78 188 123
Median salary £50,000 £45,000 £50,000
Median salary % change year-on-year
+11.11% -10.00%
90% offered a salary of more than £37,500 £30,459 £30,000
10% offered a salary of more than £66,050 £62,500 £80,000
UK excluding London median salary £43,500 £42,500 £32,500
% change year-on-year
+2.35% +30.76%
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
27130 31310 34116
As % of all permanent IT jobs located in England 29.60% 31.16% 31.86%
Number of salaries quoted 23443 26645 29008
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 £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 30 August 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 30 August 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 38 £60,000 +9.09% 3
South East -33 16 £47,500 +5.55% 2
Yorkshire +24 12 £37,500 -25.00% 3
North West -19 5 £30,000 -16.70% 2
West Midlands -12 4 £47,500 +55.94%
South West +2 2 £40,000 +25.00%
North East - 2 £48,000 -
East of England +25 1 £55,000 +8.91% 1
East Midlands +6 1 £50,000 -1.96% 1
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

For the 6 months to 30 August 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 196 (86.73%) SQL
2 187 (82.74%) Business Intelligence
3 171 (75.66%) Microsoft
4 165 (73.01%) SQL Server Reporting Services
5 159 (70.35%) SQL Server
6 142 (62.83%) SQL Server Analysis Services
7 136 (60.18%) SQL Server Integration Services
8 123 (54.42%) MS Excel
9 117 (51.77%) Power BI
10 105 (46.46%) T-SQL
11 96 (42.48%) Data Warehouse
12 87 (38.50%) ETL
13 83 (36.73%) Finance
14 80 (35.40%) MDX
15 65 (28.76%) Data Analysis Expressions (DAX)
16 53 (23.45%) Microsoft Power View
17 51 (22.57%) Tableau
17 51 (22.57%) Agile Software Development
18 50 (22.12%) SharePoint
19 49 (21.68%) SQL Server 2012
19 49 (21.68%) Kimball Methodology
20 45 (19.91%) VBA
21 44 (19.47%) Visualisation
22 42 (18.58%) OLAP
22 42 (18.58%) Management Information System
23 41 (18.14%) SQL Server 2014
24 38 (16.81%) Data Quality
24 38 (16.81%) Analytics
25 37 (16.37%) Data Analysis
26 36 (15.93%) Analytical Skills

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 50 (22.12%) SharePoint
2 8 (3.54%) SAS
3 4 (1.77%) WebSphere
4 1 (0.44%) Apache
4 1 (0.44%) MS Exchange
4 1 (0.44%) Tomcat
Applications
1 123 (54.42%) MS Excel
2 6 (2.65%) MS PowerPoint
3 4 (1.77%) MS Visio
4 3 (1.33%) MS Office
4 3 (1.33%) Spreadsheet
5 2 (0.88%) SPSS
Business Applications
1 8 (3.54%) Dynamics CRM
2 5 (2.21%) Oracle Financials
3 3 (1.33%) SAP Business One
4 1 (0.44%) Cognos TM1
4 1 (0.44%) Dynamics AX
4 1 (0.44%) Tesseract
Cloud Services
1 29 (12.83%) Microsoft Azure
2 6 (2.65%) SaaS
3 4 (1.77%) PaaS
4 3 (1.33%) Google Analytics
5 2 (0.88%) Adobe Analytics
5 2 (0.88%) Office 365
6 1 (0.44%) AdWords
6 1 (0.44%) Amazon AWS
6 1 (0.44%) Azure Machine Learning
Communications & Networking
1 1 (0.44%) DHCP
Database & Business Intelligence
1 165 (73.01%) SQL Server Reporting Services
2 159 (70.35%) SQL Server
3 142 (62.83%) SQL Server Analysis Services
4 136 (60.18%) SQL Server Integration Services
5 117 (51.77%) Power BI
6 96 (42.48%) Data Warehouse
7 53 (23.45%) Microsoft Power View
8 49 (21.68%) SQL Server 2012
9 42 (18.58%) OLAP
10 41 (18.14%) SQL Server 2014
11 32 (14.16%) Relational Database
11 32 (14.16%) SQL Server 2008
12 23 (10.18%) Microsoft Analysis Services
12 23 (10.18%) MS Access
12 23 (10.18%) SQL Server 2016
13 21 (9.29%) Big Data
14 19 (8.41%) SQL Server 2005
15 17 (7.52%) Hadoop
16 15 (6.64%) Pentaho
16 15 (6.64%) PerformancePoint
Development Applications
1 12 (5.31%) Team Foundation Server
2 9 (3.98%) Visual Studio
3 6 (2.65%) SQL Server Management Studio (SSMS)
4 2 (0.88%) JIRA
4 2 (0.88%) Visual Studio Tools for Office
5 1 (0.44%) Toad
General
1 83 (36.73%) Finance
2 25 (11.06%) Legal
3 18 (7.96%) Billing
3 18 (7.96%) Marketing
4 17 (7.52%) Advertising
5 8 (3.54%) Banking
5 8 (3.54%) Telecoms
6 5 (2.21%) Private Banking
7 2 (0.88%) Arabic Language
7 2 (0.88%) French Language
7 2 (0.88%) German Language
7 2 (0.88%) Hindi Language
7 2 (0.88%) Law
7 2 (0.88%) Retail
7 2 (0.88%) Russian Language
7 2 (0.88%) Spanish Language
8 1 (0.44%) Financial Institution
8 1 (0.44%) Investment Banking
Job Titles
1 101 (44.69%) Developer
2 81 (35.84%) Business Intelligence Developer
3 76 (33.63%) Analyst
4 41 (18.14%) SQL Developer
5 40 (17.70%) Business Intelligence Analyst
6 30 (13.27%) SSIS Developer
7 28 (12.39%) SQL Analyst
8 23 (10.18%) Report Analyst
8 23 (10.18%) SQL BI Developer
9 21 (9.29%) Microsoft BI Developer
10 19 (8.41%) Microsoft Developer
10 19 (8.41%) SSRS Analyst
11 18 (7.96%) SSAS Developer
12 17 (7.52%) SQL Server Developer
13 15 (6.64%) Business Intelligence Lead
13 15 (6.64%) Data Analyst
13 15 (6.64%) Senior Business Intelligence Developer
13 15 (6.64%) Senior Developer
13 15 (6.64%) SSRS Developer
14 13 (5.75%) Consultant
Libraries, Frameworks & Software Standards
1 80 (35.40%) MDX
2 15 (6.64%) HTML
2 15 (6.64%) XML
3 12 (5.31%) .NET
4 10 (4.42%) CSS
4 10 (4.42%) Web Services
5 5 (2.21%) JSON
6 4 (1.77%) HTML5
7 3 (1.33%) REST
7 3 (1.33%) SOAP
8 2 (0.88%) ASP.NET
9 1 (0.44%) COM
9 1 (0.44%) D3.js
9 1 (0.44%) Google Maps API
9 1 (0.44%) Leaflet
9 1 (0.44%) Middleware
Miscellaneous
1 44 (19.47%) Visualisation
2 42 (18.58%) Management Information System
3 36 (15.93%) Analytical Skills
4 18 (7.96%) Mathematics
5 15 (6.64%) Data Integration
6 10 (4.42%) Computer Science
6 10 (4.42%) Replication
7 7 (3.10%) Mobile App
7 7 (3.10%) Statistics
8 6 (2.65%) User Experience
9 5 (2.21%) Data Extraction
10 4 (1.77%) Digital Media
11 3 (1.33%) Enterprise Software
12 2 (0.88%) Economics
12 2 (0.88%) Ergonomics
12 2 (0.88%) Fintech
12 2 (0.88%) Freedom of Information
12 2 (0.88%) iPad
13 1 (0.44%) Data Conversion
13 1 (0.44%) Data Protection Act
Processes & Methodologies
1 187 (82.74%) Business Intelligence
2 87 (38.50%) ETL
3 51 (22.57%) Agile Software Development
4 49 (21.68%) Kimball Methodology
5 38 (16.81%) Analytics
6 37 (16.37%) Data Analysis
7 34 (15.04%) Data Management
8 33 (14.60%) Data Modelling
9 30 (13.27%) Data Cleansing
10 19 (8.41%) Dashboard Development
10 19 (8.41%) Data Analytics
11 17 (7.52%) CRM
11 17 (7.52%) Data Visualisation
11 17 (7.52%) Dimensional Modelling
12 16 (7.08%) Reverse Engineering
13 15 (6.64%) E-Commerce
13 15 (6.64%) Scrum
14 14 (6.19%) Presales
14 14 (6.19%) SDLC
15 11 (4.87%) Translating Business Requirements
Programming Languages
1 196 (86.73%) SQL
2 105 (46.46%) T-SQL
3 65 (28.76%) Data Analysis Expressions (DAX)
4 45 (19.91%) VBA
5 27 (11.95%) C#
6 5 (2.21%) VB.NET
7 4 (1.77%) VBScript
8 3 (1.33%) R
9 2 (0.88%) Java
9 2 (0.88%) JavaScript
9 2 (0.88%) PL/SQL
9 2 (0.88%) VB
10 1 (0.44%) Python
10 1 (0.44%) Ruby
Qualifications
1 27 (11.95%) Degree
2 5 (2.21%) DBS Check
3 2 (0.88%) MCSE
3 2 (0.88%) Microsoft Certification
4 1 (0.44%) ACCA
4 1 (0.44%) CIMA
4 1 (0.44%) MBA
4 1 (0.44%) PMI Certification
4 1 (0.44%) PMP
4 1 (0.44%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 38 (16.81%) Data Quality
2 13 (5.75%) PCI DSS
3 9 (3.98%) Solvency II
4 7 (3.10%) QA
5 6 (2.65%) SLA
6 4 (1.77%) ISO/IEC 27001
7 1 (0.44%) Basel II
System Software
1 2 (0.88%) Active Directory
2 1 (0.44%) Virtual Desktop
2 1 (0.44%) Virtual Machines
2 1 (0.44%) VMware Infrastructure
Systems Management
1 1 (0.44%) Jitterbit
Vendors
1 171 (75.66%) Microsoft
2 51 (22.57%) Tableau
3 14 (6.19%) Oracle
4 13 (5.75%) SAP
5 9 (3.98%) Cognos
6 7 (3.10%) IBM
7 5 (2.21%) Salesforce.com
8 4 (1.77%) Ab Initio
8 4 (1.77%) Google
8 4 (1.77%) Nintex
9 3 (1.33%) NetSuite
10 2 (0.88%) Adobe
10 2 (0.88%) VMware
11 1 (0.44%) Alteryx
11 1 (0.44%) Hitachi
11 1 (0.44%) JD Edwards
11 1 (0.44%) MicroStrategy
11 1 (0.44%) MuleSoft
11 1 (0.44%) RedGate
11 1 (0.44%) Sony
Leeds, West Yorkshire
The Bridge Ltd
Salary: From £30,000 to £45,000 per annum
Posted: 7 hours ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £35,000 per annum
Posted: 1 hour ago
Leicester
Nigel Frank International Ltd
Salary: £40000 - £50000 per annum + Company bonus + Benefits
Posted: 4 days ago
West Sussex
Nigel Frank International Ltd
Salary: £40000 - £60000 per annum + Pension, Negotiable
Posted: 4 days ago
Suffolk
Vantage Recruitment Solutions Ltd
Salary: From £50,000 to £60,000 per annum + Benefits
Posted: 4 days ago
City of London
Streamline Connections Ltd
Salary: £55000 - £60000.00 per annum + Benefits
Posted: 6 days ago
Manchester
Venturi
Salary: £60000 - £65000 per annum + benefits
Posted: 8 days ago
London
Next Ventures Limited
Salary: £55,000 - £70,000 per year
Posted: 8 days ago