The following table provides summary statistics for permanent job vacancies with a requirement for PowerPivot skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited PowerPivot over the 3 months to 24 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
UK
Rank 802 792 795
Rank change year-on-year -10 +3  
Permanent jobs citing PowerPivot 55 156 165
As % of all permanent IT jobs advertised in the UK 0.065% 0.15% 0.16%
As % of the Database & Business Intelligence category 0.21% 0.49% 0.50%
Number of salaries quoted 50 124 156
Median salary £49,500 £50,000 £45,000
Median salary % change year-on-year -1.00% +11.11%  
90% offered a salary of more than £28,500 £30,000 £35,000
10% offered a salary of more than £73,500 £72,500 £65,000
UK excluding London median salary £37,500 £45,000 £42,500
% change year-on-year -16.66% +5.88%  

PowerPivot is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 26033 31905 33071
As % of all permanent IT job vacancies advertised in the UK 30.64% 30.99% 31.30%
Number of salaries quoted 22070 27162 28001
Median salary £47,500 £50,000 £45,000
Median salary % change year-on-year -5.00% +11.11%  
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

PowerPivot
Job Vacancy Trend

The job posting trend of jobs advertised citing PowerPivot as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for PowerPivot in the UK

PowerPivot
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing PowerPivot.

Salary trend for PowerPivot in the UK

PowerPivot
Salary Histogram

The salary distribution of IT jobs citing PowerPivot over the 3 months to 24 March 2017.

Salary histogram for PowerPivot in the UK

PowerPivot
Top 25 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the UK over the 3 months to 24 March 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
England +17 52 £50,000 - 7
London +7 28 £60,000 +9.09% 2
South East +48 12 £45,000 -1.09% 3
City of London +40 6 £67,500 +54.28% 1
Berkshire +39 5 £27,500 -63.33% 1
Manchester -17 4 £33,750 -53.44%
North West -23 4 £33,750 +11.64%
South West - 4 £28,000 -
Somerset - 4 £28,000 -
Bath - 4 £28,000 -
Slough +24 2 - -
Sevenoaks - 2 £33,750 - 1
Wigan - 2 £29,250 -
Newbury - 2 £27,500 - 1
Kent - 2 £33,750 - 1
East of England +23 1 £40,000 -5.20%
Northamptonshire +21 1 £47,500 -5.00% 1
Yorkshire +17 1 £37,500 -21.05%
West Yorkshire +14 1 £37,500 -21.05%
Leeds +6 1 £37,500 -21.05%
East Midlands +1 1 £47,500 +18.75% 1
Reading - 1 £50,000 -
Glasgow - 1 - -
Scotland - 1 - -
Hertfordshire - 1 £40,000 -

PowerPivot
Top 30 Related IT Skills

For the 6 months to 24 March 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 with a requirement for PowerPivot.

1 131 (83.97%) Business Intelligence
2 125 (80.13%) SQL
3 120 (76.92%) SQL Server Reporting Services
4 106 (67.95%) SQL Server Integration Services
5 102 (65.38%) Power BI
6 101 (64.74%) SQL Server
7 94 (60.26%) SQL Server Analysis Services
8 83 (53.21%) Microsoft
9 74 (47.44%) Data Warehouse
10 72 (46.15%) T-SQL
11 64 (41.03%) Analytics
12 53 (33.97%) MS Excel
13 50 (32.05%) ETL
14 47 (30.13%) Data Modelling
15 43 (27.56%) Microsoft Power View
16 41 (26.28%) Agile Software Development
17 33 (21.15%) MySQL
18 32 (20.51%) Hadoop
19 30 (19.23%) Finance
19 30 (19.23%) Data Analysis Expressions (DAX)
20 29 (18.59%) Relational Database
20 29 (18.59%) Analytical Skills
21 28 (17.95%) Management Information System
22 27 (17.31%) Big Data
22 27 (17.31%) SQL Server 2012
23 26 (16.67%) Tableau
24 25 (16.03%) Microsoft Analysis Services
24 25 (16.03%) .NET
24 25 (16.03%) BusinessObjects
24 25 (16.03%) SharePoint

