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

3 months to
26 May 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 773 794 868
Rank change year-on-year
+21 +74
Permanent jobs citing PowerPivot 151 167 103
As % of all permanent IT jobs located in the UK 0.15% 0.16% 0.088%
As % of the Database & Business Intelligence category 0.51% 0.48% 0.27%
Number of salaries quoted 117 150 91
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 £33,400 £37,250 £27,500
10% offered a salary of more than £70,000 £70,500 £75,000
UK excluding London median salary £42,195 £50,000 £40,000
% change year-on-year
-15.61% +25.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
29753 34706 38099
As % of all permanent IT jobs located in the UK 30.27% 32.40% 32.38%
Number of salaries quoted 25406 29265 32701
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,500 £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 26 May 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 26 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
England +5 145 £52,500 +2.94% 14
London +20 75 £60,000 +8.10% 5
City of London +70 28 £57,500 +9.52% 1
South East -16 23 £45,500 -9.00% 3
Surrey 0 18 £50,000 +11.11% 2
North West - 14 £31,250 - 3
West Yorkshire +11 11 - - 1
Leeds +11 11 - - 1
Yorkshire +2 11 - - 1
Woking - 11 £52,500 - 1
Lancashire - 10 £30,000 - 1
Chorley - 9 £30,000 - 1
South West +7 7 £55,000 +77.41%
Wales - 6 £45,000 -
South Wales - 6 £45,000 -
East of England - 6 £53,000 - 1
Leicester +15 4 £40,000 -21.56%
East Midlands +11 4 £40,000 -15.78%
Leicestershire +8 4 £40,000 -21.56%
Bristol +7 4 £55,000 +77.41%
Hampshire +2 4 £32,500 -45.83%
Hertfordshire - 4 £53,000 -
North East - 4 £41,000 -
Durham - 4 £41,000 -
St Albans - 4 £53,000 -
Southampton +5 3 £35,000 -
Devon - 3 £22,000 -
Manchester - 3 £34,000 - 1
Cardiff - 3 £45,000 -
Exeter - 3 £22,000 -

PowerPivot
Top 30 Related IT Skills

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

