The table below looks at the statistics for PowerPivot skills in IT jobs advertised for the City of London region. Included is a guide to the average salaries offered in IT jobs that have cited PowerPivot over the 3 months to 22 May 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
22 May 2015
Same period 2014 Same period 2013
Microsoft PowerPivot
Rank 275 329 310
Rank change year-on-year
+54 -19
Permanent jobs citing PowerPivot 27 13 18
As % of all permanent IT jobs located in the City of London 0.27% 0.10% 0.15%
As % of the Applications category 2.02% 0.73% 1.15%
Number of salaries quoted 25 12 17
Average salary £52,500 £48,750 £55,000
Average salary % change year-on-year
+7.69% -11.36%
90% offered a salary of more than £42,500 £47,500 £48,000
10% offered a salary of more than £60,500 £75,000 £60,000
UK excluding London average salary £47,500 £42,500 £42,375
% change year-on-year
+11.76% +0.29%
PowerPivot
London

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

Applications Category
City of London
Permanent IT job ads with a match in the
Applications category
1337 1770 1561
As % of all permanent IT jobs located in the City of London 13.32% 14.01% 13.29%
Number of salaries quoted 1126 1522 1301
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £27,000 £27,000 £27,500
10% offered a salary of more than £65,000 £68,000 £70,000
UK excluding London average salary £35,000 £34,000 £33,500
% change year-on-year
+2.94% +1.49%

PowerPivot
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of permanent IT 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
Salary Trend in the City of London

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

PowerPivot Salary Trend in the City of London

PowerPivot
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing PowerPivot across the City of London region over the 3 months to 22 May 2015.

PowerPivot Salary Histogram in the City of London

PowerPivot
Top 30 Related IT Skills in the City of London

For the 6 months to 22 May 2015, IT 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 IT job ads sampled that cited PowerPivot.

1 42 (84.00%) Business Intelligence
2 35 (70.00%) SQL Server
2 35 (70.00%) SQL Server Integration Services
3 34 (68.00%) SQL Server Reporting Services
4 32 (64.00%) SQL Server Analysis Services
4 32 (64.00%) SQL
5 28 (56.00%) Microsoft
6 27 (54.00%) SharePoint
7 25 (50.00%) MS Excel
8 23 (46.00%) Data Warehouse
9 17 (34.00%) MDX
10 16 (32.00%) ETL
11 15 (30.00%) T-SQL
12 14 (28.00%) OLAP
12 14 (28.00%) Data Modelling
12 14 (28.00%) Data Analysis
13 13 (26.00%) OLAP Cube
14 12 (24.00%) Microsoft Power View
14 12 (24.00%) Finance
15 11 (22.00%) SQL Server 2012
16 10 (20.00%) Analytics
16 10 (20.00%) Data Analysis Expressions (DAX)
16 10 (20.00%) Change Management
16 10 (20.00%) JavaScript
17 9 (18.00%) Agile Software Development
17 9 (18.00%) Dimensional Modelling
17 9 (18.00%) jQuery
17 9 (18.00%) C#
17 9 (18.00%) Cognos
17 9 (18.00%) Kimball Methodology

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

For the 6 months to 22 May 2015, IT 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 IT job ads sampled that cited PowerPivot. Up to 20 skills are shown per category.

