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 19 September 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
19 Sep 2014
Same period 2013 Same period 2012
Microsoft PowerPivot
Rank 311 318 329
Rank change year-on-year
+7 +11
Permanent jobs citing PowerPivot 9 8 8
As % of all permanent IT jobs located in the City of London 0.078% 0.068% 0.063%
As % of the Applications category 0.56% 0.53% 0.45%
Number of salaries quoted 7 7 8
Average salary £57,500 £47,500 £65,000
Average salary % change year-on-year
+21.05% -26.92%
UK excluding London average salary £35,000 £40,750 £50,000
% change year-on-year
-14.11% -18.50%
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
1610 1506 1766
As % of all permanent IT jobs located in the City of London 13.98% 12.74% 14.01%
Number of salaries quoted 1295 1348 1550
Average salary £45,000 £45,000 £45,000
90% offered a salary of more than £25,850 £27,500 £27,500
10% offered a salary of more than £67,500 £72,500 £67,500
UK excluding London average salary £34,000 £35,000 £33,500
% change year-on-year
-2.85% +4.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 19 September 2014.

PowerPivot Salary Histogram in the City of London

PowerPivot
Top 30 Related IT Skills in the City of London

For the 6 months to 19 September 2014, 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 25 (83.33%) Business Intelligence
1 25 (83.33%) SQL Server Integration Services
2 23 (76.67%) SQL Server
3 22 (73.33%) Microsoft
3 22 (73.33%) SQL Server Reporting Services
3 22 (73.33%) SQL Server Analysis Services
4 21 (70.00%) MS Excel
5 20 (66.67%) SharePoint
6 18 (60.00%) SQL
7 16 (53.33%) Data Warehouse
8 12 (40.00%) ETL
9 10 (33.33%) MDX
10 9 (30.00%) SQL Server 2008
10 9 (30.00%) Analytics
10 9 (30.00%) OLAP
11 7 (23.33%) T-SQL
11 7 (23.33%) Cognos
11 7 (23.33%) .NET
11 7 (23.33%) IBM
11 7 (23.33%) Agile Software Development
12 6 (20.00%) Data Modelling
12 6 (20.00%) C#
12 6 (20.00%) Big Data
13 5 (16.67%) SQL Server 2012
13 5 (16.67%) BusinessObjects Web Intelligence
13 5 (16.67%) SharePoint 2010
13 5 (16.67%) PerformancePoint
13 5 (16.67%) Business Objects
13 5 (16.67%) SAP
13 5 (16.67%) Windows

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

For the 6 months to 19 September 2014, 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 20 (66.67%) SharePoint
2 5 (16.67%) SharePoint 2010
3 2 (6.67%) SharePoint 2013
3 2 (6.67%) SAS
4 1 (3.33%) IIS
Applications
1 21 (70.00%) MS Excel
Communications & Networking
1 2 (6.67%) Intranet
Database & Business Intelligence
1 25 (83.33%) SQL Server Integration Services
2 23 (76.67%) SQL Server
3 22 (73.33%) SQL Server Reporting Services
3 22 (73.33%) SQL Server Analysis Services
4 16 (53.33%) Data Warehouse
5 9 (30.00%) OLAP
5 9 (30.00%) SQL Server 2008
6 6 (20.00%) Big Data
7 5 (16.67%) SQL Server 2012
7 5 (16.67%) PerformancePoint
7 5 (16.67%) Microsoft Analysis Services
7 5 (16.67%) BusinessObjects
7 5 (16.67%) BusinessObjects Web Intelligence
8 4 (13.33%) SAP BI
8 4 (13.33%) Crystal Reports
9 3 (10.00%) SQL Server 2005
10 2 (6.67%) SSDT
Development Applications
1 3 (10.00%) Subversion
1 3 (10.00%) Team Foundation Server
General
1 1 (3.33%) Advertising
1 1 (3.33%) Multimedia
1 1 (3.33%) Marketing
Job Titles
1 17 (56.67%) Developer
2 11 (36.67%) Business Intelligence Developer
3 9 (30.00%) Analyst
4 5 (16.67%) Business Developer
5 4 (13.33%) Microsoft Developer
5 4 (13.33%) Architect
6 3 (10.00%) MI Developer
6 3 (10.00%) Business Intelligence Analyst
6 3 (10.00%) Data Analyst
7 1 (3.33%) Business Objects Developer
7 1 (3.33%) Information Analyst
7 1 (3.33%) Data Migration Analyst
7 1 (3.33%) Technical Leader
7 1 (3.33%) Systems Analyst
7 1 (3.33%) Consultant
7 1 (3.33%) Data Architect
7 1 (3.33%) Business Intelligence Consultant
7 1 (3.33%) Support Analyst
7 1 (3.33%) Lead Developer
7 1 (3.33%) Report Analyst
Libraries, Frameworks & Software Standards
1 10 (33.33%) MDX
2 7 (23.33%) .NET
3 1 (3.33%) ASP.NET
3 1 (3.33%) SAP XI
3 1 (3.33%) WPF
3 1 (3.33%) ASP.NET MVC
Miscellaneous
1 4 (13.33%) Visualisation
2 3 (10.00%) PMI
3 1 (3.33%) NHS
3 1 (3.33%) Computer Science
3 1 (3.33%) Enterprise Software
3 1 (3.33%) Analytical Skills
Operating Systems
1 5 (16.67%) Windows
Processes & Methodologies
1 25 (83.33%) Business Intelligence
2 12 (40.00%) ETL
3 9 (30.00%) Analytics
4 7 (23.33%) Agile Software Development
5 6 (20.00%) Data Modelling
6 4 (13.33%) Change Management
6 4 (13.33%) Data Management
6 4 (13.33%) Change Control
6 4 (13.33%) Data Analytics
6 4 (13.33%) Kimball Methodology
6 4 (13.33%) Scrum
7 3 (10.00%) Data Transformation
7 3 (10.00%) Performance Tuning
7 3 (10.00%) Mentoring
7 3 (10.00%) Information Management
7 3 (10.00%) Project Management
7 3 (10.00%) Enterprise Data Management
8 2 (6.67%) Requirements Analysis
9 1 (3.33%) Direct Marketing
9 1 (3.33%) Zachman Framework
Programming Languages
1 18 (60.00%) SQL
2 7 (23.33%) T-SQL
3 6 (20.00%) C#
4 4 (13.33%) VBA
5 3 (10.00%) Data Analysis Expressions (DAX)
6 1 (3.33%) C
Qualifications
1 4 (13.33%) Degree
2 3 (10.00%) PMI Certification
3 2 (6.67%) MCSE
3 2 (6.67%) Microsoft Certification
Quality Assurance & Compliance
1 2 (6.67%) ISO 9001
1 2 (6.67%) ISO/IEC 27001
Vendors
1 22 (73.33%) Microsoft
2 7 (23.33%) Cognos
2 7 (23.33%) IBM
3 5 (16.67%) Business Objects
3 5 (16.67%) SAP
3 5 (16.67%) MicroStrategy
4 4 (13.33%) Tableau
4 4 (13.33%) Cloudera
5 1 (3.33%) Ab Initio
City of London
Computer Futures
Salary: £40000 - £50000 per annum + competitive
Posted: 24 days ago