guidebook cover

The Analytics Setup Guidebook

Authors: Huy Nguyen, Ha Pham, Cedric Chin from Holistics

Restructure your knowledge of the complex data analytics landscape, and learn how to build scalable analytics & BI stacks in the modern cloud era.

Get the book

What is this
book about?

Have you ever wondered how to build a contemporary analytics stack that is useful, scalable, and easy to maintain? And have you looked into building such a stack, only to find yourself quickly drowning in a sea of jargon?

We know how that feels, because we’ve been there. The truth is that much knowledge of modern data analytics is locked up in the heads of busy practitioners. Very little of it is laid out in a self-contained format.

In this short book, we will give you a practical, high-level understanding of a modern analytics system. We will show you what the components of most modern data stacks are, and how best to put everything together.

This book is suitable for technical team members who are looking into setting up an analytics stack for their company for the very first time.

Praise for the book

I love that you went into more detail in the later chapters around modeling, transformations, and providing real-world case studies like the Snowplow case which I'd love to hear more about!


Ian Young

Business Intelligence Specialist, Inhaus Digital

[...] the book is great and is exactly what someone in my position needs, especially the part about the EL tools, the data modeling layer, and the relationship between the CEO and the Data Analyst.


Thomas Kane

Head of BI & Data, Unissu

I thought ELT was just another cool kids’ jargon [...] Chapter 2 slapped me hard in the face telling me that I was concluding too soon and I know nothing about it.


Ence Prastama

Data Engineer, Vidio

I love the bits of personality woven in [...] It's definitely getting me excited for my analytics degree and really looking to be versed on the technicalities.


Niki Torres

Director of Growth, Airalo

A whole analytics landscape in one book


High-level Overview of an Analytics Setup


A simple setup for people just starting out

A modern analytics stack

Our biases of a good analytics stack

High-level Overview of an Analytics Setup

Consolidating & Storing Analytics Data

Consolidating data from sources systems

Understanding the data warehouse

ELT vs ETL: what's the big deal?

Transforming Data in the ELT paradigm

Consolidating & Storing Analytics Data

Data Modeling for Analytics

Data modeling layer and concepts

Kimball's Dimensional Data Modeling

Modeling Example: A Real-world Use Case

Data Modeling for Analytics

Using Data

Data Servicing — A Tale of Three Jobs

Navigating The Business Intelligence Tool Space

The Arc of Adoption

Using Data

The team behind the book

We've been making data analytics tools for over four years, and helped more than a hundred companies build their business intelligence capabilities, sometimes from scratch.

Trusted by

User Experience & Cohort Insights Business Operational Reports across SEA Data Accessibility for Everyone Reservations, Ratings, Reviews and Customer Analysis Service Provider & Customer Transactions Reports Zero Learning Curve for Business Users Investors and Startups Research Insights Agile Data-driven Operation Teams Flight & Hotel Operational Reporting