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

Location
3 months to
8 Feb 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 793 734 851
Rank change year-on-year
-59 +117
Permanent jobs citing PowerPivot 141 217 84
As % of all permanent IT jobs located in the UK 0.14% 0.20% 0.081%
As % of the Database & Business Intelligence category 0.44% 0.66% 0.25%
Number of salaries quoted 100 197 63
Average salary £45,500 £45,000 £45,000
Average salary % change year-on-year
+1.11% -
90% offered a salary of more than £30,000 £32,800 £37,500
10% offered a salary of more than £75,000 £65,000 £70,000
UK excluding London average salary £40,500 £42,000 £45,000
% change year-on-year
-3.57% -6.66%

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
32150 32989 33792
As % of all permanent IT jobs located in the UK 31.70% 30.97% 32.75%
Number of salaries quoted 27271 28305 28586
Average salary £47,500 £45,000 £45,000
Average salary % change year-on-year
+5.55% -
90% offered a salary of more than £32,500 £31,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

PowerPivot
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing PowerPivot within the UK as a proportion of the total demand within 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 8 February 2016 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 average salaries quoted in IT jobs citing PowerPivot within the UK over the 3 months to 8 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -82 125 £45,500 +1.11% 17
London -22 60 £55,000 -4.34% 8
South East -22 32 £45,000 +5.88% 4
North West +6 18 £40,000 - 4
Hampshire +14 9 £51,250 +51.85% 1
Surrey -42 9 £40,500 -4.70% 2
East of England - 8 £53,750 -
Berkshire +7 7 £75,000 +76.47%
Manchester +7 7 £60,000 +50.00% 2
Basingstoke - 7 £53,750 - 1
Lancashire +15 6 £30,000 - 1
Chorley - 6 £30,000 - 1
Kent - 5 £31,500 - 1
City of London +40 4 £48,750 +2.63% 2
Cheshire +27 4 £40,000 +14.28%
East Midlands - 4 £52,500 -
Warrington - 4 £40,000 -
Ipswich - 4 £50,000 -
Hertfordshire - 4 £57,500 -
Suffolk - 4 £50,000 -
Chiswick - 3 £42,500 -
Maidenhead - 3 £75,000 -
Watford - 3 £57,500 -
Rochester - 3 £31,500 - 1
Northamptonshire - 3 £55,000 -
Winchester +5 2 £30,000 -7.69%
Yorkshire -3 2 £30,500 -12.85%
West Sussex - 2 £38,000 -
Chatham - 2 - -
Shoreham-by-Sea - 2 £38,000 -

PowerPivot
Top 30 Related IT Skills

For the 6 months to 8 February 2016, IT jobs within the UK citing PowerPivot also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited PowerPivot.

1 286 (89.38%) Business Intelligence
2 242 (75.63%) SQL Server
3 240 (75.00%) SQL
4 224 (70.00%) Microsoft
5 198 (61.88%) SQL Server Reporting Services
6 178 (55.63%) SQL Server Integration Services
7 170 (53.13%) SQL Server Analysis Services
8 158 (49.38%) SharePoint
9 156 (48.75%) MS Excel
10 149 (46.56%) Data Warehouse
11 126 (39.38%) Microsoft Power View
12 108 (33.75%) Analytics
13 105 (32.81%) ETL
14 95 (29.69%) Tableau
15 90 (28.13%) T-SQL
16 88 (27.50%) MDX
17 83 (25.94%) Agile Software Development
17 83 (25.94%) Power BI
18 77 (24.06%) Data Modelling
19 74 (23.13%) Finance
19 74 (23.13%) Data Management
20 63 (19.69%) VBA
20 63 (19.69%) Analytical Skills
21 60 (18.75%) Kimball Methodology
21 60 (18.75%) OLAP
21 60 (18.75%) Cognos
22 57 (17.81%) SQL Server 2012
23 56 (17.50%) Degree
24 50 (15.63%) C#
25 46 (14.38%) Data Mining

