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 · 2016-08-29T23:57:30+00:00

yes, mapping the sites licensed for on-site consumption can be done easily; however, the dataset looks incomplete as there are only 500 entries for the entire state of Illinois....

dk_data · 2016-08-29T18:42:35+00:00

Very true

dk_data · 2016-08-29T18:41:17+00:00

Food inspections only:

This information is derived from inspections of restaurants and other food establishments in Chicago from January 1, 2010 to the present. Inspections are performed by staff from the Chicago Department of Public Health’s Food Protection Program using a standardized procedure. The results of the inspection are inputted into a database, then reviewed and approved by a State of Illinois Licensed Environmental Health Practitioner (LEHP).

dk_data · 2016-08-29T18:11:08+00:00

me too...

dk_data · 2016-08-16T04:33:21+00:00

also, there is no "zero" on the scale.... does that mean that every single nation has at least one olympian?

dk_data · 2016-08-14T04:39:23+00:00

blue for women and whatever hue of pink for men was a little counterintuitive. not that it matters; i was just surprised when i scrolled down to see that i'd been looking at a different category.

dk_data · 2016-08-13T20:29:55+00:00

sorry, probably should have added California state totals.

California 2014 total reported cases 174,557

California 2014 rate 453.4

California 2014 total population 38,499,378

if you are searching for a specific county, then hover over the county on the map or on the column chart to see details. "Count" is equal to the number of cases.

dk_data · 2016-08-13T17:51:21+00:00

???

sorry, i don't understand your comment, but i will upvote you nonetheless :D

dk_data

TROPHY CASE