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

Location
3 months to
5 Feb 2016
Same period 2015 Same period 2014
Microsoft PowerPivot
Rank 140 - -
Rank change year-on-year
- 0
Permanent jobs citing PowerPivot 5 0 0
As % of all permanent IT jobs located in Hertfordshire 0.23% - -
As % of the Applications category 1.55% - -
Number of salaries quoted 5 0 0
Average salary £57,500 - -
UK excluding London average salary £40,500 £42,000 £45,000
% change year-on-year
-3.57% -6.66%
PowerPivot
East of England

The following table is for comparison with the above and provides statistics for the entire Applications category in permanent jobs advertised in the Hertfordshire region.

Applications Category
Hertfordshire
Permanent IT job ads with a match in the
Applications category
322 336 395
As % of all permanent IT jobs located in Hertfordshire 14.96% 16.80% 20.09%
Number of salaries quoted 265 274 293
Average salary £40,000 £34,000 £35,000
Average salary % change year-on-year
+17.64% -2.85%
90% offered a salary of more than £23,000 £22,150 £22,500
10% offered a salary of more than £65,000 £55,000 £60,000
UK excluding London average salary £35,000 £35,000 £35,000

PowerPivot
Jobs Demand Trend in Hertfordshire

This chart provides a 3-month moving total of permanent IT jobs citing PowerPivot across the Hertfordshire region as a proportion of the total demand within the Applications category.

PowerPivot Jobs Demand Trend in Hertfordshire

PowerPivot
Salary Trend in Hertfordshire

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

PowerPivot Salary Trend in Hertfordshire

PowerPivot
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing PowerPivot within the Hertfordshire region over the 3 months to 5 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
Watford - 4 £57,500 -
Stevenage - 1 £62,500 -
PowerPivot
East of England

PowerPivot
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 5 February 2016, IT jobs across the Hertfordshire 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 16 (100.00%) SQL
1 16 (100.00%) Business Intelligence
2 15 (93.75%) Toad
2 15 (93.75%) Cognos
2 15 (93.75%) QlikView
2 15 (93.75%) Analytics
2 15 (93.75%) Technical Analysis
3 13 (81.25%) Cognos Business Intelligence
4 3 (18.75%) SharePoint
4 3 (18.75%) MS Excel
4 3 (18.75%) Microsoft
4 3 (18.75%) Retail
5 2 (12.50%) Degree
5 2 (12.50%) ERwin
5 2 (12.50%) Finance
5 2 (12.50%) Line Management
5 2 (12.50%) Mentoring
5 2 (12.50%) Coaching
5 2 (12.50%) Visualisation
5 2 (12.50%) Power BI
6 1 (6.25%) Scrum
6 1 (6.25%) Agile Software Development
6 1 (6.25%) Data Warehouse
6 1 (6.25%) T-SQL
6 1 (6.25%) SQL Server
6 1 (6.25%) MDX
6 1 (6.25%) SQL Server Reporting Services
6 1 (6.25%) SQL Server Integration Services
6 1 (6.25%) Kimball Methodology
6 1 (6.25%) Data Analysis Expressions (DAX)

PowerPivot
Top Related IT Skills in Hertfordshire by Category

For the 6 months to 5 February 2016, IT jobs across the Hertfordshire 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 3 (18.75%) SharePoint
Applications
1 3 (18.75%) MS Excel
Business Applications
1 13 (81.25%) Cognos Business Intelligence
Database & Business Intelligence
1 15 (93.75%) QlikView
2 2 (12.50%) Power BI
3 1 (6.25%) Data Warehouse
3 1 (6.25%) SQL Server
3 1 (6.25%) SQL Server Analysis Services
3 1 (6.25%) SQL Server Integration Services
3 1 (6.25%) SQL Server Reporting Services
Development Applications
1 15 (93.75%) Toad
2 2 (12.50%) ERwin
General
1 3 (18.75%) Retail
2 2 (12.50%) Finance
Job Titles
1 16 (100.00%) Developer
2 14 (87.50%) Cognos Developer
2 14 (87.50%) Lead Developer
3 10 (62.50%) Business Intelligence Developer
4 9 (56.25%) Senior Business Intelligence Developer
4 9 (56.25%) Senior Developer
5 8 (50.00%) Cognos BI Developer
5 8 (50.00%) Senior Cognos BI Developer
5 8 (50.00%) Senior Cognos Developer
6 6 (37.50%) Designer
6 6 (37.50%) Lead Designer
7 1 (6.25%) Business Developer
7 1 (6.25%) SQL BI Developer
7 1 (6.25%) SQL Developer
Libraries, Frameworks & Software Standards
1 1 (6.25%) MDX
Miscellaneous
1 2 (12.50%) Visualisation
2 1 (6.25%) Data Integration
Processes & Methodologies
1 16 (100.00%) Business Intelligence
2 15 (93.75%) Analytics
2 15 (93.75%) Technical Analysis
3 2 (12.50%) Coaching
3 2 (12.50%) Line Management
3 2 (12.50%) Mentoring
4 1 (6.25%) Agile Software Development
4 1 (6.25%) Dimensional Modelling
4 1 (6.25%) Kimball Methodology
4 1 (6.25%) Scrum
Programming Languages
1 16 (100.00%) SQL
2 1 (6.25%) Data Analysis Expressions (DAX)
2 1 (6.25%) T-SQL
Qualifications
1 2 (12.50%) Degree
Vendors
1 15 (93.75%) Cognos
2 3 (18.75%) Microsoft