The table below looks at the statistics for PowerPivot skills in IT jobs advertised for the North West 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 215 226 237
Rank change year-on-year
+11 +11
Permanent jobs citing PowerPivot 16 32 11
As % of all permanent IT jobs located in the North West 0.29% 0.46% 0.17%
As % of the Database & Business Intelligence category 0.91% 1.38% 0.42%
Number of salaries quoted 12 26 11
Average salary £37,500 £40,000 £45,000
Average salary % change year-on-year
-6.25% -11.11%
UK excluding London average salary £40,500 £42,000 £45,000
% change year-on-year
-3.57% -6.66%
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 North West region.

Database & Business Intelligence Category
North West
Permanent IT job ads with a match in the
Database & Business Intelligence category
1750 2319 2628
As % of all permanent IT jobs located in the North West 31.42% 33.00% 39.56%
Number of salaries quoted 1528 2013 2284
Average salary £42,500 £40,000 £37,500
Average salary % change year-on-year
+6.25% +6.66%
90% offered a salary of more than £30,000 £28,500 £27,500
10% offered a salary of more than £52,500 £51,300 £52,500
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

PowerPivot
Jobs Demand Trend in the North West

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

PowerPivot Jobs Demand Trend in the North West

PowerPivot
Salary Trend in the North West

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

PowerPivot Salary Trend in the North West

PowerPivot
Salary Histogram in the North West

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

PowerPivot Salary Histogram in the North West

PowerPivot
Job Locations in the North West

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing PowerPivot within the North West region over the 3 months to 12 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
Manchester +2 7 £60,000 +50.00% 1
Lancashire +16 6 £30,000 - 3
Cheshire +26 2 £40,000 +14.28%
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in the North West

For the 6 months to 12 February 2016, IT jobs across the North West 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 52 (96.30%) Business Intelligence
2 46 (85.19%) SQL Server
3 43 (79.63%) SQL
4 36 (66.67%) Data Warehouse
5 35 (64.81%) SQL Server Reporting Services
6 31 (57.41%) Microsoft
6 31 (57.41%) ETL
7 30 (55.56%) SQL Server Integration Services
7 30 (55.56%) Power BI
8 27 (50.00%) Tableau
9 24 (44.44%) Data Management
10 23 (42.59%) SharePoint
11 22 (40.74%) SQL Server Analysis Services
11 22 (40.74%) SQL Server 2012
12 21 (38.89%) MDX
13 18 (33.33%) Data Modelling
14 17 (31.48%) T-SQL
14 17 (31.48%) Analytics
14 17 (31.48%) Team Foundation Server
14 17 (31.48%) Microsoft Power View
15 16 (29.63%) Relational Database
15 16 (29.63%) RDBMS
15 16 (29.63%) Subversion
16 15 (27.78%) Agile Software Development
17 12 (22.22%) Migration
18 11 (20.37%) Enterprise Data Warehouse
18 11 (20.37%) NoSQL
18 11 (20.37%) Customer Insight
18 11 (20.37%) OLAP
18 11 (20.37%) Web Analytics

PowerPivot
Top Related IT Skills in the North West by Category

