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

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
UK
Rank 742 800 735
Rank change year-on-year
+58 -65
Permanent jobs citing PowerPivot 103 147 208
As % of all permanent IT jobs located in the UK 0.12% 0.15% 0.20%
As % of the Database & Business Intelligence category 0.41% 0.46% 0.64%
Number of salaries quoted 91 105 182
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,000 £42,000
% change year-on-year
+9.75% -2.38%

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
25356 32222 32565
As % of all permanent IT jobs located in the UK 30.20% 32.17% 31.03%
Number of salaries quoted 21804 27238 27955
Median salary £50,000 £48,500 £45,000
Median salary % change year-on-year
+3.09% +7.77%
90% offered a salary of more than £32,500 £32,500 £30,565
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

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 January 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 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
England +34 100 £52,500 +23.52% 10
London +45 47 £55,000 +12.82% 4
South East +55 26 £50,000 +23.45% 3
City of London +44 13 £55,000 - 1
Yorkshire +34 8 £40,000 +31.14%
East Midlands +17 7 £34,000 -35.23% 1
West Yorkshire +37 6 £37,500 +22.95%
Berkshire +45 5 £27,500 -63.33% 1
South West +17 5 £27,500 -14.06%
Somerset +10 5 £27,500 -3.50%
Northamptonshire +8 5 £60,000 +9.09%
Bath +6 5 £27,500 -3.50%
Leeds - 5 £37,500 -
Northampton - 4 - -
Slough - 4 - -
East of England +9 3 £55,000 -4.34%
Hertfordshire +2 3 £55,000 -4.34%
West Midlands +3 2 £33,250 -21.76% 1
North Yorkshire +1 2 £70,000 +115.38%
Watford 0 2 £55,000 -4.34%
Chorley -3 2 £30,000 -
Leicestershire -3 2 £33,750 -15.62%
Leicester -9 2 £33,750 -15.62%
Lancashire -10 2 £30,000 -
North West -40 2 £30,000 -25.00% 1
Worcestershire - 2 £33,250 -
York - 2 £70,000 -
Surrey +27 1 £45,000 +11.11%
Buckinghamshire +20 1 £40,000 -15.78%
Hampshire +17 1 £50,000 +7.52%

PowerPivot
Top 30 Related IT Skills

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

