Lean Analytics (26)

When Measuring Performance, Find Lines in the Sand

One of the most useful ideas from the 2013 book Lean Analytics is the notion of 'lines in the sand' — concrete values that tell you how well you're doing on a metric that matters.

Lean Analytics Part 2: The Stages of a Data Driven Startup

In Part 2 of our summary of Lean Analytics, we cover the five stages of a data driven startup, and the book's tips for creating a data-driven culture in your company.

Lean Analytics Part 1: An Introduction to Analytical Thinking

In the first part of our comprehensive summary of Lean Analytics, we examine the basics of analytical thinking, explore six startup business models, and examine the metrics that matter the most to each.

The Two Types of Operating Indicators

In operational analytics, you're either looking at a leading indicator, or you're looking at a lagging trend indicator. Here's why this particular categorisation is so useful.

Beware What You Measure: The Principle of Pairing Indicators

When you're implementing company-wide analytics, it's easy to fall into the trap of measuring only one metric. Don't. The principle of pairing indicators is why.

How Data Analytics Helps MyanLearn’s Operations: Holistics Data Platform (Guest Post)

As we are still a very small startup, we do not have a dedicated data team but we want to democratize data access. Holistics plays a big role in our company by providing visualization and reporting features via connecting with our database.

Connecting Amazon Athena To Visualize And Query S3 Data, Using Holistics

A step by step guide and video for querying S3 data to build reports and charts, by using AWS' Amazon Athena and Holistics.

How Planogram and Share of Shelf (SOS) Reports Maximise Revenue for Retail and FMCG Companies

Planogram and Share of Shelf/Space (SOS) reports are key field execution reports that are important concerns for decision makers to carry out the marketing strategy. In this article, we will explain what Planogram and SOS reports are.

How To Setup Reporting Analytics For MongoDB

Many Mongo users get stuck going from MongoDB data to analytics. Getting data out of Mongo and into a relational database lets you build your reporting workflow.

The 4 Basic SQL Commands: SQL Basics 101

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!

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.

ETL vs ELT: How ELT is changing the BI landscape

Understanding Your Average Customer Value Over Time (CVO)

4 Ways to Improve Dashboard Performance

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.

Quick Guide: Calculate Cohort Retention Analysis with SQL

Useful PostgreSQL Queries For Monitoring Purpose

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

Holistics Data Transforms for Performance & Clarity

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

Combining Data Sources: The Holistics Approach

How Holistics Business Intelligence helps customers combine data from different sources. Without storing their data.

Combining Data Sources: Approaches & Considerations

Analyze how the way different vendors addresses the problem of combing data from different sources

Quick Guide: Building Daily + Running Total Report With SQL

SQL Is The New Excel

Quick Guide: Reusing Your SQLs with Query Templates

Why You Should Use Postgres Over MySQL For Analytics Purpose