Inner Join
What It's Like Being a Growth Hunter Intern at Holistics
This is one of the #lifeatholistics stories written by our Intern graduate.
Redash limitations and top alternatives
Redash is a good, popular open-source SQL-based BI tool that can be installed easily on local environment to get a simple SQL-to-chart functionality going. Yet as your analytics needs grow, you might face some pain points when using Redash
Using Holistics
SQL Tips
How to unnest / extract nested JSON data in MySQL 8.0
In this article, we will demonstrate how to use the JSON_EXTRACT and JSON_TABLE functions in MySQL8.0 to convert JSON table into tabular data for analysis and reports, and also how to utilise it in Holistics for drag-and-drop reports.
Business Intelligence
Business Fundamentals
Measurement Before Product Market Fit
A startup's first job is to create a customer. We take a closer look at how that affects the metrics you measure at the product stage of a startup's lifecycle.
Business Intelligence
How Metrics Change When Your Company Grows
When your company grows, the metrics that matter changes along with it. Here's a look at the three growth stages of every company, along with the metrics that matter most at each stage.
Business Intelligence
Business Fundamentals
The Magic Money Machine Model
One way to get better at business communication is to learn the fundamentals of business. We explain Return on Invested Capital from first principles, written with the data analyst in mind.
SQL Tips
How to unnest / extract nested JSON data in BigQuery
Working with nested JSON data in BigQuery analytics database might be confusing for people new to BigQuery. Yet if done well, nested …
Business Intelligence
Clearer Communication: How To Use The Ladder of Inference When Communicating Data To Your Business Users
If you work in data analytics, communicating complex information is just part of your job. Here's how to use the Ladder of Inference to get better at it.
Inner Join
Holistics Jun 2020 Product Updates
We've shipped 3 new features this month: AWS for Holistics 3.0, New Navigation Bar, Better Relationship Display