Mode is a great tool for running a query and executing some code afterwards and even distributing that report to others. However, its important to keep in mind that it doesn't have any real organizational tools which limit its use case. There are no tools for versioning and sharing notebooks (there is actually a shared query feature that is available at extra cost) and code (and you can only run the versions of code they have installed), or modeling your data and report parameterization is very difficult. Also, (perhaps due to being solely browser based) there can be issues working with larger data sets.
Mode Studio – Python, R and SQL Editor
31–40 of 46 posts
Re: Mode Studio – Python, R and SQL Editor
#32Earlier quoted context omitted.
Workarounds due to workplace-specific problems with your data...you'll learn that on the job :)
In my experience that's a lot closer to 50%. SQL is easy, Data is hard.
This can't be overstated enough. Finding people who understand SQL is difficult enough, but finding people who intuitively "get" data is nearly impossible. And lately anyone who completed a few tensorflow tutorials thinks they're a Data Scientist and every single data question can be answered accordingly. Reminds me of the hadoop craze a decade ago.
Re: Mode Studio – Python, R and SQL Editor
#33Earlier quoted context omitted.
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.
Maybe I misunderstand, if you are a free user the data has to be public right? And any user can use the public data?
Re: Mode Studio – Python, R and SQL Editor
#34Earlier quoted context omitted.
Nobody at Mode will ever look at data in your database without express written permission. Period.
Maybe I misunderstand, if you are a free user the data has to be public right? And any user can use the public data?
Regardless of whether you are on a free or paid account, you have two options:
-Public: Upload data or use data that is already in a database that Mode hosts. All data and analysis done here is visible to anyone. This is most commonly used with the SQL tutorials that others have posted about here.
-Private: Connect your database to Mode and do analysis on your own data. This is only visible to people you add to your Mode Organization. In fact, making your private data accessible to people outside your Organization is a paid feature and comes with more granular permission controls.
We have tried to make this as clear as possible in the product and ToS, but looks like we missed on the latter. We will revise to make it clearer.
Re: Mode Studio – Python, R and SQL Editor
#35If 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
Metabase is great but try as I might, I cannot get it to connect to a Postgres database over SSL. So... I'm using Redash instead, where it was easier to make that happen.
Re: Mode Studio – Python, R and SQL Editor
#36On 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?
I found that the book SQL Antipatterns helped me figure out some advanced SQL constructs. It presents a problem, shows the naive solution, takes apart that solution, and shows a better way.
Re: Mode Studio – Python, R and SQL Editor
#37If 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
just noticed it is written in clojure, always nice to see clojure (or F#) used
Re: Mode Studio – Python, R and SQL Editor
#38Earlier quoted context omitted.
In my experience that's a lot closer to 50%. SQL is easy, Data is hard.
This can't be overstated enough. Finding people who understand SQL is difficult enough, but finding people who intuitively "get" data is nearly impossible. And lately anyone who completed a few tensorflow tutorials thinks they're a Data Scientist and every single data question can be answered accordingly. Reminds me of the hadoop craze a decade ago.
Hadoop craze was a decade ago? Damn...
Re: Mode Studio – Python, R and SQL Editor
#39If 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
Metabase is great but try as I might, I cannot get it to connect to a Postgres database over SSL. So... I'm using Redash instead, where it was easier to make that happen.
Re: Mode Studio – Python, R and SQL Editor
#40I adore Mode - i find it the best SQL editor and dashboard by a huge margin. I mostly just use it as a SQL editor and then there’s an amazing ability to turn that SQL into exceptionally useful dashboards.