The table below looks at the statistics for PowerPivot skills in IT contracts advertised for the City of London region. Included is a guide to the average contractor rates offered in IT contracts that have cited PowerPivot over the 3 months to 3 September 2015 with a comparison to the same period in 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.

Location
3 months to
3 Sep 2015
Same period 2014 Same period 2013
Microsoft PowerPivot
Rank 183 191 220
Rank change year-on-year
+8 +29
Contract jobs citing PowerPivot 11 15 8
As % of all contract IT jobs located in the City of London 0.21% 0.26% 0.11%
As % of the Applications category 1.67% 2.05% 0.89%
Number of daily rates quoted 9 13 7
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£425 £400 £320
Average daily rate % change year-on-year
+6.25% +25.00%
90% offered a daily rate of more than £324 £350 £315
10% offered a daily rate of more than £523 £600 £418
UK excluding London average daily rate £363 £250 £285
% change year-on-year
+45.00% -12.28%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £33.00 £96.25 £36.00
% change year-on-year
-65.71% +167.36%
PowerPivot
London

The following table is for comparison with the above and provides statistics for the entire Applications category in contract jobs advertised in the City of London region.

Applications Category
City of London
Contract IT job ads with a match in the
Applications category
659 732 900
As % of all contract IT jobs located in the City of London 12.52% 12.44% 12.31%
Number of daily rates quoted 487 503 588
Average daily rate £375 £364 £375
Average daily rate % change year-on-year
+3.09% -3.00%
90% offered a daily rate of more than £200 £165 £173
10% offered a daily rate of more than £600 £550 £550
UK excluding London average daily rate £325 £325 £313
% change year-on-year
- +4.00%
Number of hourly rates quoted 31 42 55
Average hourly rate £13.98 £20.50 £19.25
Average hourly rate % change year-on-year
-31.80% +6.49%
90% offered a hourly rate of more than £9.50 £11.50 £13.50
10% offered a hourly rate of more than £21.50 £26.40 £60.80
UK excluding London average hourly rate £14.51 £15.39 £15.50
% change year-on-year
-5.68% -0.74%

PowerPivot
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of IT contractor jobs citing PowerPivot across the City of London region as a proportion of the total demand within the Applications category.

PowerPivot Jobs Demand Trend in the City of London

PowerPivot
Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing PowerPivot across the City of London region.

PowerPivot Daily Rate Trend in the City of London

PowerPivot
Daily Rate Histogram in the City of London

This chart provides a histogram of daily rates quoted in contract IT jobs citing PowerPivot across the City of London region over the 3 months to 3 September 2015.

PowerPivot Daily Rate Histogram in the City of London

PowerPivot
Top 30 Related IT Skills in the City of London

For the 6 months to 3 September 2015, IT contractor jobs across the City of London region 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 contract IT job ads sampled that cited PowerPivot.

1 24 (88.89%) Business Intelligence
2 18 (66.67%) SQL
2 18 (66.67%) SQL Server
2 18 (66.67%) SQL Server Analysis Services
2 18 (66.67%) Microsoft Power View
3 17 (62.96%) Data Warehouse
3 17 (62.96%) SQL Server Reporting Services
4 16 (59.26%) SQL Server Integration Services
5 15 (55.56%) Microsoft
6 13 (48.15%) T-SQL
6 13 (48.15%) SQL Server 2012
7 12 (44.44%) MS Excel
7 12 (44.44%) SharePoint
8 10 (37.04%) OLAP
9 9 (33.33%) Agile Software Development
10 8 (29.63%) Data Analysis Expressions (DAX)
10 8 (29.63%) MDX
10 8 (29.63%) Analytical Skills
11 7 (25.93%) Data Quality
11 7 (25.93%) C#
12 6 (22.22%) Advertising
13 5 (18.52%) Retail
13 5 (18.52%) Finance
13 5 (18.52%) ETL
13 5 (18.52%) Kimball Methodology
13 5 (18.52%) Performance Tuning
14 4 (14.81%) Master Data Management
14 4 (14.81%) Marketing
14 4 (14.81%) NHS
14 4 (14.81%) BusinessObjects

PowerPivot
Top Related IT Skills in the City of London by Category

For the 6 months to 3 September 2015, IT contractor jobs across the City of London region 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 contract IT job ads sampled that cited PowerPivot. Up to 20 skills are shown per category.

