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

Location
3 months to
21 Nov 2014
Same period 2013 Same period 2012
Microsoft PowerPivot
Rank 257 220 220
Rank change year-on-year
-37 0
Permanent jobs citing PowerPivot 13 15 2
As % of all permanent IT jobs located in Yorkshire 0.17% 0.25% 0.035%
As % of the Applications category 0.99% 1.42% 0.23%
Number of salaries quoted 10 14 1
Average salary £35,000 £42,500 £32,000
Average salary % change year-on-year
-17.64% +32.81%
UK excluding London average salary £42,000 £50,000 £52,500
% change year-on-year
-16.00% -4.76%
PowerPivot
England

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

Applications Category
Yorkshire
Permanent IT job ads with a match in the
Applications category
1313 1059 888
As % of all permanent IT jobs located in Yorkshire 17.37% 17.88% 15.39%
Number of salaries quoted 1017 846 748
Average salary £32,500 £32,500 £30,000
Average salary % change year-on-year
- +8.33%
90% offered a salary of more than £21,000 £21,000 £20,500
10% offered a salary of more than £45,000 £45,000 £50,000
UK excluding London average salary £34,250 £35,000 £34,000
% change year-on-year
-2.14% +2.94%

PowerPivot
Jobs Demand Trend in Yorkshire

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

PowerPivot Jobs Demand Trend in Yorkshire

PowerPivot
Salary Trend in Yorkshire

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

PowerPivot Salary Trend in Yorkshire

PowerPivot
Salary Histogram in Yorkshire

This chart provides a salary histogram for IT jobs citing PowerPivot across the Yorkshire region over the 3 months to 21 November 2014.

PowerPivot Salary Histogram in Yorkshire

PowerPivot
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing PowerPivot within the Yorkshire region over the 3 months to 21 November 2014. 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
West Yorkshire -25 7 £43,250 +1.76%
South Yorkshire -27 6 £32,500 -31.57%
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in Yorkshire

For the 6 months to 21 November 2014, IT jobs across the Yorkshire 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 20 (100.00%) SQL Server
1 20 (100.00%) Data Warehouse
1 20 (100.00%) Business Intelligence
1 20 (100.00%) Microsoft
1 20 (100.00%) SQL Server Integration Services
2 19 (95.00%) SQL Server Analysis Services
2 19 (95.00%) SQL Server Reporting Services
3 18 (90.00%) MS Excel
4 16 (80.00%) SQL Server 2012
5 15 (75.00%) SQL Server 2008
6 14 (70.00%) Microsoft Power View
6 14 (70.00%) SQL
7 13 (65.00%) T-SQL
8 11 (55.00%) ETL
9 10 (50.00%) Agile Software Development
10 9 (45.00%) ProClarity
10 9 (45.00%) Microsoft Analysis Services
10 9 (45.00%) SharePoint
11 8 (40.00%) Data Management
11 8 (40.00%) Business Analysis
11 8 (40.00%) SharePoint 2013
11 8 (40.00%) Master Data Management
11 8 (40.00%) SharePoint 2010
12 7 (35.00%) Unit Testing
12 7 (35.00%) Finance
13 6 (30.00%) Data Analysis
13 6 (30.00%) Management Information System
13 6 (30.00%) VBA
14 4 (20.00%) Customer Engagement
14 4 (20.00%) MDX

PowerPivot
Top Related IT Skills in Yorkshire by Category

For the 6 months to 21 November 2014, IT jobs across the Yorkshire 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 9 (45.00%) SharePoint
2 8 (40.00%) SharePoint 2010
2 8 (40.00%) SharePoint 2013
Applications
1 18 (90.00%) MS Excel
Database & Business Intelligence
1 20 (100.00%) SQL Server
1 20 (100.00%) Data Warehouse
1 20 (100.00%) SQL Server Integration Services
2 19 (95.00%) SQL Server Analysis Services
2 19 (95.00%) SQL Server Reporting Services
3 16 (80.00%) SQL Server 2012
4 15 (75.00%) SQL Server 2008
5 14 (70.00%) Microsoft Power View
6 9 (45.00%) ProClarity
6 9 (45.00%) Microsoft Analysis Services
7 3 (15.00%) PerformancePoint
8 1 (5.00%) OLAP
Development Applications
1 1 (5.00%) Team Foundation Server
General
1 7 (35.00%) Finance
2 1 (5.00%) Retail
Job Titles
1 10 (50.00%) Developer
2 9 (45.00%) Business Intelligence Developer
3 8 (40.00%) Business Developer
4 6 (30.00%) Analyst
4 6 (30.00%) Report Analyst
4 6 (30.00%) Data Analyst
5 3 (15.00%) SQL Developer
5 3 (15.00%) Senior Developer
5 3 (15.00%) Business Intelligence Manager
5 3 (15.00%) Senior Business Intelligence Developer
5 3 (15.00%) Business Manager
6 1 (5.00%) MI Analyst
6 1 (5.00%) SQL Server Developer
6 1 (5.00%) SQL Database Developer
6 1 (5.00%) Database Developer
Libraries, Frameworks & Software Standards
1 4 (20.00%) MDX
Miscellaneous
1 6 (30.00%) Management Information System
2 1 (5.00%) FMCG
Processes & Methodologies
1 20 (100.00%) Business Intelligence
2 11 (55.00%) ETL
3 10 (50.00%) Agile Software Development
4 8 (40.00%) Data Management
4 8 (40.00%) Business Analysis
4 8 (40.00%) Master Data Management
5 7 (35.00%) Unit Testing
6 6 (30.00%) Data Analysis
7 4 (20.00%) Customer Engagement
8 3 (15.00%) Dimensional Modelling
8 3 (15.00%) Line Management
8 3 (15.00%) Requirements Analysis
9 2 (10.00%) RUP
9 2 (10.00%) Scrum
10 1 (5.00%) Mentoring
10 1 (5.00%) People Management
10 1 (5.00%) Inmon Methodology
10 1 (5.00%) Test Strategy
10 1 (5.00%) Kimball Methodology
Programming Languages
1 14 (70.00%) SQL
2 13 (65.00%) T-SQL
3 6 (30.00%) VBA
Quality Assurance & Compliance
1 1 (5.00%) Data Quality
Vendors
1 20 (100.00%) Microsoft