The table below looks at the statistics for PowerPivot skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited PowerPivot over the 3 months to 19 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
19 Feb 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
UK
Rank 765 794 739
Rank change year-on-year
+29 -55
Permanent jobs citing PowerPivot 84 144 214
As % of all permanent IT jobs located in the UK 0.10% 0.14% 0.20%
As % of the Database & Business Intelligence category 0.33% 0.45% 0.65%
Number of salaries quoted 75 103 194
Median salary £45,000 £45,000 £45,000
90% offered a salary of more than £30,000 £28,950 £33,600
10% offered a salary of more than £67,500 £75,000 £65,000
UK excluding London median salary £45,000 £40,500 £42,000
% change year-on-year
+11.11% -3.57%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
25165 32309 33175
As % of all permanent IT jobs located in the UK 30.16% 31.58% 31.18%
Number of salaries quoted 21454 27397 28415
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,500 £31,000
10% offered a salary of more than £74,000 £70,000 £72,150
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

PowerPivot
Jobs Demand Trend

The demand trend of job ads citing PowerPivot as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

PowerPivot Jobs Demand Trend in the UK

PowerPivot
Salary Trend

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

PowerPivot Salary Trend in the UK

PowerPivot
Salary Histogram

This chart provides a salary histogram for IT jobs citing PowerPivot over the 3 months to 19 February 2017 within the UK.

PowerPivot Salary Histogram in the UK

PowerPivot
Top 30 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 19 February 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 +59 81 £45,000 - 7
London +37 44 £55,000 +4.76% 3
South East +56 20 £45,000 +11.11% 1
City of London +46 9 £55,000 +25.71% 1
Berkshire +48 5 £27,500 -63.33% 1
South West +25 5 £27,500 -3.50%
Somerset +9 5 £27,500 -3.50%
Bath +5 5 £27,500 -3.50%
North West -20 4 £33,750 +10.80% 1
Slough - 4 - -
West Yorkshire +33 3 £37,500 -3.84%
Yorkshire +32 3 £37,500 +19.04%
Leeds +27 3 £37,500 -21.05%
East Midlands +11 2 £46,750 -10.95%
Chorley 0 2 £30,000 -
Lancashire -12 2 £30,000 -
Manchester -27 2 £40,000 -30.43% 1
West Midlands - 2 £33,250 -
Worcestershire - 2 £33,250 -
Surrey +40 1 £45,000 +5.26%
East of England +19 1 £60,000 +11.62% 2
Hampshire +16 1 £50,000 +66.66%
Northamptonshire +12 1 £60,000 +9.09%
Kent +11 1 £32,500 +3.17%
Hertfordshire +11 1 £60,000 +4.34% 1
Watford -1 1 £60,000 +4.34%
Leicestershire -6 1 £33,500 -16.25%
Leicester -13 1 £33,500 -16.25%
Reigate - 1 £45,000 -
Sevenoaks - 1 £32,500 -

PowerPivot
Top 30 Related IT Skills

