The following table provides summary statistics for contract job vacancies advertised in England with a requirement for PowerPivot skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited PowerPivot over the 3 months to 29 June 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Microsoft Power Pivot
UK > England
3 months to
29 Jun 2017
Same period 2016 Same period 2015
Rank 551 589 552
Rank change year-on-year +38 -37  
Contract jobs citing PowerPivot 43 33 89
As % of all contract IT jobs advertised in England 0.099% 0.067% 0.17%
As % of the Database & Business Intelligence category 0.44% 0.31% 0.74%
Number of daily rates quoted 29 21 72
England median daily rate £460 £370 £400
Median daily rate % change year-on-year +24.32% -7.50%  
10th Percentile £150 £263 £306
90th Percentile £575 £625 £548
UK median daily rate £460 £370 £400
% change year-on-year +24.32% -7.50%  
Number of hourly rates quoted 4 4 4
England median hourly rate £20.25 £27.00 £33.00
Median hourly rate % change year-on-year -25.00% -18.18%  
10th Percentile £18.50 £27.00 £20.30
90th Percentile £22.25 £35.23 £34.85
UK median hourly rate £20.25 £27.00 £33.00
% change year-on-year -25.00% -18.18%  

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 contract job vacancies advertised in England with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills
England
Contract job vacancies with a requirement for database and business intelligence skills 9680 10741 12064
As % of all contract IT job vacancies advertised in England 22.39% 21.79% 23.65%
Number of daily rates quoted 14278 16260 18628
England median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25%  
10th Percentile £313 £300 £269
90th Percentile £625 £600 £575
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25%  
Number of hourly rates quoted 214 290 328
England median hourly rate £31.00 £30.75 £25.83
Median hourly rate % change year-on-year +0.81% +19.04%  
10th Percentile £12.00 £12.00 £15.00
90th Percentile £50.00 £51.00 £52.17
UK median hourly rate £31.25 £31.90 £26.75
% change year-on-year -2.03% +19.25%  

PowerPivot
Job Vacancy Trend in England

Job postings citing PowerPivot as a percentage of all IT jobs advertised in England.

Job vacancy trend for PowerPivot in England

PowerPivot
Contractor Daily Rate Trend in England

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing PowerPivot in England.

Contractor daily rate trend for PowerPivot in England

PowerPivot
Contractor Daily Rate Histogram in England

The daily rate distribution of IT jobs citing PowerPivot in England over the 3 months to 29 June 2017.

Contractor daily rate histogram for PowerPivot in England

PowerPivot
Contractor Hourly Rate Trend in England

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing PowerPivot in England.

Contractor hourly rate trend for PowerPivot in England

PowerPivot
Contract Job Locations in England

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing PowerPivot within the England region over the 3 months to 29 June 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
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
London +20 30 £525 +31.25% 6
South East +21 11 £263 -36.36% 1
Midlands +12 1 £400 +39.13%
South West +1 1 £375 -
East Midlands -4 1 £400 +60.00%
PowerPivot
UK

For the 6 months to 29 June 2017, IT contractor jobs citing PowerPivot also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the England region with a requirement for PowerPivot.

1 46 (75.41%) Business Intelligence
2 43 (70.49%) SQL
3 42 (68.85%) Microsoft
4 39 (63.93%) SQL Server Reporting Services
5 33 (54.10%) Microsoft Excel
6 31 (50.82%) Power BI
7 29 (47.54%) SQL Server
8 22 (36.07%) SQL Server Integration Services
9 21 (34.43%) Data Warehouse
10 20 (32.79%) SQL Server Analysis Services
11 17 (27.87%) T-SQL
12 16 (26.23%) Analytics
12 16 (26.23%) Data Analysis Expressions (DAX)
13 15 (24.59%) Data Analysis
13 15 (24.59%) ETL
14 14 (22.95%) OLAP
15 13 (21.31%) VBA
15 13 (21.31%) Data Modelling
15 13 (21.31%) MDX
15 13 (21.31%) Visualisation
15 13 (21.31%) Dashboard Development
16 12 (19.67%) Data Visualisation
17 11 (18.03%) Data Extraction
18 10 (16.39%) Dimensional Modelling
18 10 (16.39%) Finance
18 10 (16.39%) Kimball Methodology
19 9 (14.75%) Microsoft Analysis Services
19 9 (14.75%) Agile Software Development
20 8 (13.11%) R
20 8 (13.11%) Analytical Skills

