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

3 months to
29 Jul 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 579 619 614
Rank change year-on-year
+40 -5
Permanent jobs citing PowerPivot 44 60 76
As % of all permanent IT jobs located in London 0.11% 0.14% 0.16%
As % of the Database & Business Intelligence category 0.38% 0.44% 0.50%
Number of salaries quoted 40 51 67
Median salary £60,000 £57,500 £57,500
Median salary % change year-on-year
+4.34% -
90% offered a salary of more than £50,000 £42,500 £37,500
10% offered a salary of more than £70,000 £80,000 £80,000
UK excluding London median salary £44,500 £50,000 £32,500
% change year-on-year
-11.00% +53.84%
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
11512 13739 15158
As % of all permanent IT jobs located in London 29.26% 30.95% 31.33%
Number of salaries quoted 9988 11599 13192
Median salary £57,500 £57,500 £55,000
Median salary % change year-on-year
- +4.54%
90% offered a salary of more than £40,000 £38,500 £36,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

PowerPivot
Jobs Demand Trend in London

The demand trend of job ads across the London region citing PowerPivot as a proportion of all IT jobs with a match in 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 29 July 2016.

PowerPivot Salary Histogram in London

PowerPivot
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the London region over the 3 months to 29 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
City of London +58 22 £57,500 +6.97% 2
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in London

For the 6 months to 29 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 across the London region with a requirement for PowerPivot.

1 113 (83.09%) Business Intelligence
2 110 (80.88%) SQL
3 99 (72.79%) SQL Server Reporting Services
4 96 (70.59%) Microsoft
5 83 (61.03%) SQL Server
6 80 (58.82%) SQL Server Analysis Services
7 74 (54.41%) SQL Server Integration Services
8 72 (52.94%) MS Excel
9 68 (50.00%) Data Warehouse
9 68 (50.00%) T-SQL
10 67 (49.26%) Finance
11 66 (48.53%) MDX
12 57 (41.91%) Data Analysis Expressions (DAX)
13 56 (41.18%) ETL
14 51 (37.50%) Power BI
15 44 (32.35%) Data Quality
16 40 (29.41%) Kimball Methodology
17 39 (28.68%) Tableau
18 38 (27.94%) Analytical Skills
19 36 (26.47%) SharePoint
20 35 (25.74%) Management Information System
21 34 (25.00%) Data Analysis
22 33 (24.26%) Agile Software Development
23 32 (23.53%) Microsoft Power View
23 32 (23.53%) SQL Server 2008
24 31 (22.79%) Data Management
25 29 (21.32%) Data Modelling
26 27 (19.85%) Data Cleansing
27 26 (19.12%) Relational Database
27 26 (19.12%) SQL Server 2012

