The table below looks at the statistics for PowerPivot skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited PowerPivot over the 3 months to 1 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 798 761 863
Rank change year-on-year
-37 +102
Permanent jobs citing PowerPivot 118 209 134
As % of all permanent IT jobs located in the UK 0.12% 0.19% 0.11%
As % of the Database & Business Intelligence category 0.40% 0.58% 0.35%
Number of salaries quoted 97 183 118
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £30,600 £36,300 £27,500
10% offered a salary of more than £65,000 £70,000 £75,000
UK excluding London median salary £44,000 £50,000 £43,750
% change year-on-year
-12.00% +14.28%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
29145 36067 38672
As % of all permanent IT jobs located in the UK 29.87% 32.55% 32.15%
Number of salaries quoted 24822 30399 33209
Median salary £49,000 £47,500 £45,000
Median salary % change year-on-year
+3.15% +5.55%
90% offered a salary of more than £32,500 £32,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

PowerPivot
Jobs Demand Trend

The demand trend of job ads citing PowerPivot as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

PowerPivot Jobs Demand Trend in the UK

PowerPivot
Salary Trend

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

PowerPivot Salary Trend in the UK

PowerPivot
Salary Histogram

This chart provides a salary histogram for IT jobs citing PowerPivot over the 3 months to 1 July 2016 within the UK.

PowerPivot Salary Histogram in the UK

PowerPivot
Top 30 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 3 months to 1 July 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -36 116 £50,000 - 12
London +21 50 £60,000 +5.72% 5
City of London +59 22 £57,500 +9.52% 2
South East -25 19 £51,250 +2.50% 2
Surrey +5 16 £52,500 +16.66%
North West +17 15 £30,000 -20.00% 1
Woking - 13 £52,500 -
West Yorkshire +15 12 £44,500 +11.25% 2
Yorkshire +1 12 £44,500 -1.11% 2
Lancashire - 9 £30,000 -
Chorley - 9 £30,000 -
Leeds +6 8 £37,500 -6.25% 2
East of England +43 5 £53,000 +11.57%
South West +12 5 £55,000 +77.41%
Bristol +29 4 £55,000 +77.41%
Hertfordshire +28 4 £53,000 +11.57%
Bradford +15 4 £45,000 -18.18%
Manchester -2 4 £34,000 -9.33% 1
West Midlands -5 4 £40,000 +14.28% 2
Durham - 4 £41,000 -
St Albans - 4 £53,000 -
North East - 4 £41,000 -
Birmingham -8 3 £40,000 +14.28% 1
Cheshire +45 2 £20,000 -
Leicester +6 2 £40,000 -21.56%
East Midlands +6 2 £40,000 -18.78%
Leicestershire +2 2 £40,000 -21.56%
South Wales - 2 £40,967 -
Wales - 2 £40,967 -
Berkshire +8 1 £60,000 +17.07%

PowerPivot
Top 30 Related IT Skills

For the 6 months to 1 July 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 with a requirement for PowerPivot.

1 240 (86.33%) Business Intelligence
2 234 (84.17%) SQL
3 209 (75.18%) SQL Server
4 205 (73.74%) Microsoft
5 203 (73.02%) SQL Server Reporting Services
6 179 (64.39%) SQL Server Analysis Services
7 168 (60.43%) SQL Server Integration Services
8 148 (53.24%) MS Excel
9 139 (50.00%) Data Warehouse
10 132 (47.48%) T-SQL
11 126 (45.32%) Power BI
12 119 (42.81%) ETL
13 108 (38.85%) MDX
14 96 (34.53%) Microsoft Power View
15 93 (33.45%) Finance
16 76 (27.34%) SharePoint
17 73 (26.26%) Data Analysis Expressions (DAX)
18 71 (25.54%) Agile Software Development
19 68 (24.46%) SQL Server 2012
20 65 (23.38%) Analytics
21 61 (21.94%) Kimball Methodology
22 60 (21.58%) Tableau
22 60 (21.58%) VBA
23 56 (20.14%) OLAP
24 55 (19.78%) SQL Server 2008
25 52 (18.71%) Management Information System
26 51 (18.35%) Data Management
26 51 (18.35%) SQL Server 2014
27 48 (17.27%) Data Quality
28 46 (16.55%) Visualisation

