Period
to 17 January 2018

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for PowerPivot skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited PowerPivot over the 6 months to 17 January 2018 with a comparison to the same period in the previous 2 years.

Microsoft Power Pivot
Central London > City of London
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 317 310 378
Rank change year-on-year -7 +68 +54
Permanent jobs citing PowerPivot 13 24 6
As % of all permanent IT jobs advertised in the City of London 0.13% 0.22% 0.042%
As % of the Database & Business Intelligence category 0.41% 0.72% 0.14%
Number of salaries quoted 13 24 3
City of London median annual salary £55,000 £55,000 £55,000
10th Percentile £36,250 £39,975 £52,500
90th Percentile £71,500 £68,750 £60,500
Central London median annual salary £55,000 £55,000 £55,000

PowerPivot is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 3,190 3,313 4,332
As % of all permanent IT jobs advertised in the City of London 30.81% 30.88% 30.64%
Number of salaries quoted 2,865 3,064 3,824
City of London median annual salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.35% - +4.55%
10th Percentile £41,250 £36,750 £37,000
90th Percentile £87,500 £87,500 £85,875
Central London median annual salary £60,000 £57,500 £57,500
% change year-on-year +4.35% - +5.50%

PowerPivot
Job Vacancy Trend in the City of London

Job postings citing PowerPivot as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for PowerPivot 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 in the City of London.

Salary trend for PowerPivot in the City of London

PowerPivot
Salary Histogram in the City of London

The salary distribution of IT jobs citing PowerPivot in the City of London over the 6 months to 17 January 2018.

Salary histogram for PowerPivot in the City of London

For the 6 months to 17 January 2018, IT jobs citing PowerPivot also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the City of London region with a requirement for PowerPivot.

1 10 (76.92%) SQL
2 9 (69.23%) Microsoft Excel
2 9 (69.23%) Business Intelligence
2 9 (69.23%) Microsoft
3 8 (61.54%) SQL Server Reporting Services
4 7 (53.85%) SQL Server Integration Services
4 7 (53.85%) SQL Server Analysis Services
4 7 (53.85%) SQL Server
4 7 (53.85%) Power BI
5 6 (46.15%) Data Warehouse
6 4 (30.77%) Data Modelling
6 4 (30.77%) ETL
6 4 (30.77%) VBA
6 4 (30.77%) Finance
6 4 (30.77%) Visualisation
6 4 (30.77%) Kimball Methodology
6 4 (30.77%) Data Analysis Expressions (DAX)
7 3 (23.08%) Microsoft Azure
7 3 (23.08%) .NET
7 3 (23.08%) Oracle
7 3 (23.08%) C#
8 2 (15.38%) Java
8 2 (15.38%) JavaScript
8 2 (15.38%) T-SQL
8 2 (15.38%) IIS
8 2 (15.38%) Windows
8 2 (15.38%) ACCA
8 2 (15.38%) GAAP
8 2 (15.38%) Reverse Engineering
8 2 (15.38%) Windows Server 2012

PowerPivot
Co-occurring IT Skills in the City of London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 2 (15.38%) IIS
2 1 (7.69%) SharePoint
Applications
1 9 (69.23%) Microsoft Excel
Cloud Services
1 3 (23.08%) Microsoft Azure
Database & Business Intelligence
1 8 (61.54%) SQL Server Reporting Services
2 7 (53.85%) Power BI
2 7 (53.85%) SQL Server
2 7 (53.85%) SQL Server Analysis Services
2 7 (53.85%) SQL Server Integration Services
3 6 (46.15%) Data Warehouse
4 1 (7.69%) Data Mining
4 1 (7.69%) Oracle Database
4 1 (7.69%) SQL Server 2005
4 1 (7.69%) SQL Server 2008
General
1 4 (30.77%) Finance
2 1 (7.69%) Advertising
Job Titles
1 9 (69.23%) Developer
2 7 (53.85%) Business Intelligence Developer
3 3 (23.08%) Analyst
3 3 (23.08%) Senior Business Intelligence Developer
3 3 (23.08%) Senior Developer
3 3 (23.08%) SSAS Developer
3 3 (23.08%) SSIS Developer
4 2 (15.38%) C# Developer
4 2 (15.38%) DBA
4 2 (15.38%) Java Developer
4 2 (15.38%) Microsoft BI Developer
4 2 (15.38%) Microsoft Developer
4 2 (15.38%) Senior DBA
4 2 (15.38%) Senior Microsoft Developer
4 2 (15.38%) Senior SQL DBA
4 2 (15.38%) Senior SQL Developer
4 2 (15.38%) SQL BI Developer
4 2 (15.38%) SQL DBA
4 2 (15.38%) SQL Developer
5 1 (7.69%) Data Analytics Manager
Libraries, Frameworks & Software Standards
1 3 (23.08%) .NET
2 1 (7.69%) MDX
2 1 (7.69%) Web Services
2 1 (7.69%) XML
Miscellaneous
1 2 (15.38%) Analytical Skills
Operating Systems
1 2 (15.38%) Windows
1 2 (15.38%) Windows Server 2008
1 2 (15.38%) Windows Server 2012
Processes & Methodologies
1 9 (69.23%) Business Intelligence
2 4 (30.77%) Data Modelling
2 4 (30.77%) ETL
2 4 (30.77%) Kimball Methodology
2 4 (30.77%) Visualisation
3 2 (15.38%) Agile Software Development
3 2 (15.38%) Data Analysis
3 2 (15.38%) Data Cleansing
3 2 (15.38%) Data Management
3 2 (15.38%) Data Visualisation
3 2 (15.38%) Dimensional Modelling
3 2 (15.38%) Master Data Management
3 2 (15.38%) Reverse Engineering
3 2 (15.38%) Waterfall
4 1 (7.69%) Analytics
4 1 (7.69%) Capacity Planning
4 1 (7.69%) Dashboard Development
4 1 (7.69%) Data Encryption
4 1 (7.69%) Investment Management
4 1 (7.69%) Performance Tuning
Programming Languages
1 10 (76.92%) SQL
2 4 (30.77%) Data Analysis Expressions (DAX)
2 4 (30.77%) VBA
3 3 (23.08%) C#
4 2 (15.38%) Java
4 2 (15.38%) JavaScript
4 2 (15.38%) PowerShell
4 2 (15.38%) T-SQL
Qualifications
1 2 (15.38%) ACCA
Quality Assurance & Compliance
1 2 (15.38%) Data Quality
1 2 (15.38%) GAAP
1 2 (15.38%) Solvency II
Systems Management
1 1 (7.69%) Systems Management Server (SMS)
Vendors
1 9 (69.23%) Microsoft
2 3 (23.08%) Oracle
3 1 (7.69%) Cognos