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 10 December 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
10 Dec 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 580 610 606
Rank change year-on-year
+30 -4
Contract jobs citing PowerPivot 34 39 42
As % of all contract IT jobs located in the UK 0.069% 0.071% 0.074%
As % of the Database & Business Intelligence category 0.31% 0.31% 0.35%
Number of daily rates quoted 19 30 25
Median daily rate £370 £400 £375
Median daily rate % change year-on-year
-7.50% +6.66%
90% offered a daily rate of more than £323 £283 £319
10% offered a daily rate of more than £525 £500 £438
UK excluding London median daily rate £370 £375 £350
% change year-on-year
-1.33% +7.14%
Number of hourly rates quoted 4 1 1
Median hourly rate £40.50 £15.00 £36.00
Median hourly rate % change year-on-year
+170.00% -58.33%
UK excluding London median hourly rate £40.50 £15.00 £36.00
% change year-on-year
+170.00% -58.33%

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
11129 12677 12105
As % of all contract IT jobs located in the UK 22.45% 23.05% 21.46%
Number of daily rates quoted 7386 8470 8029
Median daily rate £450 £425 £400
Median daily rate % change year-on-year
+5.88% +6.25%
90% offered a daily rate of more than £308 £300 £275
10% offered a daily rate of more than £600 £575 £550
UK excluding London median daily rate £400 £385 £363
% change year-on-year
+3.89% +6.20%
Number of hourly rates quoted 154 191 180
Median hourly rate £38.00 £24.50 £30.00
Median hourly rate % change year-on-year
+55.10% -18.33%
90% offered a hourly rate of more than £12.00 £12.00 £14.00
10% offered a hourly rate of more than £56.50 £45.00 £50.00
UK excluding London median hourly rate £38.00 £25.00 £33.50
% change year-on-year
+52.00% -25.37%

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 10 December 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
Hourly Rate Histogram

This chart provides a histogram of hourly rates quoted in contract IT jobs citing PowerPivot within the UK over the 3 months to 10 December 2016.

PowerPivot Hourly Rate Histogram in the UK

PowerPivot
Top 20 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 10 December 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 +13 33 £370 -7.50% 18
London +1 14 £419 +0.90% 5
South West - 10 £370 - 2
East Midlands +7 6 £356 -5.00%
Northamptonshire -10 6 £356 -5.00%
Northampton - 4 £356 -
Yeovil - 3 - -
Swindon - 3 £370 - 1
Bristol - 3 - -
Somerset - 3 - - 1
Wiltshire - 3 £370 - 1
North West -5 2 - - 3
Lancashire -6 2 - - 1
South East +13 1 £450 -5.26% 5
Berkshire +7 1 £450 - 1
City of London -16 1 - - 2
Slough - 1 £450 - 1
Devon - 1 £315 -
Edinburgh - 1 - -
Scotland - 1 - -

PowerPivot
Top 30 Related IT Skills

