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

3 months to
27 Sep 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 585 595 579
Rank change year-on-year
+10 -16
Permanent jobs citing PowerPivot 35 69 86
As % of all permanent IT jobs located in London 0.092% 0.16% 0.19%
As % of the Database & Business Intelligence category 0.31% 0.53% 0.62%
Number of salaries quoted 33 60 76
Median salary £57,500 £47,500 £57,500
Median salary % change year-on-year
+21.05% -17.39%
90% offered a salary of more than £40,500 £30,000 £32,500
10% offered a salary of more than £67,800 £70,000 £80,000
UK excluding London median salary £47,500 £40,500 £36,250
% change year-on-year
+17.28% +11.72%
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
11290 12977 13962
As % of all permanent IT jobs located in London 29.57% 29.74% 30.85%
Number of salaries quoted 9831 10991 12115
Median salary £60,000 £57,500 £52,500
Median salary % change year-on-year
+4.34% +9.52%
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

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 27 September 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 27 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
City of London +56 15 £57,500 -
Chiswick - 1 £32,500 -
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in London

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

1 80 (90.91%) Business Intelligence
2 75 (85.23%) SQL
3 74 (84.09%) Microsoft
3 74 (84.09%) SQL Server Reporting Services
4 59 (67.05%) SQL Server Analysis Services
5 57 (64.77%) SQL Server
6 55 (62.50%) MS Excel
7 51 (57.95%) T-SQL
8 46 (52.27%) Finance
8 46 (52.27%) SQL Server Integration Services
8 46 (52.27%) Power BI
9 40 (45.45%) MDX
10 37 (42.05%) Data Warehouse
11 34 (38.64%) ETL
11 34 (38.64%) Data Analysis Expressions (DAX)
11 34 (38.64%) Tableau
12 31 (35.23%) Data Cleansing
13 28 (31.82%) Kimball Methodology
13 28 (31.82%) Analytical Skills
14 27 (30.68%) Data Quality
15 26 (29.55%) Data Analysis
16 25 (28.41%) Management Information System
16 25 (28.41%) Visualisation
17 24 (27.27%) SharePoint
17 24 (27.27%) VBA
17 24 (27.27%) Data Management
18 23 (26.14%) Data Modelling
18 23 (26.14%) Legal
19 22 (25.00%) Microsoft Analysis Services
20 20 (22.73%) Agile Software Development

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 24 (27.27%) SharePoint
2 4 (4.55%) WebSphere
3 1 (1.14%) SAS
Applications
1 55 (62.50%) MS Excel
2 4 (4.55%) MS Visio
3 1 (1.14%) MS PowerPoint
Business Applications
1 1 (1.14%) Dynamics CRM
1 1 (1.14%) Oracle Financials
Cloud Services
1 8 (9.09%) Microsoft Azure
2 6 (6.82%) SaaS
3 4 (4.55%) PaaS
4 1 (1.14%) Azure Machine Learning
4 1 (1.14%) Office 365
Database & Business Intelligence
1 74 (84.09%) SQL Server Reporting Services
2 59 (67.05%) SQL Server Analysis Services
3 57 (64.77%) SQL Server
4 46 (52.27%) Power BI
4 46 (52.27%) SQL Server Integration Services
5 37 (42.05%) Data Warehouse
6 22 (25.00%) Microsoft Analysis Services
7 18 (20.45%) SQL Server 2012
8 17 (19.32%) MS Access
9 14 (15.91%) Relational Database
10 12 (13.64%) Microsoft Power View
10 12 (13.64%) OLAP
10 12 (13.64%) SQL Server 2008
11 11 (12.50%) SQL Server 2014
11 11 (12.50%) SQL Server 2016
12 6 (6.82%) PerformancePoint
12 6 (6.82%) RDBMS
12 6 (6.82%) SQL Server 2005
13 5 (5.68%) BusinessObjects
13 5 (5.68%) MySQL
Development Applications
1 5 (5.68%) Team Foundation Server
General
1 46 (52.27%) Finance
2 23 (26.14%) Legal
3 20 (22.73%) Billing
4 6 (6.82%) Advertising
5 5 (5.68%) Marketing
6 2 (2.27%) Banking
6 2 (2.27%) Telecoms
7 1 (1.14%) Financial Institution
7 1 (1.14%) Investment Banking
7 1 (1.14%) Manufacturing
7 1 (1.14%) Private Banking
Job Titles
1 34 (38.64%) Developer
2 32 (36.36%) Business Intelligence Developer
3 22 (25.00%) Analyst
4 18 (20.45%) SSIS Developer
5 17 (19.32%) SSAS Developer
6 15 (17.05%) Microsoft BI Developer
6 15 (17.05%) Microsoft Developer
7 14 (15.91%) Business Intelligence Analyst
7 14 (15.91%) Business Intelligence Lead
7 14 (15.91%) Report Analyst
7 14 (15.91%) SSRS Developer
8 13 (14.77%) SSRS Analyst
9 12 (13.64%) SQL Developer
10 11 (12.50%) DBA
10 11 (12.50%) SQL BI Developer
10 11 (12.50%) Team Leader
11 10 (11.36%) Senior Business Intelligence Developer
11 10 (11.36%) Senior Developer
12 9 (10.23%) Senior DBA
12 9 (10.23%) Senior Microsoft Developer
Libraries, Frameworks & Software Standards
1 40 (45.45%) MDX
2 9 (10.23%) XML
3 7 (7.95%) Web Services
4 5 (5.68%) .NET
5 3 (3.41%) REST
5 3 (3.41%) SOAP
6 2 (2.27%) .NET Framework
6 2 (2.27%) HTML
6 2 (2.27%) HTML5
6 2 (2.27%) JSON
7 1 (1.14%) COM
7 1 (1.14%) D3.js
7 1 (1.14%) Leaflet
Miscellaneous
1 28 (31.82%) Analytical Skills
2 25 (28.41%) Management Information System
2 25 (28.41%) Visualisation
3 10 (11.36%) Replication
4 9 (10.23%) Data Integration
5 5 (5.68%) Mathematics
6 2 (2.27%) Data Extraction
6 2 (2.27%) Fintech
6 2 (2.27%) Wiki
Operating Systems
1 2 (2.27%) Windows
1 2 (2.27%) Windows Server
1 2 (2.27%) Windows Server 2012
Processes & Methodologies
1 80 (90.91%) Business Intelligence
2 34 (38.64%) ETL
3 31 (35.23%) Data Cleansing
4 28 (31.82%) Kimball Methodology
5 26 (29.55%) Data Analysis
6 24 (27.27%) Data Management
7 23 (26.14%) Data Modelling
8 20 (22.73%) Agile Software Development
9 16 (18.18%) Reverse Engineering
10 14 (15.91%) Analytics
11 11 (12.50%) Master Data Management
11 11 (12.50%) Presales
12 8 (9.09%) Dimensional Modelling
13 7 (7.95%) TOGAF
13 7 (7.95%) Validation
14 6 (6.82%) Data Validation
14 6 (6.82%) Logistics
14 6 (6.82%) Performance Tuning
14 6 (6.82%) Test Scripting
15 5 (5.68%) Capacity Planning
Programming Languages
1 75 (85.23%) SQL
2 51 (57.95%) T-SQL
3 34 (38.64%) Data Analysis Expressions (DAX)
4 24 (27.27%) VBA
5 14 (15.91%) C#
6 3 (3.41%) R
7 2 (2.27%) PowerShell
Qualifications
1 2 (2.27%) Degree
2 1 (1.14%) ACCA
2 1 (1.14%) CIMA
2 1 (1.14%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 27 (30.68%) Data Quality
2 13 (14.77%) PCI DSS
3 6 (6.82%) QA
4 4 (4.55%) ISO/IEC 27001
5 3 (3.41%) SLA
5 3 (3.41%) Solvency II
Vendors
1 74 (84.09%) Microsoft
2 34 (38.64%) Tableau
3 6 (6.82%) Oracle
4 5 (5.68%) SAP
5 4 (4.55%) IBM
5 4 (4.55%) Nintex
6 3 (3.41%) Salesforce.com
7 1 (1.14%) Alteryx
7 1 (1.14%) Cognos
7 1 (1.14%) MuleSoft
London
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + pension, healthcare, dental
Posted: 13 days ago