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

Mode Studio – Python, R and SQL Editor

blog.modeanalytics.com

Post reply on HN
Print view View original

21–30 of 46 posts

Re: Mode Studio – Python, R and SQL Editor

#21

Post by mulmen »

smoe wrote: post #6

After quickly skimming the terms of service[0]. Do I understand correctly that in the free version, all your content has to be public? I'm not against that model (actually like it), but it isn't at all clear to me from the blog post or the main page. [0]: https://about.modeanalytics.com/tos/ under "4. Financial Terms" "The public function is available free of charge for public use and allows you only to view informat…

That's a really interesting approach. Give away the platform to get everyone's data for free. Like GitHub for data.

Re: Mode Studio – Python, R and SQL Editor

#22

Post by luminousbit »

tlrobinson wrote: post #13

If you're looking for something free, open source, selfhosted, or doesn't require programming knowledge (but allows SQL if needed), there's Metabase: https://metabase.com/ Disclaimer: I work on Metabase

We use metabase too! Far superior to Mode with no cost!

Re: Mode Studio – Python, R and SQL Editor

#23

Post by abhishekjha »

gringoDan wrote: post #8

On a related note, Mode's SQL tutorial is the best comprehensive introduction to the language that I've come across. If you go through all of it you can get from zero knowledge to 95% of the SQL skills you'll need as a data analyst. https://community.modeanalytics.com/sql/tutorial/introductio...

I am trying to learn intermediate to advanced SQL as my employer wants me to but apart from the the most basic keywords I don't see a lot of difference between Basic to Intermediate SQL. Or maybe by intermediate it means designing a good data model which shouldn't be concerned with SQL. My question is, if someone asks me to learn the advanced SQL constructs, where do I go? What do I look for?

Re: Mode Studio – Python, R and SQL Editor

#24

Post by dereksteer »

mulmen wrote: post #21
smoe wrote: post #6

After quickly skimming the terms of service[0]. Do I understand correctly that in the free version, all your content has to be public? I'm not against that model (actually like it), but it isn't at all clear to me from the blog post or the main page. [0]: https://about.modeanalytics.com/tos/ under "4. Financial Terms" "The public function is available free of charge for public use and allows you only to view informat…

That's a really interesting approach. Give away the platform to get everyone's data for free. Like GitHub for data.

Nobody at Mode will ever look at data in your database without express written permission. Period.

Re: Mode Studio – Python, R and SQL Editor

#25

Post by pbreit »

luminousbit wrote: post #22
tlrobinson wrote: post #13

If you're looking for something free, open source, selfhosted, or doesn't require programming knowledge (but allows SQL if needed), there's Metabase: https://metabase.com/ Disclaimer: I work on Metabase

We use metabase too! Far superior to Mode with no cost!

What are some things you like in Metabase better?

Re: Mode Studio – Python, R and SQL Editor

#26

Post by scottmcdot »

I can see the use case of this being similar to having Excel connected to an SQL server and creating some pivot charts off of the connection. Then rather than emailing the Excel file (which might be quite large depending on how much data is pulled into Excel), emailing a URL which is much cleaner.

Am I correct in thinking that Mode is not really a reporting platform (e.g., QlikView, Power BI) and more of an investigative, analytics-sharing tool?

Re: Mode Studio – Python, R and SQL Editor

#27

Post by gordon_freeman »

gringoDan wrote: post #8

On a related note, Mode's SQL tutorial is the best comprehensive introduction to the language that I've come across. If you go through all of it you can get from zero knowledge to 95% of the SQL skills you'll need as a data analyst. https://community.modeanalytics.com/sql/tutorial/introductio...

Impressive tutorial! their advanced level tutorial is pretty awesome and helps someone who wants to brush up SQL skills before having analyst interviews. They even have Python tutorial too which I want to try as well.

Re: Mode Studio – Python, R and SQL Editor

#28

Post by gordon_freeman »

abhishekjha wrote: post #23
gringoDan wrote: post #8

On a related note, Mode's SQL tutorial is the best comprehensive introduction to the language that I've come across. If you go through all of it you can get from zero knowledge to 95% of the SQL skills you'll need as a data analyst. https://community.modeanalytics.com/sql/tutorial/introductio...

I am trying to learn intermediate to advanced SQL as my employer wants me to but apart from the the most basic keywords I don't see a lot of difference between Basic to Intermediate SQL. Or maybe by intermediate it means designing a good data model which shouldn't be concerned with SQL. My question is, if someone asks me to learn the advanced SQL constructs, where do I go? What do I look for?

https://community.modeanalytics.com/sql/tutorial/sql-data-ty...

Re: Mode Studio – Python, R and SQL Editor

#29

Post by manigandham »

scottmcdot wrote: post #26

I can see the use case of this being similar to having Excel connected to an SQL server and creating some pivot charts off of the connection. Then rather than emailing the Excel file (which might be quite large depending on how much data is pulled into Excel), emailing a URL which is much cleaner. Am I correct in thinking that Mode is not really a reporting platform (e.g., QlikView, Power BI) and more of an investiga…

Yes, it's more exploratory and lower-level. It can do the usual "dashboard" style reports but its closer to Juypter notebooks and allows you to run python + sql (+ R now) and even edit the HTML to make your own visualizations.

Re: Mode Studio – Python, R and SQL Editor

#30

Post by manigandham »

mulmen wrote: post #21
smoe wrote: post #6

After quickly skimming the terms of service[0]. Do I understand correctly that in the free version, all your content has to be public? I'm not against that model (actually like it), but it isn't at all clear to me from the blog post or the main page. [0]: https://about.modeanalytics.com/tos/ under "4. Financial Terms" "The public function is available free of charge for public use and allows you only to view informat…

That's a really interesting approach. Give away the platform to get everyone's data for free. Like GitHub for data.

None of these platforms "get" your data other than running the queries in your databases and displaying the results (and sometimes caching it for future lookups).
Post reply on HN