Period
to 18 November 2017

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

Microsoft Power Pivot
UK
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 1039 1040 936
Rank change year-on-year +1 -104 +27
Permanent jobs citing PowerPivot 138 182 385
As % of all permanent IT jobs advertised in the UK 0.077% 0.096% 0.18%
As % of the Database & Business Intelligence category 0.26% 0.32% 0.56%
Number of salaries quoted 123 168 327
UK median annual salary £54,979 £52,500 £45,000
Median salary % change year-on-year +4.72% +16.67% -
10th Percentile £28,200 £32,500 £28,250
90th Percentile £67,500 £68,750 £68,000
UK excluding London median annual salary £40,000 £45,000 £42,500
% change year-on-year -11.11% +5.88% +6.25%

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

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 54109 56256 68994
As % of all permanent IT jobs advertised in the UK 30.24% 29.63% 31.50%
Number of salaries quoted 44517 48077 58103
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +1.12%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £76,750 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

PowerPivot
Job Vacancy Trend

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

Job vacancy trend for PowerPivot in the UK

PowerPivot
Salary Trend

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

Salary trend for PowerPivot in the UK

PowerPivot
Salary Histogram

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

Salary histogram for PowerPivot in the UK

PowerPivot
Top 13 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the UK over the 6 months to 18 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -20 133 £54,979 +4.72% 6
London -2 73 £60,000 +4.35% 4
UK excluding London +20 61 £40,000 -11.11% 3
South East +22 22 £30,000 -40.00% 1
North of England -7 21 £40,000 -3.03% 1
Yorkshire +26 12 £40,000 -
North West -24 9 £38,000 +11.76% 1
Midlands +21 8 £50,000 +14.29%
East Midlands +38 6 £55,000 +37.50%
East of England +8 6 £53,750 +1.42%
South West -15 3 £56,250 +73.08%
West Midlands +14 2 £38,250 -19.47%
Wales - 1 £21,000 - 1

For the 6 months to 18 November 2017, 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 with a requirement for PowerPivot.

1 118 (85.51%) Business Intelligence
2 112 (81.16%) SQL
3 103 (74.64%) SQL Server
4 101 (73.19%) Power BI
5 89 (64.49%) SQL Server Reporting Services
6 85 (61.59%) SQL Server Integration Services
7 83 (60.14%) Microsoft
8 73 (52.90%) Data Warehouse
9 67 (48.55%) Microsoft Excel
10 63 (45.65%) SQL Server Analysis Services
11 57 (41.30%) ETL
12 51 (36.96%) Agile Software Development
13 50 (36.23%) T-SQL
14 46 (33.33%) Analytical Skills
15 42 (30.43%) Degree
16 41 (29.71%) Analytics
17 38 (27.54%) Microsoft Power View
18 35 (25.36%) MDX
19 32 (23.19%) Finance
20 31 (22.46%) Data Modelling
20 31 (22.46%) Tableau
21 30 (21.74%) OLAP
22 28 (20.29%) Scrum
22 28 (20.29%) Team Foundation Server
23 27 (19.57%) Microsoft Analysis Services
23 27 (19.57%) Data Analysis Expressions (DAX)
24 25 (18.12%) Kimball Methodology
24 25 (18.12%) Relational Database
24 25 (18.12%) Data Analysis
25 22 (15.94%) SQL Server 2008