For the 6 months to 19 February 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 147 (84.00%) Business Intelligence
2 143 (81.71%) SQL
3 135 (77.14%) SQL Server Reporting Services
4 117 (66.86%) SQL Server Integration Services
5 113 (64.57%) SQL Server
6 108 (61.71%) SQL Server Analysis Services
7 105 (60.00%) Power BI
8 97 (55.43%) Microsoft
9 82 (46.86%) Data Warehouse
10 78 (44.57%) T-SQL
11 68 (38.86%) Analytics
12 58 (33.14%) MS Excel
13 54 (30.86%) ETL
14 53 (30.29%) Data Modelling
15 51 (29.14%) Agile Software Development
16 46 (26.29%) Microsoft Power View
17 44 (25.14%) MySQL
18 37 (21.14%) Finance
18 37 (21.14%) Tableau
19 35 (20.00%) Hadoop
20 34 (19.43%) Relational Database
21 33 (18.86%) Data Analysis Expressions (DAX)
22 32 (18.29%) MDX
22 32 (18.29%) Analytical Skills
23 31 (17.71%) SQL Server 2012
23 31 (17.71%) Big Data
23 31 (17.71%) Management Information System
24 30 (17.14%) Microsoft Analysis Services
25 29 (16.57%) BusinessObjects
26 27 (15.43%) 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 27 (15.43%) SharePoint
2 11 (6.29%) WebSphere
3 8 (4.57%) Apache Pig
3 8 (4.57%) OpenStack
4 4 (2.29%) SAS
5 3 (1.71%) Apache Spark
6 2 (1.14%) SharePoint 2013
7 1 (0.57%) IIS
7 1 (0.57%) SharePoint 2010
7 1 (0.57%) SharePoint Server
Applications
1 58 (33.14%) MS Excel
2 11 (6.29%) MS Visio
3 8 (4.57%) MS Office
4 6 (3.43%) SPSS
5 3 (1.71%) MS PowerPoint
6 1 (0.57%) InfoPath
6 1 (0.57%) Photoshop
6 1 (0.57%) Spreadsheet
Business Applications
1 3 (1.71%) Dynamics AX
2 2 (1.14%) Dynamics CRM
2 2 (1.14%) NetSuite
3 1 (0.57%) OPENHousing
3 1 (0.57%) Oracle Financials
3 1 (0.57%) StreamServe
Cloud Services
1 17 (9.71%) GitHub
2 13 (7.43%) Amazon AWS
3 11 (6.29%) Microsoft Azure
4 7 (4.00%) PaaS
5 6 (3.43%) SaaS
6 4 (2.29%) Google Analytics
7 1 (0.57%) Akamai
7 1 (0.57%) IaaS
7 1 (0.57%) Office 365
Communications & Networking
1 4 (2.29%) MVNO
2 1 (0.57%) LDAP
Database & Business Intelligence
1 135 (77.14%) SQL Server Reporting Services
2 117 (66.86%) SQL Server Integration Services
3 113 (64.57%) SQL Server
4 108 (61.71%) SQL Server Analysis Services
5 105 (60.00%) Power BI
6 82 (46.86%) Data Warehouse
7 46 (26.29%) Microsoft Power View
8 44 (25.14%) MySQL
9 35 (20.00%) Hadoop
10 34 (19.43%) Relational Database
11 31 (17.71%) Big Data
11 31 (17.71%) SQL Server 2012
12 30 (17.14%) Microsoft Analysis Services
13 29 (16.57%) BusinessObjects
14 21 (12.00%) Apache Hive
15 20 (11.43%) QlikView
16 18 (10.29%) OLAP
16 18 (10.29%) SQL Server 2014
17 17 (9.71%) Data Mining
18 16 (9.14%) NoSQL
Development Applications
1 19 (10.86%) JIRA
2 9 (5.14%) Git (software)
2 9 (5.14%) Visual Studio
3 8 (4.57%) Jenkins
4 6 (3.43%) Talend Open Studio
5 4 (2.29%) Team Foundation Server
6 1 (0.57%) SQL Server Management Studio (SSMS)
General
1 37 (21.14%) Finance
2 16 (9.14%) Legal
3 11 (6.29%) Law
4 6 (3.43%) Games
4 6 (3.43%) Marketing
4 6 (3.43%) Retail
5 4 (2.29%) Advertising
5 4 (2.29%) Billing
5 4 (2.29%) Manufacturing
5 4 (2.29%) Telecoms
6 3 (1.71%) Banking
6 3 (1.71%) Publishing
7 1 (0.57%) Financial Institution
7 1 (0.57%) Pharmaceutical
Job Titles
1 74 (42.29%) Developer
2 67 (38.29%) Analyst
3 36 (20.57%) Business Intelligence Developer
4 33 (18.86%) SQL Developer
5 30 (17.14%) Business Intelligence Analyst
6 16 (9.14%) Architect
7 15 (8.57%) Report Developer
8 14 (8.00%) Report Analyst
8 14 (8.00%) SQL BI Developer
8 14 (8.00%) SQL Server Developer
9 13 (7.43%) Insight Analyst
9 13 (7.43%) Senior Analyst
10 11 (6.29%) Data Analyst
10 11 (6.29%) Senior Business Intelligence Analyst
10 11 (6.29%) Senior Developer
10 11 (6.29%) Solutions Architect
10 11 (6.29%) SQL Analyst
10 11 (6.29%) SSRS Developer
11 10 (5.71%) Senior Business Intelligence Developer
12 9 (5.14%) NoSQL Developer
Libraries, Frameworks & Software Standards
1 32 (18.29%) MDX
2 25 (14.29%) .NET
3 13 (7.43%) .NET Framework
4 7 (4.00%) ASP.NET
5 4 (2.29%) HTML
6 3 (1.71%) CSS
6 3 (1.71%) Kafka
6 3 (1.71%) XML
7 2 (1.14%) Ajax
7 2 (1.14%) jQuery
7 2 (1.14%) Web Services
8 1 (0.57%) KnockoutJS
8 1 (0.57%) LLBLGen Pro
8 1 (0.57%) WCF
8 1 (0.57%) XSL
8 1 (0.57%) XSLT
Miscellaneous
1 32 (18.29%) Analytical Skills
2 31 (17.71%) Management Information System
3 13 (7.43%) Visualisation
4 10 (5.71%) Wiki
5 9 (5.14%) NHS
6 6 (3.43%) Algorithms
7 3 (1.71%) Driving Licence
7 3 (1.71%) Mathematics
7 3 (1.71%) Performance Metrics
8 2 (1.14%) Fintech
8 2 (1.14%) Life Science
8 2 (1.14%) User Experience
9 1 (0.57%) Blog
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%) Statistics
9 1 (0.57%) W3C
Operating Systems
1 13 (7.43%) Windows
1 13 (7.43%) Windows Server
1 13 (7.43%) Windows Server 2012
2 2 (1.14%) Unix
Processes & Methodologies
1 147 (84.00%) Business Intelligence
2 68 (38.86%) Analytics
3 54 (30.86%) ETL
4 53 (30.29%) Data Modelling
5 51 (29.14%) Agile Software Development
6 22 (12.57%) Scrum
7 17 (9.71%) Data Analysis
7 17 (9.71%) Kimball Methodology
8 16 (9.14%) ETL Development
8 16 (9.14%) Mentoring
9 15 (8.57%) Time Management
10 14 (8.00%) Performance Optimisation
11 13 (7.43%) Translating Business Requirements
11 13 (7.43%) Use Case
12 12 (6.86%) Workflow
13 11 (6.29%) Coaching
13 11 (6.29%) Dashboard Development
13 11 (6.29%) TOGAF
14 10 (5.71%) Test Scripting
15 9 (5.14%) MapReduce
Programming Languages
1 143 (81.71%) SQL
2 78 (44.57%) T-SQL
3 33 (18.86%) Data Analysis Expressions (DAX)
4 27 (15.43%) C#
5 21 (12.00%) VBA
6 20 (11.43%) Python
7 19 (10.86%) JavaScript
8 15 (8.57%) PowerShell
9 9 (5.14%) PL/SQL
10 8 (4.57%) Java
11 6 (3.43%) R
11 6 (3.43%) Ruby
12 3 (1.71%) VBScript
13 2 (1.14%) C
14 1 (0.57%) C++
14 1 (0.57%) Pascal
14 1 (0.57%) VB
14 1 (0.57%) VB.NET
Qualifications
1 17 (9.71%) Degree
2 4 (2.29%) DBS Check
3 1 (0.57%) MCP
3 1 (0.57%) Microsoft Certification
3 1 (0.57%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 21 (12.00%) Data Quality
2 16 (9.14%) QA
3 7 (4.00%) ISO/IEC 27001
4 2 (1.14%) PCI DSS
4 2 (1.14%) SLA
System Software
1 3 (1.71%) Apache Flume
Systems Management
1 9 (5.14%) Puppet
2 1 (0.57%) CA Single Sign-On
Vendors
1 97 (55.43%) Microsoft
2 37 (21.14%) Tableau
3 25 (14.29%) Cognos
4 20 (11.43%) Oracle
5 13 (7.43%) SAP
6 12 (6.86%) IBM
6 12 (6.86%) Nintex
7 10 (5.71%) RedGate
8 7 (4.00%) Teradata
9 6 (3.43%) Talend
10 5 (2.86%) Google
11 3 (1.71%) Ab Initio
11 3 (1.71%) Hortonworks
11 3 (1.71%) Informatica
11 3 (1.71%) JD Edwards
12 2 (1.14%) Cloudera
12 2 (1.14%) IDERA
13 1 (0.57%) Capita
13 1 (0.57%) Riverbed
13 1 (0.57%) Telerik
Hertfordshire
Lawrence Harvey Enterprise
Salary: £35000.00 - £45000.00 per annum + pension, health care
Posted: 4 days ago
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 6 days ago
City, London
Venturi
Salary: £68000 - £77000 per annum + bonus +Full bens
Posted: 6 days ago
Reading, Berkshire
Oxbridge Answers
Salary: 50000
Posted: 6 days ago
London
Networkers
Salary: £65000 - £70000 per annum + Excellent benefits
Posted: 4 days ago
London
Arrows Group Ltd
Salary: £45000 per annum + benefits
Posted: 9 days ago
Cambridge
Bluetown Online LTD
Posted: 10 days ago