PowerPivot
Top Related IT Skills 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 25 (16.03%) SharePoint
2 10 (6.41%) WebSphere
3 9 (5.77%) Apache Pig
4 8 (5.13%) OpenStack
5 3 (1.92%) Apache Spark
5 3 (1.92%) SAS
6 2 (1.28%) SharePoint 2013
7 1 (0.64%) IIS
7 1 (0.64%) SharePoint 2010
7 1 (0.64%) SharePoint Server
Applications
1 53 (33.97%) MS Excel
2 10 (6.41%) MS Visio
3 8 (5.13%) MS Office
4 6 (3.85%) SPSS
5 2 (1.28%) MS PowerPoint
5 2 (1.28%) Spreadsheet
6 1 (0.64%) InfoPath
6 1 (0.64%) Photoshop
Business Applications
1 3 (1.92%) Dynamics AX
2 2 (1.28%) Dynamics NAV
3 1 (0.64%) Dynamics CRM
3 1 (0.64%) OPENHousing
3 1 (0.64%) Oracle Financials
3 1 (0.64%) StreamServe
Cloud Services
1 17 (10.90%) GitHub
2 11 (7.05%) Amazon AWS
3 8 (5.13%) Microsoft Azure
4 6 (3.85%) PaaS
5 5 (3.21%) SaaS
6 3 (1.92%) Google Analytics
7 1 (0.64%) Akamai
7 1 (0.64%) IaaS
7 1 (0.64%) Office 365
Communications & Networking
1 4 (2.56%) MVNO
2 2 (1.28%) LAN
2 2 (1.28%) WAN
3 1 (0.64%) LDAP
Database & Business Intelligence
1 120 (76.92%) SQL Server Reporting Services
2 106 (67.95%) SQL Server Integration Services
3 102 (65.38%) Power BI
4 101 (64.74%) SQL Server
5 94 (60.26%) SQL Server Analysis Services
6 74 (47.44%) Data Warehouse
7 43 (27.56%) Microsoft Power View
8 33 (21.15%) MySQL
9 32 (20.51%) Hadoop
10 29 (18.59%) Relational Database
11 27 (17.31%) Big Data
11 27 (17.31%) SQL Server 2012
12 25 (16.03%) BusinessObjects
12 25 (16.03%) Microsoft Analysis Services
13 22 (14.10%) Apache Hive
13 22 (14.10%) QlikView
14 15 (9.62%) OLAP
15 14 (8.97%) NoSQL
16 13 (8.33%) SQL Server 2014
17 12 (7.69%) Data Mart
Development Applications
1 18 (11.54%) JIRA
2 9 (5.77%) Git (software)
3 8 (5.13%) Jenkins
4 7 (4.49%) Visual Studio
5 5 (3.21%) Talend Open Studio
6 3 (1.92%) Team Foundation Server
7 1 (0.64%) MSTest
7 1 (0.64%) SpecFlow
7 1 (0.64%) SQL Server Management Studio (SSMS)
General
1 30 (19.23%) Finance
2 10 (6.41%) Legal
3 8 (5.13%) Law
4 6 (3.85%) Games
4 6 (3.85%) Marketing
4 6 (3.85%) Retail
5 4 (2.56%) Telecoms
6 3 (1.92%) Banking
6 3 (1.92%) Manufacturing
6 3 (1.92%) Pharmaceutical
6 3 (1.92%) Publishing
7 2 (1.28%) Advertising
8 1 (0.64%) Billing
8 1 (0.64%) Financial Institution
Job Titles
1 65 (41.67%) Developer
2 62 (39.74%) Analyst
3 28 (17.95%) Business Intelligence Developer
3 28 (17.95%) SQL Developer
4 25 (16.03%) Business Intelligence Analyst
5 16 (10.26%) Architect
6 14 (8.97%) Report Developer
6 14 (8.97%) SQL Server Developer
7 13 (8.33%) Insight Analyst
7 13 (8.33%) Senior Analyst
8 12 (7.69%) Report Analyst
9 11 (7.05%) Senior Business Intelligence Analyst
9 11 (7.05%) SQL BI Developer
10 10 (6.41%) Data Analyst
10 10 (6.41%) Solutions Architect
10 10 (6.41%) SSRS Developer
11 9 (5.77%) NoSQL Developer
12 8 (5.13%) Consultant
12 8 (5.13%) SQL Analyst
12 8 (5.13%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 25 (16.03%) .NET
2 23 (14.74%) MDX
3 11 (7.05%) .NET Framework
4 8 (5.13%) ASP.NET
5 6 (3.85%) XML
6 5 (3.21%) HTML
6 5 (3.21%) Kafka
7 4 (2.56%) CSS
8 3 (1.92%) Ajax
8 3 (1.92%) jQuery
9 2 (1.28%) EDI
9 2 (1.28%) Web Services
10 1 (0.64%) KnockoutJS
10 1 (0.64%) LLBLGen Pro
10 1 (0.64%) WCF
10 1 (0.64%) XSL
10 1 (0.64%) XSLT
Miscellaneous
1 29 (18.59%) Analytical Skills
2 28 (17.95%) Management Information System
3 9 (5.77%) NHS
4 8 (5.13%) Wiki
5 3 (1.92%) Driving Licence
5 3 (1.92%) User Experience
6 2 (1.28%) Algorithms
6 2 (1.28%) Fintech
6 2 (1.28%) Life Science
7 1 (0.64%) Blog
7 1 (0.64%) Computer Science
7 1 (0.64%) Credit Risk
7 1 (0.64%) W3C
Operating Systems
1 11 (7.05%) Windows
1 11 (7.05%) Windows Server
1 11 (7.05%) Windows Server 2012
2 4 (2.56%) Unix
Processes & Methodologies
1 131 (83.97%) Business Intelligence
2 64 (41.03%) Analytics
3 50 (32.05%) ETL
4 47 (30.13%) Data Modelling
5 41 (26.28%) Agile Software Development
6 22 (14.10%) Scrum
7 16 (10.26%) Mentoring
8 15 (9.62%) Time Management
9 14 (8.97%) Data Analysis
10 13 (8.33%) Customer Requirements
10 13 (8.33%) ETL Development
10 13 (8.33%) Use Case
11 11 (7.05%) Dashboard Development
11 11 (7.05%) Kimball Methodology
11 11 (7.05%) Performance Optimisation
11 11 (7.05%) Workflow
12 10 (6.41%) Coaching
12 10 (6.41%) TOGAF
12 10 (6.41%) Translating Business Requirements
12 10 (6.41%) Visualisation
Programming Languages
1 125 (80.13%) SQL
2 72 (46.15%) T-SQL
3 30 (19.23%) Data Analysis Expressions (DAX)
4 23 (14.74%) C#
5 20 (12.82%) VBA
6 16 (10.26%) JavaScript
6 16 (10.26%) Python
7 13 (8.33%) PowerShell
8 8 (5.13%) Java
8 8 (5.13%) PL/SQL
9 7 (4.49%) R
10 3 (1.92%) VBScript
11 2 (1.28%) C
11 2 (1.28%) Ruby
11 2 (1.28%) VB
12 1 (0.64%) C++
12 1 (0.64%) Pascal
12 1 (0.64%) VB.NET
Qualifications
1 20 (12.82%) Degree
2 2 (1.28%) PRINCE2 Practitioner
3 1 (0.64%) DBS Check
3 1 (0.64%) MCP
3 1 (0.64%) Microsoft Certification
Quality Assurance & Compliance
1 19 (12.18%) Data Quality
2 17 (10.90%) QA
3 6 (3.85%) ISO/IEC 27001
4 5 (3.21%) Cyber Essentials
5 2 (1.28%) SLA
6 1 (0.64%) PCI DSS
System Software
1 5 (3.21%) Apache Flume
Systems Management
1 9 (5.77%) Puppet
2 1 (0.64%) CA Single Sign-On
Vendors
1 83 (53.21%) Microsoft
2 26 (16.67%) Tableau
3 23 (14.74%) Cognos
4 18 (11.54%) Oracle
5 13 (8.33%) SAP
6 11 (7.05%) IBM
6 11 (7.05%) Nintex
7 10 (6.41%) RedGate
8 9 (5.77%) Teradata
9 5 (3.21%) Ab Initio
9 5 (3.21%) Hortonworks
9 5 (3.21%) Informatica
9 5 (3.21%) Talend
10 4 (2.56%) Google
11 3 (1.92%) JD Edwards
12 2 (1.28%) Cloudera
12 2 (1.28%) F5
12 2 (1.28%) IDERA
13 1 (0.64%) Capita
13 1 (0.64%) Riverbed
England
Lawrence Harvey
Salary: £4000.00 - £50000 per annum
Posted: 16 days ago
Newbury
Spectrum IT
Salary: £30000 per annum
Posted: 17 days ago
Northamptonshire
Lawrence Harvey
Salary: £45000 - £50000 per annum
Posted: 16 days ago
Sevenoaks
Mint
Salary: £30000 - £40000 per annum + Excellent
Posted: 22 days ago
City of London
Bluetown Online LTD
Salary: £24000 - £32000 per annum
Posted: 18 days ago
London
TRG
Salary: 55000 Per Annum Plus excellent benefits
Posted: 20 days ago