Period
to 22 November 2017

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 6 months to 22 November 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
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 749 788 772
Rank change year-on-year +39 -16 -23
Contract jobs citing PowerPivot 102 78 96
As % of all contract IT jobs advertised in England 0.11% 0.080% 0.093%
As % of the Database & Business Intelligence category 0.49% 0.35% 0.40%
Number of daily rates quoted 71 57 66
England median daily rate £460 £375 £400
Median daily rate % change year-on-year +22.67% -6.25% +12.68%
10th Percentile £363 £295 £291
90th Percentile £625 £518 £525
UK median daily rate £450 £375 £400
% change year-on-year +20.00% -6.25% +12.68%
Number of hourly rates quoted 8 3 3
England median hourly rate £21.50 £26.50 £33.00
Median hourly rate % change year-on-year -18.87% -19.70% -68.72%
10th Percentile £18.50 £20.35 £31.80
90th Percentile £22.25 £27.25 £34.90
UK median hourly rate £21.50 £26.50 £33.00
% change year-on-year -18.87% -19.70% -8.33%

PowerPivot is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Contract vacancies with a requirement for database or business intelligence skills 20954 22096 24092
As % of all contract IT jobs advertised in England 22.08% 22.56% 23.39%
Number of daily rates quoted 14518 14800 16043
England median daily rate £460 £425 £413
Median daily rate % change year-on-year +8.24% +3.03% +3.13%
10th Percentile £313 £290 £275
90th Percentile £638 £600 £588
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% +0.63%
Number of hourly rates quoted 266 319 380
England median hourly rate £31.75 £28.00 £27.89
Median hourly rate % change year-on-year +13.39% +0.39% +13.84%
10th Percentile £14.39 £11.20 £12.00
90th Percentile £56.18 £48.15 £52.17
UK median hourly rate £31.23 £28.00 £28.75
% change year-on-year +11.54% -2.61% +15.00%

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 6 months to 22 November 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 6 months to 22 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
London -1 71 £500 +23.08% 4
South East +13 11 £400 -5.88% 1
Midlands +24 10 £450 +33.33%
North of England +70 9 £450 +20.00% 1
West Midlands +33 8 £450 +14.29%
North West +16 6 £450 - 1
Yorkshire +18 2 £375 -
East Midlands -10 2 £425 +25.93%
East of England -11 2 £325 -
North East - 1 - -
PowerPivot
UK

