Business Intelligence
Slice n' Dice: A Self-Service Story
What self-service analytics is, and why it is important. Explained using a story of a pizza restaurant. If you enjoyed this comic …
Business Intelligence
Feature Release
Introducing Holistics AI: Your Thought Partner for Self-Service Analytics
We’re introducing a simpler, faster way to explore data in Holistics: you just need to chat with Holistics AI.
Business Intelligence
The Goldilocks Rule of Getting Data Driven
Have you ever played table tennis? Imagine you’re a recreational table tennis player. You’re not great, but you’re not …
Feature Release
Introducing Holistics Canal - a fast query streaming engine
Canal aims to provide much better performance, maintainability, and scalability throughout Holistics querying operations.
Business Intelligence
The 4 Types of Data Scales
Numbers aren't all created equal; they fall into four distinct categories known as data scales. Understanding this, you'll learn how to handle each type correctly to make your data work for you.
Feature Release
Aggregate Awareness: Optimize query performance with pre-aggregates
Automatically pick the most optimal aggregated tables per each query for maximal query performance.
Feature Release
Introducing Canvas Dashboard (Dashboard As Code)
Turn rigid dashboards into living documents, rich with interactivity, business context, and storytelling.
Business Intelligence
The Self-Service Analytics Maturity Scorecard
The industry seems split on what "self-service analytics means". Benn Stancil suggests it's more of a "feeling, …
Designing Data Organizations
How to Restructure Data Teams Effectively, the Modern Analytics Leader, and the Evolution of Data Roles: An Interview with Christine Jiang
For this week’s episode of Designing Data Organizations, we spoke with Christine Jiang, former Director of Core Analytics at Vimeo, who was with the organization between 2020 and 2024.
Designing Data Organizations
Effective Performance Tracking, Analytics as a Strategic Partner, and Managing Globally Distributed Teams at ZoomInfo: An Interview with Michael Perlis
Designing Data Organizations is brought to you by Holistics, where we delve into the intricate process of creating and optimizing data teams within organizations.
Business Intelligence
Metrics Deserve Better Composition Than What SQL Allows
If you have dabbled in the Software Engineering world, you may think this post is about the catchphrase: “Composition over Inheritance” and …
Data Modeling
Business Intelligence
The Three Types of Fact Tables
A concise tour of one of the basic components of Kimball dimensional data modeling. We explore the three types of fact tables, and then analyze why they have lasted the test of time.
Designing Data Organizations
Data as a Thermostat, the Necessity of Reorganizations, and Data Generalists vs. Data Specialists at Wayfair: An Interview with Nachiket Mehta
Designing Data Organizations is brought to you by Holistics, where we delve into the intricate process of creating and optimizing data teams within organizations.
Business Intelligence
4 levels of Analytics-as-Code
How did Analytics-as-Code evolve? We explain the history behind the movement, and present the 4 levels of analytics as code over the years.
Designing Data Organizations
Data Teams as Product Teams, Managing Growing Teams, and Good KPI Design at Trade Republic: An Interview with Hannes Felsberg
Designing Data Organizations is brought to you by Holistics, where we delve into the intricate process of creating and optimizing data teams within organizations.
Business Intelligence
You’re a Data Leader About to Get Laid Off. Here’s What You Can Do
As of this article’s publication, over 15,000 data and analytics professionals have been laid off since January 2022.* The job …
Business Intelligence
Death to Dashboards, Really?
Are dashboards really 'dead'? A response to a vendor trend that seems rather premature.
Business Intelligence
The Emotional Needs of Dashboarding
Treating your dashboards like a product means thinking about ALL of your user's needs — rational or otherwise.
Business Intelligence
Nailing An Analytics Interview Case Study: 10 Practical Strategies
10 practical tips/strategies I extracted myself when doing analytics case study as part of job interview process.
Business Intelligence
The Two Forms of Metrics: Interval vs Point
In actual business conversations, the metric's form is sometimes ignored and implicitly understood. Understanding this concept gives you much better clarity in dealing with metrics.
Business Intelligence
The Future Of Self-Service BI Is AI-Guided
What does the future of self-service business intelligence look like?
Business Intelligence
The skills chasm of the data analyst career
Why are so few data analysts get good at business problem-solving?
Business Intelligence
Data Careers: Dealing With Being in a Cost Center
Building a career in data often means building a career in a business cost center. This isn't necessarily bad. Here's how to think about it.
Business Intelligence
LLM Is Not Enough (For Self-Service Analytics)
Introduction A few weeks ago, Microsoft announced a new data analytics product called Fabric. One of Fabric’s most exciting features is …
New at Holistics
Press Release: Holistics Achieved Select Tier Partner Status with Snowflake
Holistics.io the self-service BI platform, announced that it has achieved Select Tier partner status as part of the Snowflake Partner Network
Business Intelligence
Data Modeling
How Would An Ideal Semantic Layer Look Like?
Most data practitioners I talked to agree on two things. * We need an abstraction layer to define metrics consistently and rigorously. * We …
New at Holistics
It's Official, Holistics Is Now SOC2 Compliant
As a provider of business intelligence software, we understand the importance of maintaining the highest standards of security and trust. Our customers …
Business Intelligence
How to run a Data Clinic (aka Data Office Hours)
Data clinic is one of many ways you create value and drive your organization toward better data literacy. Here's how.
Business Intelligence
Data analysts, think about your work from the business stakeholders perspective
As data analysts, we often do lots of work — writing SQL, modeling data, drawing charts, and building data presentations. We spent hours …
Business Intelligence
The Misleading Data Analyst Job Title (and Career Ladder)
Investment analyst is an entry-level investment position. So is data analyst an entry-level data position, too?
Business Intelligence
Data at Work
Business Metrics vs Customer Metrics
What are the typical metrics that you’d normally look at weekly? If you're like me (a startup founder), you …
Business Intelligence
The Silos between Data Analysts and Data Engineers
This is part two of the “Silos of Data Organization” series. Part one was sent out last week. For this one, let’ …
Business Intelligence
The Silos of Data Organization: Data Analysts vs Business Users
As a Data Analyst, you usually work with two types of stakeholders: the clients (business users) who ask for data, and the …
Business Intelligence
Analytics as Code
A short story about my history with programmatic configuration (or lack thereof) and how it's related to analytics.
Using Holistics
Holistics August 2021 Product Updates
We understand that things are getting tougher and tougher during this pandemic but we will not wave the white flag right now. …
Business Intelligence
What is an OLAP Cube? An Exhaustive Explainer
The definitive explainer for OLAP cubes, where we cover every single possible definition for the phrase.
Data Modeling
Business Intelligence
A 2020 Reader's Guide to The Data Warehouse Toolkit
Ralph Kimball's classic book The Data Warehouse Toolkit introduce the world to the practice of data modeling. Here's how to read it in 2022.
Business Intelligence
Read Data Research Papers
A hack for when you don't understand data jargon.
Business Intelligence
The Six Ways People Deflect Inconvenient Data
We take a look at an exhaustive list of reasons people give when they want to ignore anomalous data.
Business Intelligence
Fitting Into Your Company's Learning Cadence
How a data person might fit into your company's learning cadence, and what that means for company performance.
Business Fundamentals
Business Intelligence
The Intuition Behind The Rule of 40
The origins and intuition behind a famous SaaS business metric.
Using Holistics
Holistics March and February 2021 Product Updates ☀️
For the past two months, we've been shipping some great features to improve your experience and interactivity inside Holistics.
Business Intelligence
Data at Work
Obsess Over Controllable Input Metrics
Why Amazon's notion of measuring controllable input metrics is a lot more profound than you might think.
Business Intelligence
This is How Amazon Measures Itself
How Amazon uses metrics. A summary of chapter 6 of Working Backwards, the first book to explain how Amazon really works.
Business Intelligence
Simple Data People Tricks
Simple data people tricks, a hierarchy of feature stores, and Shreyas Doshi on product metrics.
Business Intelligence
How Amazon Uses Input Metrics
How Amazon uses input metrics, a data pipeline is a materialized view, and the case against self-service data and analytics.
Business Intelligence
Snowflake and the Data Lakehouse
A quick look at what Snowflake's been up to re: the Data Lakehouse, an inside look at Amazon's data-driven decision making, and how Airbnb customized Superset to fit their needs.
Using Holistics
Holistics January 2021 Product Updates 🎉
We've shipped 2 new features in January 2021: Bulk actions and Top/Bottom N filters.
Business Intelligence
The Data Lakehouse is a Thing
The data lakehouse is a thing, Superset is also a thing, and how to make dashboards using a product thinking approach.
Business Intelligence
So You Want To Find an Analytics Engineering Job?
Looking for an analytics engineering job in your locale? Read this.
Business Intelligence
What We Know and Don't Know About Analytics Engineering
Everything we know and don't yet know about the emerging role of analytics engineering.
Business Intelligence
Three Data Industry Questions We're Investigating For The New Year
Three changes in the data landscape we're investigating over the next few months.
Using Holistics
Holistics December 2020 Product Updates 🎉
2020 has been a really tough period for people around the world due to COVID-19. Regardless, Here at Holistics, we continue to …
Business Intelligence
Five Things We're Pretty Sure About
Five quick things we know to be true, written for the end of the year.
Business Intelligence
Embrace The Data Schlep First
Every cool data project has some schlep up front. Here's why it's a good idea to keep that in mind.
Using Holistics
Holistics November 2020 Product Updates 🎄❄️
Another festive season is coming! If you haven’t got any plan for the upcoming holidays, here’s our little suggestion: Explore Holistics’ newest features and improvements.
Using Holistics
Introducing an improved Conversion Funnel
Conversion Funnel has been with Holistics since the first day, but it never got the attention that matches its importance. That' …
Data Modeling
Business Intelligence
Applying The Principles of Agile to Data Modeling
In our third and final part on Agile Data Warehouse, we take a look at the origins of the Agile Manifesto, from which Corr and Stagnitto took inspiration.
Business Intelligence
Data Modeling
A Business Process Worth Measuring
The second part of our series on Agile Data Warehouse Design, a 2011 attempt at applying the principles of agile to the practice of data modeling.
Data Modeling
Business Intelligence
First Impressions from Agile Data Warehouse Design
Agile Data Warehouse Design is a 2011 attempt at applying the principles of agile to the practice of data modeling. This is the first post in a series on the ideas from the book.
Using Holistics
Holistics October 2020 Product Updates
We've shipped 3 new features this month: Metric Sheet, Point Map and Adhoc Export.
Business Intelligence
The Four Flavors of Goodhart's Law
Goodhart's law says that 'when a measure becomes a target, it fails to become a good measure. Here are four ways that occurs.
Business Intelligence
A Short Story About SQL’s Biggest Rival
A short story about SQL's better rival: Michael Stonebraker's storied query language, QUEL.
Business Intelligence
Top 5 Data Books To Read in 2020
Stuck at home during the pandemic? We give you Holistics's top five data books to read in 2020.
Business Intelligence
Why is Data Analytics So Far Behind Software Engineering?
Why does data analytics and business intelligence lag behind the best practices and tooling of software? Two anecdotes and a theory.
Business Intelligence
Business Intelligence Lessons from Softwar: A Portrait of Larry Ellison And Oracle
What we can learn from Softwar, a book about Larry Ellison's attempt to take over the enterprise software world.
Business Intelligence
Redshift, Snowflake, and the Two Philosophies of Cost
What intermix.io's forced acquisition tells us about the two philosophies of cost in data analytics.
Inner Join
Gartner's FrontRunners 2020 Ranks Holistics As Top 3 Data Analysis Tools By Customer Satisfaction
Holistics was ranked one of the top 3 data analysis tools globally by Gartner's FrontRunners 2020 report, in terms of Customer Satisfaction. Only 20 out of 176 software products considered were selected for this list.
Business Intelligence
A Dive Into Metadata Hubs
A look into metadata hubs, which might just be the hottest category of data tools of the past two years.
Business Intelligence
Measuring a Company When a Company Is Mature
We take a look at the business fundamentals of the operations stage — the last of three stages in a company's life.
Business Intelligence
Understanding the Scale Stage
The scale stage is the second of three stages in a startup's life. In this post, we discuss what product-market fit means, and then we look at healthy growth (the kind that leads to winning) and unhealthy growth (the kind that leads to company death).
Inner Join
What It's Like Being a Growth Hunter Intern at Holistics
This is one of the #lifeatholistics stories written by our Intern graduate.
Redash limitations and top alternatives
Redash is a good, popular open-source SQL-based BI tool that can be installed easily on local environment to get a simple SQL-to-chart functionality going. Yet as your analytics needs grow, you might face some pain points when using Redash
Using Holistics
SQL Tips
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.
Business Intelligence
Business Fundamentals
Measurement Before Product Market Fit
A startup's first job is to create a customer. We take a closer look at how that affects the metrics you measure at the product stage of a startup's lifecycle.
Business Intelligence
How Metrics Change When Your Company Grows
When your company grows, the metrics that matter changes along with it. Here's a look at the three growth stages of every company, along with the metrics that matter most at each stage.
Business Intelligence
Business Fundamentals
The Magic Money Machine Model
One way to get better at business communication is to learn the fundamentals of business. We explain Return on Invested Capital from first principles, written with the data analyst in mind.
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 …
Business Intelligence
Clearer Communication: How To Use The Ladder of Inference When Communicating Data To Your Business Users
If you work in data analytics, communicating complex information is just part of your job. Here's how to use the Ladder of Inference to get better at it.
Inner Join
Holistics Jun 2020 Product Updates
We've shipped 3 new features this month: AWS for Holistics 3.0, New Navigation Bar, Better Relationship Display
Inner Join
Business Intelligence
Announcing The Analytics Setup Guidebook: The First Principles Approach to Data Analytics
We're releasing The Analytics Setup Guidebook, a first-principles approach to data analytics. Get it free today!
Using Holistics
Holistics May 2020 Product Updates
Discover our new and May-verllous features: Data drill-through, Smart date parser, Filter suggestions, and more!
Using Holistics
Use Holistics to boost your eCommerce sales with data
Learn how to leverage data to craft personalized messages to your customers, pinpoint your business' Achilles heel and take timely actions!
Business Intelligence
Data Quality from First Principles
Why data quality is an ongoing, people, process, and tools problem, and how to think about getting better at it.
New at Holistics
Engineering
Inner Join
Introducing Holistics Open-source Smart Date Parser
Smart Date Parser allows users to input date/time expressions that are more natural/closer to your day-to-day language, and output date/time values that adhere to programming language's standards.
Using Holistics
A Complete Guide to Analyze Pipedrive data with Holistics for Free
This tutorial will show you simple steps to build an interactive dashboard to visualize your Pipedrive data using Holistics.
Using Holistics
A Complete Guide to Build Reporting Analytics on CSV / Google Sheets using Holistics for Free
I'll show you 5 simple steps to integrate CSV / Google Sheets and build a real time dashboard by using Holistics.
Data Modeling
Slowly Changing Dimensions (SCDs) In The Age of The Cloud Data Warehouse
What a new approach to slowly changing dimensions tell us about the future of dimensional data modeling.
Business Intelligence
When Doing Digital Transformation, Think Capabilities, Not Maturity
Why maturity models can be a bad idea, and why using a capability model is a better idea for digital transformation.
Business Intelligence
How to Measure Software Development, from ‘Accelerate: The Science of Lean Software and DevOps’
Tracking the performance of your software development team is really, really difficult. The 2018 book Accelerate: The Science of Lean Software and DevOps gives us a fantastic way to measure just that. Here's how.
Business Intelligence
Why Measuring Cash Flow is More Important Than Measuring Profitability
Why your CEO is so obsessed with cash flow metrics, and what you can do to help as an analytics person in your company.
Inner Join
What It's Like Being a Growth Hunter Intern at Holistics
This is one of the #lifeatholistics stories written by our Intern graduate.
Business Intelligence
The Two Philosophies of Cost in Data Analytics
There appears to be two philosophies today when it comes to managing costs in a modern data stack. We explore what they are.
Inner Join
What It's Like Being a Designer Intern at Holistics
Creative designer intern Teo shares his experiences working at Holistics Indonesia.
Business Intelligence
Business Fundamentals
Developing an Intuitive Understanding of the SaaS Quick Ratio
An explanation of the SaaS Quick Ratio that focuses on the intuition behind the metric. Written with the data analyst in mind.
Business Intelligence
Data Modeling
OLAP != OLAP Cube
There's a tendency for people to conflate OLAP with OLAP cube. We take a quick look at how this happens, why it shouldn't, and why it matters if you're a data practitioner.
Business Intelligence
Data Modeling
The Rise and Fall of the OLAP Cube
A definitive history of the rise of the OLAP cube, how it's affected our industry, and what comes after.
Using Holistics
How to Create Data Models from External Data Sources in Holistics
In Holistics, you are now able to create data models on top of external data sources like MongoDB and Google Sheets. Here's a video tutorial on how to do exactly that.
Business Intelligence
How We Combine Data Sources at Holistics
Good data teams combine data from different sources in order to do their jobs well. Here's what we've learnt while putting this into practice at Holistics.
Business Intelligence
Judge Your Company: Using The Three Levels of Data Analysis For Data Career Decision-Making
Data team careers are different from equivalent careers in software engineering, product management, or UI design. Here's how to evaluate prospective employers as part of your data career.
Business Intelligence
Why Google Analytics sucks and what you can do about it
Google Analytics is an incredible tool to have in your toolbox. But it only offers aggregated data, which limits your ability to track visitor behavior. In this post, we discuss a simple, affordable alternative to GA that we've implemented at Holistics.
Business Intelligence
The rise of SQL-based data modeling and DataOps
The resurgence of SQL-based data modeling is a something we should all be interested in. Here's why it's important.
Data at Work
Startups
Business Intelligence
How To Choose A BI Tool - Insights from Datanest
“There is nothing so terrible as activity without insight.” Insight has become an essential need for every company in order to understand what the company is experiencing, why it happens, and what might come in handy in the future.
Business Intelligence
Hire Your Data Analysts First
In the past, setting up an analytics department meant hiring data engineers first. But in a cloud-first world, you can and should hire data analysts first. Here's why.
Using Holistics
Data at Work
Custom SQL with Tableau? No Problems
Using custom SQL for your Tableau workbooks is usually a really bad idea. Here's how using Holistics with Tableau makes this a non-problem.
Using Holistics
Effortless Materialized Views for Tableau with Holistics
Tableau may be the best data visualizer on the planet today, but Holistics makes Tableau more awesome, by making data prep trivially easy.
Business Intelligence
Data Analytics for the App Generation
We live in the age of apps — and therefore, the age of data. This presents us with an unparalleled opportunity for data analytics, as well as an unparalleled challenge! Here's how to not get left behind.
Business Intelligence
When Should You Get a Data Warehouse?
Occasionally, we get asked “when should we consider getting a data warehouse?”. The answer is a lot simpler than you think!
Holistics — The Best Affordable Alternative to Looker
Looker is among the most popular data analytics platforms on the market today. It has a unique approach to data modeling that …
Using Holistics
Holistics Power-ups
Data Modeling
Holistics Data Modeling, Explained
Holistics's data modeling layer allows data teams to radically increase their productivity. No repeated queries. Self-serve reports and dashboards. Here's how it works.
Using Holistics
How Holistics Fits Into A Data Organisation
The new version of Holistics is designed from the ground up to increase the productivity of your data team. Here's how that works.
Business Intelligence
Lean Analytics
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.
Business Intelligence
Lean Analytics
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.
Business Intelligence
Lean Analytics
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.
Business Intelligence
Lean Analytics
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.
dbdiagram
Startups
Inner Join
Launch a Product to 200,000 Users with 0 Dollars Spent on Marketing Budget
How we managed to launch a database designer to more than 100,000 users around the world without a budget.
Business Intelligence
Lean Analytics
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.
Business Intelligence
dbdiagram
A Quick Way To Get On Top Of Your Company’s Data: Create a Spreadsheet-Based Data Dictionary!
A data dictionary is a document that assists you in navigating your team's mountain of data. We show you how to create a spreadsheet-based data dictionary with Excel and dbdiagram.io.
Data at Work
Setup A Google BigQuery Data Warehouse In 3 Minutes
With cloud services today like Google Cloud Platform (GCP) and Holistics, setting up a data warehouse is insanely simple. In this video, …
New at Holistics
Inner Join
Gartner's FrontRunners 2019 Lists Holistics As Top 2 Most Usable BI Tools Globally
Holistics listed by Gartner's FrontRunners 2019 among the top 2 most Usable business intelligence tools globally, for the second consecutive year running.
Startups
Inner Join
Qualitative data-driven: How we boost team alignment and customer empathy by written communications
At Holistics, we have the habit of noting down every interactions the team has with the market. Whether it's customer, …
Data at Work
Lean Analytics
Business Intelligence
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.
Data at Work
Using Holistics
Make Tableau work better for you with Holistics
Tableau is a great data visualization tool to help data teams provide senior executives with summarized data. However, there is typically lots …
Using Holistics
Get Your Answers Efficiently With Holistics Concurrent Workers
'A queuing system makes everything faster!' What is a Concurrent Worker? Holistics Workers control the number of concurrent database queries …
Lean Analytics
Holistics Power-ups
Using Holistics
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.
Startups
dbdiagram
Inner Join
Making Our Tiny Feature Free, We Got 20,000 Users and 2,500 Leads within 2 Months - Part 1: Build
This project started out as a tiny feature intended for our DataOps cloud BI platform, Holistics.io. Our interns helped develop dbdiagram. …
dbdiagram
Data at Work
dbdiagram.io Many to Many Relationship and Diagram Generator SQL Script
In this post, we will be sharing with you two tips to make dbdiagram.io work better for you * How to define …
Holistics Power-ups
Data at Work
Using Holistics
Optimizing Embedded Analytics Dashboard Performance by Pre-transforming Data
Your embedded analytics dashboard in Holistics takes a long time to load, thus impacting your customers' experience. This post shows you how to optimize the performance of embedded dashboard by preaggregating the data.
Using Holistics
How to Set-up your own Google Cloud PostgreSQL database and Start Automating your Business Intelligence Operations using Holistics
Why bother creating a database? The world is full of data. According to Forbes, there are 2.5 quintillion bytes of data …
Data at Work
Lean Analytics
Business Intelligence
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.
Data at Work
Startups
Business Intelligence
4 Case Study Questions for Interviewing Data Analysts at a Startup
A good data analyst is one who has an absolute passion for data, he/she has a strong understanding of the business/product you are running, and will be always seeking meaningful insights to help the team make better decisions.
Inner Join
December 2018 Update: Our Top 5 Favorite Holistics Moments
We are always looking back to see what we have achieved in the past year. It's our way of giving …
Using Holistics
Increase Sales Through Data-Driven Insights With Holistics For Pipedrive
Sales data consists of many key statistics such as number of leads, lead score data from apps like Autopilot, success rate of …
New at Holistics
Inner Join
Inner Join: Ending The Year Strong (November 2018)
Almost the end of the year! Has it been a good one? We're gonna try to make it better. Here's our November update and year end highlights!
Data at Work
Lean Analytics
Business Intelligence
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.
New at Holistics
Inner Join
Gartner's FrontRunners 2018 Lists Holistics Among Top BI Tools
Holistics was listed by Gartner's FrontRunners 2018 as one of the highest ranked business intelligence tools for Usability and User Recommendations.
Holistics Power-ups
Using Holistics
How to Query MongoDB Using SQL
In this tutorial, you will learn how to query your MongoDB with SQL and use it for different purposes such as Analytics, Embedded Analytics, Machine Learning, Statistics etc.,
New at Holistics
Startups
Inner Join
The Holistics Way Of Life
We believe that doing meaningful work requires giving people independence and autonomy. That’s why at Holistics, we are creating data champions.
dbdiagram
Using Holistics
How to Visualize Your Rails ERD Diagram Instantly
Learn how to use this simple free tool dbdiagram.io to visualize your Rails ERD diagram, made by Holistics
Data at Work
dbdiagram
Using Holistics
dbdiagram.io - A Database Diagram Designer Built for Developers and Analysts
Starting as a feature developed by our interns to help our customers visualize their database schemas on holistics.io (Business Intelligence Platform) …
Holistics Power-ups
Using Holistics
Automating Email Reports And Marketing Operations With AppsFlyer Data: Holistics X AppsFlyer Data Masterclass (Holistics Crash Course #5)
Your marketing team has tons of useful data from your mobile app for tracking and attribution. In this webinar, we show how Holistics and AppsFlyer, lets you work with these raw datasets, to automate email reporting and develop data-driven marketing operations,
Data at Work
Business Intelligence
What is a Pivot Table?
Pivot Table is a concept that allows you to summarize and aggregate a set of data by different groups of fields. The …
Lean Analytics
Business Intelligence
The 4 Basic SQL Commands: SQL Basics 101
Fear not data traveller, though the data landscape may seem wild and treacherous, we will help you, young padawan, to navigate the …
Data at Work
Business Intelligence
How Do I Prepare for A Data Analyst Interview?
Preparing for a data analyst interview can be intimidating. Learn a few tips to help you prepare your interview better.
Engineering
Inner Join
Managing Sidekiq Workers And Processes
At Holistics we use Sidekiq, the de facto Ruby background processing framework. By combining the reliability of Sidekiq Pro and our own retry logic, no back-end job gets lost or forgotten.
New at Holistics
Using Holistics
Holistics supports native Google Analytics integration!
View metrics from your Google Analytics data in a simpler dashboard format.
Lean Analytics
Using Holistics
SQL Tips
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!
Data at Work
Using Holistics
Automating Email Reports from Big Data Lakes (Qubole+Holistics)
Struggling to draw insights regularly from your data lake? Accessing data lakes for timely insights does not need to be technical or difficult. Using Holistics and Qubole, you can schedule reports to be emailed automatically, from your data lake straight to your inbox.
New at Holistics
Using Holistics
August Product Updates!
Welcome back Everyone, August has been an important month here at Holistics and we are excited to share our updates this month! …
Holistics Power-ups
Using Holistics
Holistics Crash Course: Embedded Analytics In Your Applications
Learn about our Holistics Embedded Analytics feature, which allows our customers to embed their Holistics dashboards into their own applications or web services, using secured iframes (just like embedding a YouTube video).
Data at Work
Startups
Using Holistics
Startup Data 101: Building Scalable Data Infrastructure With Holistics (Rezdy Guest Post)
Infrastructure is only as good as the business value it provides. The use of data in a startup, becomes increasingly important as its number of users grows.
Holistics Power-ups
Using Holistics
Holistics Crash Course: Automated Data Reporting (Email & Slack Schedules)
Scheduling the delivery of data insights and datasets is simple with Holistics. Now you can automatically send reports and dashboards via email and Slack, from your SQL database.
Data at Work
Startups
Business Intelligence
3 Things To Consider When Choosing The Right BI Tool!
Choosing an appropriate BI tool for your business can be very difficult and time consuming. In order to avoid such constraints, we …
Data at Work
Business Intelligence
3 Points to Consider When Deciding Between Google BigQuery and Amazon Redshift!
What to choose between BigQuerry and Amazon Redshift when it comes to build a cost-efficient, fast, and reliable data warehouse?
New at Holistics
Using Holistics
Inner Join: Relentless Improvements - Holistics June 2018 Update
“It’s not about how good you are, it’s about how good you want to be” That's why at Holistics, we're always learning and thrilling for improvements, to serve our users better! Let’s have a look into what we’ve done in June 2018
New at Holistics
Startups
Inner Join
Why should you have a Public Roadmap and how to build your Public Product Roadmap
"Would be great if we have this feature…" "We really need this feature…" "Could you let me …
Holistics Power-ups
Using Holistics
Holistics Crash Course: Applying Holistics for Business Users
With the intuitive design, Holistics is not only a powerful tool for Analysts but also a lean and easy-to-use data self-serve portal for less technical users. Accessing data becomes as easy as using a phone app. No training required!
Holistics Power-ups
Using Holistics
Hide/Show Columns in a Report based on User Permission
Imagine that you have some reports that contain sensitive or confidential data that should show certain columns basing on the users who …
Holistics Power-ups
Using Holistics
Holistics Crash Course #1: Data Governance with Holistics
On May 21st 2018, the Holistics team hosted a webinar about controlling data access in organizations. In this article, you will find …
Holistics Power-ups
Engineering
Using Holistics
How to Update Your Data In Google Spreadsheet Automatically (from Database)
Learn how to use Scheduled Google Sheets Export to get your data from different sources into google spreadsheet and update them automatically.
Data at Work
Business Intelligence
The Analyst Guide to Designing a Modern Data Warehouse
High level guide for data analysts and engineers starting their first data warehouse project.
Data at Work
Startups
Business Intelligence
Data Analyst or Excel Monkey? (Becoming a 10x Data Analyst)
When people think of data analytics, they often think of charts and visualizations. However, the 10x data analyst cannot just be a visualizer. There are several abilities and techniques that a data analyst requires to truly become fully empowered and effective.
Lean Analytics
Data at Work
Business Intelligence
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.
New at Holistics
Inner Join
Holistics celebrates the Lunar New Year!
Holistics celebrate Lunar New Year 2018 with festive designs.
Data at Work
Startups
Business Intelligence
How To Interview A Data Analyst Candidate
How do you usually interview a data analyst candidates? In this article, I'll share some of the guidelines and areas you can focus on when interviewing a data analyst candidate. These serve as pointers to aid with your interview.
Data at Work
Business Intelligence
Data Lake vs Data Warehouse vs Data Mart
The term "Data Lake", "Data Warehouse" and "Data Mart" are often times used interchangbly. But what …
Engineering
Inner Join
How We Built A Job Queue System with PostgreSQL & Ruby For Our B2B SaaS Application
Why and how we built a multi-tenant job queue system for our B2B SaaS Application with PostgreSQL and Ruby
Lean Analytics
Data at Work
Business Intelligence
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
Business Intelligence
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
Business Intelligence
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
Business Intelligence
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
Business Intelligence
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 …
Lean Analytics
Engineering
Business Intelligence
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 …
Engineering
Startups
Inner Join
When Engineering drives Growth: Why we release everyday
The benefits of how an engineering-driven culture drives the growth of Holistics, a data analytics company
Engineering
Inner Join
Why and How We Migrated from AngularJS to VueJS
As I'm writing this, we've just removed the last line of AngularJS code from our application codebase, ending …
Lean Analytics
Business Intelligence
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. …
New at Holistics
Using Holistics
Holistics Data Journey - How Data Is Applied In Governments, Non-profits vs. Private Organizations
Thanks for joining our recent inaugural session of our Holistics Data Journey webinar series, on "How Is Data Applied In Governments, …
Lean Analytics
Data at Work
Using Holistics
Holistics Data Transforms for Performance & Clarity
How Holistics help to join, standardize, clean, pre-process, transform data for reporting.
Data at Work
Lean Analytics
Using Holistics
Combining Data Sources: The Holistics Approach
How Holistics Business Intelligence helps customers combine data from different sources. Without storing their data.
Holistics Power-ups
Using Holistics
3 features Data Analysts love about Data Reporting with Holistics
3 key reasons why data analysts love Holistics
Lean Analytics
Data at Work
Business Intelligence
Combining Data Sources: Approaches & Considerations
Analyze how the way different vendors addresses the problem of combing data from different sources
New at Holistics
Using Holistics
Embed Analytics Dashboards Into Your Applications
As startups and tech-enabled companies, often times we are sitting upon invaluable data for making decisions, be it for conversion, retention or …
New at Holistics
Startups
Inner Join
Our Experience Going Through YC Startup School (B2B Startup)
Y-Combinator (YC) has always been recognized as one of the top accelerators/incubator for promising startups to apply for. They recently launched …
Holistics Power-ups
Data at Work
New at Holistics
Using Holistics
Creating A Culture Of Metrics With Metric Sheets
It's just been slightly over a week since our last release, and already we've launched the next one! …
New at Holistics
Using Holistics
Introducing Geo Heatmap Feature
In our new Holistics release (v1.29), we finally unveiled a popularly requested feature: Geo Heatmaps! Our engineering team has been working …
New at Holistics
Using Holistics
Introducing Annotations
As you progress in your business, it's becoming more and more difficult to keep track of the small or big …
Engineering
Data at Work
Business Intelligence
Moving From Redshift to Presto - Data Engineering at Grab
Recently one of our customers, Grab - the Uber's competitor in SEA, unicorn startup - published a blog post on …
New at Holistics
Using Holistics
Freezing Report Table Header For A Better Experience
In our last release (v1.22), we've supported the ability for you to freeze your table header. This is among …
Lean Analytics
Using Holistics
Quick Guide: Building Daily + Running Total Report With SQL
In this article I will show you how to build daily user growth report with cumulative number (running total) using mostly SQL, …
Lean Analytics
Business Intelligence
SQL Is The New Excel
There was a time when being a power Excel user gave you an edge in your resume – it implied that you can …
Data at Work
Business Intelligence
Quick Guide: Setting Up Your Own MySQL Instance Using Google CloudSQL
Holistics helps you present any queries from your database as online reports and dashboards. As Holistics does not store your data, you …
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 …
Lean Analytics
Holistics Power-ups
Using Holistics
Quick Guide: Reusing Your SQLs with Query Templates
As engineers we refactor and abstract our code regularly, this is part of process to improve our code quality and scale up …
New at Holistics
Using Holistics
Tableau vs Holistics
Holistics gives you more flexibility and control over Tableau for data extraction and preparation. Holistics featured at Grab Engineering's presentation …
Engineering
Lean Analytics
Business Intelligence
Why You Should Use Postgres Over MySQL For Analytics Purpose
Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, …