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

3 months to
29 Jun 2016
Same period 2015 Same period 2014
Microsoft Power Pivot
Rank 184 182 225
Rank change year-on-year
-2 +43
Permanent jobs citing PowerPivot 16 37 7
As % of all permanent IT jobs located in Surrey 0.44% 0.80% 0.13%
As % of the Database & Business Intelligence category 1.37% 2.45% 0.41%
Number of salaries quoted 15 28 7
Median salary £52,500 £45,000 £55,000
Median salary % change year-on-year
+16.66% -18.18%
UK excluding London median salary £44,500 £50,000 £43,750
% change year-on-year
-11.00% +14.28%
PowerPivot
South East

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

Database & Business Intelligence Category
Surrey
Permanent IT job ads with a match in the
Database & Business Intelligence category
1165 1511 1691
As % of all permanent IT jobs located in Surrey 31.78% 32.58% 32.41%
Number of salaries quoted 1023 1297 1428
Median salary £50,000 £45,000 £45,000
Median salary % change year-on-year
+11.11% -
90% offered a salary of more than £32,500 £30,000 £32,000
10% offered a salary of more than £70,000 £65,000 £65,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

PowerPivot
Jobs Demand Trend in Surrey

The demand trend of job ads across the Surrey region citing PowerPivot as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

PowerPivot Jobs Demand Trend in Surrey

PowerPivot
Salary Trend in Surrey

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

PowerPivot Salary Trend in Surrey

PowerPivot
Salary Histogram in Surrey

This chart provides a salary histogram for IT jobs citing PowerPivot across the Surrey region over the 3 months to 29 June 2016.

PowerPivot Salary Histogram in Surrey

PowerPivot
Job Locations in Surrey

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the Surrey region over the 3 months to 29 June 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
(Click see detailed
statistics and trends)
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
Woking - 13 £52,500 -
PowerPivot
South East

PowerPivot
Top 30 Related IT Skills in Surrey

For the 6 months to 29 June 2016, 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 Surrey region with a requirement for PowerPivot.

1 27 (100.00%) Business Intelligence
1 27 (100.00%) SQL Server Reporting Services
1 27 (100.00%) SQL Server Analysis Services
2 26 (96.30%) Microsoft
3 20 (74.07%) SQL
3 20 (74.07%) SQL Server
4 18 (66.67%) Data Warehouse
5 15 (55.56%) SQL Server Integration Services
6 13 (48.15%) Degree
6 13 (48.15%) Microsoft Power View
6 13 (48.15%) SharePoint
6 13 (48.15%) HTML
6 13 (48.15%) CSS
7 12 (44.44%) MS Excel
7 12 (44.44%) C#
7 12 (44.44%) Cognos
7 12 (44.44%) T-SQL
7 12 (44.44%) Finance
7 12 (44.44%) Mobile App
8 11 (40.74%) VBA
9 9 (33.33%) SQL Server 2012
9 9 (33.33%) Power BI
10 8 (29.63%) SQL Server 2014
10 8 (29.63%) Data Visualisation
10 8 (29.63%) Visualisation
10 8 (29.63%) Agile Software Development
11 7 (25.93%) Data Analysis Expressions (DAX)
12 6 (22.22%) OLAP
12 6 (22.22%) Scrum
12 6 (22.22%) ETL

PowerPivot
Top Related IT Skills in Surrey 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 13 (48.15%) SharePoint
2 1 (3.70%) Apache
2 1 (3.70%) Tomcat
Applications
1 12 (44.44%) MS Excel
Business Applications
1 1 (3.70%) Dynamics AX
1 1 (3.70%) Dynamics CRM
Cloud Services
1 1 (3.70%) Amazon AWS
1 1 (3.70%) Microsoft Azure
Database & Business Intelligence
1 27 (100.00%) SQL Server Analysis Services
1 27 (100.00%) SQL Server Reporting Services
2 20 (74.07%) SQL Server
3 18 (66.67%) Data Warehouse
4 15 (55.56%) SQL Server Integration Services
5 13 (48.15%) Microsoft Power View
6 9 (33.33%) Power BI
6 9 (33.33%) SQL Server 2012
7 8 (29.63%) SQL Server 2014
8 6 (22.22%) OLAP
9 1 (3.70%) Microsoft Analysis Services
General
1 12 (44.44%) Finance
Job Titles
1 18 (66.67%) Business Intelligence Developer
1 18 (66.67%) Developer
2 12 (44.44%) Report Developer
3 4 (14.81%) Data Visualisation Specialist
4 2 (7.41%) Analyst
4 2 (7.41%) Analyst Developer
4 2 (7.41%) Business Intelligence Analyst
4 2 (7.41%) Developer Analyst
4 2 (7.41%) Report Analyst
5 1 (3.70%) Software Engineer
Libraries, Frameworks & Software Standards
1 13 (48.15%) CSS
1 13 (48.15%) HTML
2 1 (3.70%) .NET
2 1 (3.70%) Web Services
2 1 (3.70%) XML
Miscellaneous
1 12 (44.44%) Mobile App
2 8 (29.63%) Visualisation
3 1 (3.70%) Analytical Skills
3 1 (3.70%) Management Information System
Processes & Methodologies
1 27 (100.00%) Business Intelligence
2 8 (29.63%) Agile Software Development
2 8 (29.63%) Data Visualisation
3 6 (22.22%) ETL
3 6 (22.22%) Scrum
4 1 (3.70%) Agile Project Management
4 1 (3.70%) Business Transformation
4 1 (3.70%) CAD
4 1 (3.70%) CRM
4 1 (3.70%) Dashboard Development
4 1 (3.70%) Data Management
4 1 (3.70%) Data Modelling
4 1 (3.70%) ERP
4 1 (3.70%) Information Management
4 1 (3.70%) Kimball Methodology
4 1 (3.70%) PDM
4 1 (3.70%) Process Improvement
4 1 (3.70%) Project Management
4 1 (3.70%) Software Engineering
Programming Languages
1 20 (74.07%) SQL
2 12 (44.44%) C#
2 12 (44.44%) T-SQL
3 11 (40.74%) VBA
4 7 (25.93%) Data Analysis Expressions (DAX)
5 1 (3.70%) JavaScript
5 1 (3.70%) VB.NET
Qualifications
1 13 (48.15%) Degree
Quality Assurance & Compliance
1 1 (3.70%) QA
Vendors
1 26 (96.30%) Microsoft
2 12 (44.44%) Cognos
3 1 (3.70%) JD Edwards