[Topic][Open] Open Discussion Thread — Anybody can post a general visualization question or start a fresh discussion!

Submitted by AutoModerator t3_z9n9d5 in dataisbeautiful

Anybody can post a question related to data visualization or discussion in the monthly topical threads. Meta questions are fine too, but if you want a more direct line to the mods, click here

If you have a general question you need answered, or a discussion you'd like to start, feel free to make a top-level comment.

Beginners are encouraged to ask basic questions, so please be patient responding to people who might not know as much as yourself.

To view all Open Discussion threads, click here.

To view all topical threads, click here.

Want to suggest a topic? Click here.

45

Comments

You must log in or register to comment.

myownmoses t1_iysd9jc wrote

Question: Where are good places to find raw data?

I am a high school math teacher in Michigan teaching my first stats class. I'd like to do more authentic assignments where students are working with real sets of data answering questions about the real world. Doing our own gathering was cool, but we are in a very small alternative school so we end up with small data sets which just isn't as cool for doing some types of visualizations, etc. If there is another subreddit altogether for something like this, I'd love recommendations there too. Thank you!

6

OfficialWireGrind t1_j0ibb3p wrote

data.gov is another source. There's also /r/datasets/, which might be a good place to ask this.

For me, sourcing raw data is actually part of the problem, and finding it can involve some amount of creativity. A lot of it is hiding in plain sight, but it has to realized as such.

2

myownmoses t1_j0pp48r wrote

Oh I had no idea about r/datasets. Thank you!

1

fudgefive t1_iyln0kf wrote

I need some help! I have a dataset of criteria for multiple options that I'm trying to make a decision between, and I want to do so by creating a visual representation of the data, what would be some good ways of doing so? :)

any suggestions would be very helpful, thanks!

2

leprachaun77 t1_iywc842 wrote

Does anyone have a recommendation for a Data Visualization course to take online?

2

kerver2 t1_izawz67 wrote

I've hear some good things about the Google Analytics course (hosted on Coursera). I myself have done a Power BI Course through my company but there is also a free one to follow online on learn.microsoft for Power BI training. I must say that the visualisation is the flashiest but easiest part, gathering, cleaning and thinking of how to present data is the hard part!

4

codywi t1_izx85xe wrote

What tool do you use to track daily habits for data visualization? I want to track things like mood, hours of sleep, etc

2

HoldMyDirrk t1_izyy3g3 wrote

I have a solution that's totally SMS based, so not another app and you don't have to remember to log your behavior because it will ask you. I'm toying with the idea of selling it but for now I'm looking for more beta users.

If you're interested in using it just send me a DM and I'll hook you up.

3

Fokoladenkekfe t1_iyilakh wrote

What’s the nicest visual for a decision tree you’ve ever seen?

1

Klumber t1_iylszvs wrote

Right, this is a question that has been driving me nuts... What is this sort of chart called and how can I make one to visualise the time me and my team spend on different areas?

https://www.reddit.com/r/dataisbeautiful/comments/z8mt96/oc_ryanair_is_known_for_its_absurdly_cheap_fares/

What I would like to do is have a centre point with the total available weekly hours of the team, the individual team members on the left and the tasks we carry out on the right... I've got the data, I just don't have a tool to make this sort of chart (I think!) nor the knowledge of the name, so I can't Google it either! Any help more than welcome.

1

C4PT41N_N4PK1NS t1_iyssgo3 wrote

What is the name of a chart with the days of the month/week and colors from less saturated to more saturated

1

kerver2 t1_izauevy wrote

Do you mean like a heatmap? like a table heatmap?

1

oceanblue12345 t1_iyzb4c6 wrote

What software do you typically use for data visualisation? I’ve been using R to make a multi-panel figure containing a series of line graphs but was wondering if there was an easier way?

1

kerver2 t1_izatzgj wrote

I use Power Bi and Excel's Power Pivot (because my company just looooves Excel). Power Bi is definitely more business oriented and more meant for interactive dashboards. But I just love the graphical interface of it. I am a programmer as well but just hitting buttons is so much easier when visualizing stuff. I think Python and R are definetely more powerful, versatile and customizable. But the ease of use of Power BI (and even Excel) as a visualisation tool are a big plus for me.

1

oceanblue12345 t1_izdc3dm wrote

Thanks for the detailed reply! I need my figures to be publication quality for a scientific journal so I find excel doesn’t really meet that standard. I’m not familiar with Power Bi but will take a look!