PowerPivot
Top Related IT Skills by Category

For the 6 months to 8 February 2016, IT jobs within the UK citing PowerPivot also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited PowerPivot. Up to 20 skills are shown per category.

Application Platforms
1 158 (49.38%) SharePoint
2 13 (4.06%) SharePoint Server
3 11 (3.44%) SAS
4 10 (3.13%) SharePoint 2010
4 10 (3.13%) SharePoint 2013
5 2 (0.63%) IIS
5 2 (0.63%) NServiceBus
6 1 (0.31%) ArcGIS
6 1 (0.31%) Confluence
Applications
1 156 (48.75%) MS Excel
2 29 (9.06%) MS Office
3 18 (5.63%) MS PowerPoint
4 13 (4.06%) MS Visio
5 4 (1.25%) SPSS
6 2 (0.63%) GNU Octave
6 2 (0.63%) Spreadsheet
7 1 (0.31%) InfoPath
7 1 (0.31%) MS Project
Business Applications
1 27 (8.44%) Cognos Business Intelligence
2 18 (5.63%) Cognos TM1
3 3 (0.94%) Sage 1000
4 1 (0.31%) Dynamics AX
4 1 (0.31%) SAP Business One
Cloud Services
1 23 (7.19%) Microsoft Azure
2 7 (2.19%) Office 365
3 6 (1.88%) Azure Machine Learning
3 6 (1.88%) IaaS
3 6 (1.88%) PaaS
4 4 (1.25%) Cloud Computing
5 1 (0.31%) Adobe Analytics
5 1 (0.31%) Amazon AWS
5 1 (0.31%) Amazon EMR
5 1 (0.31%) Google Analytics
Communications & Networking
1 10 (3.13%) DNS
2 9 (2.81%) LAN
2 9 (2.81%) WAN
3 2 (0.63%) DHCP
3 2 (0.63%) Internet
4 1 (0.31%) SAN
4 1 (0.31%) TCP/IP
Database & Business Intelligence
1 242 (75.63%) SQL Server
2 198 (61.88%) SQL Server Reporting Services
3 178 (55.63%) SQL Server Integration Services
4 170 (53.13%) SQL Server Analysis Services
5 149 (46.56%) Data Warehouse
6 126 (39.38%) Microsoft Power View
7 83 (25.94%) Power BI
8 60 (18.75%) OLAP
9 57 (17.81%) SQL Server 2012
10 46 (14.38%) Data Mining
11 44 (13.75%) SQL Server 2008
12 43 (13.44%) Microsoft Analysis Services
13 41 (12.81%) QlikView
13 41 (12.81%) Relational Database
14 40 (12.50%) SQL Server 2014
15 36 (11.25%) PerformancePoint
16 34 (10.63%) RDBMS
17 20 (6.25%) Enterprise Data Warehouse
18 19 (5.94%) Cognos Framework Manager
19 14 (4.38%) Big Data
Development Applications
1 41 (12.81%) Team Foundation Server
2 24 (7.50%) Subversion
3 16 (5.00%) Git (software)
3 16 (5.00%) Toad
4 15 (4.69%) Talend Open Studio
5 13 (4.06%) Visual Studio
6 11 (3.44%) SQL Server Management Studio (SSMS)
7 7 (2.19%) JIRA
8 5 (1.56%) ERwin
9 4 (1.25%) VSS/SourceSafe
10 1 (0.31%) Atlassian Bamboo
10 1 (0.31%) GitLab
10 1 (0.31%) Visual Studio Tools for Office
General
1 74 (23.13%) Finance
2 17 (5.31%) Retail
3 15 (4.69%) Marketing
4 7 (2.19%) Banking
4 7 (2.19%) Manufacturing
5 6 (1.88%) Advertising
5 6 (1.88%) Games
6 5 (1.56%) iGaming
7 3 (0.94%) Legal
8 1 (0.31%) Billing
8 1 (0.31%) Financial Institution
8 1 (0.31%) Investment Banking
8 1 (0.31%) Publishing
Job Titles
1 173 (54.06%) Developer
2 128 (40.00%) Business Intelligence Developer
3 78 (24.38%) Analyst
4 57 (17.81%) SQL Developer
5 46 (14.38%) SQL BI Developer
6 37 (11.56%) Architect
7 35 (10.94%) Business Intelligence Analyst
7 35 (10.94%) Senior Developer
8 29 (9.06%) Senior Business Intelligence Developer
9 27 (8.44%) Business Developer
10 22 (6.88%) Lead Developer
11 20 (6.25%) Junior
12 18 (5.63%) Business Intelligence Consultant
12 18 (5.63%) Consultant
12 18 (5.63%) Report Developer
13 17 (5.31%) Analyst Developer
14 16 (5.00%) Business Intelligence Architect
14 16 (5.00%) Cognos Developer
14 16 (5.00%) Data Analyst
15 15 (4.69%) Data Architect
Libraries, Frameworks & Software Standards
1 88 (27.50%) MDX
2 35 (10.94%) .NET
3 28 (8.75%) CSS
3 28 (8.75%) HTML
4 18 (5.63%) XML
5 12 (3.75%) Web Services
6 9 (2.81%) ASP.NET
7 6 (1.88%) D3.js
7 6 (1.88%) Leaflet
8 5 (1.56%) Ajax
8 5 (1.56%) jQuery
9 3 (0.94%) HTML5
10 2 (0.63%) CSS3
10 2 (0.63%) RabbitMQ
11 1 (0.31%) .NET Framework
11 1 (0.31%) CAML
11 1 (0.31%) EDI
11 1 (0.31%) REST
11 1 (0.31%) XSLT
Miscellaneous
1 63 (19.69%) Analytical Skills
2 46 (14.38%) Visualisation
3 35 (10.94%) Data Integration
4 26 (8.13%) Statistics
5 24 (7.50%) Computer Science
5 24 (7.50%) Management Information System
6 16 (5.00%) Data Structures
7 13 (4.06%) Mathematics
8 10 (3.13%) Mobile App
9 9 (2.81%) CMDB
10 8 (2.50%) Neural Network
10 8 (2.50%) NHS
11 7 (2.19%) Economics
12 6 (1.88%) Algorithms
13 5 (1.56%) Online Games
13 5 (1.56%) PlayStation
14 4 (1.25%) Client/Server
14 4 (1.25%) Hybrid Cloud
15 3 (0.94%) Reinsurance
15 3 (0.94%) Replication
Operating Systems
1 13 (4.06%) Windows
2 9 (2.81%) Windows Server
2 9 (2.81%) Windows Server 2012
3 7 (2.19%) Windows Server 2003
4 2 (0.63%) Windows Server 2008
5 1 (0.31%) Linux
Processes & Methodologies
1 286 (89.38%) Business Intelligence
2 108 (33.75%) Analytics
3 105 (32.81%) ETL
4 83 (25.94%) Agile Software Development
5 77 (24.06%) Data Modelling
6 74 (23.13%) Data Management
7 60 (18.75%) Kimball Methodology
8 40 (12.50%) Data Analysis
9 26 (8.13%) Performance Tuning
10 23 (7.19%) Master Data Management
11 21 (6.56%) Data Analytics
11 21 (6.56%) Validation
12 20 (6.25%) ITIL
13 19 (5.94%) Information Management
14 18 (5.63%) Data Visualisation
14 18 (5.63%) Migration
14 18 (5.63%) Scrum
15 17 (5.31%) Business Analysis
15 17 (5.31%) Data Governance
16 16 (5.00%) Data Architecture
Programming Languages
1 240 (75.00%) SQL
2 90 (28.13%) T-SQL
3 63 (19.69%) VBA
4 50 (15.63%) C#
5 35 (10.94%) Data Analysis Expressions (DAX)
6 17 (5.31%) R
7 14 (4.38%) Python
8 11 (3.44%) JavaScript
9 9 (2.81%) PowerShell
10 8 (2.50%) VB.NET
11 7 (2.19%) VBScript
12 5 (1.56%) VB
13 4 (1.25%) Java
14 2 (0.63%) COBOL
14 2 (0.63%) Data Mining Extensions (DMX)
15 1 (0.31%) Bash Shell
Qualifications
1 56 (17.50%) Degree
2 33 (10.31%) Microsoft Certification
3 16 (5.00%) MCSE
4 9 (2.81%) Security Cleared
5 2 (0.63%) CCAB
6 1 (0.31%) CIMA
6 1 (0.31%) ITIL Certification
6 1 (0.31%) MCP
Quality Assurance & Compliance
1 28 (8.75%) Data Quality
2 17 (5.31%) QA
3 1 (0.31%) PCI DSS
System Software
1 11 (3.44%) VMware ESX
2 9 (2.81%) Active Directory
3 5 (1.56%) VMware Infrastructure
Systems Management
1 4 (1.25%) SCCM
Vendors
1 224 (70.00%) Microsoft
2 95 (29.69%) Tableau
3 60 (18.75%) Cognos
4 25 (7.81%) Informatica
5 24 (7.50%) IBM
6 15 (4.69%) Talend
7 12 (3.75%) Capita
8 11 (3.44%) Ab Initio
8 11 (3.44%) DataFlux
8 11 (3.44%) Datanomic
8 11 (3.44%) MicroStrategy
8 11 (3.44%) Teradata
8 11 (3.44%) Trillium
9 10 (3.13%) Oracle
10 9 (2.81%) Hitachi
10 9 (2.81%) Symantec
11 8 (2.50%) VMware
12 7 (2.19%) Dell
12 7 (2.19%) HP
13 5 (1.56%) ESRI
London
Hitachi Consulting UK
Salary: From £35,000 to £80,000 per annum Incl Benefits + Bonus
Posted: 9 hours ago
Leatherhead, Surrey
Think IT Recruitment
Salary: £40000.00 - £50000.00 per annum + Bonus + Benefits
Posted: 11 hours ago
Leatherhead, Surrey
Think IT Recruitment
Salary: £30000.00 - £40000.00 per annum + package
Posted: 11 hours ago
Bury, Lancashire
DCS Recruitment
Salary: £35000 - £40000 per annum + Bens
Posted: 3 days ago
Central London
Bluefire Professional Services
Salary: £30,000 - £40,000 per year + fantastic benefits package
Posted: 3 days ago
City, London
Streamline Connections
Salary: £40000 - £50000 per annum + Benefits
Posted: 4 days ago
City, London
Streamline Connections
Salary: £40000 - £45000 per annum + Benefits
Posted: 5 days ago
Rochester, Kent
Bluetownonline
Posted: 6 days ago
Bury, Lancashire
Blue Octopus Recruitment LLP
Salary: Salary £27,886 - £32,431
Posted: 6 days ago
London
Blue Fire Professional Services
Salary: Unspecified circa £35,000 + fantastic benefits package
Posted: 6 days ago
Cardiff
Pertemps IT
Salary: Up tp £30k p.a. plus benefits
Posted: 10 days ago
Liverpool
Computer Futures
Salary: competitive
Posted: 12 days ago
Basingstoke
Langley James Limited
Salary: £24000 - £28000 per annum + 25 days A/L
Posted: 12 days ago
Coventry
Computer Futures
Salary: £5500 - £55000 per annum + competitive benefits
Posted: 19 days ago
Chorley
Applause IT Ltd
Salary: £25000 - £35000 per annum
Posted: 27 days ago