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 30 April 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.

3 months to
30 Apr 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 152 177 205
Rank change year-on-year
+25 +28
Contract jobs citing PowerPivot 2 19 7
As % of all contract IT jobs located in the City of London 0.057% 0.35% 0.11%
As % of the Database & Business Intelligence category 0.23% 1.35% 0.49%
Number of daily rates quoted 1 14 7
Average daily rate £400 £406 £355
Average daily rate % change year-on-year
-1.53% +14.43%
UK excluding London average daily rate £375 £400 £460
% change year-on-year
-6.25% -13.04%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £38.75 £16.00 -
% change year-on-year
+142.18% -
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
870 1408 1431
As % of all contract IT jobs located in the City of London 24.91% 25.61% 22.91%
Number of daily rates quoted 709 1122 1053
Average daily rate £488 £450 £430
Average daily rate % change year-on-year
+8.33% +4.65%
90% offered a daily rate of more than £350 £325 £300
10% offered a daily rate of more than £600 £600 £575
UK excluding London average daily rate £388 £375 £350
% change year-on-year
+3.33% +7.14%
Number of hourly rates quoted 8 7 9
Average hourly rate £19.00 £45.00 £27.50
Average hourly rate % change year-on-year
-57.77% +63.63%
UK excluding London average hourly rate £34.00 £32.50 £35.00
% change year-on-year
+4.61% -7.14%

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
Top 30 Related IT Skills in the City of London

For the 6 months to 30 April 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 5 (100.00%) SQL
1 5 (100.00%) SQL Server
2 4 (80.00%) Business Intelligence
3 3 (60.00%) Microsoft
3 3 (60.00%) Finance
3 3 (60.00%) SQL Server Reporting Services
3 3 (60.00%) SQL Server Analysis Services
4 2 (40.00%) Data Analysis
4 2 (40.00%) SQL Server Integration Services
4 2 (40.00%) MS Excel
4 2 (40.00%) T-SQL
4 2 (40.00%) MDX
4 2 (40.00%) Data Quality
4 2 (40.00%) Microsoft Power View
4 2 (40.00%) Power BI
4 2 (40.00%) Data Warehouse
5 1 (20.00%) Kimball Methodology
5 1 (20.00%) Analytics
5 1 (20.00%) Relational Database
5 1 (20.00%) SQL Server Management Studio (SSMS)
5 1 (20.00%) Line Management
5 1 (20.00%) Analytical Skills
5 1 (20.00%) Mathematics
5 1 (20.00%) Computer Science
5 1 (20.00%) Test Scripting
5 1 (20.00%) VBA
5 1 (20.00%) MS Access
5 1 (20.00%) NHS
5 1 (20.00%) SLA
5 1 (20.00%) Legal

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

For the 6 months to 30 April 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.

Applications
1 2 (40.00%) MS Excel
Database & Business Intelligence
1 5 (100.00%) SQL Server
2 3 (60.00%) SQL Server Analysis Services
2 3 (60.00%) SQL Server Reporting Services
3 2 (40.00%) Data Warehouse
3 2 (40.00%) Microsoft Power View
3 2 (40.00%) Power BI
3 2 (40.00%) SQL Server Integration Services
4 1 (20.00%) Microsoft Analysis Services
4 1 (20.00%) MS Access
4 1 (20.00%) Relational Database
Development Applications
1 1 (20.00%) SQL Server Management Studio (SSMS)
General
1 3 (60.00%) Finance
2 1 (20.00%) Billing
2 1 (20.00%) Legal
Job Titles
1 3 (60.00%) Analyst
2 1 (20.00%) Business Developer
2 1 (20.00%) Business Intelligence Analyst
2 1 (20.00%) Business Intelligence Consultant
2 1 (20.00%) Business Intelligence Developer
2 1 (20.00%) Consultant
2 1 (20.00%) Data Analyst
2 1 (20.00%) Developer
2 1 (20.00%) Excel Analyst
2 1 (20.00%) Information Analyst
2 1 (20.00%) Power BI Consultant
2 1 (20.00%) Senior Analyst
2 1 (20.00%) Senior Information Analyst
2 1 (20.00%) SQL Analyst
2 1 (20.00%) SQL BI Developer
2 1 (20.00%) SQL Data Analyst
2 1 (20.00%) SQL Developer
Libraries, Frameworks & Software Standards
1 2 (40.00%) MDX
Miscellaneous
1 1 (20.00%) Analytical Skills
1 1 (20.00%) Computer Science
1 1 (20.00%) Management Information System
1 1 (20.00%) Mathematics
1 1 (20.00%) NHS
Processes & Methodologies
1 4 (80.00%) Business Intelligence
2 2 (40.00%) Data Analysis
3 1 (20.00%) Analytics
3 1 (20.00%) Data Cleansing
3 1 (20.00%) Data Management
3 1 (20.00%) Kimball Methodology
3 1 (20.00%) Line Management
3 1 (20.00%) Stakeholder Management
3 1 (20.00%) Test Scripting
3 1 (20.00%) Test Strategy
3 1 (20.00%) Validation
Programming Languages
1 5 (100.00%) SQL
2 2 (40.00%) T-SQL
3 1 (20.00%) R
3 1 (20.00%) VBA
Qualifications
1 1 (20.00%) Degree
Quality Assurance & Compliance
1 2 (40.00%) Data Quality
2 1 (20.00%) PCI DSS
2 1 (20.00%) SLA
2 1 (20.00%) Solvency II
Vendors
1 3 (60.00%) Microsoft
2 1 (20.00%) Tableau
City of London
Lawrence Harvey
Rate: £350 - £450 per day
Posted: 24 days ago