Period
to 23 January 2018

The following table provides summary statistics for permanent job vacancies with a requirement for Data Analysis Expressions (DAX) skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Analysis Expressions (DAX) over the 6 months to 23 January 2018 with a comparison to the same period in the previous 2 years.

Data Analysis Expressions (DAX)
UK
6 months to
23 Jan 2018
Same period 2017 Same period 2016
Rank 1047 998 1154
Rank change year-on-year -49 +156 +118
Permanent jobs citing Data Analysis Expressions (DAX) 129 195 105
As % of all permanent IT jobs advertised in the UK 0.074% 0.11% 0.051%
As % of the Programming Languages category 0.13% 0.21% 0.097%
Number of salaries quoted 100 188 84
UK median annual salary £57,500 £60,000 £57,500
Median salary % change year-on-year -4.17% +4.35% -4.17%
10th Percentile £38,575 £42,500 £42,500
90th Percentile £76,250 £92,500 £87,500
UK excluding London median annual salary £42,000 £47,500 £55,000
% change year-on-year -11.58% -13.64% -8.33%

Data Analysis Expressions (DAX) is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for coding skills.

All Programming Languages
UK
Permanent vacancies with a requirement for coding skills 96,975 93,595 107,770
As % of all permanent IT jobs advertised in the UK 55.55% 53.22% 52.01%
Number of salaries quoted 81,011 80,394 92,634
UK median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £29,750 £28,750 £27,750
90th Percentile £77,500 £76,250 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

Data Analysis Expressions (DAX)
Job Vacancy Trend

Job postings citing Data Analysis Expressions (DAX) as a percentage of all IT jobs advertised.

Job vacancy trend for Data Analysis Expressions (DAX) in the UK

Data Analysis Expressions (DAX)
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Analysis Expressions (DAX).

Salary trend for Data Analysis Expressions (DAX) in the UK

Data Analysis Expressions (DAX)
Salary Histogram

The salary distribution of IT jobs citing Data Analysis Expressions (DAX) over the 6 months to 23 January 2018.

Salary histogram for Data Analysis Expressions (DAX) in the UK

Data Analysis Expressions (DAX)
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Analysis Expressions (DAX) within the UK over the 6 months to 23 January 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -66 128 £57,500 -4.17% 27
London -73 86 £60,000 -4.00% 19
UK excluding London -16 35 £42,000 -11.58% 9
South East +6 22 £42,500 -22.73% 2
North of England -14 5 £31,000 -31.11% 1
Midlands +17 3 £41,500 -4.60% 4
East of England +12 2 £51,250 +13.89%
Yorkshire -4 2 £34,250 -23.89% 1
North West -5 2 £31,250 -30.56%
East Midlands - 2 £44,000 - 4
South West - 2 £42,500 -
West Midlands -9 1 £41,500 -4.60%
Scotland - 1 £57,500 - 2
North East - 1 £31,000 -

For the 6 months to 23 January 2018, IT jobs citing Data Analysis Expressions (DAX) also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for Data Analysis Expressions (DAX).

1 121 (93.80%) Business Intelligence
2 119 (92.25%) SQL
3 114 (88.37%) SQL Server Reporting Services
4 104 (80.62%) SQL Server Integration Services
5 100 (77.52%) SQL Server Analysis Services
6 97 (75.19%) Power BI
7 90 (69.77%) SQL Server
8 87 (67.44%) T-SQL
9 85 (65.89%) Data Warehouse
10 72 (55.81%) ETL
11 67 (51.94%) Microsoft
12 59 (45.74%) MDX
13 52 (40.31%) Tableau
14 41 (31.78%) Microsoft Azure
15 40 (31.01%) QlikView
15 40 (31.01%) Data Modelling
16 39 (30.23%) Finance
17 38 (29.46%) Visualisation
18 37 (28.68%) Kimball Methodology
19 36 (27.91%) Agile Software Development
20 34 (26.36%) Analytics
21 33 (25.58%) Data Visualisation
22 32 (24.81%) Advertising
23 31 (24.03%) Microsoft Excel
24 27 (20.93%) PowerPivot
24 27 (20.93%) C#
25 26 (20.16%) Big Data
26 24 (18.60%) OLAP
27 22 (17.05%) Data Management
28 21 (16.28%) PowerShell

