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

3 months to
29 Sep 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 825 765 800
Rank change year-on-year
-60 +35
Permanent jobs citing PowerPivot 82 202 184
As % of all permanent IT jobs located in the UK 0.086% 0.18% 0.16%
As % of the Database & Business Intelligence category 0.29% 0.60% 0.51%
Number of salaries quoted 76 175 160
Median salary £50,000 £42,500 £45,000
Median salary % change year-on-year
+17.64% -5.55%
90% offered a salary of more than £37,500 £30,459 £30,000
10% offered a salary of more than £65,000 £62,500 £66,250
UK excluding London median salary £45,000 £40,500 £37,500
% change year-on-year
+11.11% +8.00%

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
28097 33606 35887
As % of all permanent IT jobs located in the UK 29.57% 30.75% 31.39%
Number of salaries quoted 23895 28456 30138
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 £32,500 £30,000
10% offered a salary of more than £75,000 £67,500 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

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 29 September 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 29 September 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 -51 80 £50,000 +17.64% 9
London +7 33 £57,500 +21.05% 1
South East +3 18 £37,500 -13.79%
City of London +63 14 £53,750 -6.52%
Yorkshire +29 8 £37,500 -25.00% 1
Hampshire +10 8 £36,250 -27.50%
Basingstoke -17 8 £36,250 -27.50%
Leeds +30 7 £37,500 -25.00% 1
West Yorkshire +18 7 £37,500 -25.00% 1
Manchester -1 6 £62,500 +66.66% 4
North West -24 6 £62,500 +105.19% 5
Berkshire +26 5 £47,500 -
East of England +16 5 £55,000 +2.80%
Cambridgeshire - 4 £53,750 -
South West -4 3 £40,000 +25.00% 1
West Sussex - 3 £42,500 -
Slough - 3 £47,500 -
Maidenhead -6 2 - -
West Midlands -24 2 £47,500 +55.94% 1
Tyne and Wear - 2 £48,000 -
East Midlands - 2 £45,000 -
North East - 2 £48,000 -
Bristol - 2 £40,000 -
Coventry - 2 £47,500 -
Newcastle upon Tyne - 2 £48,000 -
Derbyshire - 2 £45,000 -
Scotland +19 1 £50,000 +85.18%
Wiltshire -3 1 - -
Surrey -3 1 £57,500 +41.10%
Chiswick - 1 £32,500 -

PowerPivot
Top 30 Related IT Skills

