hyperquery blog
  • Home
  • About
  • Careers
  • Pricing
Subscribe
Why Analytics Sucks
Opinion

Why Analytics Sucks

We’re data vending machines, and our tools aren’t helping. Hyperquery can help.Image from unsplash.When I was a data scientist at Airbnb, I once received an ad-hoc request to identify Olympians that had accounts on Airbnb. No context given, just a colorless request in Slack. After a

  • Robert Yi
Robert Yi Mar 31, 2022 • 5 min read
Astronaut holding onto the hyperquery logo (a > symbol), with a contrail flowing b

Speed Changed Analytics, but Our Processes Need to Change Too.

Let's take a breath and rethink how we work.When the automobile went mainstream in the U.S. during the 1920s, the nation re-built roads, wrote new laws, and erected signs and signals to control the flow of traffic. Without these process improvements and infrastructural overhauls, the advent of the

  • Robert Yi
Robert Yi Mar 4, 2022 • 6 min read
The Startup Founder’s Guide to the Modern Data Stack
How-to

The Startup Founder’s Guide to the Modern Data Stack

You need analytics. And while no-code solutions like Google Analytics will get you quite far, around your Series A, you’ll realize there are far too many questions you can’t answer, and you’ll start Googling “how to set up analytics properly” to jerry-rig a solution. You’ll swim

  • Robert Yi
Robert Yi Jan 17, 2022 • 5 min read
This Is Why You Are Getting So Many Ad-Hoc Requests
Opinion

This Is Why You Are Getting So Many Ad-Hoc Requests

You are an analytics machine. You take in coffee and output actionable insights. But you have one kryptonite: the infamous ad-hoc request. “Hey can you quickly pull these numbers again…” “Hey where was that analysis that you made…” “Hey do you have the query for this?” “Hey is this the

  • Robert Yi
Robert Yi Jan 6, 2022 • 4 min read
Introducing Hyperquery’s Public Beta 🙌
Product News

Introducing Hyperquery’s Public Beta 🙌

Over the last decade, we’ve seen a renaissance in how data is handled and stored. But the analytics industry missed the memo — we’ve got data, but using it is still a slog. Let’s talk through what’s missing, and how Hyperquery can help. Analytics is fragmented. 💔Analytics

  • Robert Yi
Robert Yi Dec 17, 2021 • 3 min read
Why You Should Rethink Where You Write Your SQL
Opinion

Why You Should Rethink Where You Write Your SQL

Back when I was a data scientist, I spent a substantial amount of time doing product analytics work — opportunity sizing, experiment deep dives, ad-hoc checks. But although I worked across a wide range of tools — Jupyter/Python, tidyverse, superset, internal tools, even Java UDFs — the bulk of this work was

  • Robert Yi
Robert Yi Oct 7, 2021 • 5 min read
The Rise and Fall of Standalone Data Discovery
Opinion

The Rise and Fall of Standalone Data Discovery

Last year, we launched a data discovery tool called Dataframe. We wanted to solve the following pain point: it’s hard to find and get context on tables in your warehouse. But by working with customers over the last year we’ve learned that standalone data discovery, while effective at

  • Robert Yi
Robert Yi Sep 28, 2021 • 6 min read
How to Scale Your Analytics Org by Embracing SQL (and Ditching Git, Sometimes)
Opinion

How to Scale Your Analytics Org by Embracing SQL (and Ditching Git, Sometimes)

Process is critical to scaling an org, and we’ve gotten the processes for analytics wrong.A critical aspect of scaling organizations is process. Process allows you to normalize and incorporate best practices to ensure things work smoothly and scalably even when no one is minding the controls. But process

  • Robert Yi
Robert Yi Aug 30, 2021 • 8 min read
What is Deep Analytics?
Opinion

What is Deep Analytics?

As data analysts, we waste too much time on making dashboards for other people and not enough time on answering deep questions about critical business issues. This is a waste of resources for the individual, and a waste of resources for the business.The real meaty questions about the business

  • hyperquery
hyperquery Jul 31, 2021 • 3 min read
Don’t Be “Data-Driven.” Be Analytics-Driven.
Opinion

Don’t Be “Data-Driven.” Be Analytics-Driven.

“We are a data-driven company.”I hear you groaning at your screen already. Let’s talk about what this phrase means these days, what we as data scientists and analysts really want it to mean, and how to bridge that gap. Read this before you respond to your next ad-hoc

  • Robert Yi
Robert Yi Jun 19, 2021 • 5 min read
The Death of Data Analytics Tools ️☠
Opinion

The Death of Data Analytics Tools ️☠

Or why a consolidation is coming your wayMy take: the current tools to work with data in the market are ineffective and will face a wave of consolidation. Why? There are too many tools, and these tools are not great. Read on to learn more.👇 Problem 1/ there are too

  • hyperquery
hyperquery May 24, 2021 • 3 min read
Why the IDE is not the future of SQL-based analytics
Opinion

Why the IDE is not the future of SQL-based analytics

I’m just going to say it: the traditional IDE format is not great for writing queries for analytics work. I’ll start by explaining why, then tell you what you can do about it. First, my explanation — there are two things that you really need to know when you’

  • Robert Yi
Robert Yi May 18, 2021 • 4 min read
Tired of working with people who aren’t data savvy? Here’s what you can do about it
Inside hyperquery

Tired of working with people who aren’t data savvy? Here’s what you can do about it

If you’re like me, then you’ve had (many) experiences working with people who aren’t data savvy. This isn’t meant to be judgmental. It’s just a statement of fact. Even in today’s modern economy, with all its emphasis on technology and data, most employees are

  • hyperquery
hyperquery May 17, 2020 • 4 min read
Why car mechanics make better enterprise software salespeople than car salesmen
Inside hyperquery

Why car mechanics make better enterprise software salespeople than car salesmen

You’re building an enterprise SaaS company and looking to put together a top-notch sales team. Given the choice between a car salesman and a car mechanic, who would you prefer to add to your team and sell your software? Initially, the answer might seem obvious: the car salesman. After

  • hyperquery
hyperquery May 6, 2020 • 4 min read
hyperquery blog © 2022
  • Privacy Notice
  • Terms of Use
  • Security
Powered by Ghost