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

3 months to
20 Feb 2017
Same period 2016 Same period 2015
Microsoft Power Pivot
England / South East
Rank 366 416 398
Rank change year-on-year
+50 -18
Permanent jobs citing PowerPivot 21 30 69
As % of all permanent IT jobs located in the South East 0.14% 0.16% 0.33%
As % of the Database & Business Intelligence category 0.48% 0.49% 1.09%
Number of salaries quoted 17 26 65
Median salary £45,000 £42,750 £42,500
Median salary % change year-on-year
+5.26% +0.58%
90% offered a salary of more than £40,000 £30,000 £40,500
10% offered a salary of more than £55,500 £75,000 £60,000
UK excluding London median salary £45,000 £40,500 £42,000
% change year-on-year
+11.11% -3.57%

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 South East region.

Database & Business Intelligence Category
South East
Permanent IT job ads with a match in the
Database & Business Intelligence category
4350 6088 6310
As % of all permanent IT jobs located in the South East 29.31% 31.99% 30.28%
Number of salaries quoted 3729 5346 5496
Median salary £45,000 £45,000 £42,500
Median salary % change year-on-year
- +5.88%
90% offered a salary of more than £31,500 £32,500 £29,500
10% offered a salary of more than £65,000 £60,239 £62,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

PowerPivot
Jobs Demand Trend in the South East

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

PowerPivot Jobs Demand Trend in the South East

PowerPivot
Salary Trend in the South East

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

PowerPivot Salary Trend in the South East

PowerPivot
Salary Histogram in the South East

This chart provides a salary histogram for IT jobs citing PowerPivot across the South East region over the 3 months to 20 February 2017.

PowerPivot Salary Histogram in the South East

PowerPivot
Job Locations in the South East

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PowerPivot within the South East region over the 3 months to 20 February 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
Berkshire +45 6 £38,750 -48.33%
Surrey +39 1 £45,000 -
Kent +15 1 £32,500 +3.17%
Hampshire +10 1 £50,000 +66.66%
PowerPivot
England

PowerPivot
Top 30 Related IT Skills in the South East

For the 6 months to 20 February 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 South East region with a requirement for PowerPivot.

1 36 (92.31%) SQL
2 34 (87.18%) Business Intelligence
3 28 (71.79%) Analytics
4 27 (69.23%) Power BI
5 26 (66.67%) SQL Server Integration Services
6 25 (64.10%) SQL Server
7 23 (58.97%) MySQL
7 23 (58.97%) Cognos
8 22 (56.41%) SQL Server Reporting Services
9 21 (53.85%) SQL Server Analysis Services
10 20 (51.28%) Agile Software Development
11 19 (48.72%) Scrum
11 19 (48.72%) JIRA
11 19 (48.72%) T-SQL
11 19 (48.72%) Hadoop
12 17 (43.59%) Big Data
12 17 (43.59%) Data Warehouse
12 17 (43.59%) Management Information System
13 15 (38.46%) Microsoft
13 15 (38.46%) Apache Hive
13 15 (38.46%) Time Management
14 14 (35.90%) NoSQL
14 14 (35.90%) BusinessObjects
14 14 (35.90%) Data Modelling
15 13 (33.33%) OLAP
15 13 (33.33%) Python
16 12 (30.77%) ETL
16 12 (30.77%) Analytical Skills
17 11 (28.21%) OLTP
18 9 (23.08%) PL/SQL