For the 6 months to 29 September 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 174 (86.14%) SQL
2 173 (85.64%) Business Intelligence
3 157 (77.72%) Microsoft
4 152 (75.25%) SQL Server Reporting Services
5 149 (73.76%) SQL Server
6 141 (69.80%) SQL Server Analysis Services
7 128 (63.37%) SQL Server Integration Services
8 113 (55.94%) Power BI
9 103 (50.99%) MS Excel
10 97 (48.02%) T-SQL
11 80 (39.60%) Data Warehouse
11 80 (39.60%) ETL
12 70 (34.65%) MDX
13 69 (34.16%) Finance
14 57 (28.22%) Tableau
15 55 (27.23%) Agile Software Development
16 53 (26.24%) Data Analysis Expressions (DAX)
17 50 (24.75%) SQL Server 2012
18 47 (23.27%) Kimball Methodology
19 44 (21.78%) Visualisation
20 42 (20.79%) Microsoft Power View
21 40 (19.80%) Analytical Skills
21 40 (19.80%) SharePoint
22 39 (19.31%) VBA
22 39 (19.31%) SQL Server 2014
23 37 (18.32%) Management Information System
24 34 (16.83%) OLAP
24 34 (16.83%) Analytics
25 33 (16.34%) Data Modelling
26 32 (15.84%) Data Cleansing

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 40 (19.80%) SharePoint
2 4 (1.98%) WebSphere
3 2 (0.99%) SAS
4 1 (0.50%) Apache
4 1 (0.50%) Apache Pig
4 1 (0.50%) Apache Spark
4 1 (0.50%) MS Exchange
4 1 (0.50%) Tomcat
Applications
1 103 (50.99%) MS Excel
2 5 (2.48%) MS PowerPoint
3 4 (1.98%) MS Visio
4 1 (0.50%) MS Office
Business Applications
1 5 (2.48%) Dynamics CRM
1 5 (2.48%) Oracle Financials
2 1 (0.50%) Cognos TM1
2 1 (0.50%) Dynamics AX
Cloud Services
1 29 (14.36%) Microsoft Azure
2 6 (2.97%) SaaS
3 4 (1.98%) PaaS
4 3 (1.49%) Amazon AWS
5 2 (0.99%) Google Analytics
6 1 (0.50%) AdWords
6 1 (0.50%) Azure Machine Learning
6 1 (0.50%) Office 365
Communications & Networking
1 1 (0.50%) DHCP
Database & Business Intelligence
1 152 (75.25%) SQL Server Reporting Services
2 149 (73.76%) SQL Server
3 141 (69.80%) SQL Server Analysis Services
4 128 (63.37%) SQL Server Integration Services
5 113 (55.94%) Power BI
6 80 (39.60%) Data Warehouse
7 50 (24.75%) SQL Server 2012
8 42 (20.79%) Microsoft Power View
9 39 (19.31%) SQL Server 2014
10 34 (16.83%) OLAP
11 32 (15.84%) Relational Database
12 26 (12.87%) MS Access
12 26 (12.87%) SQL Server 2008
13 25 (12.38%) Microsoft Analysis Services
14 23 (11.39%) Big Data
15 22 (10.89%) MySQL
16 19 (9.41%) SQL Server 2016
17 18 (8.91%) Hadoop
18 16 (7.92%) SQL Server 2005
19 14 (6.93%) PerformancePoint
Development Applications
1 10 (4.95%) Team Foundation Server
2 8 (3.96%) Visual Studio
3 4 (1.98%) SQL Server Management Studio (SSMS)
4 1 (0.50%) JIRA
4 1 (0.50%) Talend Open Studio
4 1 (0.50%) Toad
General
1 69 (34.16%) Finance
2 30 (14.85%) Legal
3 20 (9.90%) Billing
4 15 (7.43%) Advertising
5 7 (3.47%) Marketing
6 6 (2.97%) Telecoms
7 5 (2.48%) Law
8 2 (0.99%) Arabic Language
8 2 (0.99%) Banking
8 2 (0.99%) French Language
8 2 (0.99%) German Language
8 2 (0.99%) Hindi Language
8 2 (0.99%) Russian Language
8 2 (0.99%) Spanish Language
9 1 (0.50%) Financial Institution
9 1 (0.50%) Investment Banking
9 1 (0.50%) Manufacturing
9 1 (0.50%) Private Banking
9 1 (0.50%) Welsh Language
Job Titles
1 93 (46.04%) Developer
2 75 (37.13%) Business Intelligence Developer
3 61 (30.20%) Analyst
4 38 (18.81%) Business Intelligence Analyst
4 38 (18.81%) SQL Developer
5 27 (13.37%) SSIS Developer
6 26 (12.87%) SQL Analyst
7 22 (10.89%) SQL BI Developer
8 19 (9.41%) Microsoft BI Developer
9 18 (8.91%) SSAS Developer
10 17 (8.42%) Business Intelligence Lead
10 17 (8.42%) Microsoft Developer
10 17 (8.42%) Report Analyst
11 16 (7.92%) Senior Business Intelligence Developer
11 16 (7.92%) Senior Developer
11 16 (7.92%) SSRS Developer
12 15 (7.43%) Data Analyst
13 13 (6.44%) Excel Analyst
13 13 (6.44%) SQL Server Developer
13 13 (6.44%) Team Leader
Libraries, Frameworks & Software Standards
1 70 (34.65%) MDX
2 12 (5.94%) XML
3 10 (4.95%) .NET
3 10 (4.95%) Web Services
4 8 (3.96%) HTML
5 4 (1.98%) CSS
5 4 (1.98%) JSON
6 3 (1.49%) REST
6 3 (1.49%) SOAP
7 2 (0.99%) .NET Framework
7 2 (0.99%) ASP.NET
7 2 (0.99%) HTML5
8 1 (0.50%) COM
8 1 (0.50%) D3.js
8 1 (0.50%) DWR
8 1 (0.50%) Leaflet
8 1 (0.50%) Middleware
Miscellaneous
1 44 (21.78%) Visualisation
2 40 (19.80%) Analytical Skills
3 37 (18.32%) Management Information System
4 10 (4.95%) Replication
5 9 (4.46%) Data Integration
6 7 (3.47%) Mathematics
7 5 (2.48%) Algorithms
7 5 (2.48%) Data Extraction
8 4 (1.98%) Digital Media
8 4 (1.98%) User Experience
9 3 (1.49%) Computer Science
9 3 (1.49%) Enterprise Software
9 3 (1.49%) Mobile App
9 3 (1.49%) Statistics
10 2 (0.99%) Ergonomics
10 2 (0.99%) Fintech
10 2 (0.99%) Freedom of Information
10 2 (0.99%) Wiki
11 1 (0.50%) Driving Licence
11 1 (0.50%) Economics
Operating Systems
1 2 (0.99%) Windows
1 2 (0.99%) Windows Server
1 2 (0.99%) Windows Server 2012
Processes & Methodologies
1 173 (85.64%) Business Intelligence
2 80 (39.60%) ETL
3 55 (27.23%) Agile Software Development
4 47 (23.27%) Kimball Methodology
5 34 (16.83%) Analytics
6 33 (16.34%) Data Modelling
7 32 (15.84%) Data Cleansing
8 31 (15.35%) Data Analysis
8 31 (15.35%) Data Management
9 16 (7.92%) Reverse Engineering
10 14 (6.93%) Data Visualisation
10 14 (6.93%) Dimensional Modelling
10 14 (6.93%) Scrum
11 13 (6.44%) Dashboard Development
11 13 (6.44%) E-Commerce
12 12 (5.94%) CRM
12 12 (5.94%) Presales
12 12 (5.94%) Translating Business Requirements
13 11 (5.45%) Master Data Management
14 10 (4.95%) Data Analytics
Programming Languages
1 174 (86.14%) SQL
2 97 (48.02%) T-SQL
3 53 (26.24%) Data Analysis Expressions (DAX)
4 39 (19.31%) VBA
5 23 (11.39%) C#
6 6 (2.97%) JavaScript
6 6 (2.97%) Python
7 5 (2.48%) Ruby
7 5 (2.48%) VB.NET
8 4 (1.98%) PL/SQL
8 4 (1.98%) VBScript
9 3 (1.49%) R
10 2 (0.99%) Java
10 2 (0.99%) PowerShell
10 2 (0.99%) VB
Qualifications
1 16 (7.92%) Degree
2 8 (3.96%) DBS Check
3 1 (0.50%) ACCA
3 1 (0.50%) CIMA
3 1 (0.50%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 28 (13.86%) Data Quality
2 13 (6.44%) PCI DSS
3 7 (3.47%) SLA
4 6 (2.97%) QA
5 4 (1.98%) ISO/IEC 27001
6 1 (0.50%) Solvency II
System Software
1 2 (0.99%) Active Directory
2 1 (0.50%) Virtual Desktop
2 1 (0.50%) Virtual Machines
2 1 (0.50%) VMware Infrastructure
Systems Management
1 1 (0.50%) Jitterbit
Vendors
1 157 (77.72%) Microsoft
2 57 (28.22%) Tableau
3 11 (5.45%) Oracle
3 11 (5.45%) SAP
4 7 (3.47%) Cognos
5 5 (2.48%) IBM
5 5 (2.48%) Salesforce.com
6 4 (1.98%) NetSuite
6 4 (1.98%) Nintex
7 2 (0.99%) Google
7 2 (0.99%) VMware
8 1 (0.50%) Alteryx
8 1 (0.50%) IDERA
8 1 (0.50%) JD Edwards
8 1 (0.50%) MuleSoft
8 1 (0.50%) RedGate
8 1 (0.50%) Sony
8 1 (0.50%) Talend
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £35,000 per annum
Posted: 2 days ago
Manchester, Lancashire
Venturi
Salary: £50000 - £65000 per annum + Bonus + Benefits
Posted: 2 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 6 days ago
Manchester
Venturi
Salary: £50000 - £65000 per annum + Bonus + Benefits
Posted: 9 days ago
London
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + pension, healthcare, dental
Posted: 15 days ago
Manchester
Venturi
Posted: 22 days ago