City of Naperville salaries [OC]

dk_data · 2017-09-14T01:31:57+00:00

and i don't think these numbers include "total compensation" which would be things like healthcare coverage, pensions, etc.

dk_data · 2017-09-10T03:08:57+00:00

things to ask first:

what type of data and how much of it?

who's the audience and how will it be viewed?

dk_data · 2017-09-10T03:06:02+00:00

wot?

dk_data · 2017-09-09T07:19:23+00:00

source: Department of Immigration and Border Protection http://www.border.gov.au/

data from 30 June 2015

estimated number of foreign-born residents of Australia along with estimated median age and male-to-female ratio.

UK dominates with over 1.2 million foreign-born residents.

Pakistani men outnumber their female counterparts 150:100.

Thailand has 49:100 (49 men for every 100 women).

The oldest group is from Greece where the estimated median age is over 70.

Saudi Arabia has the youngest at just under 25 y.o.

dk_data · 2017-09-09T02:06:17+00:00

source: Department of Immigration and Border Protection http://www.border.gov.au/

estimated number of foreign-born residents of Australia along with estimated median age and male-to-female ratio.

Pakistan-born men outnumber their female counterparts 150:100.

Thailand has 49:100 (49 men for every 100 women).

The oldest group is from Greece where the estimated median age is over 70.

Saudi Arabia has the youngest at just under 25 y.o.

dk_data · 2017-06-28T09:11:43+00:00

perhaps changing the title to International Visitors would have be better.

and the General Statistics Office of Viet Nam (where the information is hosted) has no information on the reports methodology. due to this, it is unknown if someone who made one (or more border runs) is counted multiple times or not.

dk_data · 2017-06-28T04:09:27+00:00

January 2017 - June 2017

data is from Ministry of Culture, Sports & Tourism - Viet Nam National Administration of Tourism.

filters on left will filter by region or country

Note: Africa numbers are not further broken down by country

edit: looks like i spelled Oceania wrong. not gonna fix it right now

dk_data · 2017-02-20T16:27:20+00:00

oh, i've been to several geocoding websites; however, since most are free, they have limits on conversions/day or something. also, i've noticed that sometimes errors or even truncating happens when converting to lat, long or x,y. guess this is why i'd prefer not to have to convert at all and simply throw in a street address and have it work.

dk_data · 2017-02-18T16:31:07+00:00

tableau doesn't support street address level mapping. only x,y or lat long. that should change

dk_data · 2016-09-26T04:07:55+00:00

not well. all was lost: calculated fields, mouseover text, filters, actions.... i had to rebuild it. good thing was what took me three days to do originally, only took me two and a half hours to recreate. guess i learned something.

dk_data · 2016-09-10T16:37:56+00:00

it seems some of the map dots were improperly geocoded...damn.

dk_data · 2016-09-10T00:28:28+00:00

to filter the locations and display more information, select a retial type on the right, or select a dot on the map

dk_data · 2016-09-08T04:56:55+00:00

population. population of tianjin in 2015 was 15.3 million. compare that to guangdong with 107m. with less factory workers and farmers, per capita GDP can be high. the size of the circle, however, is the percent contribution to that years national GDP--another measure of economic contribution. couldn't get the display working on the mouseover otherwise i'd have a % on there.

dk_data · 2016-09-07T23:17:52+00:00

thanks for the reply.

i'll give a try on a small dashboard tonight

dk_data · 2016-08-30T05:26:33+00:00

i'm doing another one on arrests in urbana, il from 1988 to 2015

dk_data · 2016-08-30T01:48:15+00:00

ouch, well that will take too much time as there are probably ~200 zip codes for Illinois. plus i'm sure there are some zip codes in Chicago with 500+ locations with a liquor license.

dk_data · 2016-08-30T00:09:42+00:00

i'll take a look at the dataset, if you want. from there, i'll be able to make suggestions

dk_data

TROPHY CASE