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.