For the 6 months to 22 November 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 83 (81.37%) Business Intelligence
2 77 (75.49%) Microsoft
3 74 (72.55%) SQL Server Reporting Services
4 65 (63.73%) SQL
5 64 (62.75%) Power BI
6 51 (50.00%) SQL Server
7 48 (47.06%) ETL
7 48 (47.06%) Data Warehouse
8 46 (45.10%) SQL Server Integration Services
9 43 (42.16%) Data Analysis Expressions (DAX)
10 42 (41.18%) Microsoft Excel
11 41 (40.20%) MDX
12 32 (31.37%) T-SQL
12 32 (31.37%) SQL Server Analysis Services
13 31 (30.39%) Finance
14 26 (25.49%) Kimball Methodology
15 23 (22.55%) Visualisation
15 23 (22.55%) Microsoft Power View
16 22 (21.57%) Data Modelling
16 22 (21.57%) Tableau
17 21 (20.59%) Dimensional Modelling
18 19 (18.63%) OLAP
18 19 (18.63%) Agile Software Development
18 19 (18.63%) Banking
19 18 (17.65%) Legal
20 16 (15.69%) C#
20 16 (15.69%) Data Visualisation
20 16 (15.69%) Analytics
20 16 (15.69%) Logical Data Model
20 16 (15.69%) Physical Data Model

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 15 (14.71%) SharePoint
2 6 (5.88%) SAS
3 2 (1.96%) SharePoint 2010
4 1 (0.98%) Apache Spark
4 1 (0.98%) IIS
Applications
1 42 (41.18%) Microsoft Excel
2 10 (9.80%) Microsoft Office
3 2 (1.96%) Microsoft PowerPoint
3 2 (1.96%) Microsoft Project
3 2 (1.96%) MS Visio
3 2 (1.96%) Spreadsheet
3 2 (1.96%) SPSS
Business Applications
1 2 (1.96%) Dynamics CRM
1 2 (1.96%) iTrent
Cloud Services
1 6 (5.88%) Microsoft Azure
2 1 (0.98%) Data Lake Analytics
Database & Business Intelligence
1 74 (72.55%) SQL Server Reporting Services
2 64 (62.75%) Power BI
3 51 (50.00%) SQL Server
4 48 (47.06%) Data Warehouse
5 46 (45.10%) SQL Server Integration Services
6 32 (31.37%) SQL Server Analysis Services
7 23 (22.55%) Microsoft Power View
8 19 (18.63%) OLAP
9 14 (13.73%) SQL Server 2014
10 13 (12.75%) QlikView
11 12 (11.76%) Microsoft Analysis Services
11 12 (11.76%) SQL Server 2008
11 12 (11.76%) SQL Server 2016
12 8 (7.84%) OLAP Cube
13 7 (6.86%) Big Data
13 7 (6.86%) Relational Database
14 6 (5.88%) BusinessObjects
14 6 (5.88%) RDBMS
14 6 (5.88%) Star Schema
15 4 (3.92%) SQL Server 2012
Development Applications
1 10 (9.80%) Team Foundation Server
2 4 (3.92%) Git (software)
2 4 (3.92%) Subversion
3 2 (1.96%) Visual Studio
General
1 31 (30.39%) Finance
2 19 (18.63%) Banking
3 18 (17.65%) Legal
4 8 (7.84%) Retail Banking
5 6 (5.88%) Law
5 6 (5.88%) Publishing
6 4 (3.92%) Retail
7 2 (1.96%) International Banking
8 1 (0.98%) Advertising
8 1 (0.98%) Financial Institution
8 1 (0.98%) Front Office
8 1 (0.98%) Investment Banking
8 1 (0.98%) Marketing
Job Titles
1 63 (61.76%) Developer
2 55 (53.92%) Business Intelligence Developer
3 31 (30.39%) Analyst
4 23 (22.55%) Business Developer
5 16 (15.69%) Data Analyst
6 9 (8.82%) Power BI Developer
6 9 (8.82%) Senior Business Intelligence Developer
6 9 (8.82%) Senior Developer
7 8 (7.84%) Business Intelligence Consultant
7 8 (7.84%) Consultant
7 8 (7.84%) JavaScript Developer
7 8 (7.84%) SQL Developer
7 8 (7.84%) SSIS Developer
8 7 (6.86%) Business Intelligence Analyst
8 7 (6.86%) C# Developer
8 7 (6.86%) Power BI Consultant
8 7 (6.86%) SQL BI Developer
8 7 (6.86%) SSAS Developer
8 7 (6.86%) SSRS Developer
9 6 (5.88%) Banking Analyst
Libraries, Frameworks & Software Standards
1 41 (40.20%) MDX
2 10 (9.80%) COM
3 8 (7.84%) D3.js
4 5 (4.90%) .NET
5 4 (3.92%) Web Services
6 3 (2.94%) Spring
6 3 (2.94%) XML
7 1 (0.98%) TensorFlow
Miscellaneous
1 11 (10.78%) Analytical Skills
2 8 (7.84%) Hedge funds
2 8 (7.84%) Management Information System
3 4 (3.92%) Reinsurance
4 3 (2.94%) Equities
4 3 (2.94%) Market Risk
5 2 (1.96%) Analytical Mindset
5 2 (1.96%) Credit Risk
6 1 (0.98%) Algorithms
6 1 (0.98%) Computer Science
6 1 (0.98%) Data Structures
6 1 (0.98%) FMCG
6 1 (0.98%) Greenfield Project
6 1 (0.98%) iPad
6 1 (0.98%) NHS
6 1 (0.98%) Reference Data
6 1 (0.98%) Social Network
6 1 (0.98%) Taxonomies
Operating Systems
1 1 (0.98%) Windows
1 1 (0.98%) Windows Server 2008
1 1 (0.98%) Windows Server 2012
Processes & Methodologies
1 83 (81.37%) Business Intelligence
2 48 (47.06%) ETL
3 26 (25.49%) Kimball Methodology
4 23 (22.55%) Visualisation
5 22 (21.57%) Data Modelling
6 21 (20.59%) Dimensional Modelling
7 19 (18.63%) Agile Software Development
8 16 (15.69%) Analytics
8 16 (15.69%) Data Visualisation
8 16 (15.69%) Logical Data Model
8 16 (15.69%) Physical Data Model
9 11 (10.78%) Information Governance
9 11 (10.78%) Migration
10 9 (8.82%) Data Analysis
10 9 (8.82%) Data Management
11 8 (7.84%) Complex ETL
11 8 (7.84%) Statistics
12 6 (5.88%) Dashboard Development
12 6 (5.88%) Kanban
13 5 (4.90%) ETL Development
Programming Languages
1 65 (63.73%) SQL
2 43 (42.16%) Data Analysis Expressions (DAX)
3 32 (31.37%) T-SQL
4 16 (15.69%) C#
5 11 (10.78%) VBA
6 10 (9.80%) R
7 9 (8.82%) JavaScript
8 7 (6.86%) Python
9 4 (3.92%) Java
9 4 (3.92%) PowerShell
10 3 (2.94%) Perl
10 3 (2.94%) PL/SQL
11 1 (0.98%) MATLAB
11 1 (0.98%) VB
Qualifications
1 10 (9.80%) Degree
2 3 (2.94%) Master's Degree
3 1 (0.98%) BPSS Clearance
3 1 (0.98%) Numerate Degree
3 1 (0.98%) Security Cleared
Quality Assurance & Compliance
1 7 (6.86%) Data Quality
2 4 (3.92%) QA
3 3 (2.94%) GDPR
Systems Management
1 1 (0.98%) EMC NetWorker
Vendors
1 77 (75.49%) Microsoft
2 22 (21.57%) Tableau
3 7 (6.86%) Oracle
4 2 (1.96%) Cognos
4 2 (1.96%) Salesforce.com
4 2 (1.96%) SAP
4 2 (1.96%) Teradata
5 1 (0.98%) Alteryx
5 1 (0.98%) MicroStrategy
5 1 (0.98%) TIBCO