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

3 months to
18 Jan 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
England / Yorkshire
Rank 220 249 234
Rank change year-on-year
+29 -15
Permanent jobs citing PowerPivot 8 2 21
As % of all permanent IT jobs located in Yorkshire 0.16% 0.033% 0.31%
As % of the Database & Business Intelligence category 0.51% 0.093% 1.03%
Number of salaries quoted 8 2 16
Median salary £40,000 £30,500 £35,000
Median salary % change year-on-year
+31.14% -12.85%
90% offered a salary of more than £37,500 £30,500 £32,500
10% offered a salary of more than £70,000 £32,100 £45,000
UK excluding London median salary £45,000 £41,500 £42,000
% change year-on-year
+8.43% -1.19%

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 Yorkshire region.

Database & Business Intelligence Category
Yorkshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1574 2151 2032
As % of all permanent IT jobs located in Yorkshire 30.52% 35.70% 30.29%
Number of salaries quoted 1377 1741 1711
Median salary £41,500 £40,000 £40,000
Median salary % change year-on-year
+3.75% -
90% offered a salary of more than £31,500 £30,000 £27,500
10% offered a salary of more than £55,000 £50,000 £57,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

PowerPivot
Jobs Demand Trend in Yorkshire

The demand trend of job ads across the Yorkshire region citing PowerPivot as a proportion of all IT jobs with a match in the Database & Business Intelligence 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 18 January 2017.

PowerPivot Salary Histogram in Yorkshire

PowerPivot
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the Yorkshire region over the 3 months to 18 January 2017. 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 Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
West Yorkshire +28 6 £37,500 +22.95%
North Yorkshire -4 2 £70,000 +115.38%
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in Yorkshire

For the 6 months to 18 January 2017, IT jobs citing PowerPivot also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Yorkshire region with a requirement for PowerPivot.

1 15 (100.00%) SQL Server
1 15 (100.00%) SQL Server Integration Services
1 15 (100.00%) SQL Server Analysis Services
1 15 (100.00%) SQL Server Reporting Services
2 13 (86.67%) Power BI
3 12 (80.00%) SQL
4 10 (66.67%) ETL
4 10 (66.67%) Agile Software Development
4 10 (66.67%) Relational Database
5 9 (60.00%) SSDT
5 9 (60.00%) T-SQL
5 9 (60.00%) Visual Studio
6 5 (33.33%) SharePoint
6 5 (33.33%) Data Warehouse
6 5 (33.33%) Microsoft
7 4 (26.67%) Business Intelligence
7 4 (26.67%) MS Excel
7 4 (26.67%) Analytics
7 4 (26.67%) Microsoft Power View
7 4 (26.67%) Microsoft Azure
8 3 (20.00%) Analytical Skills
8 3 (20.00%) Driving Licence
8 3 (20.00%) SQL Server 2012
9 2 (13.33%) IBM
9 2 (13.33%) Microsoft Analysis Services
10 1 (6.67%) TOGAF
10 1 (6.67%) BusinessObjects
10 1 (6.67%) MS Visio
10 1 (6.67%) Management Information System
10 1 (6.67%) Workflow

PowerPivot
Top Related IT Skills in Yorkshire by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 5 (33.33%) SharePoint
2 1 (6.67%) WebSphere
Applications
1 4 (26.67%) MS Excel
2 1 (6.67%) MS Visio
Business Applications
1 1 (6.67%) Dynamics CRM
1 1 (6.67%) StreamServe
Cloud Services
1 4 (26.67%) Microsoft Azure
2 1 (6.67%) PaaS
2 1 (6.67%) SaaS
Database & Business Intelligence
1 15 (100.00%) SQL Server
1 15 (100.00%) SQL Server Analysis Services
1 15 (100.00%) SQL Server Integration Services
1 15 (100.00%) SQL Server Reporting Services
2 13 (86.67%) Power BI
3 10 (66.67%) Relational Database
4 9 (60.00%) SSDT
5 5 (33.33%) Data Warehouse
6 4 (26.67%) Microsoft Power View
7 3 (20.00%) SQL Server 2012
8 2 (13.33%) Microsoft Analysis Services
9 1 (6.67%) BusinessObjects
9 1 (6.67%) MS Access
9 1 (6.67%) PerformancePoint
9 1 (6.67%) SAP Data Services
9 1 (6.67%) Snowflake Schema
9 1 (6.67%) Star Schema
Development Applications
1 9 (60.00%) Visual Studio
2 1 (6.67%) Git (software)
2 1 (6.67%) Team Foundation Server
General
1 1 (6.67%) Finance
Job Titles
1 10 (66.67%) Developer
1 10 (66.67%) SQL Developer
2 1 (6.67%) Architect
2 1 (6.67%) Business Intelligence Consultant
2 1 (6.67%) Business Intelligence Lead
2 1 (6.67%) Business Intelligence Specialist
2 1 (6.67%) Consultant
2 1 (6.67%) Solutions Architect
2 1 (6.67%) SQL Server Consultant
2 1 (6.67%) SQL Server Specialist
Libraries, Frameworks & Software Standards
1 1 (6.67%) CSS
1 1 (6.67%) HTML
1 1 (6.67%) MDX
Miscellaneous
1 3 (20.00%) Analytical Skills
1 3 (20.00%) Driving Licence
2 1 (6.67%) Management Information System
Processes & Methodologies
1 10 (66.67%) Agile Software Development
1 10 (66.67%) ETL
2 4 (26.67%) Analytics
2 4 (26.67%) Business Intelligence
3 1 (6.67%) CRM
3 1 (6.67%) Enterprise Architecture
3 1 (6.67%) Kimball Methodology
3 1 (6.67%) Scrum
3 1 (6.67%) SDLC
3 1 (6.67%) SSADM
3 1 (6.67%) Stakeholder Engagement
3 1 (6.67%) Stakeholder Management
3 1 (6.67%) TOGAF
3 1 (6.67%) Translating Business Requirements
3 1 (6.67%) UML
3 1 (6.67%) Validation
3 1 (6.67%) Workflow
Programming Languages
1 12 (80.00%) SQL
2 9 (60.00%) T-SQL
3 1 (6.67%) C#
3 1 (6.67%) Data Analysis Expressions (DAX)
3 1 (6.67%) JavaScript
3 1 (6.67%) VB
Qualifications
1 1 (6.67%) Degree
Quality Assurance & Compliance
1 1 (6.67%) ISO/IEC 27001
1 1 (6.67%) QA
Vendors
1 5 (33.33%) Microsoft
2 2 (13.33%) IBM
3 1 (6.67%) Cognos
3 1 (6.67%) Nintex
3 1 (6.67%) SAP