<commit_before>---
layout:     post
title:      Over-Represented Jobs
date:       2014-12-16 12:31:20
summary:    It turns out Cork City is the real Irish capital of customer service.
categories: tableau
---

<head>
  <style>
  .tableau-container { 
    margin-top: 0.5rem;
    margin-bottom: 0rem;
  }
  </style>
</head>

### Which Jobs are over-represented in different parts of Ireland?

##### What is being investigated?

Using Census 2011 data, the aim was to see which occupations were most over-represented in the counties and cities of Ireland. _Are some areas over-reliant on certain types of jobs?_

##### How is this measured?

Take the example of Cork City and the occupation of 'Customer Service'. For the whole of Ireland there are 22,833 Customer Service jobs out of a total 2,232,203 jobs. So people working in this sector account for about _102 jobs out of every 10,000 nationwide_.

In Cork City there are 1,656 Customer Service jobs out of a total 55,328 jobs, which equates to _299 in every 10,000 jobs_.

The ratio between these two measures is the 'Location Quotient'. So for Cork City the measure for Customer Service jobs is 299 divided by 102, giving 2.9.

### Results

##### Top 5

 Below are the areas with the most over-represented occupations. __Cork City tops the table with 2.9 times as many Customer Service employees compared to the national average__ (per 10,000 jobs).

- 2.9 - Cork City __+__ Customer Service
- 2.4 - <NAME> __+__ Business, media and public service professionals
- 2.3 - Mayo __+__ Skilled agricultural and related trades
- 2.2 - Laois __+__ Protective service occupations
- 2.2 - Cavan __+__ Skilled agricultural and related trades

##### by County/City

The map below shows the most over-represented occupations in each County/City. The bigger the dot the greater the over-representation. (The chart is interactive but if you pinch or zoom into a dead end just refresh the webpage.)

<div class="tableau-container">
	<iframe
	  style="border: 0px;"
	  src="https://public.tableausoftware.com/views/OverRepresentedOccupationsinIreland/Blog_Post?%3AshowVizHome=no#3"
	  scrolling="no"
	  width="445px" height="560px">
	</iframe>
</div>

(_Done with [Tableau software](http://www.tableausoftware.com/public/about-tableau-products)._)

---

##### ...and what about the most common jobs?

Nothing hugely insightful here... of the 34 county and city areas the top three are 'Other/not stated' (20), 'Administrative occupations' (10), and 'Skilled Agriculture & related trades (3).

Most surprising is the result for Dún Laoghaire-Rathdown. Here the most common occupation is 'Corporate Managers and Directors'. 

---

Much of the above was originally presented entirely in Tableau Public [here](http://public.tableausoftware.com/shared/NZYBYF4QT?:display_count=no). Data and details can be found under the '__i__' at the bottom of the page.<commit_msg>Semicolon to be removed<commit_after>---
layout:     post
title:      Over-Represented Jobs
date:       2014-12-16 12:31:20
summary:    It turns out Cork City is the real Irish capital of customer service.
categories: tableau
---

<head>
  <style>
  .tableau-container { 
    margin-top: 0.5rem;
    margin-bottom: 0rem
  }
  </style>
</head>

### Which Jobs are over-represented in different parts of Ireland?

##### What is being investigated?

Using Census 2011 data, the aim was to see which occupations were most over-represented in the counties and cities of Ireland. _Are some areas over-reliant on certain types of jobs?_

##### How is this measured?

Take the example of Cork City and the occupation of 'Customer Service'. For the whole of Ireland there are 22,833 Customer Service jobs out of a total 2,232,203 jobs. So people working in this sector account for about _102 jobs out of every 10,000 nationwide_.

In Cork City there are 1,656 Customer Service jobs out of a total 55,328 jobs, which equates to _299 in every 10,000 jobs_.

The ratio between these two measures is the 'Location Quotient'. So for Cork City the measure for Customer Service jobs is 299 divided by 102, giving 2.9.

### Results

##### Top 5

 Below are the areas with the most over-represented occupations. __Cork City tops the table with 2.9 times as many Customer Service employees compared to the national average__ (per 10,000 jobs).

- 2.9 - Cork City __+__ Customer Service
- 2.4 - <NAME> __+__ Business, media and public service professionals
- 2.3 - Mayo __+__ Skilled agricultural and related trades
- 2.2 - Laois __+__ Protective service occupations
- 2.2 - Cavan __+__ Skilled agricultural and related trades

##### by County/City

The map below shows the most over-represented occupations in each County/City. The bigger the dot the greater the over-representation. (The chart is interactive but if you pinch or zoom into a dead end just refresh the webpage.)

<div class="tableau-container">
	<iframe
	  style="border: 0px;"
	  src="https://public.tableausoftware.com/views/OverRepresentedOccupationsinIreland/Blog_Post?%3AshowVizHome=no#3"
	  scrolling="no"
	  width="445px" height="560px">
	</iframe>
</div>

(_Done with [Tableau software](http://www.tableausoftware.com/public/about-tableau-products)._)

---

##### ...and what about the most common jobs?

Nothing hugely insightful here... of the 34 county and city areas the top three are 'Other/not stated' (20), 'Administrative occupations' (10), and 'Skilled Agriculture & related trades (3).

Most surprising is the result for Dún Laoghaire-Rathdown. Here the most common occupation is 'Corporate Managers and Directors'. 

---

Much of the above was originally presented entirely in Tableau Public [here](http://public.tableausoftware.com/shared/NZYBYF4QT?:display_count=no). Data and details can be found under the '__i__' at the bottom of the page.
{'fraction_non_alphanumeric': 0.0862157976251936, 'fraction_numerical': 0.034761658922732745, 'mean_word_length': 4.062717770034843, 'pattern_counts': {'":': 0, '<': 21, '<?xml version=': 0, '>': 21, 'https://': 2, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5740', 'n_tokens_mistral': 1842, 'n_tokens_neox': 1590, 'n_words': 750}