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

Data Analysis Expressions (DAX)
UK
6 months to
20 Apr 2018
Same period 2017 Same period 2016
Rank 983 947 1167
Rank change year-on-year -36 +220 +84
Permanent jobs citing Data Analysis Expressions (DAX) 220 224 121
As % of all permanent IT jobs advertised in the UK 0.12% 0.13% 0.059%
As % of the Programming Languages category 0.22% 0.24% 0.11%
Number of salaries quoted 174 202 99
UK median annual salary £55,000 £57,500 £55,000
Median salary % change year-on-year -4.35% +4.55% +15.79%
10th Percentile £34,500 £41,250 £42,250
90th Percentile £76,250 £75,000 £77,500
UK excluding London median annual salary £42,000 £45,000 £50,000
% change year-on-year -6.67% -10.00% +42.86%

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 99,559 94,181 106,355
As % of all permanent IT jobs advertised in the UK 56.09% 54.58% 51.97%
Number of salaries quoted 83,684 80,447 91,813
UK median annual salary £50,000 £47,500 £46,000
Median salary % change year-on-year +5.26% +3.26% +2.22%
10th Percentile £30,000 £28,750 £28,000
90th Percentile £78,750 £76,250 £75,000
UK excluding London median annual salary £44,000 £42,500 £40,000
% change year-on-year +3.53% +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 20 April 2018.

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

Data Analysis Expressions (DAX)
Top 12 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 20 April 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 -11 219 £55,000 -4.35% 22
London -57 142 £62,500 - 13
UK excluding London +5 60 £42,000 -6.67% 11
East of England +11 16 £34,000 +4.62%
Midlands +3 15 £44,250 +3.51% 1
South East -3 14 £30,750 -44.09% 3
East Midlands +8 12 £45,000 -5.26%
North of England +7 10 £43,750 +2.94% 5
North West -4 10 £43,750 +2.94% 3
South West - 4 £42,500 -
West Midlands -10 3 £36,250 -9.38% 1
Scotland - 1 - - 2

