Top all-time · #2572
Modern Business Intelligence
Company blog · mode.com/blogdatabusiness
Modern Business Intelligence is the company blog at mode.com, writing about data and business. Since 2019, 30 different Hacker News readers have linked it 55 times, most often “Dispassionate Examination of Empirical Evidence Re Positional Punctuation in SQL”. No feed was found, so read it on the site itself.
Too few sampled comments (23) to say how often HN recommends it.?
Why HN links it
HN readers mostly link Mode's free SQL tutorial as a learning resource for SQL. Other mentions are about the company's product, job postings, and a blog post on trailing versus leading commas.
Summarised by Claude from a sample of 23 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Mode is a collaborative data platform that combines SQL, R, Python, and visual analytics in one place. Connect, analyze, and share, faster.
Most-linked posts?
- /6 people · 13 mentions · first linked 2019-08-20
- /sql-tutorial/4 people · 4 mentions · first linked 2019-02-13
- /careers/3 people · 9 mentions · first linked 2021-05-03
- /2 people · 2 mentions · first linked 2020-11-19
- Dispassionate Examination of Empirical Evidence Re Positional Punctuation in SQL2 people · 2 mentions · first linked 2020-01-11
- We Silently Switched Mode’s In-Memory Data Engine to DuckDB2 people · 2 mentions · first linked 2023-04-12
What Hacker News says?
Hmm, haven't seen those a ton at work / in interviews! Would love to see some examples though if you have any. Mode's SQL tutorial uses SUM(CASE ...) and CROSS JOIN to mimic pivots: https://mode.com/sql-tutorial/sql-pivot-table/
Comment linking /sql-tutorial/sql-pivot-table/
on “Medium-hard SQL interview questions”Submitted Forecasting in Python with Prophet as a story · 151 points
HN discussionTutorial format: https://mode.com/sql-tutorial/ Books: 1) SQL Antipatterns https://pragprog.com/book/bksqla/sql-antipatterns 2) Effective SQL https://learning.oreilly.com/library/view/effective-sql-61/9...
Comment linking /sql-tutorial/
on “Ask HN: What Skills to Acquire in 2020?”Submitted Dispassionate Examination of Empirical Evidence Re Positional Punctuation in SQL as a story · 3 points
HN discussionI am also a fan of Mode's SQL Tutorial: https://mode.com/sql-tutorial
Comment linking /sql-tutorial
on “SQL for data scientists in 100 queries”Submitted We Silently Switched Mode’s In-Memory Data Engine to DuckDB as a story · 2 points
HN discussionMode Analytics tutorial is well laid out: https://mode.com/sql-tutorial/
Comment linking /sql-tutorial/
on “SQL: One of the most valuable skills”Submitted Migrating to DuckDB to support millions of queries a day as a story · 2 points
HN discussionsome tutorials i've collected recently * https://mode.com/sql-tutorial/sql-joins/ * https://github.com/NUKnightLab/sql-mysteries * https://selectstarsql.com/ * https://sqlbolt.com/ * https://www.craft.do/s/VzvaPiNX6jvxX5
Comment linking /sql-tutorial/sql-joins/
on “SQLite 3 Fiddle”Submitted Finding user sessions with SQL (2015) as a story · 2 points
HN discussionAll the commercial ones support it, but most of them are expensive. Mode has a free plan which allows you to connect to BQ, run queries and then analyze the result sets in Jupyter. It's pretty cool for smaller stuff https://mode.com/compare-plans/
Comment linking /compare-plans/
on “Falcon is a free, open-source SQL editor with inline data visualization”Submitted Mode Helix: Interactive Data Analysis as a story · 2 points
HN discussionLooks interesting. Alas, no support for VPNing into DB. Like what mode.com is doing with its "bridge": https://mode.com/help/articles/how-mode-connects/#bridge
Comment linking /help/articles/how-mode-connects/
on “Show HN: Visual SQL”Submitted Thoughtspot Acquires Mode as a story · 1 points
HN discussionMode | San Francisco, CA or Remote (US) | Remote OK | https://mode.com Senior Ruby on Rails Engineer https://boards.greenhouse.io/modeanalytics/jobs/2676807 Senior Go Engineer https://boards.greenhouse.io/modeanalytics/jobs/2516962 Engineering Manager https://boards.greenhouse.io/modeanalytics/jobs/2335202 Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and a…
Comment linking /
on “Ask HN: Who is hiring? (February 2021)”Submitted 67 Years of Lego Sets as a story · 1 points
HN discussionMode | San Francisco, CA or Remote (US) | Remote OK | https://mode.com Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether this is…
Comment linking /
on “Ask HN: Who is hiring? (January 2021)”Submitted Should SQL queries use trailing or leading commas? as a story · 1 points
HN discussionMode | San Francisco, CA or Remote (US) | Onsite | Remote OK | https://mode.com Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether…
Comment linking /
on “Ask HN: Who is hiring? (January 2020)”Mode | San Francisco, CA or Remote (US) | Onsite | Remote OK | https://mode.com Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether…
Comment linking /
on “Ask HN: Who is hiring? (November 2019)”Mode | HQ - San Francisco, CA or Remote (US) | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether…
Comment linking /careers/
on “Ask HN: Who is hiring? (July 2021)”Mode | HQ - San Francisco, CA | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether this is the ri…
Comment linking /careers/
on “Ask HN: Who is hiring? (June 2022)”Mode | Remote (US) | Onsite | Remote OK | https://mode.com Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether this is the right pl…
Comment linking /
on “Ask HN: Who is hiring? (November 2021)”Mode | HQ - San Francisco, CA | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether this is the ri…
Comment linking /careers/
on “Ask HN: Who is hiring? (June 2021)”Mode | San Francisco, CA or Remote (US) | Onsite | Remote OK | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and…
Comment linking /
on “Ask HN: Who is hiring? (March 2021)”Mode | HQ - San Francisco, CA or Remote (US) | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether…
Comment linking /careers/
on “Ask HN: Who is hiring? (August 2021)”Mode | HQ - San Francisco, CA or Remote (US) | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether…
Comment linking /careers/
on “Ask HN: Who is hiring? (September 2021)”Mode | HQ - San Francisco, CA or Remote (US or India) | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, an…
Comment linking /careers/
on “Ask HN: Who is hiring? (September 2022)”Mode | HQ - San Francisco, CA or Remote (US) | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether…
Comment linking /careers/
on “Ask HN: Who is hiring? (September 2022)”Mode | HQ - San Francisco, CA or Remote (US) | REMOTE | https://mode.com | VISA Mode is building a world-class platform for data scientists, analysts, and everyone else who needs to ask and answer questions with data. Our product is an integral part of data science workflows at Lyft, Twitch, Shopify, and thousands of other data-savvy organizations. To learn more about who we are, our engineering culture, and whether…
Comment linking /careers/
on “Ask HN: Who is hiring? (September 2022)”