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

3 months to
20 Jan 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
UK / England
Rank 715 768 719
Rank change year-on-year
+53 -49
Permanent jobs citing PowerPivot 98 131 205
As % of all permanent IT jobs located in England 0.12% 0.14% 0.21%
As % of the Database & Business Intelligence category 0.41% 0.44% 0.67%
Number of salaries quoted 86 99 179
Median salary £52,500 £42,500 £45,000
Median salary % change year-on-year
+23.52% -5.55%
90% offered a salary of more than £30,000 £30,000 £32,500
10% offered a salary of more than £67,500 £75,000 £65,000
UK excluding London median salary £45,000 £41,500 £42,000
% change year-on-year
+8.43% -1.19%

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
23805 30086 30421
As % of all permanent IT jobs located in England 30.09% 32.23% 30.94%
Number of salaries quoted 20643 25769 26286
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 £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 20 January 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 20 January 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 +63 45 £55,000 +12.82% 4
South East +63 26 £50,000 +21.95% 3
Yorkshire +29 8 £40,000 +31.14%
East Midlands +11 7 £34,000 -35.23% 1
South West +14 5 £27,500 -14.06%
East of England +13 3 £55,000 -4.34%
West Midlands +4 2 £33,250 -21.76% 1
North West -36 2 £30,000 -25.00% 1
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

