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

Location
3 months to
13 Feb 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 562 557 617
Rank change year-on-year
-5 +60
Permanent jobs citing PowerPivot 61 89 43
As % of all permanent IT jobs located in London 0.15% 0.22% 0.099%
As % of the Database & Business Intelligence category 0.48% 0.72% 0.32%
Number of salaries quoted 41 84 28
Average salary £55,000 £57,500 £60,000
Average salary % change year-on-year
-4.34% -4.16%
90% offered a salary of more than £25,000 £42,500 £36,750
10% offered a salary of more than £85,000 £80,000 £82,500
UK excluding London average salary £40,500 £42,000 £45,000
% change year-on-year
-3.57% -6.66%
PowerPivot
England

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

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
12703 12371 13420
As % of all permanent IT jobs located in London 31.37% 30.14% 31.00%
Number of salaries quoted 11023 10660 11437
Average salary £55,000 £55,000 £55,000
90% offered a salary of more than £40,000 £37,500 £37,500
10% offered a salary of more than £80,000 £77,500 £75,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

PowerPivot
Jobs Demand Trend in London

This chart provides a 3-month moving total of permanent IT jobs citing PowerPivot across the London region as a proportion of the total demand within the Database & Business Intelligence category.

PowerPivot Jobs Demand Trend in London

PowerPivot
Salary Trend in London

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

PowerPivot Salary Trend in London

PowerPivot
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing PowerPivot across the London region over the 3 months to 13 February 2016.

PowerPivot Salary Histogram in London

PowerPivot
Job Locations in London

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing PowerPivot within the London region over the 3 months to 13 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +49 6 £43,750 -7.89% 1
Chiswick - 3 £42,500 -
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in London

For the 6 months to 13 February 2016, IT jobs across the London region citing PowerPivot also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited PowerPivot.

1 110 (90.91%) Business Intelligence
2 98 (80.99%) SQL Server
3 86 (71.07%) SQL Server Integration Services
4 85 (70.25%) Microsoft
5 79 (65.29%) SQL
6 77 (63.64%) SQL Server Reporting Services
7 76 (62.81%) SQL Server Analysis Services
8 65 (53.72%) Microsoft Power View
9 64 (52.89%) Data Warehouse
10 58 (47.93%) MS Excel
11 57 (47.11%) SharePoint
12 49 (40.50%) ETL
13 48 (39.67%) Analytics
14 43 (35.54%) Agile Software Development
15 41 (33.88%) Kimball Methodology
16 39 (32.23%) MDX
17 37 (30.58%) Data Modelling
18 35 (28.93%) Tableau
19 34 (28.10%) OLAP
20 33 (27.27%) T-SQL
21 32 (26.45%) Analytical Skills
22 31 (25.62%) SQL Server 2008
23 30 (24.79%) Data Analysis
24 29 (23.97%) Degree
25 26 (21.49%) Data Management
26 25 (20.66%) Data Integration
26 25 (20.66%) Data Analysis Expressions (DAX)
27 23 (19.01%) Power BI
28 20 (16.53%) SQL Server 2012
29 19 (15.70%) Data Quality

PowerPivot
Top Related IT Skills in London by Category

For the 6 months to 13 February 2016, IT jobs across the London region citing PowerPivot also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited PowerPivot. Up to 20 skills are shown per category.