Application Platforms
1 12 (44.44%) SharePoint
2 2 (7.41%) BizTalk Server
2 2 (7.41%) SharePoint Server
3 1 (3.70%) SharePoint 2013
Applications
1 12 (44.44%) MS Excel
2 3 (11.11%) MS Office
Cloud Services
1 1 (3.70%) Microsoft Azure
1 1 (3.70%) SaaS
Database & Business Intelligence
1 18 (66.67%) SQL Server
1 18 (66.67%) SQL Server Analysis Services
1 18 (66.67%) Microsoft Power View
2 17 (62.96%) SQL Server Reporting Services
2 17 (62.96%) Data Warehouse
3 16 (59.26%) SQL Server Integration Services
4 13 (48.15%) SQL Server 2012
5 10 (37.04%) OLAP
6 4 (14.81%) BusinessObjects
7 3 (11.11%) OLAP Cube
8 2 (7.41%) Star Schema
8 2 (7.41%) Crystal Reports
8 2 (7.41%) QlikView
8 2 (7.41%) BusinessObjects Web Intelligence
8 2 (7.41%) Microsoft Analysis Services
8 2 (7.41%) PerformancePoint
9 1 (3.70%) SQL Server 2008
9 1 (3.70%) Data Mart
9 1 (3.70%) Oracle Reports
9 1 (3.70%) SAP BI
Development Applications
1 2 (7.41%) Visual Studio
1 2 (7.41%) SQL Server Management Studio (SSMS)
2 1 (3.70%) Team Foundation Server
General
1 6 (22.22%) Advertising
2 5 (18.52%) Finance
2 5 (18.52%) Retail
3 4 (14.81%) Marketing
4 2 (7.41%) Music Industry
4 2 (7.41%) Publishing
5 1 (3.70%) Legal
Job Titles
1 14 (51.85%) Developer
2 9 (33.33%) Business Developer
2 9 (33.33%) Business Intelligence Developer
3 8 (29.63%) Analyst
4 4 (14.81%) Senior Developer
5 3 (11.11%) Architect
5 3 (11.11%) Senior Business Intelligence Developer
6 2 (7.41%) Business Intelligence Analyst
6 2 (7.41%) NHS Information Analyst
6 2 (7.41%) Business Intelligence Architect
6 2 (7.41%) Business Intelligence Consultant
6 2 (7.41%) Technical Analyst
6 2 (7.41%) Information Analyst
6 2 (7.41%) Business Architect
6 2 (7.41%) Consultant
7 1 (3.70%) Account Manager
7 1 (3.70%) Support Analyst
7 1 (3.70%) Applications Support
7 1 (3.70%) Data Analyst
7 1 (3.70%) Applications Support Analyst
Libraries, Frameworks & Software Standards
1 8 (29.63%) MDX
2 3 (11.11%) .NET
3 2 (7.41%) XML
4 1 (3.70%) Web Services
Miscellaneous
1 8 (29.63%) Analytical Skills
2 4 (14.81%) NHS
3 2 (7.41%) Data Integration
3 2 (7.41%) Visualisation
3 2 (7.41%) Digital Media
3 2 (7.41%) Data Structures
4 1 (3.70%) Informatics
4 1 (3.70%) Computer Science
Operating Systems
1 2 (7.41%) Windows
Processes & Methodologies
1 24 (88.89%) Business Intelligence
2 9 (33.33%) Agile Software Development
3 5 (18.52%) ETL
3 5 (18.52%) Kimball Methodology
3 5 (18.52%) Performance Tuning
4 4 (14.81%) Data Management
4 4 (14.81%) Data Analysis
4 4 (14.81%) Master Data Management
5 3 (11.11%) Migration
5 3 (11.11%) Change Management
6 2 (7.41%) Dimensional Modelling
6 2 (7.41%) Data Migration
6 2 (7.41%) Data Protection
6 2 (7.41%) Stakeholder Management
6 2 (7.41%) Scrum
6 2 (7.41%) Information Security
6 2 (7.41%) Quality Management
6 2 (7.41%) Analytics
7 1 (3.70%) Enterprise Architecture
7 1 (3.70%) Line Management
Programming Languages
1 18 (66.67%) SQL
2 13 (48.15%) T-SQL
3 8 (29.63%) Data Analysis Expressions (DAX)
4 7 (25.93%) C#
5 4 (14.81%) C
6 2 (7.41%) PL/SQL
Qualifications
1 1 (3.70%) Degree
Quality Assurance & Compliance
1 7 (25.93%) Data Quality
2 2 (7.41%) ISO/IEC 27001
3 1 (3.70%) SLA
Vendors
1 15 (55.56%) Microsoft
2 3 (11.11%) MicroStrategy
2 3 (11.11%) Tableau
3 2 (7.41%) Oracle
3 2 (7.41%) SAP
3 2 (7.41%) Cognos
3 2 (7.41%) IBM
4 1 (3.70%) Dundas
4 1 (3.70%) Sun
4 1 (3.70%) Nintex