PowerPivot
Co-occurring IT Skills 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 20 (14.49%) SharePoint
2 7 (5.07%) Apache Spark
3 3 (2.17%) WebSphere
4 2 (1.45%) IIS
4 2 (1.45%) SAS
5 1 (0.72%) Apache
5 1 (0.72%) Tomcat
Applications
1 67 (48.55%) Microsoft Excel
2 7 (5.07%) Spreadsheet
3 6 (4.35%) Microsoft PowerPoint
4 3 (2.17%) MS Visio
5 2 (1.45%) Microsoft Office
6 1 (0.72%) SPSS
Business Applications
1 9 (6.52%) Dynamics AX
2 3 (2.17%) NetSuite
3 2 (1.45%) Oracle ERP
4 1 (0.72%) Dynamics CRM
4 1 (0.72%) Dynamics NAV
4 1 (0.72%) StreamServe
Cloud Services
1 21 (15.22%) Microsoft Azure
2 7 (5.07%) Azure Machine Learning
2 7 (5.07%) Cloud Computing
2 7 (5.07%) Cortana Intelligence Suite
2 7 (5.07%) Dynamics 365
3 3 (2.17%) PaaS
3 3 (2.17%) SaaS
4 1 (0.72%) Amazon AWS
4 1 (0.72%) Azure Data Factory
4 1 (0.72%) Data Lake Analytics
Communications & Networking
1 11 (7.97%) Internet
2 1 (0.72%) LAN
2 1 (0.72%) WAN
Database & Business Intelligence
1 103 (74.64%) SQL Server
2 101 (73.19%) Power BI
3 89 (64.49%) SQL Server Reporting Services
4 85 (61.59%) SQL Server Integration Services
5 73 (52.90%) Data Warehouse
6 63 (45.65%) SQL Server Analysis Services
7 38 (27.54%) Microsoft Power View
8 30 (21.74%) OLAP
9 27 (19.57%) Microsoft Analysis Services
10 25 (18.12%) Relational Database
11 22 (15.94%) SQL Server 2008
12 21 (15.22%) QlikView
13 19 (13.77%) BusinessObjects
14 18 (13.04%) OLAP Cube
15 15 (10.87%) Big Data
15 15 (10.87%) GIS
15 15 (10.87%) SQL Server 2016
16 12 (8.70%) SQL Server 2014
17 11 (7.97%) Hadoop
18 9 (6.52%) Data Lake
Development Applications
1 28 (20.29%) Team Foundation Server
2 12 (8.70%) SQL Server Management Studio (SSMS)
3 10 (7.25%) Visual Studio
4 9 (6.52%) Octopus Deploy
5 7 (5.07%) JIRA
6 1 (0.72%) Git (software)
6 1 (0.72%) Talend Open Studio
6 1 (0.72%) Visual Studio Team System
General
1 32 (23.19%) Finance
2 18 (13.04%) Banking
3 16 (11.59%) Retail
4 15 (10.87%) Retail Banking
5 12 (8.70%) Publishing
6 6 (4.35%) Back Office
6 6 (4.35%) Marketing
7 4 (2.90%) Advertising
8 1 (0.72%) Automotive
8 1 (0.72%) Manufacturing
8 1 (0.72%) Pharmaceutical
Job Titles
1 66 (47.83%) Developer
2 44 (31.88%) Business Intelligence Developer
3 41 (29.71%) Analyst
4 23 (16.67%) SQL Developer
5 17 (12.32%) Data Analyst
6 16 (11.59%) Business Developer
7 15 (10.87%) Business Intelligence Analyst
7 15 (10.87%) Business Intelligence Consultant
7 15 (10.87%) Consultant
7 15 (10.87%) SQL BI Developer
8 13 (9.42%) SSAS Developer
8 13 (9.42%) SSIS Developer
9 12 (8.70%) Power BI Developer
9 12 (8.70%) SSRS Developer
10 11 (7.97%) Agile Developer
10 11 (7.97%) T-SQL Developer
11 10 (7.25%) Business Intelligence Lead
12 9 (6.52%) Database Developer
13 8 (5.80%) Architect
14 7 (5.07%) SQL DBA
Libraries, Frameworks & Software Standards
1 35 (25.36%) MDX
2 15 (10.87%) .NET
3 3 (2.17%) EDI
3 3 (2.17%) XML
4 2 (1.45%) CSS
4 2 (1.45%) HTML
4 2 (1.45%) Web Services
5 1 (0.72%) ASP.NET
5 1 (0.72%) COM
Miscellaneous
1 46 (33.33%) Analytical Skills
2 11 (7.97%) Management Information System
3 10 (7.25%) NHS
4 7 (5.07%) iPhone
5 6 (4.35%) Enterprise Software
6 5 (3.62%) Algorithms
6 5 (3.62%) Driving Licence
7 1 (0.72%) Computer Science
7 1 (0.72%) Credit Risk
7 1 (0.72%) PMI
Operating Systems
1 7 (5.07%) Linux
2 2 (1.45%) Windows
2 2 (1.45%) Windows Server 2008
2 2 (1.45%) Windows Server 2012
Processes & Methodologies
1 118 (85.51%) Business Intelligence
2 57 (41.30%) ETL
3 51 (36.96%) Agile Software Development
4 41 (29.71%) Analytics
5 31 (22.46%) Data Modelling
6 28 (20.29%) Scrum
7 25 (18.12%) Data Analysis
7 25 (18.12%) Kimball Methodology
8 19 (13.77%) Dimensional Modelling
9 17 (12.32%) Visualisation
10 15 (10.87%) Kanban
10 15 (10.87%) Migration
11 14 (10.14%) Performance Tuning
12 12 (8.70%) ERP
12 12 (8.70%) Mathematics
13 10 (7.25%) Business Analysis
13 10 (7.25%) Data Analytics
13 10 (7.25%) Mentoring
14 9 (6.52%) Collaborative Working
14 9 (6.52%) Strategic Thinking
Programming Languages
1 112 (81.16%) SQL
2 50 (36.23%) T-SQL
3 27 (19.57%) Data Analysis Expressions (DAX)
4 20 (14.49%) VBA
5 11 (7.97%) PowerShell
6 10 (7.25%) JavaScript
7 8 (5.80%) C#
7 8 (5.80%) R
8 6 (4.35%) Python
9 3 (2.17%) VB
10 2 (1.45%) Java
10 2 (1.45%) VBScript
11 1 (0.72%) C
11 1 (0.72%) C++
11 1 (0.72%) Pascal
11 1 (0.72%) VB.NET
11 1 (0.72%) X++
Qualifications
1 42 (30.43%) Degree
2 5 (3.62%) MCSA
2 5 (3.62%) MCSE
2 5 (3.62%) Microsoft Certification
3 4 (2.90%) MBA
4 2 (1.45%) PRINCE2 Practitioner
5 1 (0.72%) APMP
5 1 (0.72%) CFA
5 1 (0.72%) CIMA
5 1 (0.72%) PhD
5 1 (0.72%) PMI Certification
Quality Assurance & Compliance
1 8 (5.80%) Data Quality
2 6 (4.35%) QA
3 5 (3.62%) NEBOSH
4 3 (2.17%) Cyber Essentials
4 3 (2.17%) ISO/IEC 27001
5 1 (0.72%) SLA
Vendors
1 83 (60.14%) Microsoft
2 31 (22.46%) Tableau
3 13 (9.42%) Oracle
4 10 (7.25%) MicroStrategy
5 8 (5.80%) JD Edwards
6 6 (4.35%) RedGate
7 5 (3.62%) IBM
7 5 (3.62%) SAP
8 3 (2.17%) Nintex
9 2 (1.45%) Cloudera
9 2 (1.45%) TOWER Software
10 1 (0.72%) Alteryx
10 1 (0.72%) Cognos
10 1 (0.72%) Hortonworks
10 1 (0.72%) IDERA
10 1 (0.72%) Informatica
10 1 (0.72%) Logi
10 1 (0.72%) Logi Analytics
10 1 (0.72%) Talend