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 29 April 2016 with a comparison to the same period in the previous 2 years.

3 months to
29 Apr 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 222 246 267
Rank change year-on-year
+24 +21
Permanent jobs citing PowerPivot 12 3 1
As % of all permanent IT jobs located in the North West 0.21% 0.046% 0.014%
As % of the Database & Business Intelligence category 0.68% 0.13% 0.036%
Number of salaries quoted 12 3 1
Average salary £31,479 £40,000 £37,500
Average salary % change year-on-year
-21.30% +6.66%
UK excluding London average salary £45,000 £45,000 £40,000
% change year-on-year
- +12.50%
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
1774 2299 2772
As % of all permanent IT jobs located in the North West 31.26% 35.27% 39.38%
Number of salaries quoted 1529 1950 2412
Average salary £40,000 £40,000 £37,500
Average salary % change year-on-year
- +6.66%
90% offered a salary of more than £29,000 £27,500 £27,500
10% offered a salary of more than £54,000 £52,500 £50,000
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
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 29 April 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
Lancashire - 10 £30,459 - 2
Manchester +8 2 £34,500 -13.75% 2
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in the North West

For the 6 months to 29 April 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 32 (94.12%) SQL
1 32 (94.12%) Business Intelligence
2 31 (91.18%) SQL Server
3 27 (79.41%) Power BI
4 23 (67.65%) Microsoft
5 20 (58.82%) Analytics
6 17 (50.00%) Data Warehouse
6 17 (50.00%) SQL Server Reporting Services
6 17 (50.00%) SQL Server Integration Services
7 16 (47.06%) Microsoft Power View
8 15 (44.12%) MS Excel
8 15 (44.12%) SQL Server Analysis Services
9 14 (41.18%) VBA
10 13 (38.24%) T-SQL
10 13 (38.24%) ETL
10 13 (38.24%) Pentaho
10 13 (38.24%) MDX
10 13 (38.24%) Data Analytics
11 12 (35.29%) Dashboard Development
11 12 (35.29%) Management Information System
12 10 (29.41%) Data Management
13 9 (26.47%) Tableau
14 8 (23.53%) SQL Server 2012
14 8 (23.53%) Data Modelling
14 8 (23.53%) OLAP
15 7 (20.59%) Migration
15 7 (20.59%) Web Analytics
15 7 (20.59%) NoSQL
15 7 (20.59%) Customer Insight
15 7 (20.59%) Enterprise Data Warehouse

PowerPivot
Top Related IT Skills in the North West by Category

For the 6 months to 29 April 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 2 (5.88%) SharePoint
Applications
1 15 (44.12%) MS Excel
2 1 (2.94%) MS Office
Database & Business Intelligence
1 31 (91.18%) SQL Server
2 27 (79.41%) Power BI
3 17 (50.00%) Data Warehouse
3 17 (50.00%) SQL Server Integration Services
3 17 (50.00%) SQL Server Reporting Services
4 16 (47.06%) Microsoft Power View
5 15 (44.12%) SQL Server Analysis Services
6 13 (38.24%) Pentaho
7 8 (23.53%) OLAP
7 8 (23.53%) SQL Server 2012
8 7 (20.59%) Enterprise Data Warehouse
8 7 (20.59%) NoSQL
9 6 (17.65%) Microsoft Analysis Services
10 4 (11.76%) Relational Database
11 3 (8.82%) RDBMS
11 3 (8.82%) SQL Server 2014
12 2 (5.88%) SQL Server 2008
13 1 (2.94%) Hadoop
13 1 (2.94%) MySQL
Development Applications
1 3 (8.82%) Talend Open Studio
2 2 (5.88%) Git (software)
2 2 (5.88%) Subversion
2 2 (5.88%) Team Foundation Server
3 1 (2.94%) Toad
General
1 2 (5.88%) Finance
Job Titles
1 16 (47.06%) Analyst
2 15 (44.12%) Developer
3 13 (38.24%) Business Intelligence Analyst
3 13 (38.24%) Business Intelligence Developer
4 7 (20.59%) SQL Analyst
5 6 (17.65%) Analyst Developer
5 6 (17.65%) Architect
6 5 (14.71%) Senior Business Intelligence Developer
6 5 (14.71%) Senior Developer
7 4 (11.76%) SQL Server Analyst
8 3 (8.82%) Business Intelligence Lead
8 3 (8.82%) Business Intelligence Manager
8 3 (8.82%) IT Manager
9 2 (5.88%) Commercial Analyst
9 2 (5.88%) Commercial Data Analyst
9 2 (5.88%) Data Analyst
9 2 (5.88%) Data Warehouse Developer
9 2 (5.88%) SQL BI Developer
9 2 (5.88%) SQL Developer
9 2 (5.88%) Technical Architect
Libraries, Frameworks & Software Standards
1 13 (38.24%) MDX
Miscellaneous
1 12 (35.29%) Management Information System
2 5 (14.71%) Analytical Skills
3 3 (8.82%) Computer Science
3 3 (8.82%) Mathematics
3 3 (8.82%) NHS
3 3 (8.82%) Statistics
4 2 (5.88%) Data Structures
4 2 (5.88%) Economics
5 1 (2.94%) Data Conversion
5 1 (2.94%) Data Extraction
5 1 (2.94%) Visualisation
Processes & Methodologies
1 32 (94.12%) Business Intelligence
2 20 (58.82%) Analytics
3 13 (38.24%) Data Analytics
3 13 (38.24%) ETL
4 12 (35.29%) Dashboard Development
5 10 (29.41%) Data Management
6 8 (23.53%) Data Modelling
7 7 (20.59%) Customer Insight
7 7 (20.59%) Migration
7 7 (20.59%) Web Analytics
8 6 (17.65%) Disaster Recovery
8 6 (17.65%) High Availability
8 6 (17.65%) Master Data Management
8 6 (17.65%) Performance Tuning
9 5 (14.71%) Agile Software Development
10 4 (11.76%) ETL Development
11 2 (5.88%) E-Commerce
11 2 (5.88%) Pay per click
12 1 (2.94%) Complex ETL
12 1 (2.94%) Functional Testing
Programming Languages
1 32 (94.12%) SQL
2 14 (41.18%) VBA
3 13 (38.24%) T-SQL
4 3 (8.82%) R
Qualifications
1 3 (8.82%) Degree
2 2 (5.88%) CCAB
Vendors
1 23 (67.65%) Microsoft
2 9 (26.47%) Tableau
3 3 (8.82%) Talend
3 3 (8.82%) Vertica
4 1 (2.94%) IDERA
4 1 (2.94%) Oracle
4 1 (2.94%) RedGate
Chorley, Lancashire
Verticality Ltd
Salary: to £35k DOE
Posted: 2 days ago
Lancashire
Capita plc
Posted: 8 days ago
Manchester
Hays Specialist Recruitment Ltd
Salary: £30000.00 - £40000.00 per annum + Excellent Benefits
Posted: 24 days ago