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

3 months to
24 May 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 753 771 872
Rank change year-on-year
+18 +101
Permanent jobs citing PowerPivot 141 167 95
As % of all permanent IT jobs located in England 0.15% 0.17% 0.085%
As % of the Database & Business Intelligence category 0.50% 0.52% 0.26%
Number of salaries quoted 109 149 87
Median salary £52,500 £51,000 £50,000
Median salary % change year-on-year
+2.94% +2.00%
90% offered a salary of more than £32,000 £40,000 £27,500
10% offered a salary of more than £70,000 £71,000 £75,000
UK excluding London median salary £45,000 £47,500 £40,000
% change year-on-year
-5.26% +18.75%
PowerPivot
UK

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 England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
28012 32260 36050
As % of all permanent IT jobs located in England 30.37% 32.43% 32.41%
Number of salaries quoted 24227 27510 31185
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,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,000 £40,000
% change year-on-year
+3.65% +2.50%

PowerPivot
Jobs Demand Trend in England

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

PowerPivot Jobs Demand Trend in England

PowerPivot
Salary Trend in England

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

PowerPivot Salary Trend in England

PowerPivot
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing PowerPivot across the England region over the 3 months to 24 May 2016.

PowerPivot Salary Histogram in England

PowerPivot
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the England region over the 3 months to 24 May 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
London +17 72 £60,000 +9.09% 6
South East -9 23 £45,500 -9.00% 3
North West - 13 £30,000 - 3
Yorkshire +11 11 - - 2
South West +12 7 £55,000 +27.90%
East of England - 6 £53,000 - 1
East Midlands +9 4 £40,000 -15.78%
North East - 4 £41,000 -
West Midlands -17 1 £40,000 +6.66% 1
PowerPivot
UK

PowerPivot
Top 30 Related IT Skills in England

For the 6 months to 24 May 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 England region with a requirement for PowerPivot.

1 232 (87.22%) Business Intelligence
2 216 (81.20%) SQL
3 207 (77.82%) SQL Server
4 196 (73.68%) Microsoft
5 186 (69.92%) SQL Server Reporting Services
6 163 (61.28%) SQL Server Integration Services
6 163 (61.28%) SQL Server Analysis Services
7 143 (53.76%) Data Warehouse
8 141 (53.01%) MS Excel
9 115 (43.23%) T-SQL
10 102 (38.35%) Microsoft Power View
10 102 (38.35%) Power BI
11 99 (37.22%) MDX
12 95 (35.71%) ETL
13 82 (30.83%) Finance
14 75 (28.20%) SharePoint
15 71 (26.69%) Data Analysis Expressions (DAX)
16 64 (24.06%) SQL Server 2008
17 60 (22.56%) VBA
18 57 (21.43%) Kimball Methodology
19 56 (21.05%) OLAP
20 55 (20.68%) Agile Software Development
21 52 (19.55%) Analytics
22 49 (18.42%) SQL Server 2012
23 47 (17.67%) Management Information System
24 42 (15.79%) Tableau
25 41 (15.41%) Analytical Skills
25 41 (15.41%) Data Modelling
26 38 (14.29%) Relational Database
27 37 (13.91%) SQL Server 2014