PowerPivot
Top Related IT Skills in London 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 36 (26.47%) SharePoint
2 12 (8.82%) SAS
3 3 (2.21%) WebSphere
4 1 (0.74%) NServiceBus
Applications
1 72 (52.94%) MS Excel
2 5 (3.68%) SPSS
3 4 (2.94%) Spreadsheet
4 3 (2.21%) MS Office
4 3 (2.21%) MS Visio
5 1 (0.74%) MS PowerPoint
Business Applications
1 6 (4.41%) Dynamics CRM
2 1 (0.74%) Oracle Financials
Cloud Services
1 8 (5.88%) Microsoft Azure
2 5 (3.68%) Adobe Analytics
2 5 (3.68%) Google Analytics
2 5 (3.68%) SaaS
3 3 (2.21%) PaaS
4 1 (0.74%) Azure Machine Learning
Database & Business Intelligence
1 99 (72.79%) SQL Server Reporting Services
2 83 (61.03%) SQL Server
3 80 (58.82%) SQL Server Analysis Services
4 74 (54.41%) SQL Server Integration Services
5 68 (50.00%) Data Warehouse
6 51 (37.50%) Power BI
7 32 (23.53%) Microsoft Power View
7 32 (23.53%) SQL Server 2008
8 26 (19.12%) Relational Database
8 26 (19.12%) SQL Server 2012
9 24 (17.65%) OLAP
10 18 (13.24%) MS Access
11 17 (12.50%) Microsoft Analysis Services
12 16 (11.76%) RDBMS
13 14 (10.29%) SQL Server 2014
14 13 (9.56%) SQL Server 2005
15 11 (8.09%) SQL Server 2016
16 9 (6.62%) QlikView
17 8 (5.88%) PerformancePoint
18 5 (3.68%) HDInsight
Development Applications
1 8 (5.88%) Team Foundation Server
2 3 (2.21%) JIRA
2 3 (2.21%) SQL Server Management Studio (SSMS)
2 3 (2.21%) Visual Studio
2 3 (2.21%) Visual Studio Tools for Office
General
1 67 (49.26%) Finance
2 20 (14.71%) Legal
2 20 (14.71%) Marketing
3 17 (12.50%) Billing
4 11 (8.09%) Banking
5 10 (7.35%) Advertising
6 6 (4.41%) Private Banking
7 5 (3.68%) Retail
7 5 (3.68%) Telecoms
8 2 (1.47%) Financial Institution
8 2 (1.47%) Investment Banking
Job Titles
1 52 (38.24%) Developer
2 49 (36.03%) Business Intelligence Developer
3 48 (35.29%) Analyst
4 25 (18.38%) SSRS Analyst
5 24 (17.65%) Report Analyst
5 24 (17.65%) SQL Developer
6 23 (16.91%) SQL BI Developer
7 20 (14.71%) Business Intelligence Analyst
7 20 (14.71%) Microsoft BI Developer
7 20 (14.71%) Microsoft Developer
7 20 (14.71%) SSAS Developer
7 20 (14.71%) SSIS Developer
8 17 (12.50%) Senior Business Intelligence Developer
8 17 (12.50%) Senior Developer
9 16 (11.76%) SQL Analyst
9 16 (11.76%) SSRS Developer
10 15 (11.03%) SQL Reporting Analyst
11 13 (9.56%) Business Intelligence Lead
12 11 (8.09%) DBA
12 11 (8.09%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 66 (48.53%) MDX
2 13 (9.56%) XML
3 7 (5.15%) .NET
3 7 (5.15%) Web Services
4 4 (2.94%) HTML
4 4 (2.94%) HTML5
5 3 (2.21%) REST
5 3 (2.21%) SOAP
6 2 (1.47%) CSS
7 1 (0.74%) JSON
7 1 (0.74%) RabbitMQ
Miscellaneous
1 38 (27.94%) Analytical Skills
2 35 (25.74%) Management Information System
3 24 (17.65%) Visualisation
4 20 (14.71%) Mathematics
5 15 (11.03%) Data Integration
6 10 (7.35%) Computer Science
6 10 (7.35%) Replication
7 8 (5.88%) Statistics
8 5 (3.68%) iPad
8 5 (3.68%) User Experience
9 2 (1.47%) Data Extraction
9 2 (1.47%) Fintech
10 1 (0.74%) Economics
Processes & Methodologies
1 113 (83.09%) Business Intelligence
2 56 (41.18%) ETL
3 40 (29.41%) Kimball Methodology
4 34 (25.00%) Data Analysis
5 33 (24.26%) Agile Software Development
6 31 (22.79%) Data Management
7 29 (21.32%) Data Modelling
8 27 (19.85%) Data Cleansing
9 25 (18.38%) Analytics
10 18 (13.24%) Reverse Engineering
11 16 (11.76%) Presales
12 15 (11.03%) Performance Tuning
12 15 (11.03%) Test Scripting
13 13 (9.56%) Business Analysis
13 13 (9.56%) Validation
14 12 (8.82%) Master Data Management
15 11 (8.09%) Dimensional Modelling
15 11 (8.09%) SDLC
16 10 (7.35%) Data Analytics
17 9 (6.62%) Data Visualisation
Programming Languages
1 110 (80.88%) SQL
2 68 (50.00%) T-SQL
3 57 (41.91%) Data Analysis Expressions (DAX)
4 24 (17.65%) VBA
5 11 (8.09%) C#
6 3 (2.21%) R
Qualifications
1 13 (9.56%) Degree
2 3 (2.21%) MCSE
2 3 (2.21%) Microsoft Certification
3 2 (1.47%) ACCA
3 2 (1.47%) CIMA
4 1 (0.74%) MBA
4 1 (0.74%) PMI Certification
4 1 (0.74%) PMP
4 1 (0.74%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 44 (32.35%) Data Quality
2 14 (10.29%) PCI DSS
3 12 (8.82%) Solvency II
4 7 (5.15%) QA
5 4 (2.94%) Basel II
6 3 (2.21%) ISO/IEC 27001
7 1 (0.74%) SLA
Vendors
1 96 (70.59%) Microsoft
2 39 (28.68%) Tableau
3 13 (9.56%) Oracle
4 8 (5.88%) IBM
5 5 (3.68%) Adobe
5 5 (3.68%) Google
6 4 (2.94%) Ab Initio
6 4 (2.94%) Hitachi
6 4 (2.94%) SAP
7 3 (2.21%) Nintex
7 3 (2.21%) Salesforce.com
8 1 (0.74%) Alteryx
8 1 (0.74%) Cognos
8 1 (0.74%) MicroStrategy
8 1 (0.74%) MuleSoft
City, London
Streamline Connections
Salary: £55000 - £60000.00 per annum + Benefits
Posted: 4 days ago
London
Venturi
Salary: £50000 - £80000 per annum + Bonus + Benefits
Posted: 2 days ago
London
Next Ventures Limited
Salary: £60,000 - £75,000 per year
Posted: 7 days ago
City, London
Next Ventures Ltd
Salary: From £60,000 to £70,000 per annum
Posted: 6 days ago