Application Platforms
1 57 (47.11%) SharePoint
2 6 (4.96%) SharePoint 2010
2 6 (4.96%) SharePoint 2013
3 2 (1.65%) NServiceBus
3 2 (1.65%) SAS
4 1 (0.83%) ArcGIS
Applications
1 58 (47.93%) MS Excel
2 11 (9.09%) MS Office
3 6 (4.96%) MS PowerPoint
4 2 (1.65%) Spreadsheet
5 1 (0.83%) MS Visio
5 1 (0.83%) SPSS
Business Applications
1 1 (0.83%) SAP Business One
Cloud Services
1 16 (13.22%) Microsoft Azure
2 6 (4.96%) Azure Machine Learning
2 6 (4.96%) IaaS
2 6 (4.96%) PaaS
3 5 (4.13%) Office 365
4 2 (1.65%) Adobe Analytics
4 2 (1.65%) Google Analytics
5 1 (0.83%) Amazon AWS
5 1 (0.83%) Amazon EMR
Communications & Networking
1 2 (1.65%) Internet
2 1 (0.83%) DNS
2 1 (0.83%) SAN
2 1 (0.83%) TCP/IP
Database & Business Intelligence
1 98 (80.99%) SQL Server
2 86 (71.07%) SQL Server Integration Services
3 77 (63.64%) SQL Server Reporting Services
4 76 (62.81%) SQL Server Analysis Services
5 65 (53.72%) Microsoft Power View
6 64 (52.89%) Data Warehouse
7 34 (28.10%) OLAP
8 31 (25.62%) SQL Server 2008
9 23 (19.01%) Power BI
10 20 (16.53%) SQL Server 2012
11 17 (14.05%) PerformancePoint
12 15 (12.40%) Relational Database
13 14 (11.57%) Data Mining
13 14 (11.57%) SQL Server 2005
14 13 (10.74%) RDBMS
15 11 (9.09%) Microsoft Analysis Services
16 9 (7.44%) DataStage
16 9 (7.44%) IBM InfoSphere
16 9 (7.44%) QlikView
17 8 (6.61%) GIS
Development Applications
1 10 (8.26%) Team Foundation Server
2 7 (5.79%) Visual Studio
3 6 (4.96%) JIRA
4 1 (0.83%) ERwin
4 1 (0.83%) SQL Server Management Studio (SSMS)
4 1 (0.83%) Toad
4 1 (0.83%) Visual Studio Tools for Office
General
1 19 (15.70%) Finance
2 12 (9.92%) Marketing
3 11 (9.09%) Retail
4 5 (4.13%) Advertising
4 5 (4.13%) Games
5 4 (3.31%) Banking
5 4 (3.31%) Legal
6 3 (2.48%) Billing
6 3 (2.48%) Manufacturing
7 1 (0.83%) Financial Institution
7 1 (0.83%) Investment Banking
7 1 (0.83%) Publishing
Job Titles
1 45 (37.19%) Developer
2 44 (36.36%) Analyst
3 33 (27.27%) Business Intelligence Developer
4 24 (19.83%) Business Intelligence Analyst
5 23 (19.01%) SQL Developer
6 19 (15.70%) SQL BI Developer
7 18 (14.88%) Junior
8 16 (13.22%) Architect
8 16 (13.22%) Business Intelligence Consultant
8 16 (13.22%) Consultant
9 15 (12.40%) Business Developer
10 13 (10.74%) SQL Server Developer
11 12 (9.92%) Business Consultant
11 12 (9.92%) Business Intelligence Architect
11 12 (9.92%) SQL Server BI Developer
12 11 (9.09%) Data Analyst
13 9 (7.44%) Microsoft BI Developer
14 8 (6.61%) Analyst Developer
14 8 (6.61%) Microsoft BI Consultant
14 8 (6.61%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 39 (32.23%) MDX
2 17 (14.05%) .NET
3 15 (12.40%) XML
4 7 (5.79%) Web Services
5 6 (4.96%) D3.js
5 6 (4.96%) Leaflet
6 3 (2.48%) Ajax
6 3 (2.48%) ASP.NET
6 3 (2.48%) CSS
6 3 (2.48%) HTML
6 3 (2.48%) jQuery
7 2 (1.65%) CSS3
7 2 (1.65%) HTML5
7 2 (1.65%) RabbitMQ
Miscellaneous
1 32 (26.45%) Analytical Skills
2 25 (20.66%) Data Integration
3 17 (14.05%) Computer Science
4 16 (13.22%) Visualisation
5 15 (12.40%) Statistics
6 9 (7.44%) Management Information System
7 8 (6.61%) Neural Network
8 7 (5.79%) Data Structures
9 6 (4.96%) Mathematics
9 6 (4.96%) Mobile App
10 5 (4.13%) Online Games
10 5 (4.13%) PlayStation
11 4 (3.31%) Algorithms
12 3 (2.48%) Economics
12 3 (2.48%) Reinsurance
13 2 (1.65%) Clustering
13 2 (1.65%) Social Media
14 1 (0.83%) Data Extraction
14 1 (0.83%) iPad
14 1 (0.83%) User Experience
Operating Systems
1 1 (0.83%) Linux
Processes & Methodologies
1 110 (90.91%) Business Intelligence
2 49 (40.50%) ETL
3 48 (39.67%) Analytics
4 43 (35.54%) Agile Software Development
5 41 (33.88%) Kimball Methodology
6 37 (30.58%) Data Modelling
7 30 (24.79%) Data Analysis
8 26 (21.49%) Data Management
9 17 (14.05%) Information Management
10 15 (12.40%) Data Governance
11 14 (11.57%) Business Analysis
11 14 (11.57%) Data Architecture
12 13 (10.74%) Data Analytics
12 13 (10.74%) Master Data Management
13 12 (9.92%) Dimensional Modelling
13 12 (9.92%) Scrum
14 11 (9.09%) Validation
15 10 (8.26%) Performance Tuning
15 10 (8.26%) Software Engineering
15 10 (8.26%) Waterfall
Programming Languages
1 79 (65.29%) SQL
2 33 (27.27%) T-SQL
3 25 (20.66%) Data Analysis Expressions (DAX)
4 13 (10.74%) C#
4 13 (10.74%) VBA
5 8 (6.61%) Python
5 8 (6.61%) R
6 7 (5.79%) JavaScript
7 2 (1.65%) VB.NET
8 1 (0.83%) Bash Shell
Qualifications
1 29 (23.97%) Degree
2 9 (7.44%) Microsoft Certification
3 6 (4.96%) MCSE
4 1 (0.83%) ACCA
4 1 (0.83%) CIMA
4 1 (0.83%) MCP
Quality Assurance & Compliance
1 19 (15.70%) Data Quality
2 17 (14.05%) QA
3 2 (1.65%) PCI DSS
Vendors
1 85 (70.25%) Microsoft
2 35 (28.93%) Tableau
3 16 (13.22%) IBM
4 10 (8.26%) Informatica
5 9 (7.44%) Ab Initio
5 9 (7.44%) DataFlux
5 9 (7.44%) Datanomic
5 9 (7.44%) MicroStrategy
5 9 (7.44%) Teradata
5 9 (7.44%) Trillium
6 8 (6.61%) Hitachi
7 7 (5.79%) Cognos
8 2 (1.65%) Adobe
8 2 (1.65%) Google
8 2 (1.65%) Oracle
8 2 (1.65%) SAP
9 1 (0.83%) Cadence
9 1 (0.83%) Salesforce.com
9 1 (0.83%) VMware
City, London
Hitachi Consulting UK
Salary: From £75,000 to £95,000 per annum Incl Benefits + Bonus
Posted: 4 days ago
London
Hitachi Consulting UK
Salary: From £35,000 to £80,000 per annum Incl Benefits + Bonus
Posted: 5 days ago