For the 6 months to 10 December 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 57 (71.25%) Business Intelligence
2 56 (70.00%) SQL Server Reporting Services
3 55 (68.75%) SQL
3 55 (68.75%) SQL Server
4 49 (61.25%) Microsoft
5 45 (56.25%) SQL Server Integration Services
6 35 (43.75%) MS Excel
7 34 (42.50%) Power BI
8 33 (41.25%) SQL Server Analysis Services
9 32 (40.00%) T-SQL
10 28 (35.00%) Data Warehouse
11 26 (32.50%) ETL
12 25 (31.25%) Microsoft Power View
13 23 (28.75%) Agile Software Development
14 20 (25.00%) Finance
15 19 (23.75%) SQL Server 2012
16 18 (22.50%) SharePoint
17 16 (20.00%) C#
17 16 (20.00%) Analytics
18 15 (18.75%) Data Modelling
19 14 (17.50%) Data Quality
20 13 (16.25%) Data Visualisation
20 13 (16.25%) Analytical Skills
20 13 (16.25%) Visualisation
21 12 (15.00%) Visual Studio
22 11 (13.75%) .NET
23 9 (11.25%) JavaScript
23 9 (11.25%) VBA
23 9 (11.25%) MS Office
23 9 (11.25%) Microsoft Analysis Services

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 18 (22.50%) SharePoint
2 7 (8.75%) SharePoint 2010
2 7 (8.75%) SharePoint 2013
3 4 (5.00%) IIS
3 4 (5.00%) SharePoint Server
4 2 (2.50%) SAS
Applications
1 35 (43.75%) MS Excel
2 9 (11.25%) MS Office
3 7 (8.75%) MS PowerPoint
4 4 (5.00%) InfoPath
4 4 (5.00%) Spreadsheet
5 2 (2.50%) MS Project
5 2 (2.50%) SPSS
Business Applications
1 2 (2.50%) Dynamics NAV
2 1 (1.25%) Dynamics AX
2 1 (1.25%) Dynamics CRM
Cloud Services
1 9 (11.25%) Microsoft Azure
2 6 (7.50%) Office 365
3 4 (5.00%) IaaS
3 4 (5.00%) PaaS
4 1 (1.25%) Google Analytics
Communications & Networking
1 4 (5.00%) LDAP
2 1 (1.25%) Intranet
2 1 (1.25%) Wireless
Database & Business Intelligence
1 56 (70.00%) SQL Server Reporting Services
2 55 (68.75%) SQL Server
3 45 (56.25%) SQL Server Integration Services
4 34 (42.50%) Power BI
5 33 (41.25%) SQL Server Analysis Services
6 28 (35.00%) Data Warehouse
7 25 (31.25%) Microsoft Power View
8 19 (23.75%) SQL Server 2012
9 9 (11.25%) Microsoft Analysis Services
9 9 (11.25%) SQL Server 2008
10 8 (10.00%) OLAP
10 8 (10.00%) PerformancePoint
10 8 (10.00%) SQL Server 2014
11 5 (6.25%) Relational Database
11 5 (6.25%) SQL Server 2016
12 4 (5.00%) OLAP Cube
12 4 (5.00%) Star Schema
13 3 (3.75%) Big Data
13 3 (3.75%) BusinessObjects
13 3 (3.75%) MS Access
Development Applications
1 12 (15.00%) Visual Studio
2 6 (7.50%) Team Foundation Server
3 2 (2.50%) Visual Studio Tools for Office
4 1 (1.25%) MSTest
4 1 (1.25%) NUnit
General
1 20 (25.00%) Finance
2 5 (6.25%) Legal
3 4 (5.00%) Marketing
4 3 (3.75%) Retail
5 2 (2.50%) Advertising
6 1 (1.25%) Aerospace
6 1 (1.25%) Back Office
6 1 (1.25%) Banking
6 1 (1.25%) Front Office
6 1 (1.25%) Games
6 1 (1.25%) Investment Banking
Job Titles
1 36 (45.00%) Developer
2 21 (26.25%) Analyst
3 13 (16.25%) Business Intelligence Developer
3 13 (16.25%) SQL Developer
4 8 (10.00%) Architect
5 7 (8.75%) Business Intelligence Analyst
5 7 (8.75%) Data Analyst
6 6 (7.50%) Report Developer
7 5 (6.25%) Business Analyst
7 5 (6.25%) Designer
7 5 (6.25%) SharePoint Developer
7 5 (6.25%) SSRS Developer
8 4 (5.00%) Data Manager
8 4 (5.00%) Database Developer
8 4 (5.00%) SQL BI Developer
8 4 (5.00%) SSAS Developer
8 4 (5.00%) Web Architect
9 3 (3.75%) Office 365 Architect
9 3 (3.75%) SharePoint Architect
9 3 (3.75%) SSIS Developer
Libraries, Frameworks & Software Standards
1 11 (13.75%) .NET
2 8 (10.00%) XML
3 6 (7.50%) ASP.NET
3 6 (7.50%) D3.js
3 6 (7.50%) jQuery
4 5 (6.25%) Ajax
4 5 (6.25%) HTML
4 5 (6.25%) MDX
4 5 (6.25%) Web Services
5 4 (5.00%) KnockoutJS
5 4 (5.00%) XSL
6 1 (1.25%) CSS
6 1 (1.25%) HTML5
6 1 (1.25%) XHTML
6 1 (1.25%) XSLT
Miscellaneous
1 13 (16.25%) Analytical Skills
1 13 (16.25%) Visualisation
2 5 (6.25%) Management Information System
3 4 (5.00%) NHS
3 4 (5.00%) Reinsurance
4 3 (3.75%) Statistics
5 2 (2.50%) Data Structures
5 2 (2.50%) Digital Media
6 1 (1.25%) Computer Science
6 1 (1.25%) Enterprise Software
6 1 (1.25%) FMCG
6 1 (1.25%) IVR
6 1 (1.25%) Mainframe
6 1 (1.25%) RIA
6 1 (1.25%) User Experience
Operating Systems
1 5 (6.25%) Windows
2 3 (3.75%) Windows Server 2012
Processes & Methodologies
1 57 (71.25%) Business Intelligence
2 26 (32.50%) ETL
3 23 (28.75%) Agile Software Development
4 16 (20.00%) Analytics
5 15 (18.75%) Data Modelling
6 13 (16.25%) Data Visualisation
7 8 (10.00%) Mentoring
8 7 (8.75%) Data Analysis
8 7 (8.75%) Project Management
8 7 (8.75%) Workflow
9 6 (7.50%) Coaching
10 5 (6.25%) Information Management
10 5 (6.25%) Kimball Methodology
10 5 (6.25%) Migration
11 4 (5.00%) Content Management
11 4 (5.00%) Data Migration
11 4 (5.00%) Dimensional Modelling
11 4 (5.00%) Enterprise Content Management
11 4 (5.00%) Software Engineering
11 4 (5.00%) Waterfall
Programming Languages
1 55 (68.75%) SQL
2 32 (40.00%) T-SQL
3 16 (20.00%) C#
4 9 (11.25%) JavaScript
4 9 (11.25%) PowerShell
4 9 (11.25%) VBA
5 5 (6.25%) Data Analysis Expressions (DAX)
5 5 (6.25%) VB
6 2 (2.50%) VB.NET
6 2 (2.50%) VBScript
7 1 (1.25%) C
7 1 (1.25%) C++
Qualifications
1 8 (10.00%) Degree
2 7 (8.75%) Microsoft Certification
3 5 (6.25%) Security Cleared
4 3 (3.75%) SC Cleared
5 2 (2.50%) MCDBA
5 2 (2.50%) MCITP
5 2 (2.50%) MCPD
5 2 (2.50%) MCSA
5 2 (2.50%) MCSD
5 2 (2.50%) MCSE
6 1 (1.25%) ACCA
6 1 (1.25%) BPSS Clearance
6 1 (1.25%) CIMA
6 1 (1.25%) MCP
Quality Assurance & Compliance
1 14 (17.50%) Data Quality
2 8 (10.00%) QA
3 2 (2.50%) Disclosure Scotland
Systems Management
1 4 (5.00%) CA Single Sign-On
Vendors
1 49 (61.25%) Microsoft
2 6 (7.50%) Oracle
3 4 (5.00%) Akamai
3 4 (5.00%) F5
3 4 (5.00%) Riverbed
4 2 (2.50%) SAP
4 2 (2.50%) Tableau
4 2 (2.50%) Teradata
5 1 (1.25%) Ab Initio
5 1 (1.25%) Cognos
5 1 (1.25%) Google
5 1 (1.25%) Remedy
5 1 (1.25%) Salesforce.com
Lancashire
HAYS INFORMATION TECHNOLOGY
Rate: £250.00 - £300.00 per day
Posted: 2 days ago
Cambridge
Bluetown Online LTD
Rate: £26000 - £30000 per annum
Posted: 18 days ago
Sheffield
Bluetown Online LTD
Rate: £26000 per annum
Posted: 18 days ago