The Holistics Blog Holistics Blog
  • Start Here
  • Business Intelligence
  • Data Modeling
  • Using Holistics
  • Our Newsletter
  • Visit Holistics

Lean Analytics

Getting things done with analytics, SQL and statistics

Subscribe
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!

Lean Analytics

Learning SQL - Why it is critical for Analysts

As a derivative of the development of technology, the importance of data to business is indisputable. Converting that information into insights becomes a business advantage. Understanding data flows to be able to work with data is essential for all Analysts.

Lean Analytics

ETL vs ELT: How ELT is changing the BI landscape

In any organization’s analytics stack, the most intensive step usually lies is data preparation: combining, cleaning, and creating data sets that …

Lean Analytics

Understanding Your Average Customer Value Over Time (CVO)

As business owners, understanding your customers’ behaviour is among the key things that will help you grow your business. If you’re …

Lean Analytics

4 Ways to Improve Dashboard Performance

A common problem that data analysts and report users face is slow dashboards, making users wait for charts and reports to load. …

Lean Analytics

Knowing Your Key Metrics

In his early days of investing, Warren Buffett drove to the airport at Omaha to pick up David Strassler, a New York based businessman whose family bought and fixed distressed companies.

Lean Analytics

Quick Guide: Calculate Cohort Retention Analysis with SQL

Cohort Retention Analysis is a powerful thing that most business owners need to look at. In this post, I'm going to give …

Lean Analytics

Useful PostgreSQL Queries For Monitoring Purpose

Below are some useful Postgres queries for both troubleshooting, monitoring and analytics purpose. Note: if you're looking for a simple tool to …

Lean Analytics

Quick Guide: Converting Rows to Columns — Pivoting with SQL & BI Tools

A common requirement in data reporting is converting data present in row-form to a dataset that is organized in a columnar format. …

Lean Analytics

Holistics Data Transforms for Performance & Clarity

How Holistics help to join, standardize, clean, pre-process, transform data for reporting.

← Newer Posts Older Posts →
The Holistics Blog © 2023
Latest Posts Facebook Twitter