1 259 (87.50%) Business Intelligence
2 246 (83.11%) SQL
3 231 (78.04%) SQL Server
4 216 (72.97%) Microsoft
5 213 (71.96%) SQL Server Reporting Services
6 187 (63.18%) SQL Server Analysis Services
7 186 (62.84%) SQL Server Integration Services
8 158 (53.38%) Data Warehouse
9 157 (53.04%) MS Excel
10 129 (43.58%) T-SQL
11 124 (41.89%) Power BI
12 120 (40.54%) MDX
13 113 (38.18%) ETL
13 113 (38.18%) Microsoft Power View
14 94 (31.76%) SharePoint
15 89 (30.07%) Finance
16 76 (25.68%) Data Analysis Expressions (DAX)
17 73 (24.66%) Agile Software Development
18 72 (24.32%) Analytics
19 66 (22.30%) SQL Server 2012
20 65 (21.96%) SQL Server 2008
20 65 (21.96%) Kimball Methodology
21 64 (21.62%) VBA
22 58 (19.59%) Tableau
23 55 (18.58%) OLAP
24 53 (17.91%) SQL Server 2014
25 52 (17.57%) Data Modelling
26 50 (16.89%) Management Information System
27 47 (15.88%) Data Management
28 46 (15.54%) Microsoft Analysis Services

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 94 (31.76%) SharePoint
2 15 (5.07%) SAS
3 13 (4.39%) SharePoint Server
4 3 (1.01%) IIS
5 2 (0.68%) NServiceBus
6 1 (0.34%) WebSphere
Applications
1 157 (53.04%) MS Excel
2 23 (7.77%) MS Office
3 14 (4.73%) MS Visio
4 10 (3.38%) MS PowerPoint
5 5 (1.69%) SPSS
6 4 (1.35%) Spreadsheet
7 1 (0.34%) MS Project
Business Applications
1 8 (2.70%) Dynamics CRM
2 5 (1.69%) Cognos Business Intelligence
2 5 (1.69%) Cognos TM1
3 4 (1.35%) Oracle Financials
3 4 (1.35%) SAP Business One
4 2 (0.68%) Sage 1000
4 2 (0.68%) Tesseract
5 1 (0.34%) Dynamics AX
Cloud Services
1 26 (8.78%) Microsoft Azure
2 5 (1.69%) Adobe Analytics
2 5 (1.69%) Google Analytics
3 2 (0.68%) SaaS
4 1 (0.34%) Office 365
4 1 (0.34%) PaaS
Communications & Networking
1 10 (3.38%) DNS
2 3 (1.01%) DHCP
Database & Business Intelligence
1 231 (78.04%) SQL Server
2 213 (71.96%) SQL Server Reporting Services
3 187 (63.18%) SQL Server Analysis Services
4 186 (62.84%) SQL Server Integration Services
5 158 (53.38%) Data Warehouse
6 124 (41.89%) Power BI
7 113 (38.18%) Microsoft Power View
8 66 (22.30%) SQL Server 2012
9 65 (21.96%) SQL Server 2008
10 55 (18.58%) OLAP
11 53 (17.91%) SQL Server 2014
12 46 (15.54%) Microsoft Analysis Services
13 38 (12.84%) Relational Database
14 37 (12.50%) PerformancePoint
15 34 (11.49%) SQL Server 2005
16 32 (10.81%) Data Mining
17 27 (9.12%) RDBMS
18 20 (6.76%) SQL Server 2016
19 18 (6.08%) Hadoop
20 16 (5.41%) Big Data
Development Applications
1 15 (5.07%) Team Foundation Server
2 12 (4.05%) Talend Open Studio
3 10 (3.38%) SQL Server Management Studio (SSMS)
4 8 (2.70%) JIRA
5 6 (2.03%) Visual Studio
6 3 (1.01%) Visual Studio Tools for Office
7 2 (0.68%) Toad
8 1 (0.34%) ERwin
8 1 (0.34%) Git (software)
8 1 (0.34%) Subversion
General
1 89 (30.07%) Finance
2 20 (6.76%) Marketing
3 15 (5.07%) Legal
4 14 (4.73%) Banking
5 11 (3.72%) Advertising
5 11 (3.72%) Billing
6 9 (3.04%) Telecoms
7 7 (2.36%) Manufacturing
8 6 (2.03%) Private Banking
8 6 (2.03%) Retail
9 2 (0.68%) Financial Institution
9 2 (0.68%) iGaming
9 2 (0.68%) Investment Banking
10 1 (0.34%) Arabic Language
10 1 (0.34%) French Language
10 1 (0.34%) German Language
10 1 (0.34%) Hindi Language
10 1 (0.34%) Russian Language
10 1 (0.34%) Spanish Language
10 1 (0.34%) Welsh Language
Job Titles
1 135 (45.61%) Developer
2 102 (34.46%) Business Intelligence Developer
3 93 (31.42%) Analyst
4 57 (19.26%) SQL Developer
5 43 (14.53%) Business Intelligence Analyst
6 34 (11.49%) SQL BI Developer
7 32 (10.81%) Architect
7 32 (10.81%) SSIS Developer
8 28 (9.46%) SQL Analyst
9 27 (9.12%) Report Analyst
9 27 (9.12%) SQL Server Developer
10 21 (7.09%) SSAS Developer
10 21 (7.09%) SSRS Analyst
10 21 (7.09%) SSRS Developer
11 20 (6.76%) Business Developer
11 20 (6.76%) Microsoft BI Developer
12 18 (6.08%) Microsoft Developer
13 16 (5.41%) Consultant
14 15 (5.07%) Business Intelligence Consultant
14 15 (5.07%) Data Analyst
Libraries, Frameworks & Software Standards
1 120 (40.54%) MDX
2 26 (8.78%) HTML
3 22 (7.43%) CSS
4 19 (6.42%) XML
5 17 (5.74%) .NET
6 10 (3.38%) Web Services
7 6 (2.03%) ASP.NET
8 4 (1.35%) Ajax
8 4 (1.35%) jQuery
9 3 (1.01%) DWR
9 3 (1.01%) HTML5
10 2 (0.68%) RabbitMQ
11 1 (0.34%) Google Maps API
11 1 (0.34%) JSON
11 1 (0.34%) Middleware
Miscellaneous
1 50 (16.89%) Management Information System
2 44 (14.86%) Analytical Skills
3 39 (13.18%) Visualisation
4 24 (8.11%) Data Integration
5 23 (7.77%) Mathematics
6 17 (5.74%) Computer Science
7 16 (5.41%) Statistics
8 12 (4.05%) Mobile App
9 9 (3.04%) User Experience
10 5 (1.69%) Data Extraction
10 5 (1.69%) iPad
10 5 (1.69%) Replication
11 4 (1.35%) Digital Media
11 4 (1.35%) Hybrid Cloud
12 3 (1.01%) Data Structures
13 2 (0.68%) Clustering
13 2 (0.68%) Economics
13 2 (0.68%) Fintech
13 2 (0.68%) Neural Network
13 2 (0.68%) NHS
Operating Systems
1 10 (3.38%) Windows
1 10 (3.38%) Windows Server
1 10 (3.38%) Windows Server 2012
2 7 (2.36%) Windows Server 2003
3 3 (1.01%) Windows Server 2008
Processes & Methodologies
1 259 (87.50%) Business Intelligence
2 113 (38.18%) ETL
3 73 (24.66%) Agile Software Development
4 72 (24.32%) Analytics
5 65 (21.96%) Kimball Methodology
6 52 (17.57%) Data Modelling
7 47 (15.88%) Data Management
8 44 (14.86%) Data Analysis
9 31 (10.47%) Performance Tuning
10 27 (9.12%) Data Analytics
11 24 (8.11%) Dashboard Development
11 24 (8.11%) Presales
12 22 (7.43%) Data Visualisation
13 21 (7.09%) SDLC
14 19 (6.42%) Validation
15 18 (6.08%) Dimensional Modelling
16 17 (5.74%) E-Commerce
16 17 (5.74%) Information Management
16 17 (5.74%) Scrum
17 16 (5.41%) Business Analysis
Programming Languages
1 246 (83.11%) SQL
2 129 (43.58%) T-SQL
3 76 (25.68%) Data Analysis Expressions (DAX)
4 64 (21.62%) VBA
5 41 (13.85%) C#
6 11 (3.72%) VBScript
7 7 (2.36%) PowerShell
8 4 (1.35%) JavaScript
8 4 (1.35%) Python
9 3 (1.01%) R
10 1 (0.34%) COBOL
10 1 (0.34%) Java
10 1 (0.34%) PL/SQL
10 1 (0.34%) VB.NET
Qualifications
1 38 (12.84%) Degree
2 30 (10.14%) Microsoft Certification
3 18 (6.08%) MCSE
4 4 (1.35%) MCSA
5 2 (0.68%) ACCA
5 2 (0.68%) CIMA
6 1 (0.34%) ITIL Certification
6 1 (0.34%) MBA
6 1 (0.34%) PMI Certification
6 1 (0.34%) PMP
Quality Assurance & Compliance
1 42 (14.19%) Data Quality
2 12 (4.05%) Solvency II
3 9 (3.04%) PCI DSS
4 8 (2.70%) QA
5 4 (1.35%) Basel II
6 2 (0.68%) SLA
7 1 (0.34%) ISO/IEC 27001
System Software
1 10 (3.38%) Active Directory
2 7 (2.36%) VMware ESX
3 5 (1.69%) VMware Infrastructure
Vendors
1 216 (72.97%) Microsoft
2 58 (19.59%) Tableau
3 32 (10.81%) Cognos
4 15 (5.07%) IBM
4 15 (5.07%) Oracle
5 12 (4.05%) Capita
5 12 (4.05%) Hitachi
5 12 (4.05%) Informatica
5 12 (4.05%) Talend
6 7 (2.36%) Dell
6 7 (2.36%) HP
6 7 (2.36%) SAP
6 7 (2.36%) VMware
7 6 (2.03%) Google
8 5 (1.69%) Adobe
9 4 (1.35%) Ab Initio
10 3 (1.01%) ESRI
11 2 (0.68%) Sage
12 1 (0.34%) MicroStrategy
12 1 (0.34%) RedGate
Edinburgh, Midlothian
NSK International Consultants Ltd
Salary: Generous Bonus + Excellent Benefits
Posted: 18 hours ago
Leatherhead, Surrey
Think IT Recruitment
Salary: £30000.00 - £50000.00 per annum + Bonus + Benefits
Posted: 20 hours ago
London
Harrington Starr
Salary: £40000 - £60000 per annum + Benefits + Bonus
Posted: Yesterday
Chorley, Lancashire
Verticality Ltd
Salary: to £35k DOE
Posted: Yesterday
Leeds, West Yorkshire
Hotfoot Recruitment
Salary: Up to £45,000 per annum
Posted: Yesterday
London
Computer Futures
Salary: competitive
Posted: 2 days ago
London
Eaglecliff
Salary: From £60,000 to £70,000 per annum + Benefits
Posted: 2 days ago
Woking, Surrey
Evolution Recruitment Solutions
Salary: 45,000 - 55,000
Posted: 2 days ago
Bolton, Lancashire
onezeero.
Salary: £28000 - £40000 per annum + Excellent Benefits
Posted: 2 days ago
Reading, Berkshire
RecruitmentRevolution.com Limited
Salary: From £28,000 to £34,000 per annum
Posted: 5 days ago
Cheshire
KDR
Salary: £18000 - £22000 per annum + pension, health insurance, holidays
Posted: 5 days ago
City, London
Streamline Connections
Salary: £45000 - £55000 per annum + Benefits
Posted: 5 days ago
UK
JM
Salary: £60000 - £65000 per annum + bonus and pension
Posted: 6 days ago
Burton-On-Trent, Staffordshire
Healthcare at Home
Salary: From £45,000 to £55,000 per annum
Posted: 12 days ago