For the 6 months to 12 February 2016, IT jobs across the North West 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 23 (42.59%) SharePoint
2 1 (1.85%) Confluence
2 1 (1.85%) SAS
Applications
1 9 (16.67%) MS Excel
Database & Business Intelligence
1 46 (85.19%) SQL Server
2 36 (66.67%) Data Warehouse
3 35 (64.81%) SQL Server Reporting Services
4 30 (55.56%) Power BI
4 30 (55.56%) SQL Server Integration Services
5 22 (40.74%) SQL Server 2012
5 22 (40.74%) SQL Server Analysis Services
6 17 (31.48%) Microsoft Power View
7 16 (29.63%) RDBMS
7 16 (29.63%) Relational Database
8 11 (20.37%) Enterprise Data Warehouse
8 11 (20.37%) NoSQL
8 11 (20.37%) OLAP
9 9 (16.67%) SQL Server 2014
10 7 (12.96%) Microsoft Analysis Services
11 6 (11.11%) Pentaho
12 4 (7.41%) SQL Server 2008
13 2 (3.70%) MySQL
14 1 (1.85%) Hadoop
14 1 (1.85%) MS Access
Development Applications
1 17 (31.48%) Team Foundation Server
2 16 (29.63%) Subversion
3 11 (20.37%) Git (software)
4 3 (5.56%) Talend Open Studio
5 1 (1.85%) Atlassian Bamboo
5 1 (1.85%) GitLab
5 1 (1.85%) JIRA
General
1 4 (7.41%) Finance
2 1 (1.85%) Banking
2 1 (1.85%) Games
2 1 (1.85%) Retail
Job Titles
1 33 (61.11%) Developer
2 27 (50.00%) Business Intelligence Developer
3 12 (22.22%) SQL BI Developer
3 12 (22.22%) SQL Developer
4 9 (16.67%) Senior Business Intelligence Developer
4 9 (16.67%) Senior Developer
5 8 (14.81%) Analyst
6 6 (11.11%) Architect
6 6 (11.11%) Business Intelligence Analyst
6 6 (11.11%) Data Warehouse Developer
6 6 (11.11%) DBA
7 5 (9.26%) Lead Developer
8 4 (7.41%) DBA Manager
8 4 (7.41%) Security Manager
8 4 (7.41%) Server Analyst
8 4 (7.41%) SQL Analyst
8 4 (7.41%) SQL Server Analyst
9 3 (5.56%) Business Intelligence Manager
9 3 (5.56%) IT Manager
10 2 (3.70%) Technical Architect
Libraries, Frameworks & Software Standards
1 21 (38.89%) MDX
Miscellaneous
1 7 (12.96%) NHS
2 6 (11.11%) Data Structures
2 6 (11.11%) Management Information System
3 4 (7.41%) Analytical Skills
4 2 (3.70%) Computer Science
4 2 (3.70%) Economics
4 2 (3.70%) Mathematics
4 2 (3.70%) Statistics
Processes & Methodologies
1 52 (96.30%) Business Intelligence
2 31 (57.41%) ETL
3 24 (44.44%) Data Management
4 18 (33.33%) Data Modelling
5 17 (31.48%) Analytics
6 15 (27.78%) Agile Software Development
7 12 (22.22%) Migration
8 11 (20.37%) Customer Insight
8 11 (20.37%) Web Analytics
9 7 (12.96%) Performance Tuning
10 6 (11.11%) Dashboard Development
10 6 (11.11%) Data Analytics
10 6 (11.11%) Disaster Recovery
10 6 (11.11%) High Availability
10 6 (11.11%) Master Data Management
11 5 (9.26%) Complex ETL
12 4 (7.41%) ETL Development
13 2 (3.70%) Pay per click
14 1 (1.85%) Data Analysis
14 1 (1.85%) Data Cleansing
Programming Languages
1 43 (79.63%) SQL
2 17 (31.48%) T-SQL
3 8 (14.81%) VBA
4 3 (5.56%) R
5 1 (1.85%) PowerShell
Qualifications
1 2 (3.70%) CCAB
1 2 (3.70%) Degree
Vendors
1 31 (57.41%) Microsoft
2 27 (50.00%) Tableau
3 3 (5.56%) Talend
3 3 (5.56%) Vertica
4 1 (1.85%) Red Gate
Lancashire
HAYS INFORMATION TECHNOLOGY
Salary: £26041.00 - £34876.00 per annum + Benefits
Posted: Yesterday
Leyland, Lancashire
HAYS INFORMATION TECHNOLOGY
Salary: £26041.00 - £34876.00 per annum + Benefits
Posted: 2 days ago
Chorley, Lancashire
Verticality Ltd
Salary: to £35k DOE
Posted: 3 days ago
Bury, Lancashire
DCS Recruitment
Salary: £35000 - £40000 per annum + Bens
Posted: 6 days ago
Liverpool
Computer Futures
Salary: competitive
Posted: 16 days ago