Application Platforms
1 27 (54.00%) SharePoint
2 6 (12.00%) SharePoint 2013
2 6 (12.00%) SharePoint 2010
3 1 (2.00%) Node.js
Applications
1 25 (50.00%) MS Excel
2 7 (14.00%) MS Office
3 5 (10.00%) SPSS
4 1 (2.00%) MS PowerPoint
Business Applications
1 1 (2.00%) Dynamics CRM
Cloud Services
1 4 (8.00%) Google Analytics
2 1 (2.00%) Microsoft Azure
Communications & Networking
1 1 (2.00%) Internet
1 1 (2.00%) SMS
Database & Business Intelligence
1 35 (70.00%) SQL Server
1 35 (70.00%) SQL Server Integration Services
2 34 (68.00%) SQL Server Reporting Services
3 32 (64.00%) SQL Server Analysis Services
4 23 (46.00%) Data Warehouse
5 14 (28.00%) OLAP
6 13 (26.00%) OLAP Cube
7 12 (24.00%) Microsoft Power View
8 11 (22.00%) SQL Server 2012
9 7 (14.00%) SQL Server 2008
9 7 (14.00%) Crystal Reports
9 7 (14.00%) BusinessObjects
9 7 (14.00%) BusinessObjects Web Intelligence
10 6 (12.00%) SAP BI
11 5 (10.00%) PerformancePoint
11 5 (10.00%) QlikView
12 4 (8.00%) SQL Server 2005
13 3 (6.00%) Microsoft Analysis Services
13 3 (6.00%) Data Mining
14 1 (2.00%) Pentaho
Development Applications
1 5 (10.00%) Team Foundation Server
2 1 (2.00%) Git (software)
2 1 (2.00%) Subversion
2 1 (2.00%) Visual Studio
2 1 (2.00%) Grunt
General
1 12 (24.00%) Finance
2 5 (10.00%) Music Industry
2 5 (10.00%) Marketing
3 3 (6.00%) Retail
4 1 (2.00%) Banking
4 1 (2.00%) Advertising
Job Titles
1 26 (52.00%) Developer
2 14 (28.00%) Analyst
3 10 (20.00%) Business Intelligence Analyst
4 9 (18.00%) Business Intelligence Developer
4 9 (18.00%) Senior Developer
5 4 (8.00%) AWS Developer
5 4 (8.00%) Architect
5 4 (8.00%) Senior Analyst
5 4 (8.00%) Data Analyst
5 4 (8.00%) Senior Business Intelligence Analyst
6 3 (6.00%) Business Intelligence Manager
6 3 (6.00%) SQL Developer
6 3 (6.00%) Consultant
6 3 (6.00%) Senior Business Intelligence Developer
7 2 (4.00%) Business Solution Architect
7 2 (4.00%) Business Intelligence Architect
7 2 (4.00%) Solutions Architect
7 2 (4.00%) Business Architect
7 2 (4.00%) Analyst Developer
8 1 (2.00%) Lead Architect
Libraries, Frameworks & Software Standards
1 17 (34.00%) MDX
2 9 (18.00%) jQuery
3 8 (16.00%) CSS
4 7 (14.00%) .NET
5 5 (10.00%) XML
5 5 (10.00%) Highcharts JS
6 3 (6.00%) ASP.NET
7 2 (4.00%) CSS3
7 2 (4.00%) HTML5
7 2 (4.00%) HTML
7 2 (4.00%) JSON
8 1 (2.00%) WCF
8 1 (2.00%) WPF
8 1 (2.00%) Entity Framework
8 1 (2.00%) REST
8 1 (2.00%) Ajax
8 1 (2.00%) .NET Framework
8 1 (2.00%) ASP.NET MVC
8 1 (2.00%) Backbone.js
8 1 (2.00%) AngularJS
Miscellaneous
1 7 (14.00%) Analytical Skills
1 7 (14.00%) Data Structures
2 3 (6.00%) Management Information System
3 2 (4.00%) Social Media
3 2 (4.00%) Visualisation
4 1 (2.00%) Mathematics
4 1 (2.00%) Data Integration
4 1 (2.00%) Taxonomies
4 1 (2.00%) NHS
4 1 (2.00%) User Experience
Operating Systems
1 7 (14.00%) Windows
2 1 (2.00%) Linux
Processes & Methodologies
1 42 (84.00%) Business Intelligence
2 16 (32.00%) ETL
3 14 (28.00%) Data Modelling
3 14 (28.00%) Data Analysis
4 10 (20.00%) Analytics
4 10 (20.00%) Change Management
5 9 (18.00%) Agile Software Development
5 9 (18.00%) Dimensional Modelling
5 9 (18.00%) Kimball Methodology
6 8 (16.00%) Scrum
6 8 (16.00%) Data Management
7 7 (14.00%) Performance Tuning
7 7 (14.00%) Change Control
8 5 (10.00%) Content Management
8 5 (10.00%) E-Commerce
9 4 (8.00%) Econometrics
9 4 (8.00%) Migration
9 4 (8.00%) Requirements Analysis
10 3 (6.00%) TOGAF
10 3 (6.00%) Inmon Methodology
Programming Languages
1 32 (64.00%) SQL
2 15 (30.00%) T-SQL
3 10 (20.00%) Data Analysis Expressions (DAX)
3 10 (20.00%) JavaScript
4 9 (18.00%) C#
5 6 (12.00%) VBA
6 2 (4.00%) VB.NET
7 1 (2.00%) PowerShell
7 1 (2.00%) Shell Script
Qualifications
1 2 (4.00%) Degree
Systems Management
1 1 (2.00%) SCSM
Vendors
1 28 (56.00%) Microsoft
2 9 (18.00%) Cognos
3 7 (14.00%) SAP
3 7 (14.00%) Business Objects
3 7 (14.00%) IBM
3 7 (14.00%) MicroStrategy
4 5 (10.00%) Birst
5 4 (8.00%) Google
6 3 (6.00%) Informatica
6 3 (6.00%) Oracle
7 1 (2.00%) Salesforce.com
7 1 (2.00%) ExactTarget