For the 6 months to 20 January 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 150 (85.23%) SQL
2 142 (80.68%) Business Intelligence
3 133 (75.57%) SQL Server Reporting Services
4 114 (64.77%) SQL Server Integration Services
5 113 (64.20%) SQL Server
6 106 (60.23%) SQL Server Analysis Services
7 102 (57.95%) Microsoft
8 101 (57.39%) Power BI
9 78 (44.32%) Data Warehouse
9 78 (44.32%) T-SQL
10 64 (36.36%) Analytics
11 54 (30.68%) MS Excel
12 51 (28.98%) ETL
13 50 (28.41%) Data Modelling
14 49 (27.84%) Agile Software Development
15 45 (25.57%) MySQL
16 41 (23.30%) Microsoft Power View
17 39 (22.16%) Finance
17 39 (22.16%) MDX
18 38 (21.59%) Tableau
19 35 (19.89%) Data Analysis Expressions (DAX)
20 34 (19.32%) Management Information System
21 32 (18.18%) BusinessObjects
21 32 (18.18%) Relational Database
22 31 (17.61%) Analytical Skills
22 31 (17.61%) Microsoft Analysis Services
22 31 (17.61%) Hadoop
23 30 (17.05%) SQL Server 2012
23 30 (17.05%) Big Data
24 27 (15.34%) 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 26 (14.77%) SharePoint
2 12 (6.82%) WebSphere
3 6 (3.41%) Apache Pig
3 6 (3.41%) OpenStack
4 4 (2.27%) SAS
5 2 (1.14%) Apache Spark
6 1 (0.57%) IIS
6 1 (0.57%) MS Exchange
6 1 (0.57%) SharePoint 2010
6 1 (0.57%) SharePoint 2013
6 1 (0.57%) SharePoint Server
Applications
1 54 (30.68%) MS Excel
2 12 (6.82%) MS Visio
3 7 (3.98%) MS Office
4 5 (2.84%) MS PowerPoint
5 4 (2.27%) SPSS
6 1 (0.57%) InfoPath
6 1 (0.57%) Spreadsheet
Business Applications
1 3 (1.70%) Dynamics CRM
2 1 (0.57%) Dynamics AX
2 1 (0.57%) OPENHousing
2 1 (0.57%) Oracle Financials
2 1 (0.57%) StreamServe
Cloud Services
1 15 (8.52%) GitHub
2 12 (6.82%) Microsoft Azure
3 11 (6.25%) Amazon AWS
4 8 (4.55%) PaaS
5 7 (3.98%) SaaS
6 4 (2.27%) Google Analytics
7 2 (1.14%) Office 365
8 1 (0.57%) Akamai
8 1 (0.57%) IaaS
Communications & Networking
1 4 (2.27%) MVNO
2 1 (0.57%) DHCP
2 1 (0.57%) LDAP
Database & Business Intelligence
1 133 (75.57%) SQL Server Reporting Services
2 114 (64.77%) SQL Server Integration Services
3 113 (64.20%) SQL Server
4 106 (60.23%) SQL Server Analysis Services
5 101 (57.39%) Power BI
6 78 (44.32%) Data Warehouse
7 45 (25.57%) MySQL
8 41 (23.30%) Microsoft Power View
9 32 (18.18%) BusinessObjects
9 32 (18.18%) Relational Database
10 31 (17.61%) Hadoop
10 31 (17.61%) Microsoft Analysis Services
11 30 (17.05%) Big Data
11 30 (17.05%) SQL Server 2012
12 20 (11.36%) QlikView
13 19 (10.80%) OLAP
14 18 (10.23%) Apache Hive
15 17 (9.66%) SQL Server 2014
16 15 (8.52%) Data Mining
16 15 (8.52%) NoSQL
Development Applications
1 18 (10.23%) JIRA
2 11 (6.25%) Visual Studio
3 7 (3.98%) Git (software)
4 6 (3.41%) Jenkins
4 6 (3.41%) Talend Open Studio
5 3 (1.70%) Team Foundation Server
6 1 (0.57%) SQL Server Management Studio (SSMS)
General
1 39 (22.16%) Finance
2 19 (10.80%) Legal
3 10 (5.68%) Law
4 7 (3.98%) Billing
5 5 (2.84%) Advertising
5 5 (2.84%) Marketing
6 4 (2.27%) Games
6 4 (2.27%) Retail
6 4 (2.27%) Telecoms
7 3 (1.70%) Banking
7 3 (1.70%) Manufacturing
8 2 (1.14%) Publishing
9 1 (0.57%) Financial Institution
9 1 (0.57%) Pharmaceutical
Job Titles
1 73 (41.48%) Developer
2 62 (35.23%) Analyst
3 35 (19.89%) Business Intelligence Developer
4 34 (19.32%) SQL Developer
5 25 (14.20%) Business Intelligence Analyst
6 14 (7.95%) Architect
6 14 (7.95%) Data Analyst
6 14 (7.95%) SQL Analyst
7 13 (7.39%) Report Analyst
7 13 (7.39%) Report Developer
7 13 (7.39%) SQL BI Developer
7 13 (7.39%) SQL Server Developer
8 12 (6.82%) Consultant
8 12 (6.82%) Solutions Architect
9 11 (6.25%) Senior Business Intelligence Developer
9 11 (6.25%) Senior Developer
9 11 (6.25%) SSRS Developer
10 10 (5.68%) Insight Analyst
10 10 (5.68%) Senior Analyst
11 9 (5.11%) Senior Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 39 (22.16%) MDX
2 25 (14.20%) .NET
3 11 (6.25%) .NET Framework
4 8 (4.55%) ASP.NET
5 4 (2.27%) XML
6 3 (1.70%) HTML
6 3 (1.70%) Web Services
7 2 (1.14%) CSS
8 1 (0.57%) Ajax
8 1 (0.57%) COM
8 1 (0.57%) D3.js
8 1 (0.57%) jQuery
8 1 (0.57%) JSON
8 1 (0.57%) KnockoutJS
8 1 (0.57%) Leaflet
8 1 (0.57%) REST
8 1 (0.57%) SOAP
8 1 (0.57%) XSL
Miscellaneous
1 34 (19.32%) Management Information System
2 31 (17.61%) Analytical Skills
3 17 (9.66%) Visualisation
4 8 (4.55%) Wiki
5 7 (3.98%) NHS
6 6 (3.41%) Algorithms
7 3 (1.70%) Driving Licence
7 3 (1.70%) Mathematics
7 3 (1.70%) Performance Metrics
8 2 (1.14%) Ergonomics
8 2 (1.14%) Life Science
9 1 (0.57%) Computer Science
9 1 (0.57%) Credit Risk
9 1 (0.57%) Data Extraction
9 1 (0.57%) Data Integration
9 1 (0.57%) Fintech
9 1 (0.57%) Statistics
9 1 (0.57%) User Experience
Operating Systems
1 11 (6.25%) Windows
1 11 (6.25%) Windows Server
1 11 (6.25%) Windows Server 2012
Processes & Methodologies
1 142 (80.68%) Business Intelligence
2 64 (36.36%) Analytics
3 51 (28.98%) ETL
4 50 (28.41%) Data Modelling
5 49 (27.84%) Agile Software Development
6 23 (13.07%) Data Analysis
6 23 (13.07%) Kimball Methodology
7 21 (11.93%) Scrum
8 15 (8.52%) Mentoring
8 15 (8.52%) Time Management
8 15 (8.52%) Translating Business Requirements
9 14 (7.95%) ETL Development
10 12 (6.82%) Performance Optimisation
10 12 (6.82%) TOGAF
10 12 (6.82%) Workflow
11 10 (5.68%) Coaching
11 10 (5.68%) Dashboard Development
11 10 (5.68%) Project Management
12 9 (5.11%) Business Analysis
12 9 (5.11%) Presales
Programming Languages
1 150 (85.23%) SQL
2 78 (44.32%) T-SQL
3 35 (19.89%) Data Analysis Expressions (DAX)
4 27 (15.34%) C#
5 21 (11.93%) VBA
6 18 (10.23%) Python
7 16 (9.09%) JavaScript
8 13 (7.39%) PowerShell
9 9 (5.11%) PL/SQL
10 6 (3.41%) Java
10 6 (3.41%) R
10 6 (3.41%) Ruby
11 3 (1.70%) VB
11 3 (1.70%) VBScript
12 2 (1.14%) VB.NET
13 1 (0.57%) C
13 1 (0.57%) C++
13 1 (0.57%) Pascal
Qualifications
1 16 (9.09%) Degree
2 8 (4.55%) DBS Check
3 1 (0.57%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 23 (13.07%) Data Quality
2 14 (7.95%) QA
3 8 (4.55%) ISO/IEC 27001
4 5 (2.84%) SLA
5 2 (1.14%) PCI DSS
System Software
1 2 (1.14%) Active Directory
2 1 (0.57%) Virtual Desktop
2 1 (0.57%) Virtual Machines
2 1 (0.57%) VMware Infrastructure
Systems Management
1 9 (5.11%) Puppet
2 1 (0.57%) CA Single Sign-On
Vendors
1 102 (57.95%) Microsoft
2 38 (21.59%) Tableau
3 24 (13.64%) Cognos
4 19 (10.80%) Oracle
5 17 (9.66%) SAP
6 13 (7.39%) IBM
7 12 (6.82%) Nintex
8 6 (3.41%) RedGate
8 6 (3.41%) Talend
9 5 (2.84%) Google
10 4 (2.27%) Teradata
11 3 (1.70%) NetSuite
12 2 (1.14%) VMware
13 1 (0.57%) Capita
13 1 (0.57%) Cloudera
13 1 (0.57%) F5
13 1 (0.57%) JD Edwards
13 1 (0.57%) MicroStrategy
13 1 (0.57%) Salesforce.com
13 1 (0.57%) Sony
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 1 hour ago
South East
Austin Fraser
Salary: £40000 - £50000 per annum + Benefits
Posted: 2 days ago
City, London
Comtecs
Salary: £65000 - £70000 Per Annum + Bonus + Excellent Benefits
Posted: 3 days ago
London
Arrows Group Ltd
Salary: £45000 per annum + benefits
Posted: 2 days ago
Newhaven, East Sussex
Bluetownonline
Salary: £24000 - £32000 per annum
Posted: 3 days ago
Newbury
Spectrum IT
Salary: £25000 - £30000 per annum + Benefits
Posted: 14 days ago
London
Networkers
Salary: £65000 - £70000 per annum + Excellent benefits
Posted: 6 days ago
South West London
Bluetown Online LTD
Salary: £24000 - £32000 per annum
Posted: 15 days ago
Telford
Bluetown Online LTD
Salary: £24000 - £32000 per annum
Posted: 15 days ago