Data Analysis Expressions (DAX)
Co-occurring IT Skills 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 7 (5.43%) SharePoint
2 1 (0.78%) WebSphere
Applications
1 31 (24.03%) Microsoft Excel
2 1 (0.78%) MS Visio
Business Applications
1 5 (3.88%) Salesforce.com CRM
Cloud Services
1 41 (31.78%) Microsoft Azure
2 6 (4.65%) Amazon AWS
3 5 (3.88%) Azure Data Factory
4 1 (0.78%) PaaS
4 1 (0.78%) SaaS
Communications & Networking
1 6 (4.65%) Internet
2 2 (1.55%) Kerberos
Database & Business Intelligence
1 114 (88.37%) SQL Server Reporting Services
2 104 (80.62%) SQL Server Integration Services
3 100 (77.52%) SQL Server Analysis Services
4 97 (75.19%) Power BI
5 90 (69.77%) SQL Server
6 85 (65.89%) Data Warehouse
7 40 (31.01%) QlikView
8 27 (20.93%) PowerPivot
9 26 (20.16%) Big Data
10 24 (18.60%) OLAP
11 20 (15.50%) SQL Server 2008
12 18 (13.95%) SQL Server 2016
13 16 (12.40%) Data Lake
13 16 (12.40%) Hadoop
14 14 (10.85%) Relational Database
15 13 (10.08%) Azure SQL Data Warehouse
15 13 (10.08%) SQL Server 2012
16 11 (8.53%) SQL Server 2014
17 8 (6.20%) Biml
18 7 (5.43%) Enterprise Data Warehouse
Development Applications
1 14 (10.85%) Team Foundation Server
2 6 (4.65%) JIRA
2 6 (4.65%) SQL Server Management Studio (SSMS)
3 4 (3.10%) Octopus Deploy
3 4 (3.10%) Visual Studio
4 1 (0.78%) TeamCity
General
1 39 (30.23%) Finance
2 32 (24.81%) Advertising
3 13 (10.08%) Marketing
4 7 (5.43%) Retail
5 6 (4.65%) Back Office
5 6 (4.65%) Banking
6 4 (3.10%) Investment Banking
7 3 (2.33%) Legal
8 1 (0.78%) Financial Institution
Job Titles
1 77 (59.69%) Developer
2 51 (39.53%) Business Intelligence Developer
3 50 (38.76%) SQL Developer
4 33 (25.58%) SSIS Developer
5 29 (22.48%) SQL BI Developer
5 29 (22.48%) SSAS Developer
6 27 (20.93%) SSRS Developer
7 22 (17.05%) T-SQL Developer
8 21 (16.28%) Power BI Developer
9 18 (13.95%) Architect
10 17 (13.18%) ETL Developer
11 16 (12.40%) Consultant
12 15 (11.63%) Agile Developer
12 15 (11.63%) Data Architect
13 13 (10.08%) Business Intelligence Consultant
14 11 (8.53%) DBA
14 11 (8.53%) SQL DBA
15 9 (6.98%) Database Developer
15 9 (6.98%) Senior Business Intelligence Developer
15 9 (6.98%) Senior Developer
Libraries, Frameworks & Software Standards
1 59 (45.74%) MDX
2 21 (16.28%) .NET
3 5 (3.88%) JSON
3 5 (3.88%) XML
4 1 (0.78%) ASP.NET
4 1 (0.78%) ASP.NET MVC
4 1 (0.78%) CSS
4 1 (0.78%) HTML
4 1 (0.78%) RESTful
4 1 (0.78%) Web Services
Miscellaneous
1 12 (9.30%) Analytical Skills
1 12 (9.30%) Enterprise Software
2 7 (5.43%) iPhone
3 6 (4.65%) NHS
4 5 (3.88%) Computer Science
5 3 (2.33%) Driving Licence
6 2 (1.55%) Management Information System
7 1 (0.78%) Clustering
7 1 (0.78%) Data Structures
Processes & Methodologies
1 121 (93.80%) Business Intelligence
2 72 (55.81%) ETL
3 40 (31.01%) Data Modelling
4 38 (29.46%) Visualisation
5 37 (28.68%) Kimball Methodology
6 36 (27.91%) Agile Software Development
7 34 (26.36%) Analytics
8 33 (25.58%) Data Visualisation
9 22 (17.05%) Data Management
10 21 (16.28%) CRM
11 16 (12.40%) Business Analysis
12 15 (11.63%) Inmon Methodology
12 15 (11.63%) Performance Tuning
13 14 (10.85%) Data Integration
13 14 (10.85%) Migration
13 14 (10.85%) UML
14 13 (10.08%) Enterprise Architecture
14 13 (10.08%) Requirements Analysis
14 13 (10.08%) Wealth Management
15 12 (9.30%) Data Architecture
Programming Languages
1 119 (92.25%) SQL
2 87 (67.44%) T-SQL
3 27 (20.93%) C#
4 21 (16.28%) PowerShell
5 7 (5.43%) R
6 6 (4.65%) Python
7 3 (2.33%) VB.NET
8 1 (0.78%) JavaScript
Qualifications
1 14 (10.85%) Degree
2 5 (3.88%) MCSE
2 5 (3.88%) Microsoft Certification
3 4 (3.10%) MCITP
4 1 (0.78%) Computer Science Degree
4 1 (0.78%) MCP
4 1 (0.78%) MCSA
4 1 (0.78%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 6 (4.65%) Data Quality
2 1 (0.78%) Cyber Essentials
2 1 (0.78%) GDPR
2 1 (0.78%) ISO/IEC 27001
2 1 (0.78%) QA
System Software
1 2 (1.55%) Active Directory
Systems Management
1 1 (0.78%) Failover Clustering
1 1 (0.78%) Systems Management Server (SMS)
Vendors
1 67 (51.94%) Microsoft
2 52 (40.31%) Tableau
3 11 (8.53%) RedGate
4 9 (6.98%) MicroStrategy
5 5 (3.88%) Salesforce.com
6 3 (2.33%) Google
6 3 (2.33%) Twitter
7 1 (0.78%) Cognos
7 1 (0.78%) IBM
7 1 (0.78%) Logi
7 1 (0.78%) Logi Analytics
7 1 (0.78%) Nintex
7 1 (0.78%) Oracle
7 1 (0.78%) SAP