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 20 April 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
20 Apr 2015
Same period 2014 Same period 2013
Microsoft PowerPivot
Rank 290 326 304
Rank change year-on-year
+36 -22
Permanent jobs citing PowerPivot 25 8 16
As % of all permanent IT jobs located in the City of London 0.24% 0.064% 0.14%
As % of the Applications category 1.60% 0.46% 1.04%
Number of salaries quoted 25 8 16
Average salary £50,000 £47,500 £58,750
Average salary % change year-on-year
+5.26% -19.14%
90% offered a salary of more than £42,500 £47,500 £48,000
10% offered a salary of more than £62,500 £57,500 £61,250
UK excluding London average salary £45,000 £39,750 £35,000
% change year-on-year
+13.20% +13.57%
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
1560 1734 1542
As % of all permanent IT jobs located in the City of London 14.69% 13.79% 13.14%
Number of salaries quoted 1339 1490 1305
Average salary £45,500 £45,000 £45,000
Average salary % change year-on-year
+1.11% -
90% offered a salary of more than £27,500 £26,500 £27,500
10% offered a salary of more than £70,000 £70,000 £67,500
UK excluding London average salary £35,000 £34,500 £34,000
% change year-on-year
+1.44% +1.47%

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 20 April 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 20 April 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 37 (84.09%) Business Intelligence
2 30 (68.18%) SQL
3 29 (65.91%) SQL Server
4 27 (61.36%) SQL Server Integration Services
5 26 (59.09%) SQL Server Reporting Services
6 24 (54.55%) SQL Server Analysis Services
7 21 (47.73%) SharePoint
8 19 (43.18%) MS Excel
8 19 (43.18%) Microsoft
9 18 (40.91%) Data Warehouse
9 18 (40.91%) Data Analysis
10 16 (36.36%) Data Modelling
11 15 (34.09%) MDX
12 14 (31.82%) ETL
13 12 (27.27%) Analytics
14 11 (25.00%) Data Analysis Expressions (DAX)
14 11 (25.00%) OLAP
14 11 (25.00%) Data Management
15 10 (22.73%) T-SQL
15 10 (22.73%) JavaScript
15 10 (22.73%) Finance
15 10 (22.73%) Microsoft Power View
15 10 (22.73%) OLAP Cube
16 8 (18.18%) CSS
16 8 (18.18%) jQuery
16 8 (18.18%) SQL Server 2008
16 8 (18.18%) SharePoint 2010
17 7 (15.91%) Dimensional Modelling
17 7 (15.91%) .NET
17 7 (15.91%) SharePoint 2013

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

