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 salaries offered in IT jobs that have cited PowerPivot over the 3 months to 3 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
3 Dec 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 221 258 316
Rank change year-on-year
+37 +58
Permanent jobs citing PowerPivot 11 6 15
As % of all permanent IT jobs located in the City of London 0.21% 0.087% 0.13%
As % of the Database & Business Intelligence category 0.67% 0.28% 0.49%
Number of salaries quoted 11 3 10
Median salary £55,000 £55,000 £50,000
Median salary % change year-on-year
- +10.00%
90% offered a salary of more than £46,500 £55,000 £40,000
10% offered a salary of more than £67,500 £57,000 £60,125
UK excluding London median salary £50,000 £40,500 £42,000
% change year-on-year
+23.45% -3.57%
PowerPivot
London

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

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
1642 2175 3056
As % of all permanent IT jobs located in the City of London 30.91% 31.47% 27.46%
Number of salaries quoted 1527 1946 2701
Median salary £57,802 £57,500 £55,000
Median salary % change year-on-year
+0.52% +4.54%
90% offered a salary of more than £40,000 £41,500 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

PowerPivot
Jobs Demand Trend in the City of London

The demand trend of job ads across the City of London region citing PowerPivot as a proportion of all IT jobs with a match in the Database & Business Intelligence 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 3 December 2016.

PowerPivot Salary Histogram in the City of London

PowerPivot
Top 30 Related IT Skills in the City of London

For the 6 months to 3 December 2016, 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 29 (93.55%) SQL
1 29 (93.55%) SQL Server Reporting Services
2 28 (90.32%) Business Intelligence
3 24 (77.42%) Power BI
4 23 (74.19%) Microsoft
5 19 (61.29%) Finance
5 19 (61.29%) MDX
6 18 (58.06%) SQL Server Analysis Services
6 18 (58.06%) SQL Server Integration Services
6 18 (58.06%) MS Excel
7 16 (51.61%) T-SQL
7 16 (51.61%) SQL Server
8 15 (48.39%) Management Information System
9 14 (45.16%) Legal
9 14 (45.16%) Data Analysis
9 14 (45.16%) Data Cleansing
10 13 (41.94%) Tableau
10 13 (41.94%) Microsoft Analysis Services
11 12 (38.71%) Data Analysis Expressions (DAX)
11 12 (38.71%) Billing
12 11 (35.48%) VBA
12 11 (35.48%) ETL
12 11 (35.48%) Kimball Methodology
13 10 (32.26%) Visualisation
14 9 (29.03%) Data Quality
14 9 (29.03%) Analytical Skills
14 9 (29.03%) Data Modelling
14 9 (29.03%) Data Warehouse
15 8 (25.81%) SharePoint
15 8 (25.81%) Data Management

PowerPivot
Top Related 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 8 (25.81%) SharePoint
2 3 (9.68%) WebSphere
Applications
1 18 (58.06%) MS Excel
2 3 (9.68%) MS Visio
Cloud Services
1 1 (3.23%) Microsoft Azure
Database & Business Intelligence
1 29 (93.55%) SQL Server Reporting Services
2 24 (77.42%) Power BI
3 18 (58.06%) SQL Server Analysis Services
3 18 (58.06%) SQL Server Integration Services
4 16 (51.61%) SQL Server
5 13 (41.94%) Microsoft Analysis Services
6 9 (29.03%) Data Warehouse
7 6 (19.35%) MS Access
8 4 (12.90%) BusinessObjects
8 4 (12.90%) Relational Database
9 3 (9.68%) Big Data
9 3 (9.68%) Microsoft Power View
9 3 (9.68%) PerformancePoint
9 3 (9.68%) SAP Data Services
9 3 (9.68%) SQL Server 2012
9 3 (9.68%) SQL Server 2014
9 3 (9.68%) SQL Server 2016
10 2 (6.45%) Hadoop
11 1 (3.23%) BusinessObjects Dashboards
11 1 (3.23%) OLAP Cube
General
1 19 (61.29%) Finance
2 14 (45.16%) Legal
3 12 (38.71%) Billing
4 3 (9.68%) Advertising
4 3 (9.68%) Law
5 2 (6.45%) Banking
Job Titles
1 9 (29.03%) Developer
2 8 (25.81%) Business Intelligence Lead
2 8 (25.81%) Team Leader
3 6 (19.35%) Analyst
3 6 (19.35%) Business Intelligence Analyst
4 5 (16.13%) Business Intelligence Developer
5 4 (12.90%) Consultant
5 4 (12.90%) Report Analyst
5 4 (12.90%) SSRS Analyst
6 3 (9.68%) Business Intelligence Consultant
6 3 (9.68%) DBA
6 3 (9.68%) Excel Analyst
6 3 (9.68%) Microsoft BI Developer
6 3 (9.68%) Senior Business Intelligence Developer
6 3 (9.68%) Senior SQL Developer
6 3 (9.68%) Solutions Architect
6 3 (9.68%) SQL BI Developer
6 3 (9.68%) SSAS Developer
6 3 (9.68%) SSIS Developer
6 3 (9.68%) SSRS Developer
Libraries, Frameworks & Software Standards
1 19 (61.29%) MDX
2 1 (3.23%) JSON
2 1 (3.23%) Web Services
2 1 (3.23%) XML
Miscellaneous
1 15 (48.39%) Management Information System
2 10 (32.26%) Visualisation
3 9 (29.03%) Analytical Skills
4 3 (9.68%) Replication
5 1 (3.23%) User Experience
Processes & Methodologies
1 28 (90.32%) Business Intelligence
2 14 (45.16%) Data Analysis
2 14 (45.16%) Data Cleansing
3 11 (35.48%) ETL
3 11 (35.48%) Kimball Methodology
4 9 (29.03%) Data Modelling
5 8 (25.81%) Data Management
6 5 (16.13%) Process Improvement
7 3 (9.68%) Analytics
7 3 (9.68%) Business Analysis
7 3 (9.68%) Data Governance
7 3 (9.68%) Data Lineage
7 3 (9.68%) Enterprise Architecture
7 3 (9.68%) Master Data Management
7 3 (9.68%) Reverse Engineering
7 3 (9.68%) Service Delivery
7 3 (9.68%) Stakeholder Engagement
7 3 (9.68%) Systems Analysis
7 3 (9.68%) TOGAF
7 3 (9.68%) Translating Business Requirements
Programming Languages
1 29 (93.55%) SQL
2 16 (51.61%) T-SQL
3 12 (38.71%) Data Analysis Expressions (DAX)
4 11 (35.48%) VBA
5 6 (19.35%) C#
Qualifications
1 3 (9.68%) Degree
Quality Assurance & Compliance
1 9 (29.03%) Data Quality
2 6 (19.35%) PCI DSS
3 3 (9.68%) QA
3 3 (9.68%) SLA
Vendors
1 23 (74.19%) Microsoft
2 13 (41.94%) Tableau
3 4 (12.90%) SAP
4 3 (9.68%) IBM
4 3 (9.68%) Nintex