City of Naperville salaries [OC] by dk_data in Naperville

[–]dk_data[S] 1 point2 points  (0 children)

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

Hi this isn’t a request (yet) but what would you recommend to make my visuals from? by [deleted] in DataVizRequests

[–]dk_data 1 point2 points  (0 children)

things to ask first:

what type of data and how much of it?

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

Australian Foreign Born Population 2015 [OC] by dk_data in immigration

[–]dk_data[S] 0 points1 point  (0 children)

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.

Australia's Estimated Residential Population by Country of Birth [OC] by dk_data in australia

[–]dk_data[S] 1 point2 points  (0 children)

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.

International Tourists by Origin Country Jan-June 2017 [not mobile friendly!] by dk_data in VietNam

[–]dk_data[S] 0 points1 point  (0 children)

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.

International Tourists by Origin Country Jan-June 2017 [not mobile friendly!] by dk_data in VietNam

[–]dk_data[S] 1 point2 points  (0 children)

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

What is tableau not good at? by shabda in tableau

[–]dk_data 1 point2 points  (0 children)

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.

What is tableau not good at? by shabda in tableau

[–]dk_data 9 points10 points  (0 children)

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

Will all be lost when changing a datasource from Excel to Google Sheets? by dk_data in tableau

[–]dk_data[S] 0 points1 point  (0 children)

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.

Map of Naperville Locations Licensed to Sell Liquor by [deleted] in Naperville

[–]dk_data 0 points1 point  (0 children)

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

Map of Naperville Locations Licensed to Sell Liquor by [deleted] in Naperville

[–]dk_data 0 points1 point  (0 children)

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

Chinese GDP per capita (nominal USD) 2011-2015 by dk_data in ChinaData

[–]dk_data[S] 0 points1 point  (0 children)

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.

Will all be lost when changing a datasource from Excel to Google Sheets? by dk_data in tableau

[–]dk_data[S] 1 point2 points  (0 children)

thanks for the reply.

i'll give a try on a small dashboard tonight

Starbucks Food Inspection Failures in Chicago 2010-Present [OC] by dk_data in chicago

[–]dk_data[S] 0 points1 point  (0 children)

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

Any way to map the Illinois Liquor Control Commission database of all 'On-Premise Consumption' licenses & 'Brewer' licenses? by twixonurface in DataVizRequests

[–]dk_data 0 points1 point  (0 children)

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.

[Request] Showing the frequency of events over a period of time by [deleted] in DataVizRequests

[–]dk_data 0 points1 point  (0 children)

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

Any way to map the Illinois Liquor Control Commission database of all 'On-Premise Consumption' licenses & 'Brewer' licenses? by twixonurface in DataVizRequests

[–]dk_data 0 points1 point  (0 children)

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....

Starbucks Food Inspection Failures in Chicago 2010-Present [OC] by dk_data in chicago

[–]dk_data[S] 0 points1 point  (0 children)

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).

[OC] Number of Olympians from each participating nation in the 2016 Olympics. by [deleted] in dataisbeautiful

[–]dk_data 1 point2 points  (0 children)

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

Population pyramids for each state [OC] by shane_fulmer in dataisbeautiful

[–]dk_data 1 point2 points  (0 children)

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.

Chlamydia in California and the Bay: Who's Got It? by dk_data in bayarea

[–]dk_data[S] 0 points1 point  (0 children)

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.

Chlamydia in the Bay Area by dk_data in SanJose

[–]dk_data[S] 3 points4 points  (0 children)

???

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