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 10 February 2016 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
10 Feb 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 150 174 197
Rank change year-on-year
+24 +23
Contract jobs citing PowerPivot 3 14 9
As % of all contract IT jobs located in the City of London 0.095% 0.27% 0.15%
As % of the Database & Business Intelligence category 0.35% 1.16% 0.62%
Number of daily rates quoted 3 10 7
Average daily rate £400 £379 £355
Average daily rate % change year-on-year
+5.61% +6.69%
90% offered a daily rate of more than £360 £350 £319
10% offered a daily rate of more than £480 £517 £357
UK excluding London average daily rate £375 £375 £300
% change year-on-year
- +25.00%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £15.00 £36.00 -
% change year-on-year
-58.33% -
PowerPivot
London

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

Database & Business Intelligence Category
City of London
Contract IT job ads with a match in the
Database & Business Intelligence category
856 1211 1463
As % of all contract IT jobs located in the City of London 27.21% 23.56% 24.57%
Number of daily rates quoted 679 958 1084
Average daily rate £475 £430 £438
Average daily rate % change year-on-year
+10.46% -1.71%
90% offered a daily rate of more than £338 £300 £315
10% offered a daily rate of more than £600 £600 £575
UK excluding London average daily rate £375 £375 £350
% change year-on-year
- +7.14%
Number of hourly rates quoted 2 3 9
Average hourly rate £55.00 £36.00 £31.00
Average hourly rate % change year-on-year
+52.77% +16.12%
UK excluding London average hourly rate £32.50 £32.50 £29.00
% change year-on-year
- +12.06%

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 Database & Business Intelligence 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 10 February 2016.

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 10 February 2016, 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 6 (100.00%) SQL
1 6 (100.00%) SQL Server
1 6 (100.00%) Business Intelligence
2 4 (66.67%) Data Warehouse
2 4 (66.67%) SQL Server Analysis Services
2 4 (66.67%) MDX
2 4 (66.67%) Data Quality
3 3 (50.00%) SQL Server Integration Services
3 3 (50.00%) Microsoft Power View
3 3 (50.00%) MS Excel
3 3 (50.00%) Microsoft
3 3 (50.00%) T-SQL
4 2 (33.33%) Advertising
4 2 (33.33%) Finance
4 2 (33.33%) Agile Software Development
4 2 (33.33%) Retail
4 2 (33.33%) Data Management
4 2 (33.33%) SQL Server Reporting Services
4 2 (33.33%) C#
4 2 (33.33%) .NET
4 2 (33.33%) OLAP
4 2 (33.33%) Star Schema
4 2 (33.33%) ETL
4 2 (33.33%) OLAP Cube
4 2 (33.33%) Data Analysis Expressions (DAX)
4 2 (33.33%) Performance Tuning
4 2 (33.33%) Marketing
4 2 (33.33%) SQL Server 2012
4 2 (33.33%) Kimball Methodology
4 2 (33.33%) Mathematics

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

For the 6 months to 10 February 2016, 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 1 (16.67%) IBM Notes
Applications
1 3 (50.00%) MS Excel
Database & Business Intelligence
1 6 (100.00%) SQL Server
2 4 (66.67%) Data Warehouse
2 4 (66.67%) SQL Server Analysis Services
3 3 (50.00%) Microsoft Power View
3 3 (50.00%) SQL Server Integration Services
4 2 (33.33%) OLAP
4 2 (33.33%) OLAP Cube
4 2 (33.33%) SQL Server 2012
4 2 (33.33%) SQL Server Reporting Services
4 2 (33.33%) Star Schema
5 1 (16.67%) Business Intelligence Development Studio
5 1 (16.67%) Microsoft Analysis Services
5 1 (16.67%) MS Access
5 1 (16.67%) Power BI
5 1 (16.67%) Relational Database
5 1 (16.67%) SQL Server 2014
Development Applications
1 1 (16.67%) Visual Studio
General
1 2 (33.33%) Advertising
1 2 (33.33%) Finance
1 2 (33.33%) Marketing
1 2 (33.33%) Retail
2 1 (16.67%) Billing
2 1 (16.67%) Legal
Job Titles
1 3 (50.00%) Analyst
2 2 (33.33%) Business Developer
2 2 (33.33%) Business Intelligence Analyst
2 2 (33.33%) Business Intelligence Developer
2 2 (33.33%) Developer
3 1 (16.67%) Data Analyst
3 1 (16.67%) Excel Analyst
3 1 (16.67%) Senior Business Intelligence Developer
3 1 (16.67%) Senior Developer
3 1 (16.67%) SQL Analyst
3 1 (16.67%) SQL BI Developer
3 1 (16.67%) SQL Data Analyst
3 1 (16.67%) SQL Developer
3 1 (16.67%) Technical Leader
Libraries, Frameworks & Software Standards
1 4 (66.67%) MDX
2 2 (33.33%) .NET
Miscellaneous
1 2 (33.33%) Mathematics
2 1 (16.67%) Analytical Skills
2 1 (16.67%) Computer Science
2 1 (16.67%) Management Information System
Processes & Methodologies
1 6 (100.00%) Business Intelligence
2 2 (33.33%) Agile Software Development
2 2 (33.33%) Data Management
2 2 (33.33%) ETL
2 2 (33.33%) Kimball Methodology
2 2 (33.33%) Performance Tuning
2 2 (33.33%) Test Scripting
2 2 (33.33%) Test Strategy
3 1 (16.67%) Data Analysis
3 1 (16.67%) Data Cleansing
3 1 (16.67%) Data Migration
3 1 (16.67%) ETL Development
3 1 (16.67%) Master Data Management
3 1 (16.67%) Migration
Programming Languages
1 6 (100.00%) SQL
2 3 (50.00%) T-SQL
3 2 (33.33%) C#
3 2 (33.33%) Data Analysis Expressions (DAX)
4 1 (16.67%) VBA
Qualifications
1 1 (16.67%) Degree
Quality Assurance & Compliance
1 4 (66.67%) Data Quality
2 1 (16.67%) PCI DSS
2 1 (16.67%) Solvency II
Vendors
1 3 (50.00%) Microsoft
2 1 (16.67%) Lotus
2 1 (16.67%) Tableau