PowerPivot
Top Related IT Skills in the South East 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 6 (15.38%) Apache Pig
2 1 (2.56%) SharePoint
Applications
1 1 (2.56%) MS Excel
1 1 (2.56%) Spreadsheet
Business Applications
1 2 (5.13%) Dynamics CRM
2 1 (2.56%) Dynamics AX
2 1 (2.56%) NetSuite
Cloud Services
1 9 (23.08%) GitHub
2 4 (10.26%) Amazon AWS
2 4 (10.26%) Google Analytics
Communications & Networking
1 4 (10.26%) MVNO
Database & Business Intelligence
1 27 (69.23%) Power BI
2 26 (66.67%) SQL Server Integration Services
3 25 (64.10%) SQL Server
4 23 (58.97%) MySQL
5 22 (56.41%) SQL Server Reporting Services
6 21 (53.85%) SQL Server Analysis Services
7 19 (48.72%) Hadoop
8 17 (43.59%) Big Data
8 17 (43.59%) Data Warehouse
9 15 (38.46%) Apache Hive
10 14 (35.90%) BusinessObjects
10 14 (35.90%) NoSQL
11 13 (33.33%) OLAP
12 11 (28.21%) OLTP
13 8 (20.51%) BusinessObjects XI
14 6 (15.38%) MongoDB
14 6 (15.38%) Oracle OLAP
15 5 (12.82%) Enterprise Data Warehouse
15 5 (12.82%) Relational Database
16 4 (10.26%) SQL Server 2014
Development Applications
1 19 (48.72%) JIRA
2 6 (15.38%) Talend Open Studio
3 1 (2.56%) Visual Studio
General
1 9 (23.08%) Finance
2 4 (10.26%) Marketing
2 4 (10.26%) Retail
2 4 (10.26%) Telecoms
3 3 (7.69%) Publishing
4 1 (2.56%) Financial Institution
Job Titles
1 22 (56.41%) Analyst
2 17 (43.59%) Developer
3 12 (30.77%) Report Analyst
4 9 (23.08%) NoSQL Developer
5 8 (20.51%) Business Intelligence Developer
5 8 (20.51%) SQL Developer
6 7 (17.95%) Big Data Developer
7 6 (15.38%) Data Analyst
7 6 (15.38%) SQL Analyst
7 6 (15.38%) SQL Data Analyst
7 6 (15.38%) SQL Server BI Developer
7 6 (15.38%) SQL Server Developer
8 5 (12.82%) MySQL Developer
8 5 (12.82%) SQL BI Developer
9 4 (10.26%) Excel Analyst
9 4 (10.26%) Insight Analyst
10 3 (7.69%) ETL Developer
10 3 (7.69%) Senior Business Intelligence Developer
10 3 (7.69%) Senior Developer
11 2 (5.13%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 6 (15.38%) .NET
2 5 (12.82%) ASP.NET
Miscellaneous
1 17 (43.59%) Management Information System
2 12 (30.77%) Analytical Skills
3 1 (2.56%) Fintech
Processes & Methodologies
1 34 (87.18%) Business Intelligence
2 28 (71.79%) Analytics
3 20 (51.28%) Agile Software Development
4 19 (48.72%) Scrum
5 15 (38.46%) Time Management
6 14 (35.90%) Data Modelling
7 12 (30.77%) ETL
8 9 (23.08%) Data Analysis
8 9 (23.08%) Kimball Methodology
8 9 (23.08%) MapReduce
9 8 (20.51%) Coaching
10 7 (17.95%) Dashboard Development
10 7 (17.95%) Mentoring
11 6 (15.38%) Migration
12 5 (12.82%) CRM
13 4 (10.26%) Big Data Analytics
13 4 (10.26%) Customer Analytics
13 4 (10.26%) Data Analytics
13 4 (10.26%) Dimensional Modelling
13 4 (10.26%) Project Management
Programming Languages
1 36 (92.31%) SQL
2 19 (48.72%) T-SQL
3 13 (33.33%) Python
4 9 (23.08%) PL/SQL
5 7 (17.95%) Data Analysis Expressions (DAX)
6 6 (15.38%) VBA
7 4 (10.26%) R
Qualifications
1 6 (15.38%) Degree
2 4 (10.26%) DBS Check
Quality Assurance & Compliance
1 8 (20.51%) Data Quality
Systems Management
1 9 (23.08%) Puppet
Vendors
1 23 (58.97%) Cognos
2 15 (38.46%) Microsoft
3 6 (15.38%) Oracle
3 6 (15.38%) Talend
4 4 (10.26%) Google
4 4 (10.26%) Tableau
4 4 (10.26%) Teradata
5 2 (5.13%) SAP
6 1 (2.56%) JD Edwards
6 1 (2.56%) MicroStrategy