For the 6 months to 20 April 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 21 (47.73%) SharePoint
2 8 (18.18%) SharePoint 2010
3 7 (15.91%) SharePoint 2013
4 1 (2.27%) Node.js
Applications
1 19 (43.18%) MS Excel
2 6 (13.64%) SPSS
3 1 (2.27%) MS PowerPoint
3 1 (2.27%) MS Office
Business Applications
1 5 (11.36%) Google Analytics
2 1 (2.27%) Dynamics CRM
Cloud Services
1 1 (2.27%) Microsoft Azure
Communications & Networking
1 1 (2.27%) SMS
1 1 (2.27%) Internet
Database & Business Intelligence
1 29 (65.91%) SQL Server
2 27 (61.36%) SQL Server Integration Services
3 26 (59.09%) SQL Server Reporting Services
4 24 (54.55%) SQL Server Analysis Services
5 18 (40.91%) Data Warehouse
6 11 (25.00%) OLAP
7 10 (22.73%) Microsoft Power View
7 10 (22.73%) OLAP Cube
8 8 (18.18%) SQL Server 2008
9 5 (11.36%) SQL Server 2005
9 5 (11.36%) SQL Server 2012
9 5 (11.36%) Microsoft Analysis Services
10 4 (9.09%) BusinessObjects
10 4 (9.09%) SAP BI
10 4 (9.09%) Crystal Reports
10 4 (9.09%) PerformancePoint
10 4 (9.09%) QlikView
10 4 (9.09%) BusinessObjects Web Intelligence
11 2 (4.55%) Data Mining
12 1 (2.27%) RDBMS
Development Applications
1 2 (4.55%) Subversion
2 1 (2.27%) Git (software)
2 1 (2.27%) Team Foundation Server
2 1 (2.27%) Grunt
2 1 (2.27%) Visual Studio
General
1 10 (22.73%) Finance
2 6 (13.64%) Marketing
3 5 (11.36%) Music Industry
4 2 (4.55%) Retail
5 1 (2.27%) Legal
5 1 (2.27%) Advertising
Job Titles
1 17 (38.64%) Developer
1 17 (38.64%) Analyst
2 10 (22.73%) Business Intelligence Analyst
3 8 (18.18%) Business Intelligence Developer
4 7 (15.91%) Data Analyst
5 6 (13.64%) Senior Developer
6 4 (9.09%) Senior Analyst
6 4 (9.09%) Senior Business Intelligence Analyst
7 3 (6.82%) Business Intelligence Manager
7 3 (6.82%) Architect
7 3 (6.82%) Consultant
8 2 (4.55%) Solutions Architect
8 2 (4.55%) Business Intelligence Architect
8 2 (4.55%) Analyst Developer
8 2 (4.55%) SQL Developer
8 2 (4.55%) Business Architect
8 2 (4.55%) Business Solution Architect
8 2 (4.55%) Senior Business Intelligence Developer
9 1 (2.27%) Senior Data Analyst
9 1 (2.27%) Data Manager
Libraries, Frameworks & Software Standards
1 15 (34.09%) MDX
2 8 (18.18%) CSS
2 8 (18.18%) jQuery
3 7 (15.91%) .NET
4 5 (11.36%) XML
4 5 (11.36%) Highcharts JS
5 2 (4.55%) HTML5
5 2 (4.55%) CSS3
5 2 (4.55%) ASP.NET
5 2 (4.55%) HTML
5 2 (4.55%) JSON
6 1 (2.27%) WCF
6 1 (2.27%) WPF
6 1 (2.27%) Ajax
6 1 (2.27%) Backbone.js
6 1 (2.27%) REST
6 1 (2.27%) LESS
6 1 (2.27%) AngularJS
6 1 (2.27%) Twitter Bootstrap
Miscellaneous
1 4 (9.09%) Data Structures
2 3 (6.82%) Management Information System
3 2 (4.55%) Visualisation
3 2 (4.55%) Analytical Skills
4 1 (2.27%) NHS
4 1 (2.27%) Social Media
4 1 (2.27%) User Experience
Operating Systems
1 4 (9.09%) Windows
2 1 (2.27%) Linux
Processes & Methodologies
1 37 (84.09%) Business Intelligence
2 18 (40.91%) Data Analysis
3 16 (36.36%) Data Modelling
4 14 (31.82%) ETL
5 12 (27.27%) Analytics
6 11 (25.00%) Data Management
7 7 (15.91%) Dimensional Modelling
7 7 (15.91%) Performance Tuning
8 6 (13.64%) Change Control
8 6 (13.64%) Agile Software Development
8 6 (13.64%) E-Commerce
8 6 (13.64%) Scrum
9 5 (11.36%) Econometrics
9 5 (11.36%) Content Management
9 5 (11.36%) Requirements Analysis
9 5 (11.36%) Kimball Methodology
10 4 (9.09%) Change Management
11 3 (6.82%) Business Analysis
12 2 (4.55%) Asset Management
12 2 (4.55%) Master Data Management
Programming Languages
1 30 (68.18%) SQL
2 11 (25.00%) Data Analysis Expressions (DAX)
3 10 (22.73%) T-SQL
3 10 (22.73%) JavaScript
4 6 (13.64%) VBA
5 5 (11.36%) C#
6 3 (6.82%) VB
7 2 (4.55%) VB.NET
8 1 (2.27%) Shell Script
Qualifications
1 2 (4.55%) Degree
Systems Management
1 1 (2.27%) SCSM
Vendors
1 19 (43.18%) Microsoft
2 6 (13.64%) Cognos
2 6 (13.64%) Birst
3 5 (11.36%) Google
4 4 (9.09%) IBM
4 4 (9.09%) Oracle
4 4 (9.09%) Business Objects
4 4 (9.09%) SAP
4 4 (9.09%) MicroStrategy
5 3 (6.82%) Informatica
6 1 (2.27%) Salesforce.com
6 1 (2.27%) ExactTarget
City, London
E-synergy Solutions
Salary: £55000 - £60000 per annum
Posted: 14 hours ago
City, London
Evolution Recruitment Solutions
Salary: 55,000
Posted: 5 days ago