Period
to 18 November 2018

The following table provides summary statistics for permanent job vacancies advertised in Peterborough 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 18 November 2018 with a comparison to the same period in the previous 2 years.

Microsoft Power Pivot
Cambridgeshire > Peterborough
6 months to
18 Nov 2018
Same period 2017 Same period 2016
Rank 96 73 62
Rank change year-on-year -23 -11 -
Permanent jobs citing PowerPivot 7 1 1
As % of all permanent IT jobs advertised in Peterborough 0.79% 0.18% 0.17%
As % of the Database & Business Intelligence category 4.14% 0.71% 0.66%
Number of salaries quoted 2 1 0
Peterborough median annual salary £57,500 £57,500 -
Cambridgeshire median annual salary £60,000 £57,500 £53,750
% change year-on-year +4.35% +6.98% -

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 Peterborough with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Peterborough
Permanent vacancies with a requirement for database or business intelligence skills 169 140 151
As % of all permanent IT jobs advertised in Peterborough 19.14% 24.82% 26.03%
Number of salaries quoted 93 122 145
Peterborough median annual salary £41,500 £42,500 £40,000
Median salary % change year-on-year -2.35% +6.25% -
10th Percentile £26,400 £32,500 £26,700
90th Percentile £58,750 £57,500 £50,000
Cambridgeshire median annual salary £47,500 £45,000 £42,500
% change year-on-year +5.56% +5.88% -

PowerPivot
Job Vacancy Trend in Peterborough

Job postings citing PowerPivot as a percentage of all IT jobs advertised in Peterborough.

Job vacancy trend for PowerPivot in Peterborough

PowerPivot
Salary Trend in Peterborough

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing PowerPivot in Peterborough.

Salary trend for PowerPivot in Peterborough

PowerPivot
Salary Histogram in Peterborough

The salary distribution of IT jobs citing PowerPivot in Peterborough over the 6 months to 18 November 2018.

Salary histogram for PowerPivot in Peterborough

For the 6 months to 18 November 2018, IT jobs citing PowerPivot also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Peterborough region with a requirement for PowerPivot.

1 7 (100.00%) SQL Server
1 7 (100.00%) Microsoft Excel
1 7 (100.00%) Data Warehouse
1 7 (100.00%) Data Modelling
1 7 (100.00%) Business Intelligence
1 7 (100.00%) Microsoft
1 7 (100.00%) SQL Server Reporting Services
1 7 (100.00%) SQL Server Integration Services
1 7 (100.00%) SQL Server Analysis Services
1 7 (100.00%) Power BI
2 6 (85.71%) Microsoft Power View
2 6 (85.71%) Analytics
2 6 (85.71%) ETL
2 6 (85.71%) Cognos
3 5 (71.43%) Informatica
3 5 (71.43%) BizTalk Server
3 5 (71.43%) Middleware
3 5 (71.43%) Cognos Business Intelligence
3 5 (71.43%) Talend
4 3 (42.86%) Azure Data Factory
4 3 (42.86%) Microsoft Azure
4 3 (42.86%) Oracle SOA Suite
4 3 (42.86%) Office 365
4 3 (42.86%) Data Integration
4 3 (42.86%) Business Analysis
4 3 (42.86%) Cognos TM1
4 3 (42.86%) Hyperion
4 3 (42.86%) Oracle
4 3 (42.86%) SOA
4 3 (42.86%) ERP

PowerPivot
Co-occurring IT Skills in Peterborough 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 5 (71.43%) BizTalk Server
2 3 (42.86%) Oracle SOA Suite
3 1 (14.29%) SharePoint
Applications
1 7 (100.00%) Microsoft Excel
Business Applications
1 5 (71.43%) Cognos Business Intelligence
2 3 (42.86%) Cognos TM1
3 1 (14.29%) Dynamics AX
Cloud Services
1 3 (42.86%) Azure Data Factory
1 3 (42.86%) Microsoft Azure
1 3 (42.86%) Office 365
Database & Business Intelligence
1 7 (100.00%) Data Warehouse
1 7 (100.00%) Power BI
1 7 (100.00%) SQL Server
1 7 (100.00%) SQL Server Analysis Services
1 7 (100.00%) SQL Server Integration Services
1 7 (100.00%) SQL Server Reporting Services
2 6 (85.71%) Microsoft Power View
3 1 (14.29%) Microsoft Analysis Services
3 1 (14.29%) OLAP
3 1 (14.29%) SQL Server 2008
General
1 2 (28.57%) Finance
2 1 (14.29%) Manufacturing
Job Titles
1 6 (85.71%) Architect
1 6 (85.71%) Business Intelligence Architect
2 3 (42.86%) Business Intelligence Developer
2 3 (42.86%) Developer
2 3 (42.86%) Report Developer
3 2 (28.57%) Business Architect
4 1 (14.29%) Business Consultant
4 1 (14.29%) Business Intelligence Consultant
4 1 (14.29%) Consultant
Libraries, Frameworks & Software Standards
1 5 (71.43%) Middleware
Miscellaneous
1 1 (14.29%) Self-Motivation
Processes & Methodologies
1 7 (100.00%) Business Intelligence
1 7 (100.00%) Data Modelling
2 6 (85.71%) Analytics
2 6 (85.71%) ETL
3 3 (42.86%) Business Analysis
3 3 (42.86%) Data Integration
3 3 (42.86%) ERP
3 3 (42.86%) SOA
4 2 (28.57%) Contract Management
4 2 (28.57%) Data Management
4 2 (28.57%) Data Privacy
4 2 (28.57%) Performance Monitoring
4 2 (28.57%) Project Management
5 1 (14.29%) Data Analysis
5 1 (14.29%) IT Strategy
5 1 (14.29%) Kimball Methodology
5 1 (14.29%) Mentoring
5 1 (14.29%) Service Delivery
5 1 (14.29%) Stakeholder Management
5 1 (14.29%) Time Management
Programming Languages
1 1 (14.29%) SQL
1 1 (14.29%) T-SQL
Vendors
1 7 (100.00%) Microsoft
2 6 (85.71%) Cognos
3 5 (71.43%) Informatica
3 5 (71.43%) Talend
4 3 (42.86%) Hyperion
4 3 (42.86%) Oracle
5 1 (14.29%) JD Edwards