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 31 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
31 Jul 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 816 771 868
Rank change year-on-year
-45 +97
Permanent jobs citing PowerPivot 96 198 128
As % of all permanent IT jobs located in the UK 0.098% 0.18% 0.11%
As % of the Database & Business Intelligence category 0.33% 0.57% 0.34%
Number of salaries quoted 86 165 116
Median salary £52,500 £50,000 £50,000
Median salary % change year-on-year
+5.00% -
90% offered a salary of more than £31,750 £36,000 £29,000
10% offered a salary of more than £65,000 £70,000 £80,000
UK excluding London median salary £44,500 £50,000 £33,750
% change year-on-year
-11.00% +48.14%

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
29118 34710 37374
As % of all permanent IT jobs located in the UK 29.74% 31.69% 31.95%
Number of salaries quoted 24742 29246 31876
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £31,951 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 31 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 31 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 -68 95 £52,500 +5.00% 19
London +27 44 £60,000 +4.34% 4
City of London +83 22 £57,500 +4.54% 1
South East -35 14 £52,500 +5.00% 3
Yorkshire +14 12 £38,750 -22.50% 3
West Yorkshire +5 11 £37,500 -25.00% 2
North West +5 11 £30,000 -20.00% 3
Surrey -5 10 £52,500 +23.52%
Woking - 10 £52,500 -
Leeds +6 7 £37,500 -25.00% 2
Chorley - 7 £30,000 -
Lancashire - 7 £30,000 -
East of England +40 5 £53,000 +11.57%
West Midlands -1 5 £47,500 -13.63% 2
Hertfordshire +27 4 £53,000 +11.57%
Bradford +9 4 £45,000 -18.18%
St Albans - 4 £53,000 -
Berkshire -8 3 £60,000 +14.28%
Cheshire +40 2 £20,000 -
Bristol +21 2 £55,000 +77.41%
South West +2 2 £55,000 +77.41% 1
Maidenhead -7 2 - -
Birmingham -8 2 £40,000 - 2
Manchester -13 2 £34,000 -9.33% 3
North East - 2 £42,250 - 1
Coventry - 2 £47,500 -
South Wales +10 1 £45,000 +38.46%
Cardiff +6 1 £45,000 +38.46%
Wales +6 1 £45,000 +38.46%
West Sussex - 1 £31,000 -

PowerPivot
Top 30 Related IT Skills

