Using Holistics 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.
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 …
Lean Analytics How We Built Our MRR Dashboard (Using Pipedrive & Holistics) Want to customize and automate MRR reporting, to suit your company's specific data needs? Luckily, Holistics integrates with Pipedrive, here's our guide!
SQL Tips Splitting array/string into rows in Amazon Redshift or MySQL We've worked with a lot of customers who writes SQL on a regular basis. And from time to time they come to …