The table below looks at the statistics for PowerPivot skills in IT contracts advertised across the UK. Included is a guide to the contractor rates offered in IT contracts that have cited PowerPivot over the 3 months to 28 July 2016 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
28 Jul 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 610 574 556
Rank change year-on-year
-36 -18
Contract jobs citing PowerPivot 41 72 62
As % of all contract IT jobs located in the UK 0.076% 0.13% 0.11%
As % of the Database & Business Intelligence category 0.34% 0.55% 0.52%
Number of daily rates quoted 32 54 46
Median daily rate £373 £350 £330
Median daily rate % change year-on-year
+6.42% +6.06%
90% offered a daily rate of more than £273 £300 £186
10% offered a daily rate of more than £500 £496 £458
UK excluding London median daily rate £375 £338 £288
% change year-on-year
+11.11% +17.39%
Number of hourly rates quoted 3 3 1
Median hourly rate £27.00 £33.00 £175.00
Median hourly rate % change year-on-year
-18.18% -81.14%
UK excluding London median hourly rate £27.00 £33.00 £175.00
% change year-on-year
-18.18% -81.14%

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

Database & Business Intelligence Category
UK
Contract IT job ads with a match in the
Database & Business Intelligence category
12104 13209 12032
As % of all contract IT jobs located in the UK 22.41% 23.14% 21.97%
Number of daily rates quoted 8056 8627 7434
Median daily rate £425 £400 £400
Median daily rate % change year-on-year
+6.25% -
90% offered a daily rate of more than £300 £280 £270
10% offered a daily rate of more than £575 £550 £550
UK excluding London median daily rate £375 £360 £350
% change year-on-year
+4.16% +2.85%
Number of hourly rates quoted 214 191 201
Median hourly rate £29.94 £27.50 £27.50
Median hourly rate % change year-on-year
+8.87% -
90% offered a hourly rate of more than £12.00 £16.50 £13.00
10% offered a hourly rate of more than £49.00 £52.17 £52.55
UK excluding London median hourly rate £30.00 £28.00 £27.50
% change year-on-year
+7.14% +1.81%

PowerPivot
Jobs Demand Trend

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

PowerPivot Jobs Demand Trend in the UK

PowerPivot
Daily Rate Trend

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

PowerPivot Daily Rate Trend in the UK

PowerPivot
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing PowerPivot within the UK over the 3 months to 28 July 2016.

PowerPivot Daily Rate Histogram in the UK

PowerPivot
Hourly Rate Trend

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

PowerPivot Hourly Rate Trend in the UK

PowerPivot
Top 25 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing PowerPivot within the UK over the 3 months to 28 July 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
(Click see detailed
statistics and trends)
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
England -43 41 £373 +6.42% 18
London -5 22 £373 -9.69% 5
South East +9 6 £413 +37.50% 1
East of England - 6 £300 -
Essex - 5 £300 -
West Yorkshire -1 3 £425 +21.42% 2
Yorkshire -2 3 £425 +21.42% 3
Berkshire -1 2 £450 +233.33%
Leeds -6 2 £425 +21.42% 2
West Midlands -39 2 £394 +14.13% 2
East Midlands - 2 £250 - 2
Kent - 2 £400 -
Brentwood - 2 - -
City of London +31 1 £350 -17.64% 2
Maidenhead +2 1 - -
Hampshire +2 1 £425 +21.42%
Surrey -6 1 £275 -8.33%
Birmingham -11 1 £325 -5.79% 2
Northamptonshire - 1 £250 -
Paddington - 1 £198 -
Fareham - 1 £425 -
Kettering - 1 £250 -
Ipswich - 1 - -
Reigate - 1 £275 -
Suffolk - 1 - -

PowerPivot
Top 30 Related IT Skills

For the 6 months to 28 July 2016, 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 with a requirement for PowerPivot.

