Unleashing the full power of data insights using Hyperquery

• The problem

• Insert Hyperquery

• Setup & integration

• Our experience

  • What stood out

  • Improvements

• Conclusion

With the accelerated growth of Mage in the past year, we were in a predicament where we had a lot of user data piling up from a bunch of different sources. A great problem to have, I know, but we would find ourselves spending hours each week manually pulling data and trying to keep it all organized to stay on top of our growth efforts.

Source: Giphy

Because we were pulling data from a variety of sources, we found a huge number of tabular inconsistencies and duplicate information. Each platform has its own unique limitations and customization that made creating consistency a challenge. We needed a better way to organize and seamlessly present our growth analyses in order to:

1. Ensure data consistency.

2. Provide an easy and flexible way to integrate and pull multiple data sources into a single place.

3. Be able to easily collaborate, share, and communicate our insights with our internal shareholders.

is a highly collaborative analytics notebook built to increase internal engagement and visibility, providing a simple yet intuitive UX/UI similar to

. They can integrate with numbers of different data sources and have industry-leading data security and compliance (

). There are several tiers for

, but you can get started with their Studio option for free which includes 3 creators, unlimited collaborators + viewers, 5 pages, shared python resources, default compute: XS, and 1 warehouse connection.

Getting started with Hyperquery was easy. We signed up using the quick SSO option and were ready to create our first integration in seconds.

We were able to integrate our data sources simply by going to the “Warehouses section” on the bottom left of the left sidebar and following the “+ Add warehouse” prompt.

We used Postgres to connect to a few of our data sources:

• Google Analytics

• Amplitude

• Google Sheets

Note: this was just the initial reports we pulled in for a basic workspace. You can see the full list of supported databases

.

After connecting, you can view your DW sources by expanding the right sidebar in the “Warehouses” page.

We used Mage’s

capabilities to regularly sync

,

,

, and

to our analytics database in

.

The tables created in our analytics database is then connected to Hyperquery for easy and fast hyperquerying.

The following are features we discovered and fell in love with:

• Apart from integrations (for non-technical folks like me), it was easy to onboard and begin using the tool with fairly little instructions (though they do provide

  guides

  and docs).

• The ability to connect, build, and communicate all on one centralized interface.

• The 

  /

   menu

  function,

  hotkeys

  ,

  and basic formatting with markdown.

• Work your data magic by seamlessly adding SQL block right directly into the workspace.

• Create powerful visualizations to tell your data story and query by selecting specific chart options.

• Very similar to notion UI/UX.

• Easy to organize and nest notebook hierarchically - like notion (drag and drop function on left sidebar).

• Helps organize.

• Easy for archiving and saving work.

• Audience (or collaborator) views, execution, and reactions (emojis).

  • With features like

    page comments,

    text comments

    , and

    mentions with @

    , Hyperquery makes it easy to communicate and collaborate with your teammates.

• How easy it is to share your work and analysis to your colleagues in your organization. Simply hit the ‘Invite members’ button on the bottom left side panel and send an email with a selected profile option. At the very least, they will be able to see the workspace or set them up to start contributing directly to analysis!

• Toggle query blocks to show or hide for final report/presentation. Not everyone in your organization may be technical, so the ability to hide SQL blocks to avoid confusion and distraction is definitely a nice touch!

• Share settings to edit, view, or app mode.

  • Team access

  • Copy link

  • Copy embed link

• Note: I have not tried Jinja (optional) for the more advanced users for dynamic functions, so I can’t really speak into that but here is

  the docs

  page explaining more about it.

There were only a few things we noticed that we hope to see improved in future updates:

• An easier way to move and reorder blocks within a page (drag and drop)

• Currently no feature to undo saved actions and changes within a chart

• Certain chart options and features aren’t so obvious to apply but was able to figure from their

  Visualizations docs page

  .

Hyperquery is a powerful interactive tool that allows you to stray away from your conventional dashboards and have the flexibility to integrate, build, and customize your reports for easier feedback loop amongst your stakeholders in your organization. We were able to sign-up, setup, and start creating our workspace all within a single business day span. We have already seen a difference Obviously our goals and needs may differ from others, but we just wanted to share a painless and magical way of telling the story of your data.

Source: Giphy

Ready to try it for yourself? Here’s a

to get started.