1 154 (85.08%) SQL
2 147 (81.22%) Business Intelligence
3 135 (74.59%) SQL Server Reporting Services
4 116 (64.09%) SQL Server Integration Services
5 115 (63.54%) SQL Server
6 108 (59.67%) SQL Server Analysis Services
7 105 (58.01%) Microsoft
8 104 (57.46%) Power BI
9 82 (45.30%) Data Warehouse
10 78 (43.09%) T-SQL
11 64 (35.36%) Analytics
12 57 (31.49%) MS Excel
13 52 (28.73%) ETL
14 50 (27.62%) Data Modelling
15 49 (27.07%) Agile Software Development
16 45 (24.86%) MySQL
17 41 (22.65%) Tableau
17 41 (22.65%) Microsoft Power View
18 40 (22.10%) MDX
18 40 (22.10%) Finance
19 36 (19.89%) Data Analysis Expressions (DAX)
20 34 (18.78%) Management Information System
21 33 (18.23%) Analytical Skills
22 32 (17.68%) Relational Database
22 32 (17.68%) BusinessObjects
23 31 (17.13%) Microsoft Analysis Services
23 31 (17.13%) Hadoop
24 30 (16.57%) Big Data
24 30 (16.57%) SQL Server 2012
25 27 (14.92%) C#

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 26 (14.36%) SharePoint
2 12 (6.63%) WebSphere
3 6 (3.31%) Apache Pig
3 6 (3.31%) OpenStack
4 4 (2.21%) SAS
5 2 (1.10%) Apache Spark
6 1 (0.55%) IIS
6 1 (0.55%) MS Exchange
6 1 (0.55%) SharePoint 2010
6 1 (0.55%) SharePoint 2013
6 1 (0.55%) SharePoint Server
Applications
1 57 (31.49%) MS Excel
2 12 (6.63%) MS Visio
3 7 (3.87%) MS Office
4 6 (3.31%) SPSS
5 5 (2.76%) MS PowerPoint
6 1 (0.55%) InfoPath
6 1 (0.55%) Spreadsheet
Business Applications
1 3 (1.66%) Dynamics CRM
2 2 (1.10%) Dynamics AX
3 1 (0.55%) OPENHousing
3 1 (0.55%) Oracle Financials
3 1 (0.55%) StreamServe
Cloud Services
1 15 (8.29%) GitHub
2 13 (7.18%) Microsoft Azure
3 11 (6.08%) Amazon AWS
4 8 (4.42%) PaaS
5 7 (3.87%) SaaS
6 4 (2.21%) Google Analytics
7 2 (1.10%) Office 365
8 1 (0.55%) Akamai
8 1 (0.55%) IaaS
Communications & Networking
1 4 (2.21%) MVNO
2 1 (0.55%) DHCP
2 1 (0.55%) LDAP
Database & Business Intelligence
1 135 (74.59%) SQL Server Reporting Services
2 116 (64.09%) SQL Server Integration Services
3 115 (63.54%) SQL Server
4 108 (59.67%) SQL Server Analysis Services
5 104 (57.46%) Power BI
6 82 (45.30%) Data Warehouse
7 45 (24.86%) MySQL
8 41 (22.65%) Microsoft Power View
9 32 (17.68%) BusinessObjects
9 32 (17.68%) Relational Database
10 31 (17.13%) Hadoop
10 31 (17.13%) Microsoft Analysis Services
11 30 (16.57%) Big Data
11 30 (16.57%) SQL Server 2012
12 20 (11.05%) QlikView
13 19 (10.50%) OLAP
14 18 (9.94%) Apache Hive
15 17 (9.39%) Data Mining
15 17 (9.39%) SQL Server 2014
16 15 (8.29%) NoSQL
Development Applications
1 18 (9.94%) JIRA
2 11 (6.08%) Visual Studio
3 7 (3.87%) Git (software)
4 6 (3.31%) Jenkins
4 6 (3.31%) Talend Open Studio
5 3 (1.66%) Team Foundation Server
6 1 (0.55%) SQL Server Management Studio (SSMS)
General
1 40 (22.10%) Finance
2 19 (10.50%) Legal
3 10 (5.52%) Law
4 7 (3.87%) Billing
4 7 (3.87%) Marketing
5 6 (3.31%) Advertising
5 6 (3.31%) Games
5 6 (3.31%) Retail
6 4 (2.21%) Telecoms
7 3 (1.66%) Banking
7 3 (1.66%) Manufacturing
8 2 (1.10%) Publishing
9 1 (0.55%) Financial Institution
9 1 (0.55%) Pharmaceutical
Job Titles
1 74 (40.88%) Developer
2 65 (35.91%) Analyst
3 36 (19.89%) Business Intelligence Developer
4 34 (18.78%) SQL Developer
5 26 (14.36%) Business Intelligence Analyst
6 14 (7.73%) Architect
6 14 (7.73%) Data Analyst
6 14 (7.73%) SQL Analyst
7 13 (7.18%) Consultant
7 13 (7.18%) Report Analyst
7 13 (7.18%) Report Developer
7 13 (7.18%) SQL BI Developer
7 13 (7.18%) SQL Server Developer
8 12 (6.63%) Solutions Architect
9 11 (6.08%) Insight Analyst
9 11 (6.08%) Senior Analyst
9 11 (6.08%) Senior Business Intelligence Developer
9 11 (6.08%) Senior Developer
9 11 (6.08%) SSRS Developer
10 10 (5.52%) Business Intelligence Consultant
Libraries, Frameworks & Software Standards
1 40 (22.10%) MDX
2 25 (13.81%) .NET
3 11 (6.08%) .NET Framework
4 8 (4.42%) ASP.NET
5 4 (2.21%) XML
6 3 (1.66%) HTML
6 3 (1.66%) Web Services
7 2 (1.10%) CSS
8 1 (0.55%) Ajax
8 1 (0.55%) COM
8 1 (0.55%) D3.js
8 1 (0.55%) jQuery
8 1 (0.55%) JSON
8 1 (0.55%) KnockoutJS
8 1 (0.55%) Leaflet
8 1 (0.55%) REST
8 1 (0.55%) SOAP
8 1 (0.55%) XSL
Miscellaneous
1 34 (18.78%) Management Information System
2 33 (18.23%) Analytical Skills
3 18 (9.94%) Visualisation
4 8 (4.42%) Wiki
5 7 (3.87%) NHS
6 6 (3.31%) Algorithms
7 3 (1.66%) Driving Licence
7 3 (1.66%) Mathematics
7 3 (1.66%) Performance Metrics
8 2 (1.10%) Ergonomics
8 2 (1.10%) Life Science
9 1 (0.55%) Computer Science
9 1 (0.55%) Credit Risk
9 1 (0.55%) Data Extraction
9 1 (0.55%) Data Integration
9 1 (0.55%) Fintech
9 1 (0.55%) Statistics
9 1 (0.55%) User Experience
Operating Systems
1 11 (6.08%) Windows
1 11 (6.08%) Windows Server
1 11 (6.08%) Windows Server 2012
Processes & Methodologies
1 147 (81.22%) Business Intelligence
2 64 (35.36%) Analytics
3 52 (28.73%) ETL
4 50 (27.62%) Data Modelling
5 49 (27.07%) Agile Software Development
6 24 (13.26%) Kimball Methodology
7 23 (12.71%) Data Analysis
8 21 (11.60%) Scrum
9 16 (8.84%) Translating Business Requirements
10 15 (8.29%) Mentoring
10 15 (8.29%) Time Management
11 14 (7.73%) ETL Development
12 12 (6.63%) Performance Optimisation
12 12 (6.63%) TOGAF
12 12 (6.63%) Workflow
13 10 (5.52%) Business Analysis
13 10 (5.52%) Coaching
13 10 (5.52%) Dashboard Development
13 10 (5.52%) Presales
13 10 (5.52%) Project Management
Programming Languages
1 154 (85.08%) SQL
2 78 (43.09%) T-SQL
3 36 (19.89%) Data Analysis Expressions (DAX)
4 27 (14.92%) C#
5 21 (11.60%) VBA
6 18 (9.94%) Python
7 16 (8.84%) JavaScript
8 13 (7.18%) PowerShell
9 9 (4.97%) PL/SQL
10 6 (3.31%) Java
10 6 (3.31%) R
10 6 (3.31%) Ruby
11 3 (1.66%) VB
11 3 (1.66%) VBScript
12 2 (1.10%) VB.NET
13 1 (0.55%) C
13 1 (0.55%) C++
13 1 (0.55%) Pascal
Qualifications
1 16 (8.84%) Degree
2 8 (4.42%) DBS Check
3 1 (0.55%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 23 (12.71%) Data Quality
2 14 (7.73%) QA
3 8 (4.42%) ISO/IEC 27001
4 5 (2.76%) SLA
5 2 (1.10%) PCI DSS
System Software
1 2 (1.10%) Active Directory
2 1 (0.55%) Virtual Desktop
2 1 (0.55%) Virtual Machines
2 1 (0.55%) VMware Infrastructure
Systems Management
1 9 (4.97%) Puppet
2 1 (0.55%) CA Single Sign-On
Vendors
1 105 (58.01%) Microsoft
2 41 (22.65%) Tableau
3 24 (13.26%) Cognos
4 19 (10.50%) Oracle
5 17 (9.39%) SAP
6 13 (7.18%) IBM
7 12 (6.63%) Nintex
8 6 (3.31%) RedGate
8 6 (3.31%) Talend
9 5 (2.76%) Google
10 4 (2.21%) NetSuite
10 4 (2.21%) Teradata
11 2 (1.10%) JD Edwards
11 2 (1.10%) VMware
12 1 (0.55%) Capita
12 1 (0.55%) F5
12 1 (0.55%) MicroStrategy
12 1 (0.55%) Riverbed
12 1 (0.55%) Salesforce.com
12 1 (0.55%) Sony
South East
Austin Fraser
Salary: £40000 - £50000 per annum + Benefits
Posted: Yesterday
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: Yesterday
Newhaven, East Sussex
Bluetownonline
Salary: £24000 - £32000 per annum
Posted: 2 days ago
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 6 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: 14 days ago
Telford
Bluetown Online LTD
Salary: £24000 - £32000 per annum
Posted: 14 days ago