Lean Analytics (26)

Getting things done with analytics, SQL and statistics

When Measuring Performance, Find Lines in the Sand Business Intelligence

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.

Cedric Chin · July 27, 2019 · Business Intelligence
Lean Analytics Part 2: The Stages of a Data Driven Startup Business Intelligence

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.

Cedric Chin · July 12, 2019 · Business Intelligence
Lean Analytics Part 1: An Introduction to Analytical Thinking Business Intelligence

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.

Cedric Chin · July 06, 2019 · Business Intelligence
The Two Types of Operating Indicators Business Intelligence

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.

Cedric Chin · June 05, 2019 · Business Intelligence
Beware What You Measure: The Principle of Pairing Indicators Business Intelligence

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.

Cedric Chin · May 29, 2019 · Business Intelligence
How Data Analytics Helps MyanLearn’s Operations: Holistics Data Platform (Guest Post) Data at Work

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.

MyanLearn team · March 18, 2019 · Data at Work
Connecting Amazon Athena To Visualize And Query S3 Data, Using Holistics Lean Analytics

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.

Benjamin Goh · March 07, 2019 · Lean Analytics
How Planogram and Share of Shelf (SOS) Reports Maximise Revenue for Retail and FMCG Companies Data at Work

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.

Yahya Apristianto · February 08, 2019 · Data at Work
How To Setup Reporting Analytics For MongoDB Data at Work

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.

Matt Cassel · November 19, 2018 · Data at Work
The 4 Basic SQL Commands: SQL Basics 101 Lean Analytics

The 4 Basic SQL Commands: SQL Basics 101

Evan Tan · September 20, 2018 · Lean Analytics
How We Built Our MRR Dashboard (Using Pipedrive & Holistics) 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!

Trang · September 07, 2018 · Lean Analytics
Learning SQL - Why it is critical for Analysts 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.

Hai Nguyen · February 21, 2018 · Lean Analytics
ETL vs ELT: How ELT is changing the BI landscape Lean Analytics

ETL vs ELT: How ELT is changing the BI landscape

Ragha Vasudevan · December 20, 2017 · Lean Analytics
Understanding Your Average Customer Value Over Time (CVO) Lean Analytics

Understanding Your Average Customer Value Over Time (CVO)

Huy Nguyen · November 24, 2017 · Lean Analytics
4 Ways to Improve Dashboard Performance Lean Analytics

4 Ways to Improve Dashboard Performance

Ragha Vasudevan · November 15, 2017 · Lean Analytics
Knowing Your Key Metrics 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.

Ragha Vasudevan · November 08, 2017 · Lean Analytics
Quick Guide: Calculate Cohort Retention Analysis with SQL Lean Analytics

Quick Guide: Calculate Cohort Retention Analysis with SQL

Huy Nguyen · October 30, 2017 · Lean Analytics
Useful PostgreSQL Queries For Monitoring Purpose Lean Analytics

Useful PostgreSQL Queries For Monitoring Purpose

Huy Nguyen · October 29, 2017 · Lean Analytics
Quick Guide: Converting Rows to Columns — Pivoting with SQL & BI Tools Lean Analytics

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

Ragha Vasudevan · October 03, 2017 · Lean Analytics
Holistics Data Transforms for Performance & Clarity Lean Analytics

Holistics Data Transforms for Performance & Clarity

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

Ragha Vasudevan · September 25, 2017 · Lean Analytics
Combining Data Sources: The Holistics Approach Data at Work

Combining Data Sources: The Holistics Approach

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

Ragha Vasudevan · September 18, 2017 · Data at Work
Combining Data Sources: Approaches & Considerations Lean Analytics

Combining Data Sources: Approaches & Considerations

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

Ragha Vasudevan · August 31, 2017 · Lean Analytics
Quick Guide: Building Daily + Running Total Report With SQL Lean Analytics

Quick Guide: Building Daily + Running Total Report With SQL

Huy Nguyen · March 22, 2017 · Lean Analytics
SQL Is The New Excel Lean Analytics

SQL Is The New Excel

Vincent Woon · January 02, 2017 · Lean Analytics
Quick Guide: Reusing Your SQLs with Query Templates Lean Analytics

Quick Guide: Reusing Your SQLs with Query Templates

Huy Nguyen · September 26, 2016 · Lean Analytics
Why You Should Use Postgres Over MySQL For Analytics Purpose Engineering

Why You Should Use Postgres Over MySQL For Analytics Purpose

Huy Nguyen · June 22, 2016 · Engineering