Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

RAWGraphs: missing link between spreadsheets and data visualization

rawgraphs.io

Post reply on HN
Print view View original

31–35 of 35 posts

Re: RAWGraphs: missing link between spreadsheets and data visualization

#31

Post by prennert »

zaptheimpaler wrote: post #23

My current setup is a postgres db and jupyter instance running on docker. Data visualization is easy enough with seaborn/matplotlib/pandas plotting. I would love to see a better tool for this but its hard to beat running your own. There is no vendor lock in, no subscription fee, no uploading large datasets, no privacy issues on private data, no "gotcha" moment when the tool can't produce quite the visualization you'r…

You seem to have a good setup, but if you are looking for a solution to share easily between people, have a look at Metabase.

It works pretty well, if your data lives in a DB hosted somewhere and you only want to plot data that can be derived from SQL queries (potentially from tables produced by nightly batch process), and want to allow different people to look at the data via dashboard.

I used to do all plotting in Pandas etc locally and share them if required. But with Metabase it is easier to share plots, which are also always fresh.

RAWGraphs seems to have a different target audience. Judging by the sponsors, it seems to aim at people who keep their data in Excel and then need a nice plot for a publication or something. So it might be useful as a prototyping tool for scientists who barely code and keep the data they collect in Excel spreadsheets.

Re: RAWGraphs: missing link between spreadsheets and data visualization

#33

Post by hermitcrab »

hermitcrab wrote: post #32

This works really nicely with our data munging tool. Just copy your data from Easy Data Transform (after any filtering, joining, cleaning etc) and paste it in. Choose the axes. Graph.

Does it have a REST API or some other way to drive it from another application? I couldn't find anything.

Re: RAWGraphs: missing link between spreadsheets and data visualization

#34

Post by zaptheimpaler »

prennert wrote: post #31
zaptheimpaler wrote: post #23

My current setup is a postgres db and jupyter instance running on docker. Data visualization is easy enough with seaborn/matplotlib/pandas plotting. I would love to see a better tool for this but its hard to beat running your own. There is no vendor lock in, no subscription fee, no uploading large datasets, no privacy issues on private data, no "gotcha" moment when the tool can't produce quite the visualization you'r…

You seem to have a good setup, but if you are looking for a solution to share easily between people, have a look at Metabase. It works pretty well, if your data lives in a DB hosted somewhere and you only want to plot data that can be derived from SQL queries (potentially from tables produced by nightly batch process), and want to allow different people to look at the data via dashboard. I used to do all plotting in…

Metabase looks cool, thanks I'll give it a try.

Re: RAWGraphs: missing link between spreadsheets and data visualization

#35

Post by cormacrelf »

prennert wrote: post #31
zaptheimpaler wrote: post #23

My current setup is a postgres db and jupyter instance running on docker. Data visualization is easy enough with seaborn/matplotlib/pandas plotting. I would love to see a better tool for this but its hard to beat running your own. There is no vendor lock in, no subscription fee, no uploading large datasets, no privacy issues on private data, no "gotcha" moment when the tool can't produce quite the visualization you'r…

You seem to have a good setup, but if you are looking for a solution to share easily between people, have a look at Metabase. It works pretty well, if your data lives in a DB hosted somewhere and you only want to plot data that can be derived from SQL queries (potentially from tables produced by nightly batch process), and want to allow different people to look at the data via dashboard. I used to do all plotting in…

I second this. I've deployed Metabase once and almost immediately requests for data started coming out of the woodwork, from folks who previously had no knowledge of what kind of information was available or how to ask for it. Visibility is called that for a reason.

It's also really easy to self-host. Download the .jar. Whack it on a machine with a wireguard VPN and a route to the DB or somewhere suitable in the cloud. Create a read-only credential. Letsencrypt it & bless it with a DNS name, ideally with some internal-only IP address. Invite your boss to view some live stats on what's happening with the live product. Wait a day or so for them to request that some other underling also gets access or that some Metabase query gain some formal role in a business process. Also watch them have the best week of their manager life, with every kind of stat at their fingertips.

Post reply on HN