1

kerver2 t1_izddged wrote

I have recently posted a visualisation made with Power BI if you want to take a look. I think the standard look of power BI charts is not suited for scientific publications, but you can have a look nonetheless. It might be customizable enough.

1

EllaGlasheen331 t1_iyzjo6z wrote

Does anyone mind sharing how they got into data and why they are still doing data? I need some motivation

1

CulturedFiring t1_iz0646b wrote

I need tips on how to get good paying data jobs please

1

BurnerAccountNo2 t1_izcjzsh wrote

I’ve been looking to find good data on housing. For example, for a given city, how much has the population, income (household and individual), housing supply, housing prices, interest rates, etc changed in the last few years.

It would be cool to see what companies have been buying residential properties too so I can get a good picture of what the housing outlook will be like.

Housing has been my biggest financial burden in the last few years. I hope to be able to work on this some day, but I don’t have much time or experience in data analytics. I’m not sure what conclusions I could draw without oversimplifying things. I truly don’t believe inflation is entirely, or even a large reason for the cost of living. If any reputable websites have put this together, it would be nice to see.

1

fail_whale_fan_mail t1_j1gi9c4 wrote

Housing affordability is a huge topic, so there's a lot of it there on this. Since, you didn't say what country you're interested in, I'm going to go ahead and assume the U.S., because that's what I know. I imagine many of these sources have correlaries in other countries though.

Many of the variables you listed are available through the U.S. Census Bureau's American Community Survey (population, income, housing prices, rent burden).

I'm less familiar with it, but FRED Economic Data may be able to give you more information on the interest rate side.

Housing supply and construction can be trickier to get at. A lot of places track new construction but it's often behind a paywall -- and this is often tracked by real estate professionals so there's sometimes some bias built in. The Census Bureau has a report on New Residential construction, but I haven't found it overwhelming accurate when you get down to the smaller geographies. If you have a specific place you're interested in, you may be able to get information on total residential buildings/units from the local assessor's (sometimes auditors) office. Building permits are often used as a proxy for new housing construction, though it often requires some careful cleaning, and may be publicly available from the local gov's building/planning department. A lot of states and municipalities have data portal websites which can usually be found by googling "(place name) open data."

Or if you just want some stats on American housing, Harvard has a commonly cited report: https://www.jchs.harvard.edu/state-nations-housing-2022

Though there's a lot more out there too. Good luck!

1

Makerstate1 t1_izdny5c wrote

is this a safe place to request advice on making data more beautiful/legible? Are there other subs you recommend for doing this?
I have seen someone request help in r/visualization but it's a way less active sub

1

litetaker t1_izeoniw wrote

I have been wondering for a long time (about 9 months now, ever since I saw the post!) what type of map projection was used in this particular post: https://www.reddit.com/r/dataisbeautiful/comments/tpq3bz/oc_global_wealth_inequality_in_2021_visualized_by/

I tried to look up map projections online, browsed through the list on Wikipedia and other websites, but none of them look exactly like this one. Can anyone tell me what type of projection this is?

1

kyoorius t1_izk1xar wrote

Anyone have an idea how to make a straight line representation of a river as a "ruler" attached to other polygon data, eg, surrounding census boundaries?

Like this ruler in the LA River Master Plan.

I know some GIS and can't figure it out, but I'm guessing this was done using D3 or something?

1

arika_ex t1_j0xkzn9 wrote

Are you still looking for advice on this? I’m not familiar with GIS programs so much, but such things could be done through Python or R.

I’d guess the key is just to measure the length of the river point to point and then using overlaps or distance measures to calculate which features exist at which point along the river. The visualisation itself is quite custom, but possible through libraries like ggplot, bokeh, etc. Some labels/annotations might need to be added manually via illustrator or something if there’s a very specific look you are after.

2

kyoorius t1_j0xmqpp wrote

Thanks! Yeah still looking. I know enough GIS to make the river into straight line segments defined by river length with each segment having the attributes of the census boundary it went through, but I don’t know what process to use to “warp” the census boundaries like on that ruler. On the ruler, the boundaries are abstracted bc they’ve been pulled/pushed to make a straight line, but they still correspond to the original geography/topology.

1

thebusiness7 t1_izpkzw1 wrote

Question: How do I make a chart like this which sources from data in Excel/Google Sheets: https://i.imgur.com/zwTSl7i.jpg I want to make a chart with the colored dots next to each of the topics then have the numerical values next to them also as seen here