For the 6 months to 31 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 224 (84.53%) SQL
2 223 (84.15%) Business Intelligence
3 195 (73.58%) SQL Server
4 194 (73.21%) Microsoft
5 190 (71.70%) SQL Server Reporting Services
6 169 (63.77%) SQL Server Analysis Services
7 155 (58.49%) SQL Server Integration Services
8 137 (51.70%) MS Excel
9 126 (47.55%) Data Warehouse
10 125 (47.17%) T-SQL
11 124 (46.79%) Power BI
12 114 (43.02%) ETL
13 98 (36.98%) MDX
14 94 (35.47%) Finance
15 75 (28.30%) Microsoft Power View
16 74 (27.92%) Data Analysis Expressions (DAX)
17 64 (24.15%) SharePoint
18 63 (23.77%) Agile Software Development
19 61 (23.02%) Kimball Methodology
20 58 (21.89%) SQL Server 2012
21 56 (21.13%) Tableau
21 56 (21.13%) VBA
22 53 (20.00%) OLAP
22 53 (20.00%) Management Information System
22 53 (20.00%) Analytics
23 50 (18.87%) Data Quality
24 48 (18.11%) Analytical Skills
25 47 (17.74%) SQL Server 2008
26 44 (16.60%) Data Management
26 44 (16.60%) Data Analysis

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 64 (24.15%) SharePoint
2 13 (4.91%) SAS
3 3 (1.13%) IIS
3 3 (1.13%) WebSphere
4 1 (0.38%) Apache
4 1 (0.38%) NServiceBus
4 1 (0.38%) Tomcat
Applications
1 137 (51.70%) MS Excel
2 8 (3.02%) MS Office
3 6 (2.26%) MS PowerPoint
4 5 (1.89%) SPSS
5 4 (1.51%) Spreadsheet
6 3 (1.13%) MS Visio
Business Applications
1 10 (3.77%) Dynamics CRM
2 5 (1.89%) Oracle Financials
3 4 (1.51%) SAP Business One
4 2 (0.75%) Tesseract
5 1 (0.38%) Cognos TM1
5 1 (0.38%) Dynamics AX
5 1 (0.38%) Sage 1000
Cloud Services
1 29 (10.94%) Microsoft Azure
2 6 (2.26%) Google Analytics
3 5 (1.89%) Adobe Analytics
3 5 (1.89%) SaaS
4 3 (1.13%) PaaS
5 1 (0.38%) AdWords
5 1 (0.38%) Amazon AWS
5 1 (0.38%) Azure Machine Learning
5 1 (0.38%) Office 365
Communications & Networking
1 3 (1.13%) DHCP
1 3 (1.13%) DNS
Database & Business Intelligence
1 195 (73.58%) SQL Server
2 190 (71.70%) SQL Server Reporting Services
3 169 (63.77%) SQL Server Analysis Services
4 155 (58.49%) SQL Server Integration Services
5 126 (47.55%) Data Warehouse
6 124 (46.79%) Power BI
7 75 (28.30%) Microsoft Power View
8 58 (21.89%) SQL Server 2012
9 53 (20.00%) OLAP
10 47 (17.74%) SQL Server 2008
11 41 (15.47%) SQL Server 2014
12 38 (14.34%) Relational Database
13 28 (10.57%) SQL Server 2005
14 25 (9.43%) Microsoft Analysis Services
15 24 (9.06%) SQL Server 2016
16 20 (7.55%) MS Access
17 19 (7.17%) RDBMS
18 18 (6.79%) Big Data
18 18 (6.79%) PerformancePoint
19 17 (6.42%) Pentaho
Development Applications
1 14 (5.28%) Team Foundation Server
2 9 (3.40%) Visual Studio
3 7 (2.64%) SQL Server Management Studio (SSMS)
4 3 (1.13%) JIRA
4 3 (1.13%) Visual Studio Tools for Office
5 1 (0.38%) Git (software)
5 1 (0.38%) Subversion
5 1 (0.38%) Toad
General
1 94 (35.47%) Finance
2 23 (8.68%) Legal
3 22 (8.30%) Marketing
4 18 (6.79%) Advertising
5 17 (6.42%) Billing
6 11 (4.15%) Banking
7 9 (3.40%) Telecoms
8 6 (2.26%) Private Banking
9 5 (1.89%) Retail
10 3 (1.13%) Manufacturing
11 2 (0.75%) Arabic Language
11 2 (0.75%) Financial Institution
11 2 (0.75%) French Language
11 2 (0.75%) German Language
11 2 (0.75%) Hindi Language
11 2 (0.75%) Investment Banking
11 2 (0.75%) Russian Language
11 2 (0.75%) Spanish Language
12 1 (0.38%) Welsh Language
Job Titles
1 131 (49.43%) Developer
2 102 (38.49%) Business Intelligence Developer
3 89 (33.58%) Analyst
4 56 (21.13%) SQL Developer
5 41 (15.47%) Business Intelligence Analyst
6 35 (13.21%) SQL BI Developer
7 34 (12.83%) SSIS Developer
8 31 (11.70%) Report Analyst
9 30 (11.32%) SQL Analyst
10 25 (9.43%) Microsoft BI Developer
10 25 (9.43%) SSRS Analyst
11 23 (8.68%) Microsoft Developer
11 23 (8.68%) SQL Server Developer
12 21 (7.92%) SSAS Developer
13 18 (6.79%) Business Developer
13 18 (6.79%) SSRS Developer
14 17 (6.42%) Senior Business Intelligence Developer
14 17 (6.42%) Senior Developer
15 16 (6.04%) Data Analyst
15 16 (6.04%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 98 (36.98%) MDX
2 22 (8.30%) HTML
3 20 (7.55%) XML
4 17 (6.42%) CSS
5 15 (5.66%) .NET
6 10 (3.77%) Web Services
7 5 (1.89%) ASP.NET
8 4 (1.51%) HTML5
8 4 (1.51%) JSON
9 3 (1.13%) Ajax
9 3 (1.13%) DWR
9 3 (1.13%) jQuery
9 3 (1.13%) REST
9 3 (1.13%) SOAP
10 1 (0.38%) Google Maps API
10 1 (0.38%) Middleware
10 1 (0.38%) RabbitMQ
Miscellaneous
1 53 (20.00%) Management Information System
2 48 (18.11%) Analytical Skills
3 43 (16.23%) Visualisation
4 24 (9.06%) Mathematics
5 16 (6.04%) Data Integration
6 15 (5.66%) Computer Science
7 11 (4.15%) Mobile App
7 11 (4.15%) Statistics
8 10 (3.77%) Replication
9 9 (3.40%) User Experience
10 5 (1.89%) Data Extraction
10 5 (1.89%) iPad
11 4 (1.51%) Digital Media
12 3 (1.13%) Enterprise Software
13 2 (0.75%) Data Structures
13 2 (0.75%) Economics
13 2 (0.75%) Fintech
13 2 (0.75%) Freedom of Information
13 2 (0.75%) NHS
14 1 (0.38%) Data Protection Act
Operating Systems
1 3 (1.13%) Windows
1 3 (1.13%) Windows Server
1 3 (1.13%) Windows Server 2008
1 3 (1.13%) Windows Server 2012
Processes & Methodologies
1 223 (84.15%) Business Intelligence
2 114 (43.02%) ETL
3 63 (23.77%) Agile Software Development
4 61 (23.02%) Kimball Methodology
5 53 (20.00%) Analytics
6 44 (16.60%) Data Analysis
6 44 (16.60%) Data Management
7 36 (13.58%) Data Modelling
8 28 (10.57%) Data Cleansing
9 24 (9.06%) Data Analytics
10 23 (8.68%) Dashboard Development
11 22 (8.30%) Data Visualisation
11 22 (8.30%) Scrum
12 19 (7.17%) SDLC
13 18 (6.79%) Dimensional Modelling
13 18 (6.79%) Reverse Engineering
14 17 (6.42%) E-Commerce
14 17 (6.42%) Presales
15 16 (6.04%) CRM
15 16 (6.04%) Performance Tuning
Programming Languages
1 224 (84.53%) SQL
2 125 (47.17%) T-SQL
3 74 (27.92%) Data Analysis Expressions (DAX)
4 56 (21.13%) VBA
5 36 (13.58%) C#
6 4 (1.51%) JavaScript
6 4 (1.51%) R
6 4 (1.51%) VB.NET
6 4 (1.51%) VBScript
7 2 (0.75%) Java
7 2 (0.75%) PL/SQL
7 2 (0.75%) Python
8 1 (0.38%) VB
Qualifications
1 38 (14.34%) Degree
2 7 (2.64%) MCSE
2 7 (2.64%) Microsoft Certification
3 4 (1.51%) MCSA
4 2 (0.75%) ACCA
4 2 (0.75%) CIMA
5 1 (0.38%) MBA
5 1 (0.38%) PMI Certification
5 1 (0.38%) PMP
5 1 (0.38%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 50 (18.87%) Data Quality
2 14 (5.28%) PCI DSS
3 12 (4.53%) Solvency II
4 8 (3.02%) QA
5 4 (1.51%) Basel II
5 4 (1.51%) SLA
6 3 (1.13%) ISO/IEC 27001
System Software
1 3 (1.13%) Active Directory
Systems Management
1 1 (0.38%) Jitterbit
Vendors
1 194 (73.21%) Microsoft
2 56 (21.13%) Tableau
3 19 (7.17%) Oracle
4 13 (4.91%) Cognos
5 11 (4.15%) SAP
6 9 (3.40%) IBM
7 7 (2.64%) Google
8 5 (1.89%) Adobe
8 5 (1.89%) Salesforce.com
9 4 (1.51%) Ab Initio
9 4 (1.51%) Hitachi
10 3 (1.13%) Nintex
11 1 (0.38%) Alteryx
11 1 (0.38%) IDERA
11 1 (0.38%) JD Edwards
11 1 (0.38%) MicroStrategy
11 1 (0.38%) MuleSoft
11 1 (0.38%) RedGate
11 1 (0.38%) Sage
Leicestershire
Recann
Salary: £45000 - £50000 per annum + Benefits
Posted: 3 days ago
Birmingham
Nigel Frank International Ltd
Salary: £40000 - £55000 per annum + Company bonus + Benefits
Posted: 5 days ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £35,000 per annum
Posted: 3 days ago
Leeds, West Yorkshire
The Bridge Ltd
Salary: From £30,000 to £45,000 per annum
Posted: 4 days ago
Basingstoke, Hampshire
IntaPeople
Salary: £35000 - £40000 per annum
Posted: Yesterday
Chesterfield
Nigel Frank International Ltd
Salary: £45000 - £55000 per annum + Car + Bonus + Package
Posted: 6 days ago
City, London
Streamline Connections
Salary: £55000 - £60000.00 per annum + Benefits
Posted: 6 days ago
London
Venturi
Salary: £50000 - £80000 per annum + Bonus + Benefits
Posted: 4 days ago
Basingstoke, Hampshire
Latcom Ltd
Salary: From £35,000 to £40,000 per annum
Posted: 2 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 9 days ago
South East England
Lawrence Harvey
Salary: £62000.00 - £70000.00 per annum + flexible
Posted: 12 days ago
Newcastle upon Tyne
Hays Specialist Recruitment Ltd
Salary: £40000.00 - £46000.00 per annum
Posted: 10 days ago
York
Computer Futures
Salary: competitive
Posted: 16 days ago
London
Next Ventures Limited
Salary: £60,000 - £75,000 per year
Posted: 9 days ago
Manchester
Hays Specialist Recruitment Ltd
Salary: £20000.00 - £23000.00 per annum + Benefits
Posted: 11 days ago
Manchester
Arrow Global
Salary: Competitive
Posted: 19 days ago
Birmingham, West Midlands (County)
HAYS INFORMATION TECHNOLOGY
Salary: £23000.00 per annum
Posted: 4 days ago
Malmesbury, Wiltshire
Dyson
Posted: 22 days ago