1 73 (83.91%) SQL
2 64 (73.56%) SQL Server
2 64 (73.56%) Business Intelligence
3 55 (63.22%) SQL Server Reporting Services
4 53 (60.92%) Microsoft
5 45 (51.72%) SQL Server Integration Services
6 36 (41.38%) MS Excel
6 36 (41.38%) SQL Server Analysis Services
7 33 (37.93%) Power BI
8 31 (35.63%) Data Warehouse
9 26 (29.89%) ETL
10 25 (28.74%) T-SQL
11 23 (26.44%) Finance
12 22 (25.29%) SQL Server 2012
13 21 (24.14%) Microsoft Power View
14 20 (22.99%) VBA
14 20 (22.99%) SharePoint
15 19 (21.84%) Data Analysis
15 19 (21.84%) Analytical Skills
16 17 (19.54%) SQL Server 2008
16 17 (19.54%) Agile Software Development
17 16 (18.39%) Data Modelling
17 16 (18.39%) Analytics
18 15 (17.24%) C#
19 14 (16.09%) Visual Studio
20 13 (14.94%) OLAP
20 13 (14.94%) Business Analysis
21 12 (13.79%) Visualisation
21 12 (13.79%) Data Quality
22 11 (12.64%) .NET

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 20 (22.99%) SharePoint
2 9 (10.34%) SAS
3 3 (3.45%) SharePoint 2013
4 2 (2.30%) CMS
4 2 (2.30%) SharePoint 2010
4 2 (2.30%) SharePoint Server
4 2 (2.30%) Sitefinity
5 1 (1.15%) Apache
Applications
1 36 (41.38%) MS Excel
2 9 (10.34%) MS Office
3 7 (8.05%) MS PowerPoint
4 4 (4.60%) Spreadsheet
5 2 (2.30%) InfoPath
5 2 (2.30%) MS Visio
Business Applications
1 5 (5.75%) Dynamics CRM
2 2 (2.30%) Maximo
3 1 (1.15%) SAP Oil and Gas
Cloud Services
1 6 (6.90%) Microsoft Azure
2 4 (4.60%) Office 365
3 2 (2.30%) SaaS
Communications & Networking
1 2 (2.30%) Intranet
2 1 (1.15%) Broadband
2 1 (1.15%) Internet
2 1 (1.15%) Wireless
Database & Business Intelligence
1 64 (73.56%) SQL Server
2 55 (63.22%) SQL Server Reporting Services
3 45 (51.72%) SQL Server Integration Services
4 36 (41.38%) SQL Server Analysis Services
5 33 (37.93%) Power BI
6 31 (35.63%) Data Warehouse
7 22 (25.29%) SQL Server 2012
8 21 (24.14%) Microsoft Power View
9 17 (19.54%) SQL Server 2008
10 13 (14.94%) OLAP
11 10 (11.49%) Microsoft Analysis Services
12 9 (10.34%) QlikView
13 6 (6.90%) BusinessObjects
13 6 (6.90%) SQL Server 2014
14 5 (5.75%) MS Access
14 5 (5.75%) PerformancePoint
14 5 (5.75%) Relational Database
14 5 (5.75%) SSDT
15 4 (4.60%) OLAP Cube
15 4 (4.60%) SQL Server 2005
Development Applications
1 14 (16.09%) Visual Studio
2 7 (8.05%) SQL Server Management Studio (SSMS)
3 6 (6.90%) Team Foundation Server
4 3 (3.45%) Visual Studio Tools for Office
5 1 (1.15%) JIRA
General
1 23 (26.44%) Finance
2 6 (6.90%) Marketing
3 4 (4.60%) Publishing
4 3 (3.45%) Advertising
4 3 (3.45%) Banking
4 3 (3.45%) Private Banking
5 2 (2.30%) Legal
5 2 (2.30%) Telecoms
6 1 (1.15%) Electronics
6 1 (1.15%) Manufacturing
6 1 (1.15%) Retail
Job Titles
1 39 (44.83%) Developer
2 29 (33.33%) Analyst
3 18 (20.69%) Business Intelligence Developer
4 17 (19.54%) SQL Developer
5 14 (16.09%) SSRS Developer
6 12 (13.79%) Business Analyst
6 12 (13.79%) SSIS Developer
7 10 (11.49%) SQL BI Developer
8 7 (8.05%) Business Intelligence Analyst
8 7 (8.05%) SQL Analyst
8 7 (8.05%) SQL Server Developer
9 6 (6.90%) Business Developer
9 6 (6.90%) Data Analyst
9 6 (6.90%) Report Developer
9 6 (6.90%) SQL Server BI Developer
9 6 (6.90%) SSAS Developer
10 5 (5.75%) Oracle Analyst
10 5 (5.75%) Oracle Business Analyst
10 5 (5.75%) QlikView Analyst
10 5 (5.75%) SAS Business Analyst
Libraries, Frameworks & Software Standards
1 11 (12.64%) .NET
2 8 (9.20%) MDX
3 7 (8.05%) XML
4 5 (5.75%) HTML
4 5 (5.75%) Web Services
5 4 (4.60%) ASP.NET
5 4 (4.60%) CSS
5 4 (4.60%) jQuery
6 3 (3.45%) SOAP
7 2 (2.30%) Ajax
7 2 (2.30%) ASP.NET Web API
7 2 (2.30%) COM
7 2 (2.30%) KnockoutJS
7 2 (2.30%) REST
7 2 (2.30%) XSLT
8 1 (1.15%) .NET Framework
8 1 (1.15%) CAML
8 1 (1.15%) HTML5
8 1 (1.15%) Web Services Management
8 1 (1.15%) XHTML
Miscellaneous
1 19 (21.84%) Analytical Skills
2 12 (13.79%) Visualisation
3 6 (6.90%) Management Information System
4 5 (5.75%) Data Integration
5 3 (3.45%) Data Extraction
5 3 (3.45%) Enterprise Software
5 3 (3.45%) Reinsurance
6 2 (2.30%) Digital Media
6 2 (2.30%) Minimum Viable Product
6 2 (2.30%) Mobile App
6 2 (2.30%) NHS
6 2 (2.30%) Statistics
6 2 (2.30%) Wiki
7 1 (1.15%) Algorithms
7 1 (1.15%) Computer Science
7 1 (1.15%) Data Structures
7 1 (1.15%) Economics
7 1 (1.15%) Mathematics
7 1 (1.15%) User Experience
7 1 (1.15%) Virtual Team
Operating Systems
1 2 (2.30%) Windows
2 1 (1.15%) Linux
2 1 (1.15%) Unix
2 1 (1.15%) Windows Server 2012
Processes & Methodologies
1 64 (73.56%) Business Intelligence
2 26 (29.89%) ETL
3 19 (21.84%) Data Analysis
4 17 (19.54%) Agile Software Development
5 16 (18.39%) Analytics
5 16 (18.39%) Data Modelling
6 13 (14.94%) Business Analysis
7 9 (10.34%) Dimensional Modelling
8 8 (9.20%) Migration
8 8 (9.20%) Validation
9 7 (8.05%) CRM
9 7 (8.05%) Data Visualisation
9 7 (8.05%) Performance Tuning
9 7 (8.05%) Stakeholder Management
9 7 (8.05%) Workflow
10 6 (6.90%) Data Management
10 6 (6.90%) Project Management
11 5 (5.75%) Data Migration
11 5 (5.75%) Programme Management
12 4 (4.60%) User Acceptance Testing
Programming Languages
1 73 (83.91%) SQL
2 25 (28.74%) T-SQL
3 20 (22.99%) VBA
4 15 (17.24%) C#
5 9 (10.34%) VB
6 8 (9.20%) Data Analysis Expressions (DAX)
7 6 (6.90%) Java
7 6 (6.90%) JavaScript
8 2 (2.30%) C
8 2 (2.30%) PowerShell
8 2 (2.30%) Python
8 2 (2.30%) R
9 1 (1.15%) Bash Shell
9 1 (1.15%) Perl
9 1 (1.15%) PHP
9 1 (1.15%) PL/SQL
9 1 (1.15%) Ruby
9 1 (1.15%) VB.NET
9 1 (1.15%) VBScript
Qualifications
1 4 (4.60%) Microsoft Certification
2 3 (3.45%) Degree
3 2 (2.30%) MCSD
4 1 (1.15%) ACCA
4 1 (1.15%) CIMA
4 1 (1.15%) ITIL Foundation Certificate
4 1 (1.15%) MBA
4 1 (1.15%) MCP
4 1 (1.15%) MCSE
4 1 (1.15%) SC Cleared
4 1 (1.15%) Security Cleared
Quality Assurance & Compliance
1 12 (13.79%) Data Quality
2 8 (9.20%) QA
3 2 (2.30%) SLA
4 1 (1.15%) Solvency II
Systems Management
1 1 (1.15%) Nagios
1 1 (1.15%) Opscode Chef
1 1 (1.15%) Puppet
1 1 (1.15%) Salt
1 1 (1.15%) WMI
Vendors
1 53 (60.92%) Microsoft
2 10 (11.49%) Oracle
2 10 (11.49%) Tableau
3 7 (8.05%) SAP
3 7 (8.05%) Teradata
4 3 (3.45%) Salesforce.com
5 2 (2.30%) Infor
5 2 (2.30%) Informatica
6 1 (1.15%) Remedy
London
Marcus Donald People
Rate: £450 - £550 per day
Posted: Yesterday