PowerPivot
Top Related IT Skills in England 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 75 (28.20%) SharePoint
2 15 (5.64%) SAS
3 3 (1.13%) IIS
4 2 (0.75%) NServiceBus
5 1 (0.38%) SharePoint Server
5 1 (0.38%) WebSphere
Applications
1 141 (53.01%) MS Excel
2 23 (8.65%) MS Office
3 10 (3.76%) MS PowerPoint
4 5 (1.88%) SPSS
5 4 (1.50%) Spreadsheet
6 2 (0.75%) MS Visio
7 1 (0.38%) MS Project
Business Applications
1 8 (3.01%) Dynamics CRM
2 5 (1.88%) Cognos Business Intelligence
2 5 (1.88%) Cognos TM1
3 4 (1.50%) Oracle Financials
3 4 (1.50%) SAP Business One
4 2 (0.75%) Tesseract
5 1 (0.38%) Dynamics AX
5 1 (0.38%) Sage 1000
Cloud Services
1 26 (9.77%) Microsoft Azure
2 5 (1.88%) Adobe Analytics
2 5 (1.88%) Google Analytics
3 2 (0.75%) PaaS
3 2 (0.75%) SaaS
4 1 (0.38%) Azure Machine Learning
4 1 (0.38%) IaaS
4 1 (0.38%) Office 365
Communications & Networking
1 10 (3.76%) DNS
2 3 (1.13%) DHCP
Database & Business Intelligence
1 207 (77.82%) SQL Server
2 186 (69.92%) SQL Server Reporting Services
3 163 (61.28%) SQL Server Analysis Services
3 163 (61.28%) SQL Server Integration Services
4 143 (53.76%) Data Warehouse
5 102 (38.35%) Microsoft Power View
5 102 (38.35%) Power BI
6 64 (24.06%) SQL Server 2008
7 56 (21.05%) OLAP
8 49 (18.42%) SQL Server 2012
9 38 (14.29%) Relational Database
10 37 (13.91%) SQL Server 2014
11 33 (12.41%) SQL Server 2005
12 30 (11.28%) Microsoft Analysis Services
13 27 (10.15%) RDBMS
14 25 (9.40%) PerformancePoint
15 18 (6.77%) Hadoop
15 18 (6.77%) SQL Server 2016
16 17 (6.39%) Big Data
16 17 (6.39%) Data Mining
Development Applications
1 15 (5.64%) Team Foundation Server
2 10 (3.76%) SQL Server Management Studio (SSMS)
3 8 (3.01%) JIRA
4 5 (1.88%) Visual Studio
5 3 (1.13%) Visual Studio Tools for Office
6 2 (0.75%) Toad
7 1 (0.38%) ERwin
7 1 (0.38%) Git (software)
7 1 (0.38%) Subversion
General
1 82 (30.83%) Finance
2 20 (7.52%) Marketing
3 14 (5.26%) Banking
4 12 (4.51%) Legal
5 10 (3.76%) Billing
6 9 (3.38%) Telecoms
7 7 (2.63%) Manufacturing
8 6 (2.26%) Advertising
8 6 (2.26%) Private Banking
8 6 (2.26%) Retail
9 2 (0.75%) Financial Institution
9 2 (0.75%) iGaming
9 2 (0.75%) Investment Banking
10 1 (0.38%) Arabic Language
10 1 (0.38%) French Language
10 1 (0.38%) German Language
10 1 (0.38%) Hindi Language
10 1 (0.38%) Russian Language
10 1 (0.38%) Spanish Language
Job Titles
1 111 (41.73%) Developer
2 94 (35.34%) Analyst
3 87 (32.71%) Business Intelligence Developer
4 48 (18.05%) SQL Developer
5 44 (16.54%) Business Intelligence Analyst
6 30 (11.28%) SQL BI Developer
7 29 (10.90%) SQL Analyst
7 29 (10.90%) SSIS Developer
8 27 (10.15%) Architect
8 27 (10.15%) Report Analyst
9 25 (9.40%) SQL Server Developer
10 21 (7.89%) SSRS Analyst
11 18 (6.77%) Business Developer
11 18 (6.77%) Microsoft BI Developer
11 18 (6.77%) SSAS Developer
12 17 (6.39%) SSRS Developer
13 16 (6.02%) Consultant
13 16 (6.02%) Microsoft Developer
14 15 (5.64%) Business Intelligence Consultant
14 15 (5.64%) Data Analyst
Libraries, Frameworks & Software Standards
1 99 (37.22%) MDX
2 26 (9.77%) HTML
3 22 (8.27%) CSS
4 18 (6.77%) XML
5 17 (6.39%) .NET
6 9 (3.38%) Web Services
7 5 (1.88%) ASP.NET
8 4 (1.50%) Ajax
8 4 (1.50%) jQuery
9 3 (1.13%) HTML5
10 2 (0.75%) RabbitMQ
11 1 (0.38%) D3.js
11 1 (0.38%) Google Maps API
11 1 (0.38%) JSON
11 1 (0.38%) Leaflet
11 1 (0.38%) Middleware
Miscellaneous
1 47 (17.67%) Management Information System
2 41 (15.41%) Analytical Skills
3 24 (9.02%) Visualisation
4 23 (8.65%) Data Integration
4 23 (8.65%) Mathematics
5 15 (5.64%) Computer Science
6 13 (4.89%) Mobile App
7 10 (3.76%) Statistics
8 9 (3.38%) User Experience
9 5 (1.88%) Data Extraction
9 5 (1.88%) iPad
10 4 (1.50%) Digital Media
10 4 (1.50%) Hybrid Cloud
11 3 (1.13%) Data Structures
11 3 (1.13%) Neural Network
11 3 (1.13%) Replication
12 2 (0.75%) Clustering
12 2 (0.75%) Economics
12 2 (0.75%) Freedom of Information
12 2 (0.75%) NHS
Operating Systems
1 10 (3.76%) Windows
1 10 (3.76%) Windows Server
1 10 (3.76%) Windows Server 2012
2 7 (2.63%) Windows Server 2003
3 3 (1.13%) Windows Server 2008
Processes & Methodologies
1 232 (87.22%) Business Intelligence
2 95 (35.71%) ETL
3 57 (21.43%) Kimball Methodology
4 55 (20.68%) Agile Software Development
5 52 (19.55%) Analytics
6 41 (15.41%) Data Modelling
7 37 (13.91%) Data Analysis
8 30 (11.28%) Data Management
9 28 (10.53%) Data Analytics
10 26 (9.77%) Dashboard Development
11 24 (9.02%) Performance Tuning
11 24 (9.02%) Presales
12 21 (7.89%) SDLC
13 18 (6.77%) E-Commerce
13 18 (6.77%) Validation
14 17 (6.39%) Data Visualisation
14 17 (6.39%) Dimensional Modelling
14 17 (6.39%) Information Management
15 16 (6.02%) Business Analysis
16 15 (5.64%) Test Scripting
Programming Languages
1 216 (81.20%) SQL
2 115 (43.23%) T-SQL
3 71 (26.69%) Data Analysis Expressions (DAX)
4 60 (22.56%) VBA
5 34 (12.78%) C#
6 11 (4.14%) VBScript
7 7 (2.63%) PowerShell
8 4 (1.50%) JavaScript
8 4 (1.50%) R
9 3 (1.13%) Python
10 1 (0.38%) COBOL
10 1 (0.38%) Java
10 1 (0.38%) PL/SQL
10 1 (0.38%) VB.NET
Qualifications
1 35 (13.16%) Degree
2 15 (5.64%) Microsoft Certification
3 14 (5.26%) MCSE
4 2 (0.75%) ACCA
4 2 (0.75%) CIMA
5 1 (0.38%) ITIL Certification
5 1 (0.38%) MBA
5 1 (0.38%) PMI Certification
5 1 (0.38%) PMP
Quality Assurance & Compliance
1 34 (12.78%) Data Quality
2 12 (4.51%) Solvency II
3 8 (3.01%) PCI DSS
3 8 (3.01%) QA
4 4 (1.50%) Basel II
5 2 (0.75%) SLA
6 1 (0.38%) ISO/IEC 27001
System Software
1 10 (3.76%) Active Directory
2 7 (2.63%) VMware ESX
3 5 (1.88%) VMware Infrastructure
Vendors
1 196 (73.68%) Microsoft
2 42 (15.79%) Tableau
3 20 (7.52%) Cognos
4 15 (5.64%) IBM
5 14 (5.26%) Oracle
6 12 (4.51%) Hitachi
7 7 (2.63%) Dell
7 7 (2.63%) HP
7 7 (2.63%) SAP
7 7 (2.63%) VMware
8 6 (2.26%) Google
9 5 (1.88%) Adobe
10 4 (1.50%) Ab Initio
11 3 (1.13%) ESRI
12 1 (0.38%) IDERA
12 1 (0.38%) MicroStrategy
12 1 (0.38%) Nintex
12 1 (0.38%) RedGate
12 1 (0.38%) Sage
London
Harrington Starr
Salary: £40000 - £60000 per annum + Benefits + Bonus
Posted: 3 hours ago
Chorley, Lancashire
Verticality Ltd
Salary: to £35k DOE
Posted: 7 hours ago
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £45,000 per annum
Posted: 10 hours ago
London
Computer Futures
Salary: competitive
Posted: 14 hours ago
London
Eaglecliff
Salary: From £60,000 to £70,000 per annum + Benefits
Posted: Yesterday
Woking, Surrey
Evolution Recruitment Solutions
Salary: 45,000 - 55,000
Posted: Yesterday
Bolton, Lancashire
onezeero.
Salary: £28000 - £40000 per annum + Excellent Benefits
Posted: Yesterday
Reading, Berkshire
RecruitmentRevolution.com Limited
Salary: From £28,000 to £34,000 per annum
Posted: 4 days ago
Cheshire
KDR
Salary: £18000 - £22000 per annum + pension, health insurance, holidays
Posted: 4 days ago
City, London
Streamline Connections
Salary: £45000 - £55000 per annum + Benefits
Posted: 4 days ago
City, London
Streamline Connections
Salary: £55000 - £60000.00 per annum + Benefits
Posted: 6 days ago
Tonbridge, Kent
Verelogic IT Recruitment
Salary: From £0 to £50,000 per annum
Posted: 6 days ago
Leeds, West Yorkshire
4it Recruitment Ltd
Salary: From £30,000 to £35,000 per annum
Posted: 6 days ago
Burton-On-Trent, Staffordshire
Healthcare at Home
Salary: From £45,000 to £55,000 per annum
Posted: 11 days ago