Mode Studio – Python, R and SQL Editor • Hacker News Board

Re: Mode Studio – Python, R and SQL Editor

#41

Post by wombatpm » Wed, Apr 18, 2018, 3:09 AM UTC

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?

Database Design for Mere Mortals by Ray Hernandez. Best book I've found to give a running start.

Re: Mode Studio – Python, R and SQL Editor

#42

Post by Achshar » Wed, Apr 18, 2018, 3:31 AM UTC

I've been trying my hand at something similar. It's not nearly as finished as mode is though.

https://github.com/Jungle-Works/AllSpark

Re: Mode Studio – Python, R and SQL Editor

#43

Post by digitalzombie » Wed, Apr 18, 2018, 6:49 AM UTC

I have to sign up to see this in action? No video demo or anything? I don't even know if this is a software where you download or if it's a web service cloud thing.

I think this is such a bad way to announce a product. Or lazy way.

I'll stick to Rstudio and Rodeo.

Re: Mode Studio – Python, R and SQL Editor

#44

Post by z3t4 » Wed, Apr 18, 2018, 7:34 AM UTC

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?

Explain the difference between INNER join and LEFT join, when you can do that you know intermediate to advanced SQL.

Re: Mode Studio – Python, R and SQL Editor

#45

Post by avenius » Wed, Apr 18, 2018, 7:44 AM UTC

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

Thank you for your work! Metabase has been a tremendous help in getting my coworkers interested in data and analytics, and is probably the sole reason why our call center is finally registering data in a structured and organized way.

Re: Mode Studio – Python, R and SQL Editor

#46

Post by vijucat » Wed, Apr 18, 2018, 1:12 PM UTC

This look amazing, and the WYSIWYG editor mode is what R Markdown notebooks (in RStudio) are missing right now.

However, there seems to be no way of uploading a private .csv? I need to make it public OR allow access to my company database (, which is simply not going to happen unless you have an on-premises solution)?