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

Location
3 months to
12 Feb 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 259 294 313
Rank change year-on-year
+35 +19
Permanent jobs citing PowerPivot 6 24 8
As % of all permanent IT jobs located in the City of London 0.090% 0.23% 0.076%
As % of the Database & Business Intelligence category 0.30% 0.86% 0.27%
Number of salaries quoted 6 22 8
Average salary £43,750 £48,750 £48,750
Average salary % change year-on-year
-10.25% -
90% offered a salary of more than £40,000 £42,500 £47,500
10% offered a salary of more than £55,000 £62,500 £62,250
UK excluding London average salary £40,500 £42,000 £45,000
% change year-on-year
-3.57% -6.66%
PowerPivot
London

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

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
1990 2788 2952
As % of all permanent IT jobs located in the City of London 29.81% 26.84% 27.98%
Number of salaries quoted 1760 2508 2582
Average salary £55,000 £55,000 £55,000
90% offered a salary of more than £40,000 £37,500 £35,000
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 the City of London

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

PowerPivot Jobs Demand Trend in the City of London

PowerPivot
Salary Trend in the City of London

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

PowerPivot Salary Trend in the City of London

PowerPivot
Salary Histogram in the City of London

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

PowerPivot Salary Histogram in the City of London

PowerPivot
Top 30 Related IT Skills in the City of London

For the 6 months to 12 February 2016, IT jobs across the City of 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 9 (90.00%) SQL Server
2 8 (80.00%) Business Intelligence
3 7 (70.00%) Microsoft
3 7 (70.00%) SQL
3 7 (70.00%) SQL Server Reporting Services
3 7 (70.00%) Tableau
4 6 (60.00%) Analytical Skills
4 6 (60.00%) MS Excel
5 5 (50.00%) T-SQL
6 4 (40.00%) VBA
6 4 (40.00%) Data Warehouse
6 4 (40.00%) Data Modelling
6 4 (40.00%) Finance
6 4 (40.00%) Legal
6 4 (40.00%) Analytics
6 4 (40.00%) MDX
6 4 (40.00%) SQL Server Analysis Services
7 3 (30.00%) Spotfire
7 3 (30.00%) Algorithms
7 3 (30.00%) Microsoft Power View
7 3 (30.00%) Relational Database
7 3 (30.00%) Degree
7 3 (30.00%) Agile Software Development
7 3 (30.00%) Billing
7 3 (30.00%) Economics
7 3 (30.00%) Microsoft Analysis Services
7 3 (30.00%) Statistics
7 3 (30.00%) GIS
7 3 (30.00%) MS Access
7 3 (30.00%) JavaScript

PowerPivot
Top Related IT Skills in the City of London by Category

For the 6 months to 12 February 2016, IT jobs across the City of 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 1 (10.00%) SharePoint
Applications
1 6 (60.00%) MS Excel
2 1 (10.00%) MS Office
2 1 (10.00%) Spreadsheet
Business Applications
1 1 (10.00%) SAP Business One
Database & Business Intelligence
1 9 (90.00%) SQL Server
2 7 (70.00%) SQL Server Reporting Services
3 4 (40.00%) Data Warehouse
3 4 (40.00%) SQL Server Analysis Services
4 3 (30.00%) GIS
4 3 (30.00%) Microsoft Analysis Services
4 3 (30.00%) Microsoft Power View
4 3 (30.00%) MS Access
4 3 (30.00%) Relational Database
4 3 (30.00%) Spotfire
5 2 (20.00%) SQL Server 2012
5 2 (20.00%) SQL Server Integration Services
6 1 (10.00%) OLAP
6 1 (10.00%) OLTP
6 1 (10.00%) Power BI
6 1 (10.00%) RDBMS
6 1 (10.00%) SQL Server 2008
6 1 (10.00%) SQL Server 2014
Development Applications
1 2 (20.00%) Team Foundation Server
2 1 (10.00%) SQL Server Management Studio (SSMS)
2 1 (10.00%) Visual Studio
2 1 (10.00%) Visual Studio Tools for Office
General
1 4 (40.00%) Finance
1 4 (40.00%) Legal
2 3 (30.00%) Billing
3 2 (20.00%) Retail
4 1 (10.00%) Banking
Job Titles
1 7 (70.00%) Analyst
2 4 (40.00%) Business Intelligence Analyst
2 4 (40.00%) SQL Analyst
3 3 (30.00%) Developer
3 3 (30.00%) Excel Analyst
4 2 (20.00%) Business Intelligence Developer
4 2 (20.00%) Data Analyst
4 2 (20.00%) SQL Data Analyst
5 1 (10.00%) Billing Analyst
5 1 (10.00%) Billing Business Analyst
5 1 (10.00%) Data Business Analyst
5 1 (10.00%) Excel Developer
5 1 (10.00%) Excel VBA Developer
5 1 (10.00%) Finance Business Analyst
5 1 (10.00%) OLAP Developer
5 1 (10.00%) Report Analyst
5 1 (10.00%) SQL Programmer
5 1 (10.00%) SQL Reporting Analyst
5 1 (10.00%) T-SQL Programmer
5 1 (10.00%) VBA Developer
Libraries, Frameworks & Software Standards
1 4 (40.00%) MDX
2 1 (10.00%) XML
Miscellaneous
1 6 (60.00%) Analytical Skills
2 3 (30.00%) Algorithms
2 3 (30.00%) Economics
2 3 (30.00%) Statistics
3 2 (20.00%) Data Integration
3 2 (20.00%) Management Information System
Processes & Methodologies
1 8 (80.00%) Business Intelligence
2 4 (40.00%) Analytics
2 4 (40.00%) Data Modelling
3 3 (30.00%) Agile Software Development
4 2 (20.00%) Data Analysis
4 2 (20.00%) Data Cleansing
4 2 (20.00%) Data Management
4 2 (20.00%) Dimensional Modelling
4 2 (20.00%) Kimball Methodology
4 2 (20.00%) Scrum
4 2 (20.00%) SDLC
4 2 (20.00%) User Acceptance Testing
5 1 (10.00%) Data Architecture
5 1 (10.00%) Data Transformation
5 1 (10.00%) Line Management
5 1 (10.00%) Software Testing
5 1 (10.00%) System Testing
5 1 (10.00%) TDD
5 1 (10.00%) Unit Testing
5 1 (10.00%) Waterfall
Programming Languages
1 7 (70.00%) SQL
2 5 (50.00%) T-SQL
3 4 (40.00%) VBA
4 3 (30.00%) JavaScript
4 3 (30.00%) Python
5 2 (20.00%) Data Analysis Expressions (DAX)
Qualifications
1 3 (30.00%) Degree
2 1 (10.00%) ACCA
2 1 (10.00%) CIMA
2 1 (10.00%) MCP
2 1 (10.00%) Microsoft Certification
Quality Assurance & Compliance
1 2 (20.00%) PCI DSS
2 1 (10.00%) Data Quality
2 1 (10.00%) QA
Vendors
1 7 (70.00%) Microsoft
1 7 (70.00%) Tableau
2 1 (10.00%) Oracle
2 1 (10.00%) SAP
City, London
Hitachi Consulting UK
Salary: From £75,000 to £95,000 per annum Incl Benefits + Bonus
Posted: 3 days ago