For the 6 months to 20 April 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 216 (98.18%) Business Intelligence
2 204 (92.73%) Power BI
3 184 (83.64%) SQL Server Integration Services
4 181 (82.27%) SQL Server Reporting Services
5 180 (81.82%) SQL Server Analysis Services
6 170 (77.27%) SQL
7 157 (71.36%) Microsoft
8 155 (70.45%) SQL Server
9 128 (58.18%) Data Warehouse
10 117 (53.18%) Advertising
11 110 (50.00%) ETL
12 104 (47.27%) Microsoft Azure
13 102 (46.36%) T-SQL
14 88 (40.00%) Visualisation
15 84 (38.18%) Analytics
16 66 (30.00%) Data Visualisation
17 65 (29.55%) Tableau
18 59 (26.82%) MDX
19 54 (24.55%) QlikView
20 52 (23.64%) Data Lake
21 51 (23.18%) Azure SQL Data Warehouse
22 46 (20.91%) Data Science
23 44 (20.00%) Data Modelling
24 43 (19.55%) Big Data
24 43 (19.55%) Azure Data Factory
25 39 (17.73%) PowerPivot
25 39 (17.73%) Kimball Methodology
26 38 (17.27%) Microsoft Excel
27 34 (15.45%) Finance
28 33 (15.00%) Azure SQL Database

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 5 (2.27%) SharePoint
2 4 (1.82%) Apache Spark
3 3 (1.36%) SAS
Applications
1 38 (17.27%) Microsoft Excel
2 4 (1.82%) Spreadsheet
Business Applications
1 5 (2.27%) Salesforce.com CRM
Cloud Services
1 104 (47.27%) Microsoft Azure
2 43 (19.55%) Azure Data Factory
3 20 (9.09%) PaaS
4 19 (8.64%) Azure Machine Learning
5 3 (1.36%) Dynamics 365
5 3 (1.36%) IaaS
6 2 (0.91%) Google Analytics
7 1 (0.45%) Google Cloud Platform
7 1 (0.45%) SaaS
Database & Business Intelligence
1 204 (92.73%) Power BI
2 184 (83.64%) SQL Server Integration Services
3 181 (82.27%) SQL Server Reporting Services
4 180 (81.82%) SQL Server Analysis Services
5 155 (70.45%) SQL Server
6 128 (58.18%) Data Warehouse
7 54 (24.55%) QlikView
8 52 (23.64%) Data Lake
9 51 (23.18%) Azure SQL Data Warehouse
10 43 (19.55%) Big Data
11 39 (17.73%) PowerPivot
12 33 (15.00%) Azure SQL Database
13 17 (7.73%) Microsoft Analysis Services
13 17 (7.73%) OLAP
14 16 (7.27%) Star Schema
15 15 (6.82%) Snowflake Schema
16 13 (5.91%) Hadoop
16 13 (5.91%) SQL Server 2008
16 13 (5.91%) SQL Server 2012
16 13 (5.91%) SQL Server 2016
Development Applications
1 17 (7.73%) SQL Server Management Studio (SSMS)
2 7 (3.18%) Team Foundation Server
3 6 (2.73%) Visual Studio
4 4 (1.82%) Visual Studio Team System
5 2 (0.91%) JIRA
6 1 (0.45%) Git (software)
6 1 (0.45%) Octopus Deploy
General
1 117 (53.18%) Advertising
2 34 (15.45%) Finance
3 15 (6.82%) Games
4 13 (5.91%) Marketing
5 8 (3.64%) Retail
6 3 (1.36%) Banking
7 2 (0.91%) Investment Banking
7 2 (0.91%) Legal
8 1 (0.45%) Front Office
Job Titles
1 99 (45.00%) Developer
2 81 (36.82%) Business Intelligence Developer
3 80 (36.36%) Consultant
4 44 (20.00%) Azure Consultant
5 42 (19.09%) Business Intelligence Consultant
6 40 (18.18%) Data Consultant
7 35 (15.91%) SQL Developer
8 28 (12.73%) SQL BI Developer
9 26 (11.82%) Analyst
9 26 (11.82%) Power BI Consultant
9 26 (11.82%) SSAS Developer
10 25 (11.36%) SSIS Developer
11 24 (10.91%) Power BI Developer
12 23 (10.45%) Business Intelligence Analyst
13 19 (8.64%) Data Warehouse Consultant
14 18 (8.18%) SSRS Developer
15 17 (7.73%) Business Developer
15 17 (7.73%) T-SQL Developer
16 15 (6.82%) Senior Developer
17 14 (6.36%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 59 (26.82%) MDX
2 22 (10.00%) .NET
3 5 (2.27%) ASP.NET
3 5 (2.27%) Kafka
4 4 (1.82%) XML
5 2 (0.91%) JSON
6 1 (0.45%) ASP.NET MVC
6 1 (0.45%) D3.js
Miscellaneous
1 17 (7.73%) Analytical Skills
2 12 (5.45%) Greenfield Project
3 10 (4.55%) Enterprise Software
4 6 (2.73%) Computer Science
5 5 (2.27%) NHS
6 3 (1.36%) Driving Licence
6 3 (1.36%) iPhone
7 2 (0.91%) Equities
7 2 (0.91%) Fixed Income
7 2 (0.91%) FMCG
7 2 (0.91%) Hedge funds
8 1 (0.45%) Clustering
8 1 (0.45%) Data Structures
8 1 (0.45%) Fintech
8 1 (0.45%) Management Information System
8 1 (0.45%) Social Media
8 1 (0.45%) User Experience
Processes & Methodologies
1 216 (98.18%) Business Intelligence
2 110 (50.00%) ETL
3 88 (40.00%) Visualisation
4 84 (38.18%) Analytics
5 66 (30.00%) Data Visualisation
6 46 (20.91%) Data Science
7 44 (20.00%) Data Modelling
8 39 (17.73%) Kimball Methodology
9 32 (14.55%) Agile Software Development
10 28 (12.73%) Machine Learning
11 25 (11.36%) Data Analytics
12 17 (7.73%) Dimensional Modelling
12 17 (7.73%) Predictive Analytics
13 16 (7.27%) CRM
14 14 (6.36%) Business Analysis
15 13 (5.91%) Scrum
16 11 (5.00%) Data Integration
16 11 (5.00%) Migration
17 10 (4.55%) Inmon Methodology
18 9 (4.09%) Decision-Making
Programming Languages
1 170 (77.27%) SQL
2 102 (46.36%) T-SQL
3 23 (10.45%) C#
4 10 (4.55%) PowerShell
4 10 (4.55%) Python
5 8 (3.64%) R
6 7 (3.18%) VB.NET
6 7 (3.18%) VBA
7 4 (1.82%) MATLAB
8 1 (0.45%) JavaScript
8 1 (0.45%) PL/SQL
Qualifications
1 9 (4.09%) Security Cleared
2 8 (3.64%) Degree
2 8 (3.64%) Microsoft Certification
3 7 (3.18%) MCSE
4 5 (2.27%) SC Cleared
5 1 (0.45%) Computer Science Degree
5 1 (0.45%) MCP
5 1 (0.45%) MCSA
5 1 (0.45%) Numerate Degree
Quality Assurance & Compliance
1 8 (3.64%) GDPR
2 3 (1.36%) Data Quality
3 2 (0.91%) QA
Systems Management
1 1 (0.45%) Control-M
1 1 (0.45%) Failover Clustering
1 1 (0.45%) Opscode Chef
1 1 (0.45%) Puppet
1 1 (0.45%) Systems Management Server (SMS)
Vendors
1 157 (71.36%) Microsoft
2 65 (29.55%) Tableau
3 16 (7.27%) Oracle
4 6 (2.73%) Google
5 5 (2.27%) Salesforce.com
6 4 (1.82%) Alteryx
6 4 (1.82%) MicroStrategy
7 3 (1.36%) Twitter
8 2 (0.91%) Cognos
9 1 (0.45%) RedGate