PowerPivot
Co-occurring 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 7 (11.48%) SharePoint
2 2 (3.28%) Apache Solr
2 2 (3.28%) Apache Spark
2 2 (3.28%) SharePoint 2010
3 1 (1.64%) SAS
3 1 (1.64%) SharePoint Server
Applications
1 33 (54.10%) Microsoft Excel
2 6 (9.84%) Microsoft Office
3 3 (4.92%) Spreadsheet
4 2 (3.28%) Microsoft PowerPoint
Business Applications
1 2 (3.28%) iTrent
Cloud Services
1 1 (1.64%) Microsoft Azure
Database & Business Intelligence
1 39 (63.93%) SQL Server Reporting Services
2 31 (50.82%) Power BI
3 29 (47.54%) SQL Server
4 22 (36.07%) SQL Server Integration Services
5 21 (34.43%) Data Warehouse
6 20 (32.79%) SQL Server Analysis Services
7 14 (22.95%) OLAP
8 9 (14.75%) Microsoft Analysis Services
9 7 (11.48%) Microsoft Power View
10 6 (9.84%) QlikView
11 5 (8.20%) SQL Server 2014
12 4 (6.56%) SQL Server 2008
12 4 (6.56%) SQL Server 2016
13 3 (4.92%) Apache Hive
13 3 (4.92%) BusinessObjects
13 3 (4.92%) Data Mining
13 3 (4.92%) Hadoop
13 3 (4.92%) OLAP Cube
14 2 (3.28%) Big Data
14 2 (3.28%) PerformancePoint
Development Applications
1 4 (6.56%) Team Foundation Server
1 4 (6.56%) Visual Studio
2 1 (1.64%) SQL Server Management Studio (SSMS)
General
1 10 (16.39%) Finance
2 7 (11.48%) Legal
3 3 (4.92%) Banking
4 2 (3.28%) Publishing
5 1 (1.64%) Law
5 1 (1.64%) Retail
Job Titles
1 26 (42.62%) Analyst
2 24 (39.34%) Developer
3 19 (31.15%) Business Intelligence Developer
4 17 (27.87%) Data Analyst
5 10 (16.39%) Excel Analyst
6 9 (14.75%) Power BI Developer
7 7 (11.48%) Report Analyst
8 6 (9.84%) Business Developer
9 5 (8.20%) Business Intelligence Analyst
9 5 (8.20%) JavaScript Developer
9 5 (8.20%) SQL Developer
10 4 (6.56%) Business Intelligence Consultant
10 4 (6.56%) Consultant
10 4 (6.56%) SSAS Developer
11 3 (4.92%) Business Systems Analyst
11 3 (4.92%) Insurance Systems Analyst
11 3 (4.92%) Power BI Consultant
11 3 (4.92%) SSRS Developer
11 3 (4.92%) Systems Analyst
12 2 (3.28%) Architect
Libraries, Frameworks & Software Standards
1 13 (21.31%) MDX
2 7 (11.48%) D3.js
3 4 (6.56%) COM
4 2 (3.28%) .NET
5 1 (1.64%) ASP.NET
5 1 (1.64%) WinForms
5 1 (1.64%) WPF
5 1 (1.64%) XML
5 1 (1.64%) XSLT
Miscellaneous
1 8 (13.11%) Analytical Skills
2 7 (11.48%) Hedge funds
3 5 (8.20%) Reinsurance
4 2 (3.28%) Enterprise Software
4 2 (3.28%) NHS
5 1 (1.64%) Reference Data
5 1 (1.64%) Smart Meter
Operating Systems
1 1 (1.64%) Windows
Processes & Methodologies
1 46 (75.41%) Business Intelligence
2 16 (26.23%) Analytics
3 15 (24.59%) Data Analysis
3 15 (24.59%) ETL
4 13 (21.31%) Dashboard Development
4 13 (21.31%) Data Modelling
4 13 (21.31%) Visualisation
5 12 (19.67%) Data Visualisation
6 11 (18.03%) Data Extraction
7 10 (16.39%) Dimensional Modelling
7 10 (16.39%) Kimball Methodology
8 9 (14.75%) Agile Software Development
9 8 (13.11%) Logical Data Model
9 8 (13.11%) Physical Data Model
10 3 (4.92%) Customer Insight
10 3 (4.92%) Data Mapping
10 3 (4.92%) Statistics
11 2 (3.28%) Data Analytics
11 2 (3.28%) Informatics
11 2 (3.28%) Kanban
Programming Languages
1 43 (70.49%) SQL
2 17 (27.87%) T-SQL
3 16 (26.23%) Data Analysis Expressions (DAX)
4 13 (21.31%) VBA
5 8 (13.11%) R
6 7 (11.48%) JavaScript
7 3 (4.92%) C#
7 3 (4.92%) Python
8 1 (1.64%) VB
Qualifications
1 1 (1.64%) Degree
Quality Assurance & Compliance
1 4 (6.56%) Data Quality
1 4 (6.56%) QA
2 1 (1.64%) PMO
Systems Management
1 2 (3.28%) EMC NetWorker
Vendors
1 42 (68.85%) Microsoft
2 5 (8.20%) Tableau
3 2 (3.28%) Minitab
4 1 (1.64%) Oracle
4 1 (1.64%) Teradata
4 1 (1.64%) TIBCO
4 1 (1.64%) Workday
City, London
Ebury
Rate: £20.00 - £23.00 per hour
Posted: Yesterday