1

ciarons t1_iztqpev wrote

Has anyone made a statistic showing footballer or Soccer player wages since its founding in 1863 (Google)? I think it would make for perfect data visualisation.

1

trippiler t1_j02nzcw wrote

I'm looking for a post that compared the lives of several rich people (university, trust fund, job after university, etc.). I remember seeing it but I just can't find it!

1

kjte t1_j0bf9rt wrote

Does anyone have any ideas on how I can visualize healthcare visit patterns? Assuming there's visit level data for primary care / acute care, is there any way I can visualize what are common "visit patterns"? For example, visiting clinic A before going to clinic C then ending at clinic B?

1

strikinglycrazy t1_j0bghig wrote

Question: How Data Visualization helps business to grow?

I have been in discussions with other professionals on how to grow my business through new methods. Few suggested to go ahead with Data visualization. Can anyone suggest me upon this?

1

kajri t1_j0bkhqr wrote

A month ago I had the same question that how effectively data visualization helps.

After lot of research and talks I think I can answer you in detail upon it!

Data visualization in businesses play a massive and incredible role in increasing the revenue, efficiency, and the profitability level.

Today big businesses rely entirely upon this process. Because in the end data presented in bullet formats or in bar graphs manually is nothing but waste of time and efforts

Considering you have a business with enough data work and analytics to I think this article might be a good help to you https://bit.ly/3hnvbHv

Let me know if you have more to discuss about it.

1

oddiseeus t1_j0cl9wl wrote

Im hoping someone remembers and can point me in the right direction. I’m looking for a data visualization concerning voting. I cannot remember if it was posted here or on /r/MapPorn. It showed two maps; one showed states entirely red or blue giving a false impression the entire state voted Democrat/Republican. The other showed voting by population centers represented by circles. The circles size portraying how the varied population densities had voted. Was it posted here?

1

Eastside23 t1_j0hh8wg wrote

Anyone know where I can find FIPS codes for cities within a county ?

1

Beesindogwood t1_j0lf3q5 wrote

Request: Can it be required to include your data source? Not a link to the data or anything (tho if that's available, awesome!) but just some general information in case anyone wants to share the image. For example, I teach and would love to include some of this info in my lectures, but I always try to cite where I got the info from. I can't do that if I don't know, so I can't use the info since I can't verify it's validity.

1

raspberry_rhino t1_j0r3jxu wrote

I am looking for a Phylogenetic tree database. I want to play with branching data visualisation. Evolution preferably, but anthropology, biology and chemistry are all really interesting.

I want to do a cool sunburst graph!

1

trendydots t1_j0tsbzq wrote

Question: Where you look for jobs in data visualization in Europe?

Hi everyone! I'm new to the field and the more I learn, the more I like it. I come from web frontend development and want to understand what is the career potential for data visualization. Are there roles that focus purely on visualization? Where do you find roles like these in Europe? Is the data visualization role a remote role or location based?

I appreciate very much your comments and opinions.

1

someone_191 t1_j14bdjv wrote

Lets say I have 1000 books that have tags associated with them for example

Book 1: [environment, fiction, story]
Book 2: [fiction, science, space, environment]
Book 3: [science, workbook, space]
....

As you can see any book can have multiple tags. I want to present how many books are in each category, but if I draw a simple bar graph that might not be the best representation since the total of each bar would be more than 1000 and that might be confusing.

Is there a better way to present my data.

1

AurikBTC t1_j188g82 wrote

I am looking for a list with the ticker symbols of all 500 companies of the S&P500. Does anyone have any idea how I can quickly find or create such a list without entering each company by hand?

1

Straightup32 t1_j1egolw wrote

Does anyone know how I would go about getting a city map that would showcase different data points?

I want one that showcases population density and demographic. I’m trying to strategize some business stuff.

1

emehav t1_j1uhexy wrote

Question: what programs are people using for budgeting? The ones with the graphs that I’ve been seeing more of lately

1

Fried_Mangos t1_j2ci5dv wrote

Question: How to create a Google Fit Like donut/ring shaped progress chart in Google Sheets which visualizes the completition of day's task with a tick mark and unfinished tasks with incomple circle?

Hi, I am creating a daily activity tracker. I want to track activities like sleep, work, study or workout.

I want to create a Google Fit like progress circle chart for daily, weekly, monthly and yearly data.

Kindly help!

1