PowerPivot
Top Related 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 76 (27.34%) SharePoint
2 14 (5.04%) SAS
3 9 (3.24%) SharePoint Server
4 3 (1.08%) IIS
5 2 (0.72%) NServiceBus
6 1 (0.36%) Apache
6 1 (0.36%) Tomcat
6 1 (0.36%) WebSphere
Applications
1 148 (53.24%) MS Excel
2 13 (4.68%) MS Office
3 10 (3.60%) MS Visio
4 9 (3.24%) MS PowerPoint
5 5 (1.80%) SPSS
6 4 (1.44%) Spreadsheet
Business Applications
1 9 (3.24%) Dynamics CRM
2 4 (1.44%) Oracle Financials
2 4 (1.44%) SAP Business One
3 2 (0.72%) Tesseract
4 1 (0.36%) Cognos TM1
4 1 (0.36%) Dynamics AX
4 1 (0.36%) Sage 1000
Cloud Services
1 27 (9.71%) Microsoft Azure
2 5 (1.80%) Adobe Analytics
2 5 (1.80%) Google Analytics
3 2 (0.72%) SaaS
4 1 (0.36%) Amazon AWS
4 1 (0.36%) Office 365
4 1 (0.36%) PaaS
Communications & Networking
1 5 (1.80%) DNS
2 3 (1.08%) DHCP
Database & Business Intelligence
1 209 (75.18%) SQL Server
2 203 (73.02%) SQL Server Reporting Services
3 179 (64.39%) SQL Server Analysis Services
4 168 (60.43%) SQL Server Integration Services
5 139 (50.00%) Data Warehouse
6 126 (45.32%) Power BI
7 96 (34.53%) Microsoft Power View
8 68 (24.46%) SQL Server 2012
9 56 (20.14%) OLAP
10 55 (19.78%) SQL Server 2008
11 51 (18.35%) SQL Server 2014
12 38 (13.67%) Relational Database
13 35 (12.59%) Microsoft Analysis Services
14 32 (11.51%) SQL Server 2005
15 28 (10.07%) PerformancePoint
16 26 (9.35%) Data Mining
17 25 (8.99%) SQL Server 2016
18 23 (8.27%) RDBMS
19 20 (7.19%) MS Access
20 17 (6.12%) Big Data
Development Applications
1 15 (5.40%) Team Foundation Server
2 8 (2.88%) Talend Open Studio
3 7 (2.52%) SQL Server Management Studio (SSMS)
4 6 (2.16%) Visual Studio
5 3 (1.08%) JIRA
5 3 (1.08%) Visual Studio Tools for Office
6 1 (0.36%) Git (software)
6 1 (0.36%) Subversion
6 1 (0.36%) Toad
General
1 93 (33.45%) Finance
2 19 (6.83%) Legal
3 17 (6.12%) Marketing
4 15 (5.40%) Billing
5 14 (5.04%) Advertising
6 13 (4.68%) Banking
7 9 (3.24%) Telecoms
8 6 (2.16%) Manufacturing
8 6 (2.16%) Private Banking
9 5 (1.80%) Retail
10 2 (0.72%) Arabic Language
10 2 (0.72%) Financial Institution
10 2 (0.72%) French Language
10 2 (0.72%) German Language
10 2 (0.72%) Hindi Language
10 2 (0.72%) Investment Banking
10 2 (0.72%) Russian Language
10 2 (0.72%) Spanish Language
11 1 (0.36%) Welsh Language
Job Titles
1 140 (50.36%) Developer
2 108 (38.85%) Business Intelligence Developer
3 89 (32.01%) Analyst
4 60 (21.58%) SQL Developer
5 45 (16.19%) Business Intelligence Analyst
6 36 (12.95%) SQL BI Developer
7 34 (12.23%) SSIS Developer
8 32 (11.51%) SQL Analyst
9 29 (10.43%) Report Analyst
10 26 (9.35%) Microsoft BI Developer
11 25 (8.99%) SQL Server Developer
12 24 (8.63%) Microsoft Developer
13 23 (8.27%) SSRS Analyst
14 21 (7.55%) SSAS Developer
15 20 (7.19%) SSRS Developer
16 19 (6.83%) Business Developer
17 17 (6.12%) Senior Business Intelligence Developer
17 17 (6.12%) Senior Developer
18 16 (5.76%) DBA
18 16 (5.76%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 108 (38.85%) MDX
2 22 (7.91%) HTML
3 18 (6.47%) CSS
3 18 (6.47%) XML
4 14 (5.04%) .NET
5 11 (3.96%) Web Services
6 4 (1.44%) ASP.NET
7 3 (1.08%) Ajax
7 3 (1.08%) DWR
7 3 (1.08%) HTML5
7 3 (1.08%) jQuery
7 3 (1.08%) JSON
8 2 (0.72%) RabbitMQ
9 1 (0.36%) Google Maps API
9 1 (0.36%) Middleware
Miscellaneous
1 52 (18.71%) Management Information System
2 46 (16.55%) Analytical Skills
2 46 (16.55%) Visualisation
3 24 (8.63%) Mathematics
4 18 (6.47%) Data Integration
5 16 (5.76%) Computer Science
6 14 (5.04%) Statistics
7 12 (4.32%) Mobile App
8 11 (3.96%) Replication
9 9 (3.24%) User Experience
10 5 (1.80%) Data Extraction
10 5 (1.80%) iPad
11 4 (1.44%) Digital Media
12 3 (1.08%) Enterprise Software
13 2 (0.72%) Data Structures
13 2 (0.72%) Economics
13 2 (0.72%) Fintech
13 2 (0.72%) Freedom of Information
13 2 (0.72%) NHS
14 1 (0.36%) Hybrid Cloud
Operating Systems
1 5 (1.80%) Windows
1 5 (1.80%) Windows Server
1 5 (1.80%) Windows Server 2012
2 3 (1.08%) Windows Server 2008
3 2 (0.72%) Windows Server 2003
Processes & Methodologies
1 240 (86.33%) Business Intelligence
2 119 (42.81%) ETL
3 71 (25.54%) Agile Software Development
4 65 (23.38%) Analytics
5 61 (21.94%) Kimball Methodology
6 51 (18.35%) Data Management
7 46 (16.55%) Data Modelling
8 43 (15.47%) Data Analysis
9 29 (10.43%) Data Analytics
10 26 (9.35%) Dashboard Development
11 23 (8.27%) Performance Tuning
12 22 (7.91%) Data Cleansing
12 22 (7.91%) Data Visualisation
12 22 (7.91%) Scrum
13 20 (7.19%) SDLC
14 19 (6.83%) Dimensional Modelling
14 19 (6.83%) Presales
14 19 (6.83%) Reverse Engineering
14 19 (6.83%) Validation
15 17 (6.12%) E-Commerce
Programming Languages
1 234 (84.17%) SQL
2 132 (47.48%) T-SQL
3 73 (26.26%) Data Analysis Expressions (DAX)
4 60 (21.58%) VBA
5 38 (13.67%) C#
6 6 (2.16%) VBScript
7 4 (1.44%) JavaScript
8 3 (1.08%) R
8 3 (1.08%) VB.NET
9 2 (0.72%) Java
9 2 (0.72%) PL/SQL
9 2 (0.72%) PowerShell
9 2 (0.72%) Python
Qualifications
1 36 (12.95%) Degree
2 16 (5.76%) Microsoft Certification
3 8 (2.88%) MCSE
4 4 (1.44%) MCSA
5 2 (0.72%) ACCA
5 2 (0.72%) CIMA
6 1 (0.36%) MBA
6 1 (0.36%) PMI Certification
6 1 (0.36%) PMP
Quality Assurance & Compliance
1 48 (17.27%) Data Quality
2 13 (4.68%) PCI DSS
3 12 (4.32%) Solvency II
4 7 (2.52%) QA
5 4 (1.44%) Basel II
6 3 (1.08%) SLA
7 1 (0.36%) ISO/IEC 27001
System Software
1 5 (1.80%) Active Directory
2 2 (0.72%) VMware ESX
3 1 (0.36%) VMware Infrastructure
Systems Management
1 1 (0.36%) Jitterbit
Vendors
1 205 (73.74%) Microsoft
2 60 (21.58%) Tableau
3 23 (8.27%) Cognos
4 15 (5.40%) Oracle
5 11 (3.96%) IBM
6 8 (2.88%) Capita
6 8 (2.88%) Informatica
6 8 (2.88%) SAP
6 8 (2.88%) Talend
7 7 (2.52%) Hitachi
8 6 (2.16%) Google
9 5 (1.80%) Adobe
10 4 (1.44%) Ab Initio
11 2 (0.72%) Dell
11 2 (0.72%) HP
11 2 (0.72%) VMware
12 1 (0.36%) JD Edwards
12 1 (0.36%) MicroStrategy
12 1 (0.36%) Sage
12 1 (0.36%) Salesforce.com
Leamington Spa, Warwickshire
Nigel Frank International Ltd
Salary: £40000 - £57000 per annum + Pension, Negotiable
Posted: 1 hour ago
Leeds, West Yorkshire
The Bridge Ltd
Salary: From £30,000 to £45,000 per annum
Posted: 20 hours ago
City, London
HAYS INFORMATION TECHNOLOGY
Salary: £45000.00 - £55000.00 per annum
Posted: Yesterday
City, London
HAYS INFORMATION TECHNOLOGY
Salary: £40000.00 - £55000.00 per annum
Posted: 2 days ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £35,000 per annum
Posted: 3 days ago
South East London
Bluetownonline
Salary: £28000 - £35000 per annum
Posted: Yesterday
Tonbridge, Kent
Intech 7
Salary: From £55,000 to £65,000 per annum excellent salary, benefits and worki
Posted: 3 days ago
Crawley, West Sussex
Opus Recruitment Solutions Ltd
Salary: £30000 - £32000 per annum
Posted: 6 days ago
London
Connectus
Salary: £48000 - £60000 per annum
Posted: 2 days ago
Manchester
Hays Specialist Recruitment Ltd
Salary: £20000.00 - £23000.00 per annum + Benefits
Posted: 9 days ago
Birmingham
Hays Specialist Recruitment Ltd
Salary: £23000.00 per annum
Posted: 9 days ago
South East London
Merkle DBG
Salary: Competitive + Benefits
Posted: 23 days ago